|
1160 posts
|
Hi Erman,
Good Day
Issue:
we are runnnig prepare phase and due to network outage putty session was expired.we tried to run prepare phase again but unable to continue as existing sesison found.
Enter the APPS password:
Connected.
==============================================================
ADOP (C.Delta.7)
Session Id: 13
Command: status
Output: /u02/testapps/fs_ne/EBSapps/log/status_20170822_163156/adzdshowstatus.out
===============================================================
Node Name Node Type Phase Status Started Finished Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
mrtoa1 master PREPARE RUNNING 2017/08/22 14:16:10
APPLY NOT STARTED
FINALIZE NOT STARTED
CUTOVER NOT STARTED
CLEANUP NOT STARTED
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 mrtoa1
9 Y Y Y Y Y X C mrtoa1
11 Y Y Y Y Y X C mrtoa1
12 Y N N N Y Y C mrtoa1
13 R N N N N N R 13 mrtoa1-------->this is the 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
As we are unable to continue,we ran abort and full clean up and started the prepare phase and it went completed successfully.
We wanted to know is there any other option instead of running abort in this case.
Thanks
|
Locked
Aug 23, 2017; 2:48am
