Thursday, December 5, 2013

Prepare Phase Scenario 2 - R12.2 Online Patching Cycle

Scenario

You have been asked to apply a patch and you start with the first phase “PREPARE”.


Background

Another engineer has already run the prepare phase and for some reasons the engineer did not proceed further.


$ adop phase=prepare

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

 Please wait. Validating credentials...


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

************* Start of  session *************
 version: 12.2.0
 started at: Thu Nov 14 2013 19:01:37

APPL_TOP is set to /inst122i/applmgr/fs1/EBSapps/appl
  Using ADOP Session ID from currently incomplete patching cycle
[START 2013/11/14 19:02:11] adzdoptl.pl run
  ADOP Session ID: 5
  Phase: prepare
  Log file: /inst122i/applmgr/fs_ne/EBSapps/log/adop/5/adop_20131114_190115.log
  Prepare phase seems to be already done
[END   2013/11/14 19:02:22] adzdoptl.pl run
Log file: /inst122i/applmgr/fs_ne/EBSapps/log/adop/5/adop_20131114_190115.log

adop exiting with status = 0 (Success)
$



  
The below code is checked against the database to know the previous status

[START 2013/11/14 19:02:11] adzdoptl.pl run
  ADOP Session ID: 5
  Phase: prepare
  [STATEMENT] SQL Statement: <    select count(1)
      from  ad_adop_sessions
      where  adop_session_id=5 and (prepare_status in ('N','R'))>.
  [STATEMENT] SQL Output: <0>.
  Prepare phase seems to be already done
  [STATEMENT] Patch Edition Name: V_20131114_1559

Y denotes that the phase is done
N denotes that the phase has not been completed
X denotes that the phase is not applicable
R denotes that the phase is running (in progress) or ran
F denotes that the phase has failed
P (is applicable only to APPLY phase) denotes at least one patch is already applied for the session id)

Status is N then ADOP will prompt that the previous prepare phase was incomplete and it will resume again.

Popular Posts