Frequently Asked Questins on Opatch Utility

Q. How to check opatch version?

$ORACLE_HOME/opatch/opatch version

Q. How to Apply single patch using opatch ?

What are the Pre-checks for applying a patch ?

1. You MUST read the Readme.txt file included in opatch file, look for any prereq. steps/ post installation steps or and DB related changes. Also, make sure that you have the correct opatch version required by this patch.

2.Make sure you have a good backup of database.

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

4. Shutdown All the Oracle Processes running from that Oracle Home , including the Listener and Database instance, Management agent etc.

5. You MUST Backup your oracle Home and Inventory

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

6. Unzip the patch in $ORACLE_HOME/patches

Q. What are Opatch Options you have used till now ?

command := apply

lsinventory

prereq

query

rollback

util

version

Q. How to Roll-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’

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

Above command 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?

Using the lsinventory command

$  oracle_home/opatch/opatch lsinventory

For more updates,  Like Us Our Facebook Page Here 

How to Import data via a network link in Oracle