Re: FS_CLONE failure in 12.2.7

Posted by karthikmca.bhc on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/FS-CLONE-failure-in-12-2-7-tp8664p8668.html

Dear Erman,

Thaks much. I am sure and have confirmed that there is no adop/adworker or other  adop related processes running.

I tried 3 times and ended with the same issue. I can see that the failure happening during the FMW phase as adop not able to perform in that phase.

This is my test instance, so i can try manual update on ad_adop_session_patches table. Please tell me what exactly i should update on this table to fix this issue?

I performed below but still the fs_clone failed with same issue.

[applmgr@122demo scripts]$ ./adadminsrvctl.sh stop

[applmgr@122demo ~]$ adop -status -detail
===============================================================
Node Name       Node Type  Phase           Status          Started              Finished             Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
1227demo        master     FS_CLONE        FAILED          2020/08/23 18:12:16                       4:26:35


SQL> select adop_session_id,status from ad_adop_session_patches where status in('F') order by ADOP_SESSION_ID desc;

ADOP_SESSION_ID STATUS
--------------- --------------------
             13 F
             11 F
              9 F
              8 F
              7 F
              5 F
              5 F
              5 F

[applmgr@122demo ~]$ sqlplus apps/apps

SQL> create table adop_bkp_4 as (select * from ad_adop_session_patches);

Table created.

SQL> update ad_adop_session_patches set status='Y' where status='F' and adop_session_id='5';
SQL> update ad_adop_session_patches set status='Y' where status='F' and adop_session_id='7';
SQL> update ad_adop_session_patches set status='Y' where status='F' and adop_session_id='8';
SQL> update ad_adop_session_patches set status='Y' where status='F' and adop_session_id='9';
SQL> update ad_adop_session_patches set status='Y' where status='F' and adop_session_id='11';
SQL> update ad_adop_session_patches set status='Y' where status='F' and adop_session_id='13';

SQL> commit;

[applmgr@122demo scripts]$ pkill -u applmgr

unset module

[applmgr@1227demo ~]$ adop phase=cleanup cleanup_mode=full workers=10

[applmgr@122demo scripts]$ adop -status -detail
===============================================================
Node Name       Node Type  Phase           Status          Started              Finished             Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
1227demo        master     FS_CLONE                        2020/08/23 23:00:56                       0:30:50


[applmgr@122demo scripts]$ adop phase=fs_clone force=yes workers=10


Please let me know if anything else i should try to make it resolve.

Note: I cannot run 'abort' because it says there is no active adop cycle.

Thanks,
Karthik