Saturday, December 7, 2013

Apply Phase Scenario 2 - R12.2 Online Patching Cycle

Scenario

You have been asked to apply two patches and you completed the prepare phase and now you start with the phase “APPLY”.


Background

The two patches are from same module so they are candidate for merge option. To reduce the patching time you are planning to merge the patches before applying.




Staging the patches to the PATCH_TOP

$ pwd
/inst122i/product/patchtop
$
$ ls -lrt *AP*
-rw-r--r-- 1 skrajend g999 54057 Nov 17  2013 p17637775_R12.AP.C_R12_GENERIC.zip
-rw-r--r-- 1 skrajend g999 54229 Nov 17  2013 p17539845_R12.AP.C_R12_GENERIC.zip
$
$ unzip p17637775_R12.AP.C_R12_GENERIC.zip
Archive:  p17637775_R12.AP.C_R12_GENERIC.zip
  inflating: 17637775/README.html   
  inflating: 17637775/u17637775.drv 
  inflating: 17637775/f17637775.ldt 
  inflating: 17637775/ap/patch/115/sql/apgdfalb.pls 
  inflating: 17637775/ap/patch/115/sql/apgdfals.pls 
  inflating: 17637775/marker1.txt   
  inflating: 17637775/b17637775.ldt 
  inflating: 17637775/README.txt    
  inflating: 17637775/patch_metadata.xml
$
$ unzip p17539845_R12.AP.C_R12_GENERIC.zip
Archive:  p17539845_R12.AP.C_R12_GENERIC.zip
  inflating: 17539845/README.html   
  inflating: 17539845/u17539845.drv 
  inflating: 17539845/f17539845.ldt 
  inflating: 17539845/ap/patch/115/sql/apgdfalb.pls 
  inflating: 17539845/ap/patch/115/sql/apgdfals.pls 
  inflating: 17539845/marker1.txt   
  inflating: 17539845/b17539845.ldt 
  inflating: 17539845/README.txt    
  inflating: 17539845/patch_metadata.xml 
$
$ mv 17539845 /inst122i/applmgr/fs_ne/EBSapps/patch
$ mv 17539845 /inst122i/applmgr/fs_ne/EBSapps/patch
$

Here the patches are for AP module



$ adop phase=apply patches=17637775,17539845 merge=yes

RUN file system context file: /inst122i/applmgr/fs2/inst/apps/INST122I_testserver01/appl/admin/INST122I_testserver01.xml
PATCH file system context file: /inst122i/applmgr/fs1/inst/apps/INST122I_testserver01/appl/admin/INST122I_testserver01.xml

************* Start of  session *************
 version: 12.2.0
 started at: Sun Nov 17 2013 01:33:54

APPL_TOP is set to /inst122i/applmgr/fs2/EBSapps/appl
  Using ADOP Session ID from currently incomplete patching cycle
[START 2013/11/17 01:34:28] adzdoptl.pl run
  ADOP Session ID: 9
  Phase: apply
  Log file: /inst122i/applmgr/fs_ne/EBSapps/log/adop/9/adop_20131117_013331.log
      [EVENT]     Calling: /inst122i/applmgr/fs2/EBSapps/appl/ad/12.0.0/bin/admerge.pl
  [START 2013/11/17 01:35:10] apply phase
    Calling: adpatch  workers=4      flags=autoskip   console=no interactive=no  defaultsfile=/inst122i/applmgr/fs1/EBSapps/appl/admin/INST122I_patch/adalldefaults.txt patchtop=/inst122i/applmgr/fs2/EBSapps/appl/admin/INST122I/log/ADOP_MRG_20131117_1384673684 driver=u_3312281727.drv logfile=u_3312281727.log
  [END   2013/11/17 01:40:58] apply phase
 [END   2013/11/17 01:41:13] adzdoptl.pl run
adop phase=apply - Completed Successfully

Log file: /inst122i/applmgr/fs_ne/EBSapps/log/adop/9/adop_20131117_013331.log

adop exiting with status = 0 (Success)
$



AD Merge in the background

************* Start of AD Merge Patch session *************
AD Merge Patch version: 12.0.0
AD Merge Patch started at: Sun Nov 17 2013 01:35:05

Options : "-s /inst122i/applmgr/fs2/EBSapps/appl/admin/INST122I/log/ADOP_MRG_20131117_1384673684/src -d /inst122i/applmgr/fs2/EBSapps/appl/admin/INST122I/log/ADOP_MRG_20131117_1384673684 -merge_name 3312281727 -logfile /inst122i/applmgr/fs_ne/EBSapps/log/adop/9/apply_20131117_013331/INST122I_testserver01/admrgpch.log -console off "

Executing the merge of the patch drivers


  2 unified drivers merged.

Patch merge completed successfully

$ adop -status

Enter the APPS username: apps
Enter the APPS password:


Current Patching Session ID: 9

Node Name     Node Type     Phase      Status        Started                   Finished                  Elapsed
--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
testserver01  master        APPLY      ACTIVE        17-NOV-13 01:35:15 -06:00        17-NOV-13 01:40:59 -06:00    0:05:44
                           PREPARE     COMPLETED          17-NOV-13 12:46:19 -06:00        17-NOV-13 01:00:28 -06:00        0:14:09
                           CUTOVER     NOT STARTED
                           CLEANUP     NOT STARTED
$

SQL> select ADOP_SESSION_ID,NODE_NAME, APPLTOP_ID, BUG_NUMBER,PATCH_TOP,DRIVER_FILE_NAME from ad_adop_session_patches where ADOP_SESSION_ID=9 and APPLIED_FILE_SYSTEM_BASE like '%fs1%';

ADOP_SESSION_ID NODE_NAME    APPLTOP_ID BUG_NUMBER     PATCH_TOP                                       DRIVER_FILE_NAME
--------------- ------------ ---------- --------------- ------------------------------------------------------- ------------------
             9 testserver01     195 17539845     /inst122i/applmgr/fs_ne/EBSapps/patch                  u_3312281727.drv
             9 testserver01     195 17637775     /inst122i/applmgr/fs_ne/EBSapps/patch                  u_3312281727.drv

SQL>


Popular Posts