R12.2

[Syed Tanweer Ali]

Hi Erman,

Need your valuable suggestions

we are running prepare phase and in middle of prepare phase we have a network issue and putty session was expired.

Validating configuration on node->done
Detecting configuration changes->no changes->done
Creating database patch edition->done
Running steps for CLONE
Beginning application tier FSCloneStage->done
Beginning application tier FSCloneApply->running--network issue occured here

[applscp@motral1 ~]$
[applscp@motral1 ~]$ adop -status


Enter the APPS password:
Connected.

==============================================================
ADOP (C.Delta.7)
Session Id: 13
Command: status
Output: /u02/APPSP/fs_ne/EBSapps/log/status_20170822_163156/adzdshowstatus.out
===============================================================

Node Name       Node Type  Phase           Status          Started              Finished             Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
motral1         master     PREPARE         RUNNING         2017/08/22 14:16:10
                           APPLY           NOT STARTED
                           FINALIZE        NOT STARTED
                           CUTOVER         NOT STARTED
                           CLEANUP         NOT STARTED



unable to continue as existing session is found.


SQL> select ADOP_SESSION_ID,PREPARE_STATUS,APPLY_STATUS,FINALIZE_STATUS,CUTOVER_STATUS,CLEANUP_STATUS,ABORT_STATUS,STATUS,ABANDON_FLAG,NODE_NAME from AD_ADOP_SESSIONS order by ADOP_SESSION_ID;

ADOP_SESSION_ID P A F C C A S ABANDON_FLAG NODE_NAME
--------------- - - - - - - - ------------ -------------------------------
         
              8 X Y X X Y X C              motral1
              9 Y Y Y Y Y X C              motral1
             11 Y Y Y Y Y X C              motral1
             12 Y N N N Y Y C              motral1
             13 R N N N N N R           13 motral1---this one

9 rows selected.

SQL> select ADOP_SESSION_ID, BUG_NUMBER, STATUS, APPLIED_FILE_SYSTEM_BASE, PATCH_FILE_SYSTEM_BASE, ADPATCH_OPTIONS, NODE_NAME, END_DATE, CLONE_STATUS from ad_adop_session_patches where ADOP_SESSION_ID=13;

no rows selected

SQL>
We have ran abort here and done a full cleanup.But we would like to know without performing abort is there anyway to restart the adop prepare phase.

[ErmanArslansOracleBlog]

I think you did the right thing Syed.

Next time, dont use putty or any remote terminal connections when doing these kinds of critical activities.
Do these activities via VNC or via a terminal connected directly to the local (like a serial connection or ILOM)

Also, according to this thread, there is timeout .. 3h maybe. (I didn't test it yet.)
Read this -> http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/R12-2-td3306.html