I am an Oracle enthusiast sharing with you Oracle related content for personal and professional development. My focus on this channel is on Oracle Database Administration across several version and platforms.
Thank you for this ORA 03113 video! It was exactly what I needed and solved my issue perfectly. Now my database is in READ WRITE mode. Keep up the great work!
Since these are simple statements, would you be able to just follow and copy onto your SQL prompt? Unfortunately, I did not include these in the transcript
I would not recommend this method for large databases as this will require alot of time for the exp and imp processes. If you choose to, it will require alot of resources and parallelism
Hands-down the most straightforward and simplest guide to setting up DG and the DB Broker I have seen. Thanks for taking the time to make this video! Oracle of course provides no step-by-step guide, so you are on your own to piece together a script to make this all work. There are many things I've been including based on various other guides that appear to not be necessary, possibly because they are based on older db versions items that are no longer required (such as a separate listener entry for the broker).
I did everything step by step but I couldn't connect to auxiliary database in RMAN, ,(Instance "primtstDB", status BLOCKED, has 1 handler(s) for this service. ) . RMAN> connect auxiliary sys@primtst; auxiliary database Password: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-04006: error from auxiliary database: ORA-12537: TNS:connection closed
Thanks I resolve this error by adding additional entry into my tnsnames.ora file, in the last line entry after service_name, I added this " (UR = A) ". For anyone having this error try this, it should work. :)
Very well presented. You are a great content creator and instructor. The steps are clear easy to follow but I wish you could include some other pre-requisite steps like hosts file edit, distinction between manual and automatic install parameters, maybe mention solutions to some commonly experienced installation processes. Thank you.
Can you help me i already following ur step but when i try to connect to rman auxiliary "dbstby" my tns couldnt connect the server and i see listener status on standby its blocked
I have 2 questions 1)Do we need to install Clusterware on node 2 before converting to RAC or rconfig will take care of it. 2)What if the second node has configuration issues, and how rconfig will take care of it ?
Ans 1: YES YES and YES... RAC is clustered nodes... so Clusterware must be installed. Ans2: rconfig is only a tool to help convert SI to RAC... if there are underlying issues, rconfig more than likely will fail. That is why you run rconfig with ONLY option to check first before executing
As you are excluding most of the schemas , do we need full=y export? Why not just export(include) the application schema only (must smaller list) and thats it, instead of having a long list of excluded shemas? Your thoughts much appreciated. Thank you
Great video thank you for sharing sir. Out of interest what about roles and privaleges or anything , will they be included the export/import? Secondly instead of creating a new dump directory can we not use the one already there? thank you
Great question... Yes, the single instance is shutdown and restarted multiple times and a new rac instance is created. Therefore, existing connections will be dropped as that single instance goes down