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
$ 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.
No comments:
Post a Comment