Opatch Apply and Rollback

OPATCH

 ORACLE VERSION 10.2.0.4.0

Before applying OPatch in production Database, check it on Test Database.

Shut-DOWN all Databases even their Listeners of corresponding $ORACLE_HOME.

Take a cold backup of ORACLE_HOME

Check Opatch Current Version Before applying.

Shutdown all services of corresponding Databases.

Backup of ORACLE_HOME using Tar command…

cd $ORACLE_HOME  (/d001/ora/product/10.2.0)

ls (Result:-  /d001/ora/product/10.2.0)

cd ..(Result:- /d001/ora/product)

ls  (Result:- /d001/ora/product)

cd ..(Result:- /d001/ora/oradata)

ls  (Result:- /d001/ora/oradata)

Syntax:- tar -cvzf orahome.tar 10.2.0

Syntax:- tar -cvzf oradata.tar oradata

ls

orahome.tar  

==> This is new tar file of oracle home.

10.2.0

==> This is our oracle home directory

oradata.tar  

==> This is new tar file of oracle database backup.

Steps to apply OPATCH:

à  Download the said Patch # 6084656, 6521934 (Patch number suggested by oracle)

p6084656_10204_Linux-x86.zip,   p6521934_10204_Linux-x86.zip

à Put corresponding patch zip file in your preferred location.

       [Exp: - $> cd /u02/]

à Set current working directory as compatible to OPatch apply.

       [Exp: - $> export PATH=$PATH:$ORACLE_HOME/OPatch]  

                          

à Now fire “$>opatch lsinventory” command. It must be succeeded.

à unzip the patch-file in C.W.D. (/northact/oratest/kml_patch_dir/)

   [Exp: - $> unzip p6084656_10204_Linux-x86.zip]

          · It would create a folder by the number (patch name) à 6084656

à Navigate to the extracted-Patch-folder where the patch-file was unzip/extracted

         [Exp: - $> cd /u02/6084656/]

à Run the Opatch apply command to apply the Patch as:

         [Exp: - $> opatch apply]  [It must be succeed]

(Patch would then be applied, after which you may bring the Database & Listener UP)

Steps to rollback OPATCH:

à   Shut-DOWN all Databases even their Listeners of corresponding $ORACLE_HOME.

à Take a cold backup of ORACLE_HOME.

à Set current working directory as compatible to OPatch apply.

       [Exp: - $> export PATH=$PATH:$ORACLE_HOME/OPatch]  

                          

à Now fire “$>opatch lsinventory” command. It must be succeeded.

à Run the Opatch rollback command to rollback the Patch as:

         [Exp: - $> opatch rollback –id <6084656>]  [It must be succeed]

CLUSTERWARE OPATCH