Applying Bug Patch in Rolling mode to CRS & DB Home

PLATFORM  - RHEL 5.7
DB_VERSION  - 11.2.0.1.0
GRID_VERSION  - 11.2.0.1.0
DB_HOME  - /u01/app/oracle/product/11.2.0/db_1
GRID_HOME  - /u01/app/11.2.0/grid
PATCH APPLIED - BUG PATCH 13339443 FOR BOTH CRS AND DB
PATCH DESC - Patch 13339443: ESSC: CRS AGENT KILLS ASM INSTANCE DUE TO ORA-15042


***** ON NODE 1 ******************


TO VERIFY LSINVENTORY -
---------------------


/u01/app/11.2.0/grid/OPatch/opatch lsinventory -local -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc


/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory -local -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc




TO STOP THE DATABASE RESOURCE -
------------------------------


/u01/app/oracle/product/11.2.0/db_1/bin/srvctl stop home -o /u01/app/oracle/product/11.2.0/db_1 -s /u01/log/tmp.log -n node1




AS ROOT EXECUTE BELOW TO UNLOCK THE FILE PERMISSIONS-
----------------------------------------------------


/u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock




AS ORACLE USER (PRE-PATCH, APPLY PATCH ON BOTH HOMES, POST-PATCH)-
-----------------------------------------------------------------


cd /u01/software/grid_patch/13339443/custom/scripts


./prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_1


/u01/app/11.2.0/grid/OPatch/opatch napply -local -oh /u01/app/11.2.0/grid -id 13339443


cd /u01/software/grid_patch/13339443/customer/server


/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply custom/server/ -local -oh /u01/app/oracle/product/11.2.0/db_1 -id 13339443


cd /u01/software/grid_patch/13339443/custom/scripts


./postpatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_1




AS ROOT EXECUTE BELOW TO LOCK THE FILE PERMISSIONS -
--------------------------------------------------


/u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch




TO START THE DATABASE RESOURCE AS ORACLE USER-
----------------------------------------------


/u01/app/oracle/product/11.2.0/db_1/bin/srvctl start home -o /u01/app/oracle/product/11.2.0/db_1 -s /u01/log/tmp.log -n node1



[oracle@node1 ~]$ cat /u01/log/tmp.log
db-racdevdb



TO VERIFY THE LSINVENTORY -
-------------------------


/u01/app/11.2.0/grid/OPatch/opatch lsinventory -local -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc


/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory -local -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc




NOTE: The applied patch would be displayed in the lsinventory only after the patch is applied to last node of the cluster


****************************************************************************


*** FOLLOW THE ABOVE FOR NODE2 AS WELL, BUT CHANGE THE HOSTNAME ACCORDINGLY ***


TO VERIFY THE LSINVENTORY -
-------------------------


/u01/app/11.2.0/grid/OPatch/opatch lsinventory -local -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc


/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory -local -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc


*********************************************************************************