Actulaize_all stuck

Posted by sravan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Actulaize-all-stuck-tp9084.html

HI ,

1)Actualize_all is stuck and not proceeding.

2)Checked @$AD_TOP/sql/ADZDSHOWOBJS.sql  stub objects and actual objects from all the editions should move to latest edition and it is same. It been more than 12 hours and it it stuck at same step

Below is the adop status

===============================================================
Node Name       Node Type  Phase           Status          Started              Finished             Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
loc4au01        master     PREPARE         COMPLETED       xxxxx7  xxxxxxx  0:27:58
                           APPLY           NOT STARTED
                           FINALIZE        NOT STARTED
                           CUTOVER         NOT STARTED
                           CLEANUP         NOT STARTED



File System Synchronization Type: Full

3)adzdshowlog shows below

 149413824 11:16:47 00:00:00 ad.bin.adop                                EVENT      Populating actualize actions in DDL handler table.
 149413824 11:16:47 00:00:00 ad.bin.adop                                EVENT      Clearing old rows from DDL handler table.
 149413824 11:16:47 00:00:00 ad.plsql.ad_zd_parallel_exec.cleanup       STATEMENT  Cleanup DDL handler, phase=ACTUALIZE_PARENT_OBJS
 149413824 11:16:47 00:00:00 ad.plsql.ad_zd_parallel_exec.cleanup       STATEMENT  Cleanup DDL handler, phase=ACTUALIZE_CHILD_OBJS
 149413824 11:16:47 00:00:00 ad.bin.adop                                EVENT      Populating DDLs.
 149413824 11:16:47 00:00:00 ad.bin.adop                                EVENT      Log: @ADZDSHOWLOG.sql "2020/12/01 11:16:47"
      5930 11:16:47 00:00:00 ad.plsql.ad_zd_sys.actualize_all           PROCEDURE  begin
      5930 11:16:47 00:00:00 ad.plsql.ad_zd_sys.actualize_all           EVENT      Actualize AD_ZD% packages
      5930 11:16:48 00:00:00 ad.plsql.ad_zd_sys.actualize_all           EVENT      Actualize all editioned objects

4) No errors in db alert log

5)adopmon shows as below

Timestamp           Node name           Message Type Message Text
---------------------------------------------------------------------------------------------------------------------------
2020/11/24 12:41:33 abcd             EVENT        Log: xxxxxapps/fs_ne/EBSapps/log/adop/60/20201124_123224/va
                                                     lidate/adopConsole.log
2020/11/24 12:41:33 loc4au01            EVENT        ======================================================================
                                                     =====

2020/11/24 12:41:33 abcd            EVENT        Checking for existing patching cycle.
2020/11/24 12:41:33 abcd             EVENT        Existing patching cycle exists with session ID: 60
2020/11/24 12:41:34 abcd            EVENT        Running adop validations on node: [loc4au01].
2020/11/24 12:41:34 abcd            EVENT        Log: loc4au01: xxxxapps/fs_ne/EBSapps/log/adop/60/20201124
                                                     _123224/validate/loc4au01
2020/11/24 12:41:36 abcd            EVENT        Running adop validations.
2020/11/24 12:41:36 abcd           EVENT        Node registry is valid.
2020/11/24 12:41:47 abcd            EVENT        Running TXK validations.

6) select count(*) from dba_editions;

  COUNT(*)
----------
        27

Please assist