Home > Database Upgrade, Oracle Tools > Oracle Software Patching Using OPatch – Interim Patches

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 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

Talip Hakan ÖZTÜRK

Advertisements
  1. March 31, 2017 at 5:33 pm

    Hi Talip,
    Its really useful and helpful info.

    Hope this may also useful for DBA.

    https://ora-data.blogspot.in/2016/12/step-by-step-applying-database-patch-to.html

    Thanks,

  1. No trackbacks yet.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: