Moving 11g RAC Database Instances to a New Fully Patched Oracle Home

1. If DG is Enabled then Disable the Apply

dgmgrl> edit database <DBNAME_SB> set state=APPLY-OFF

2. Shutdown the database.  Change the environment to the new Oracle home and reload the listener.

3. Modify the environment file so that the environment will point to the new Oracle home.

- Modify the listener file (listener.ora) to point to the new Oracle home.- Modify the oratab file- Copy password file/ tnsfiles/initfile to New ORACLE HOME

First on Standby:

srvctl config database -d DBNAME_SB
srvctl modify database -db DBNAME_SB -oraclehome <NEW HOME>
srvctl config database -d DBNAME_SB
srvctl stop databae -d DBNAME_SB

4. Start the database with the new Oracle home 

srvctl start database -d DBNAME_SB

Then On Primary:

srvctl config database -d DBNAME
srvctl modify database -db DBNAME -oraclehome <NEW HOME>
srvctl config database -d DBNAME

srvctl stop database -d DBNAME 

srvctl start database -d DBNAME 

Run catbundle and

@?/rdbms/admin/catbundle.sql psu apply

@?/rdbms/admin/utlrp.sql 1

 OVJVM if required.

Restart the database and enable the Replication.

srvctl stop database -d DBNAME 

srvctl start database -d DBNAME 

srvctl stop databae -d DBNAME_SB

srvctl start databae -d DBNAME_SB

edit database "DBNAME_SB" set state=APPLY-ON;