9482317 - Bug Patch apply 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 9482317 FOR BOTH CRS AND DB
PATCH DESC - Patch 9482317: Pre-requisite for Upgrade from 11.2.0.1 to 11.2.0.3

*** 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/9413827/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 9413827

cd /u01/software/grid_patch/9413827/custom/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 9413827

AS ROOT EXECUTE THE FOLLOWING -
------------------------------

chmod +w /u01/app/11.2.0/grid/log/node1/agent
chmod +w /u01/app/11.2.0/grid/log/node1/agent/crsd


AS ORACLE EXECUTE THE BELOW -
---------------------------

cd /u01/software/grid_patch/9413827/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 RESROUCE 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


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

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