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.

Status is R then ADOP will exit telling that an active ADOP session is running with the prepare phase.

Prepare Phase  - Scenario

You have been asked to apply a patch and you start with the first phase “PREPARE”. Customer has recently applied two patches during the last downtime window.

You have been asked to apply a patch and you start with the first phase “PREPARE”. Another engineer has already run the prepare phase and for some reasons the engineer did not proceed further.

You have been asked to apply a patch and you start with the first phase “PREPARE”. Your terminal got disconnected when prepare phase was running or there was an outage and server got rebooted.

You have been asked to apply a patch after a fresh installation of R12.2.X. So you are running PREPARE phase for the first time on the instance.