Thursday 10 May 2012

Oracle apply optach example

OPatch is an Oracle utility that assists you to apply interim patches to Oracle’s rdbms software. You can find opatch utility in $ORACLE_HOME/Opatch directory. For example, let’s apply patch number 8943287  to our 10.2.0.5 database.
Applying Patch:
1- Backup Oracle Home directory.
$ tar -cf ora10g.tar ora10g
2- Download patch file p8943287_10205_Linux-x86-64.zip via metalink. And copy it to database server.
3- Unzip the patch file.
$ unzip p8943287_10205_Linux-x86-64.zip
4- Apply patch with opatch utility.
$ cd 8943287
$ ORACLE_HOME/OPatch/opatch apply
To see list of applied patches :
$ORACLE_HOME/OPatch/opatch lsinventory
For example:
$ORACLE_HOME/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/ora10g
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.9
OUI version : 10.2.0.5.0
OUI location : /oracle/ora10g/oui
Log file location : /oracle/ora10g/cfgtoollogs/opatch/opatch2011-10-28_12-14-12PM.log
Patch history file: /oracle/ora10g/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/ora10g/cfgtoollogs/opatch/lsinv/lsinventory2011-10-28_12-14-12PM.txt
——————————————————————————–
Installed Top-level Products (3):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
Oracle Database 10g Release 2 Patch Set 4 10.2.0.5.0
There are 3 products installed in this Oracle Home.
Interim patches (2) :
Patch 8943287 : applied on Fri Oct 21 20:39:46 EEST 2011
Unique Patch ID: 12722995
Created on 23 Aug 2010, 11:45:16 hrs PST8PDT
Bugs fixed:
8943287
——————————————————————————–
Rollback applied patch:
Sometimes a patch is applied to the system may need to take back because of its effect. In this case, rollback is performed as follows.
$ORACLE_HOME/OPatch/opatch rollback -id 8943287

No comments:

Post a Comment

Number of Visitors