Opatch Utility for a Single Instance

Applying single patch using opatch

1.              You MUST read the Readme.txt file included in opatch file, look for any prerequisites                 steps     OR  post installation step. Also, make sure that you have the correct opatch     version required by this patch.

2.              Check the Oracle opatch version using Below command

                 $oracle_home/opatch/opatch version

3.            Make sure you have a Full Backup of database.

4.            Make a note of all Invalid objects in the database prior to the patch.

5.            Shutdown All the Oracle Processes running from that Oracle Home ,

                Such as Listener and Database instance, Management agent etc.

6.            You MUST Backup your oracle Home and Inventory

                Use below command to backup Oracle Home

                $ tar cvf – $ORACLE_HOME $ORACLE_HOME/oraInventory | gzip >   Backup_for_patch.tar.gz

7.            Unzip the patch in $ORACLE_HOME/patches

Below are the Opatch Options :

command := apply

lsinventory

prereq

query

rollback

util

version

Rolling back a patch

In case if a patch did not fix the issue or if you has applied wrong patch to oracle home, you can always rollback the patch using following command.

$ opatch rollback -id <Patch Number>

You can also apply specific patches using NApply as below :

$ opatch util napply <patch_location> -id 1,2,3 -skip_subset -skip_duplicate

This will apply patches 1, 2, and 3 which are under < the patch_location> directory.

OPatch will skip duplicate patches and subset patches (patches under <patch_location> that are subsets of patches installed in the ORACLE_HOME)

You can see all the options for NApply using following help command.

$ ORACLE_HOME/OPatch/opatch util NApply -help

How to find the applied patches?

$ oracle_home/opatch/opatch lsinventory