3 Replies Latest reply on Mar 16, 2017 1:43 PM by Prashant Umap

    adop phase=finalize is stuck

    User12337941-Oracle

      Hello All,

       

       

                We have upgraded one of our customers instance from 12.1 o 12.2.5 recently and have been applying patches within a patching cycle comfortably until today.

       

      After applying couple of small sized patches related to CSI and EAM suggested by support, we are unable to get passed finalize stage within the patching cycle.

       

      ===============================================================

      Node Name       Node Type  Phase           Status          Started              Finished             Elapsed

      --------------- ---------- --------------- --------------- -------------------- -------------------- ------------

      oraclevm-test   master     PREPARE         COMPLETED       2017/03/15 04:00:37  2017/03/15 04:04:39  0:04:02

                                 APPLY           ACTIVE          2017/03/15 04:40:17  2017/03/15 04:50:23  0:10:06

                                 FINALIZE        RUNNING         2017/03/15 04:52:48                      1:58:31

                                 CUTOVER         NOT STARTED

                                 CLEANUP         NOT STARTED

       

      finalize has taken about 2 hours but seems like nothing is happening in actual. Below is the snippet from the log file,

       

       

      [STATEMENT] SQL statement: "  select count(1)

        from  ad_adop_sessions

        where  adop_session_id=16 and (prepare_status in ('N','R')) and node_name='oraclevm-test'

      "

      [STATEMENT] SQL Output: "0".

      [PROCEDURE] [END   2017/03/15 05:52:51] Checking status of phase

      [PROCEDURE] [START 2017/03/15 05:52:51] Giving prompt for failed patches to user

      [PROCEDURE] [START 2017/03/15 05:52:51] Getting list of failed patches

      [PROCEDURE] [END   2017/03/15 05:52:51] Getting list of failed patches

      [PROCEDURE] [END   2017/03/15 05:52:51] Giving prompt for failed patches to user

      [PROCEDURE] [START 2017/03/15 05:52:51] Running finalize phase

      [PROCEDURE] [START 2017/03/15 05:52:51] Updating adop session status

      [PROCEDURE] [START 2017/03/15 05:52:52] Updating session process ID

      [PROCEDURE] [END   2017/03/15 05:52:52] Updating session process ID

      [STATEMENT] SQL statement : "  update ad_adop_sessions

        set status='R'

         where adop_session_id = 16 and appltop_id = 128 and node_name='oraclevm-test'

      "

      [PROCEDURE] [END   2017/03/15 05:52:52] Updating adop session status

      [PROCEDURE] [START 2017/03/15 05:52:52] Updating session status

      [STATEMENT] Updating apply_status=Y for session ID : 16

      [PROCEDURE] [END   2017/03/15 05:52:52] Updating session status

      [PROCEDURE] [START 2017/03/15 05:52:52] Updating session status

      [PROCEDURE] [START 2017/03/15 05:52:52] Identifying non-abandoned nodes

      [PROCEDURE] [START 2017/03/15 05:52:52] Checking if oraclevm-test was abandoned

      [PROCEDURE] [END   2017/03/15 05:52:52] Checking if oraclevm-test was abandoned

      [PROCEDURE] [END   2017/03/15 05:52:52] Identifying non-abandoned nodes

      [STATEMENT] Updating finalize_status=R for session ID : 16

      [PROCEDURE] [END   2017/03/15 05:52:52] Updating session status

      [PROCEDURE] [START 2017/03/15 05:52:52] Performing finalize phase

      [STATEMENT] Sourcing Patch edition environment /u01/app/oratest/fs1/EBSapps/appl/APPSTEST12_oraclevm-test.env

       

       

      [EVENT]     Verifying data dictionary.

       

       

      It seems like its stuck at Verifying data dictionary step. Could you please have a look and suggest if I can look for anything in specific on my system to understand the issue here.

       

      Thanks,

      Chandan