Oracle RAC manual rollback patch
Stop the CRS managed resources running from DB homes.
If this is a GI Home environment, as the database home owner execute:
$/ bin/srvctl stop home-o-s-n
If this is an Oracle Restart Home environment, as the database home owner execute:
$/ bin/srvctl stop home-o-s
Run the pre root script.
If this is a GI Home, as the root user execute:
/ crs/install/rootcrs.pl-unlock
If this is an Oracle Restart Home, as the root user execute:
/ crs/install/roothas.pl-unlock
Roll back the CRS patch. As the GI home owner execute:
$/ OPatch/opatch rollback-local-id-oh
$/ OPatch/opatch rollback-local-id-oh
$/ OPatch/opatch rollback-local-id-oh
Run the pre script for DB component of the patch. As the database home owner execute:
$/ custom/server//custom/scripts/prepatch.sh-dbhome
Roll back the DB patch from the database home. As the database home owner execute:
$/ OPatch/opatch rollback-local-id-oh
$/ OPatch/opatch rollback-local-id-oh
Run the post script for DB component of the patch. As the database home owner execute:
$/ custom/server//custom/scripts/postpatch.sh-dbhome
Run the post script. As the root user execute:
/ rdbms/install/rootadd_rdbms.sh
If this is a GI Home, as the root user execute:
/ crs/install/rootcrs.pl-patch
If this is an Oracle Restart Home, as the root user execute:
/ crs/install/roothas.pl-patch
If the message, "A system reboot is recommended before using ACFS??? is shown, then a reboot must be issued before continuing. Failure to do so will result in running with an unpatched ACFS\ ADVM\ OKS driver.
Start the CRS managed resources that were earlier running from DB homes.
If this is a GI Home environment, as the database home owner execute:
$/ bin/srvctl start home-o-s-n
If this is an Oracle Restart Home environment, as the database home owner execute:
$/ bin/srvctl start home-o-s
1. Close a node database:
$srvctl stophome-o $ORACLE_HOME-s / tmp/stophome1.log-n rac2
two。 Lock a node GI:
/ u01/app/11.2.0/grid/crs/install/rootcrs.pl-unlock
3. Roll back the patch pack under GI HOME and execute it with the GI user:
$ORACLE_HOME/OPatch/opatch rollback-local-id 27441052-oh $ORACLE_HOME$ $ORACLE_HOME/OPatch/opatch rollback-local-id 22502505-oh $ORACLE_HOME$ $ORACLE_HOME/OPatch/opatch rollback-local-id 27338049-oh $ORACLE_HOME
4. Use oracle users to use scripts to detect:
$/ u01/app/stage/27475913/27441052/custom/server/27441052/custom/scripts/prepatch.sh-dbhome $ORACLE_HOME
5. Roll back the patch pack under database home and execute it with the oracle user:
$ORACLE_HOME/OPatch/opatch rollback-local-id 27441052-oh $ORACLE_HOME $ORACLE_HOME/OPatch/opatch rollback-local-id 27338049-oh $ORACLE_HOME
6. Execute the script using the oracle user:
$/ u01/app/stage/27475913/27441052/custom/server/27441052/custom/scripts/postpatch.sh-dbhome $ORACLE_HOME
7. Execute the script using the root user:
/ u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh / u01/app/11.2.0/grid/crs/install/rootcrs.pl-patch
8. Open the node instance:
$srvctl start home-o $ORACLE_HOME-s / tmp/stophome1.log-n rac2
9. Update data dictionary (run on a single node):
-update the data dictionary SQL > @? / rdbms/admin/catbundle.sql psu apply--- compile the java class SQL > @? / rdbms/admin/utlrp.sql select * from dba_registry_history
