Patching steps on standalone database with grid

Presteps for patching
===================================

check the opatch version

1.$ORACLE_HOME/OPatch/opatch version

Opatch version should be 11.2.0.3.6 or higher. if the value is lower then perform below step.

update Opatch utitlty for 11.2.0.3 GI and DB homes respectively.

Go to GRID home and take the backup of OPatch folder as cp -r OPatch OPatch_backup
 
copy /dbaadm/media/Oracle/11gR2/x86_64/11.2.0.3/patch/p6880880_112000_Linux-x86-64.zip to $ORACLE_HOME and extract.


as Grid user when copying to GRID home
as oracle user when copying to DB home



2. Create ocm.rsp file for grid and oracle home if it does not exist already.

change directory to /export/home/<username>

cd $HOME


[root@dog1141 bin]# chown -R grid:oinstall emocmrsp
[root@dog1141 bin]# ls -ltr
total 24
-rwxr----- 1 grid   oinstall 9063 Nov 27  2009 emocmrsp
-rw-r--r-- 1 oracle oinstall  623 Jan 28  2013 ocm.rsp


$ORACLE_HOME/OPatch/ocm/bin/emocmrsp---as grid user for GI home (ORACLE_HOME is GI home)

$ORACLE_HOME/OPatch/ocm/bin/emocmrsp----as Oracle user for DB home (ORACLE_HOME is DB home)

unmount the admin mt point after stopping al db's

/sbin/acfsutil info fuser

/bin/umount /u01/app/oracle/admin


=============================================================================================
Apply the patch
=================================


As root user

1.   11.2.0.4 -- GI Home


/u01/app/11.2.0.4/grid/OPatch/opatch auto /dbaadm/rman01/Q1_Patching_2016/22378167/22191577 -oh /u01/app/11.2.0.4/grid -ocmrf /export/home/grid/ocm.rsp



2.   11.2.0.4 -- RDBMS Home

/u01/app/oracle/product/11.2.0.4/dbee_1/OPatch/opatch auto /dbaadm/rman01/Q1_Patching_2016/22378167/22191577 -oh /u01/app/oracle/product/11.2.0.4/dbee_1 -ocmrf /export/home/oracle/ocm.rsp