1.OPatch installation

Copy the opatch binary using root user to $ORACLE_HOME and $GRID_HOME.

Then please keep backup of old OPatch directory.

Unzip the binary in the $ORACLE_HOME and $GRID_HOME.

unzip -o -d $ORACLE_HOME /oracle/soft/p6880880_112000_Linux-x86-64.zip

unzip -o -d $GRID_HOME /oracle/soft/p6880880_112000_Linux-x86-64.zip

Change owner of the folder OPatch.

chown -R oracle:oinstall $ORACLE_HOME/OPatch

chown -R oracle:oinstall $GRID_HOME/OPatch

2.Stop EM DB console

 

[oracle@jminvgpdb01 ~]$ export ORACLE_UNQNAME=xcomprod
[oracle@jminvgpdb01 ~]$ emctl stop dbconsole

3.Create response file for ORACLE

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /tmp/ocmdb.rsp

4.Create response file for GRID

export ORACLE_HOME=/u01/app/grid/11.2.0
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /tmp/ocmgrid.rsp

5.Please proceed with GRID patching using root user

export PATH=/u01/app/grid/11.2.0/OPatch:$PATH
[root@jmbscspdb01 ~]# /u01/app/grid/11.2.0/OPatch/opatch auto /u01/app/oracle/soft/patch/22191577 -oh /u01/app/grid/11.2.0 -ocmrf /tmp/ocmgrid.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/app/oracle/soft -patchn grid_patch -oh /u01/app/11.2.0/grid -ocmrf /tmp/ocmgrid.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-05-09_22-34-25.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-05-09_22-34-25.report.log

2015-05-09 22:34:25: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Stopping CRS…
Stopped CRS successfully

patch /u01/app/oracle/soft/grid_patch/17592127 apply successful for home /u01/app/11.2.0/grid
patch /u01/app/oracle/soft/grid_patch/20299017 apply successful for home /u01/app/11.2.0/grid

Starting CRS…
CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.

6.Please proceed with ORACLE patching using root user

export PATH=/u01/app/oracle/product/11.2.0/db_1/OPatch:$PATH
[root@jmbscspdb01 ~]# /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch auto /u01/app/oracle/soft/patch/22191577 -oh /u01/app/oracle/product/11.2.0/db_1 -ocmrf /tmp/ocmdb.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/OPatch/crs/patch11203.pl -patchdir /u01/app/oracle/soft -patchn grid_patch -oh /u01/app/oracle/product/11.2.0/db_1 -ocmrf /tmp/ocmdb.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2015-05-09_22-50-23.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2015-05-09_22-50-23.report.log

2015-05-09 22:50:23: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0/db_1 …
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

patch /u01/app/oracle/soft/grid_patch/17592127/custom/server/17592127 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /u01/app/oracle/soft/grid_patch/20299017 apply successful for home /u01/app/oracle/product/11.2.0/db_1

Starting RAC /u01/app/oracle/product/11.2.0/db_1 …
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.

7.Please run catbundle PSU

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

One Reply to “PSU patch Oracle 11gR2 oracle single instance HA”

Leave a Reply

Your email address will not be published. Required fields are marked *