adop utility from basic

Hope you all doing well. Here  I am going to explore about ADOP utility in 12.2 env . this Utility is going to applying apps patches in oracle E-business suite 12.2 .x env .

So First of all , we need to check whether  this particular patch is applied or not .

SQL> select BUG_NUMBER,LAST_UPDATE_DATE from ad_bugs where BUG_NUMBER=22297430;

BUG_NUMBER                     LAST_UPDATE_DATE

------------------------------ ------------------

22297430                       14-APR-18

SQL> select BUG_NUMBER,LAST_UPDATE_DATE from ad_bugs where BUG_NUMBER=25260797;

no rows selected

 it means patch 25260797 need to be apply with adop utility .

Download the patch from support.oracle.com , copy to the server in staging directory then unzip it .

Unzip <patch_nem>

Then go to patch directory and below command

adop phase=apply patches=25260797  hotpatch=yes

it will ask for apps pw , system pw and web logic pw , supply all the password correctly.

You can check the log file also for monitoring in below location

$NE_BASE/EBSapps/log/adop/<adop_session_id>/<phase>_<date>_<time>/<context_name>/log/adop.log

 2^nd option to apply patch in r12.2 --------------

We do have 5  phases in adop utility  which we can run one by one but this cycle will go for minimal downtime in cutover phase .

PREPARE PHASE DETAILS :

$ adop phase=prepare

1)    Check whether perform cleanup and validate system configuration to start adop cycle.

2)    Check ETCC (E-business suite tech code level checker) has been run to verify that all required patches has been applied .

3)    ADZDPATCH --- it’s a concurrent programme that call perl script ($AD_TOP/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)

to synchronise patch to run APPL_TOP.

APPLY PHASE DETAILS : ----

1)    adop phase=apply patches=1234   with below option

         hotpatch=yes

        in case of restart the patch (if failure)  use below option ------à

        restart=yes abandon=no  or   restart=no abandon=yes

      

2)      apply phase will apply the patch in patch env file system  , we can see the current env by running command  like ----

echo $FILE_EDITION

Finalize PHASE : ----

System will run two script in this phase ---

Perl adzdoptl.pl run and ADZDSHOWLOG.sql under /u003/app/applmgr/MSIAAD2/fs1/EBSapps/appl/ad/12.0.0/sql directory .

Script ADZDSHOWLOG.sql will generate will AD_ZD_LOGS Report.

Adop phase=finalize

CUTOVER PHASE ---

In this phase system will change the runfile system (fs1) to patch file system (fs2) and vice versa

During this transition , system will be go down for short downtime period.

Adop phase=cutover

CLEANUP PHASE 

It remove obsolete objects

Adop phase=cleanup