Oracle Software Patching Using OPatch – Interim Patches

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 database.
Applying Patch:
1- Backup Oracle Home directory.
$ tar -cf ora10g.tar ora10g
2- Download patch file via metalink. And copy it to database server.
3- Unzip the patch file.
$ unzip
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
Oracle Interim Patch Installer version
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/ora10g
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version :
OUI version :
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
Oracle Database 10g Release 2 Patch Set 3
Oracle Database 10g Release 2 Patch Set 4
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:
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

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: