i have requirement to upgrade the DB from 22.214.171.124 to 126.96.36.199 and below is my setup.
1) we have three cluster database running in 3-node RAC and Two database are running in 188.8.131.52.
2) Only one DB is running in 184.108.40.206. so i already have 220.127.116.11 and 18.104.22.168 cluster installed in that server and two Database are running in 22.214.171.124.
i have been asked to upgrade from database 126.96.36.199 to 188.8.131.52
did anyone have come across such scenario where you have 184.108.40.206 and 220.127.116.11 cluster RAC binaries are in place, and we need to upgrade only the DB running in 18.104.22.168 to 22.214.171.124 ?
This is a pretty straight forward upgrade from 126.96.36.199 to 188.8.131.52. You can use the same 184.108.40.206 binaries that are already there or if you want/need then create a separate ORACLE_HOME for your new database.
The upgrade will be transparent to your other 220.127.116.11 databases on the cluster.
What is your question..or did I miss it?
Thanks for your comments.
do we have any standard procedures, we need to follow for upgrading in 18.104.22.168 to 22.214.171.124?
i have done many standalone DB upgrades , havent done any any cluster DB upgrade. so i dont want to miss out any steps?
please let me know what steps i should follow?
Use DBUA to make your life easier if you haven't done this before. Presumably your ASM and CRS are already at 126.96.36.199.
From memory, if you are doing an manual upgrade then it's not much different to doing a standalone upgrade.
You set cluster_database=false first, run through the steps and then set cluster_database=true at the end.
You will also need to update the oracle_home for this database to the new home in CRS using:
You need to confirm the steps by reading the docs at http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=