R12.2 Apps DBA. Powered by Blogger.

fs_clone error : adop exiting with status = 2 (Fail)

No comments :
Solution:
adop phase=fs_clone force=yes
========================
  I think the issue hit the following note:
Adop Fs_clone Fails with ORA-00936: missing expression ( Doc ID 2050946.1 )
From fs_clone_20151026_201319.tar\fs_clone_20151026_201319\apdba_blogspot02>>>remote_execution_result_20151026_201910.xml,
we can find error:
SQL> SQL> Connected.
SQL> SELECT clone_status||',' FROM ad_adop_session_patches WHERE status in ('R','F','N') AND bug_number = 'CLONE' AND node_name = 'apdba02' AND adop_session_id =
ERROR at line 1:
ORA-00936: missing expression
And from diagnostic_info_apdba02.tar\diagnostic_info_apdba02\diagnostic_info\adop_info>>>>adzdshowstatus.out,
we can find
====================================================================== Summary of the Last 10 ADOP Cycles
======================================================================
Session ID Node Name Node Type Started Elapsed(Prepare) Elapsed(Cutover) Elapsed(Cleanup) Elapsed(Apply) Status Patches Applied Session Type
---------- ---------- --------- ---------- ---------------- ---------------- ---------------- --------------- ------------ -------------------- ---------------
17 apdba master 26-OCT-15 1:48:10 0:00:00 0:02:25 0:00:00 FAILED CONFIG_CLONE CONFIG_CLONE
02
The same with Adop Fs_clone Fails with ORA-00936: missing expression ( Doc ID 2050946.1 ).
So please kindly try :
=================
1. Take a back up for table ad_adop_session_patches.
2. Run the following sql:
update ad_adop_session_patches set
bug_number='CLONE',status='N',SESSION_TYPE='CLONE',CLONE_STATUS='NOT STARTED'
where bug_number='CONFIG_CLONE' and status <> 'Y' and adop_Session_id=<*> ;
commit;
Where <*> = the session_id related to the CONFIG_CLONE row, in above example eg. adop_Session_id= '11'.
3. Re-run adop phase=fs_clone to confirm the results.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.