STEPS TO APPLY PSU (Patch Set Update) in RAC Environment
--------------------------------------------------------
Apply Below Steps on All nodes in RAC one by one
1- Partition where you are going to place Patch ,mount it with following
options.
Below command needs to be run on an already mounted partition
mount -o remount,exec /u02
2- Copy GI PSU and Opatch patch on /u02
3- Copy OPATCH folder from /u02 in Database and GI Homes. In GI home copy as
root and in Database as oracle user.
4- On copied OPATCH folders grant ownership to oracle user and oinstall group
chown -R oracle:oinstall /u02/oracle/Oragi_Home/[Link]/grid/OPatch
chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/dbhome_1/OPatch
5- On node where you want to apply GI PSU patch connect as root user and create
[Link] file
cd /u01/oragrid/[Link]/grid/OPatch/ocm/bin
sh emocmrsp -no_banner -output /u02/[Link]
6- Connect as oracle and shutdown database on node you want to apply patch. No
need to shutdown CRS as opatch auto automatically stops and starts it before and
after applying patch on the RAC node.
7- Now LOGIN to Linux OS as "root" user.
8- in GI PSU below Patch folder
/u02/GI_27107360/27107360/26609929/custom/server/26609929/custom/scripts
take properties of [Link] and [Link] scripts and click on
permissions tab
click check box of Execute option of both scripts.
9- LOGIN to LINUX OS as "oracle" user and Run optach from GRID HOME as root user
this will apply patch first on dbhome and then on Grid Home. It automatically stops
DbHome and GridHome before applying patch but you explicity need to stop
database (It only stop services on the node you are applying patch where as other
nodes remain available to users)
cd /u02/oracle/Oragi_Home/[Link]/grid/OPatch
sh opatch auto /u02/GI_27107360/27107360 -ocmrf /u02/[Link]
If you just want to apply it on GridHome or DbHome then use below method
sh opatch auto /u02/GI_27107360/27107360 -oh $DB_HOME -ocmrf /u02/[Link]
sh opatch auto /u02/GI_27107360/27107360 -oh $GRID_HOME -ocmrf /u02/[Link]
10- The following steps load modified SQL files into the database. For an Oracle
RAC environment, perform these steps on only one node.
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @[Link] psu apply
SQL> @[Link]
SQL> QUIT
The [Link] execution is reflected in the dba_registry_history view by a row
associated with bundle series PSU.
--------------------------------------------------------------------------------
In case patch fails for any home then you can retry patch for failed home as below
use OPATCH from home where patch apply failed to reapply the patch.
sh opatch auto /u02/GI_27107360/27107360 -ocmrf /u02/[Link] -oh $ORACLE_HOME