All about database opatch utility !!!

What is opatch?
++++++++++++++++++
opatch is a java utility which is used to apply database patches.
opatch utility does not make any changes in database (*.dbf) but do make changes in ORACLE HOME binaires.
opatch utility is located in $ORACLE_HOME/bin


what is the pre requisite to apply database patches?
------------------------------------------------------
Database and database listener must be down.


To check either patch can be apply online or not
--------------------------------------------
opatch query -is_online_patch 17230530



How to export opatch utility
+++++++++++++++++++++

export PATH=$PATH:$ORACLE_HOME/Opatch


How to check opatch version
+++++++++++++++++++++++++++++
opatch version


How to check if the patch having any conflicts
+++++++++++++++++++++++++++++++++++++++++++
/d01/erpapp/patches/CPU_PATCHES/16902043
 $ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./



Deinstall the patch by running the following command:
++++++++++++++++++++++++++++++++++++++++++++++++++++
$ opatch rollback -id 14153246

opatch rollback -id 17230530 -no_sysmod

Check whether the patch has been rolled back
++++++++++++++++++++++++++++++++++++++++++++
$ opatch lsinventory |grep 14153246


How to apply database patch
++++++++++++++++++++++++++++++
opatch apply


How to apply multiple database patches
++++++++++++++++++++++++++++++++++++++
opatch napply


How to go for help on patch
+++++++++++++++++++++++++++++
opatch help



D. Cleanup Patch Storage to Reclaim Space
+++++++++++++++++++++++++++++++++++++++++++++++
OPatch can now determine and cleanup files in the patch storage that are no longer required. To do so run the following:
SYNTAX / EXAMPLE:

[oracle@lnx01] $ORACLE_HOME/OPatch/opatch util cleanup


B. List Detailed Information About a Patch Before Applying It
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
The OPatch utility can be used to verify details of a patch before proceeding to apply to the Oracle Home directory.
Such information that can verified but not limited to are:
• Check if patch is a Rolling Patch
• Check if patch is a Patchset Update (PSU)
• Check if patch can be run with “opatch auto” option
• Check OS platform the patch can be applied on
• Actual actions and/or steps that patch contains without applying the patch. This include detailed information of files it touches, copies and relinks.



SYNTAX:

$ORACLE_HOME/OPatch/opatch query -all |more

[oracle@lnx01] cd /home/oracle/download/patches/12311357
[oracle@lnx01] $ORACLE_HOME/OPatch/opatch query -all |more




How to determine if a patch is a "rolling patch" or not?
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Based on the oracle database version we can determine whether a patch is a rolling patch or not.

- For oracle version 9i or 10gR1 issue,
$ opatch query -is_rolling