ANBOB™

to Opatch 11.2.0.4.5 PSU for RAC on hpux ia-31

Download and Unzip the Patch

ftp binary download to /u01/psu

chown grid:oinstall **<above download files>

su - grid
# /opt/java6/bin/jar -xvf <PSU>
# /opt/java6/bin/jar -xvf p6880880_112000_HPUX-IA64.zip

#chmod -R +x 20132580
#chmod -R +x OPatch

Back original opatch and upgrade OPatch software

su - root
cd   <GI HOME>
# mv OPatch OPatch_bak
# cp -r -p /u01/psu/OPatch ./

cd  <DB HOME>
# mv OPatch OPatch_bak
# cp -r -p /u01/psu/OPatch ./

Validation of Oracle Inventory

su - grid
$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

su - oracle 
$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

OCM(Oracle Configuration Manager) Configuration

[grid]#/u01/app/11.2.0/grid/OPatch/ocm/bin/emocmrsp -no_banner -output /tmp/ocm_my.rsp 

chmod 777 /tmp/ocm_my.rsp 

ls -l /tmp/ocm_my.rsp 

Patch Installation on both node (Can not be run patch in the same time on multi nodes)

OPatch auto for GI

su - root
# export ORACLE_HOME=/u01/app/11.2.0/grid
# $ORACLE_HOME/OPatch/opatch auto -oh $ORACLE_HOME -ocmrf /tmp/ocm_my.rsp

OPatch  auto for DB
# export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1/ 
# $ORACLE_HOME/OPatch/opatch auto -oh $ORACLE_HOME -ocmrf /tmp/ocm_my.rsp

To verify patch

su - grid
#$ORACLE_HOME/OPatch/opatch lsinventory

su - oracle
#$ORACLE_HOME/OPatch/opatch lsinventory

Loading Modified SQL Files into the Database

su - oracle
SQL> connect / as sysdba

SQL>@?/rdbms/admin/catbundle.sql psu apply

SQL> select * from dba_registry_history;

Note:
If you are using the Oracle Recovery Manager, the catalog needs to be upgraded. Enter the following command to upgrade it:

$ rman catalog username/password@alias 
RMAN> UPGRADE CATALOG;