Applying 11gR2 database patch

Apply the latest CPU patches for 11gR2 (11.2.0.2) using opatch

Steps:

1: Install the latest OPATCH
2: Apply the DB patches
 
Step #1

Check current version of opatch

$ opatch lsinv | grep -i version
Oracle Interim Patch Installer version 11.2.0.3.0
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.2.0

Delete the OPatch directory from $ORACLE_HOME

$ cd $ORACLE_HOME

$ pwd
/u01/oracle/maria/db/11.2.0
$ rm -rf OPatch

Download the latest Opatch, and unzip it in $ORACLE_HOME

$ cp /staging/11gR2/opatch/p6880880_112000_HPUX-IA64.zip .

$ unzip p6880880_112000_HPUX-IA64.zip
 

Change to the new OPatch directory and run emocmrsp to create a response file that opatch will use

$ cd OPatch

$ cd ocm/bin
$ pwd
/u01/oracle/maria/db/11.2.0/OPatch/ocm/bin
$ ./emocmrsp

……..

The OCM configuration response file (ocm.rsp) was successfully created.
 

Verify the new version of opatch

$ opatch lsinv | grep -i version

Oracle Interim Patch Installer version 11.2.0.3.3
OPatch version    : 11.2.0.3.3
OUI version       : 11.2.0.2.0

 

Cleanup by deleting the no longer needed zip file:

$ rm -rf p6880880_112000_HPUX-IA64.zip

Step #2

Stop the Database

SQL> shutdown immediate

 

Stop the listener

$ lsnrctl stop $ORACLE_SID

LSNRCTL for HPUX: Version 11.2.0.2.0 - Production on 22-JAN-2013 14:42:27
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCmaria))
The command completed successfully
 

Apply the patch

- Copy the patch to an appropriate directory, unzip the file, change to the patch directory and run opatch
 

$ cd patch/

$ cp /staging/11gR2/patchsets/11.2.0.2/oneoffs/p14727315_112020_HPUX-IA64.zip .
$ unzip p14727315_112020_HPUX-IA64.zip
$ cd 14727315
$ opatch apply -silent -ocmrf $ORACLE_HOME/OPatch/ocm/bin/ocm.rsp
Oracle Interim Patch Installer version 11.2.0.3.3
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/oracle/maria/db/11.2.0
Central Inventory : /var/opt/oracle
   from           : /u01/oracle/maria/db/11.2.0/oraInst.loc
OPatch version    : 11.2.0.3.3
OUI version       : 11.2.0.2.0
Log file location : /u01/oracle/maria/db/11.2.0/cfgtoollogs/opatch/opatch2013-01-22_14-22-37PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   14275621  14727315
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
…....
Verifying the update...
Composite patch 14727315 successfully applied.
Log file location: /u01/oracle/maria/db/11.2.0/cfgtoollogs/opatch/opatch2013-01-22_14-22-37PM_1.log
OPatch succeeded.

Verify patch was applied

$ opatch lsinv | grep 14727315

Patch  14727315     : applied on Tue Jan 22 14:25:47 EST 2013
Patch description:  "Database Patch Set Update : 11.2.0.2.9 (14727315)"
     10238786, 10132870, 10247152, 9953542, 14727315, 9572787, 15896434

 

Start the database and the listener

SQL> startup mount

ORACLE instance started.

….
 

$ lsnrctl start $ORACLE_SID

 Cleanup by deleting the zip file which is no longer needed.