This content has been marked as final. Show 6 replies
new Oracle binary or the new Oracle home if you will.
So you install the new software on the standby only, all the upgrade SQL gets done on the Primary and then you ENABLE and startup mount on the new oracle home and the standby gets upgraded from the Primary redo.
Its pretty simple ( My exact plan )
1. Disable log shipping from the Primary
2. Shutdown Standby
3. Install 220.127.116.11 on Standby - Just the software
4. Startup Standby in recovery mode - do NOT run r any SQL at the standby
5. Shutdown Primary
6. Install 18.104.22.168 on Primary
7. Run Upgrade SQL or DBUA at Primary
8. Re-enable log shipping
9. Monitor the redo apply from Primary to Standby - this will also upgrade the Standby data dictionary
Make sure your tnsnames and listener files move to the new Oracle home and edit as needed.
Another oracle note is 278641.1
Edited by: mseberg on Jan 29, 2013 8:21 PM
So do you mean that in my case, we have to manually change the executable path of the service manually just before we mount the standby database? I can not find any documentation regarding this anywhere, but I am quite sure if dont change the executable path the upgrade will failed and I have to rebuilding the standby database from scratch again.
Windows is a different animal. Frankly I'm not sure what you do there to make sure you are pointing at the new Oracle Home.
However you should be able to test by opening SQL Plus on the standby and the banner should show you if you need an additional step or not.
sqlplus "/ as sysdba"
SQL*Plus: Release 22.214.171.124.0 Production on Mon Jan 28 12:00:24 2013
Home Selector (Available on Win32 Platforms)
Edited by: mseberg on Jan 29, 2013 8:55 PM