Thursday, 8 September 2022

adop phase=finalize failed with Data dictionary corrupted

ADOP (C.Delta.12)
Session ID: 17
Node: apapp1
Phase: finalize

Log: /d01/oracle/apps/fs_ne/EBSapps/log/adop/17/20220829_153322/adop.log

Verifying existence of context files in database.

Verifying data dictionary.
    [UNEXPECTED]Data dictionary corrupted:
    [UNEXPECTED]Data dictionary corruption - timestamp mismatch
    XCSCHEM         XCSHEMA_ADDRESS_ORG   V_20220821_1154 APPS   CSHEMA_ADDRESS_ORG  V_20220821_1154 TS mismatch: 21-AUG-22 13:14:03 21-AUG-22 13:39:18
    [UNEXPECTED] Follow the instructions in the "Fix data dictionary corruption"
    [UNEXPECTED] section of My Oracle Support Knowledge Document 1531121.1 .

  [UNEXPECTED]Finalize phase has failed.
    Summary report for current adop session:
    Node applapp1: Failed
        - Finalize status:   Failed
    Node applapp2: Completed successfully
      - Finalize status:   Running
    Node applapp3: Completed successfully
        - Finalize status:   Running


 Solution:

     Run below script as apps user as per Doc ID 1531121.1 ( Section 3.1)

sqlplus apps/<pwd> @$AD_TOP/patch/115/sql/adzddtsfix.sql
sqlplus apps/<pwd> @$AD_TOP/patch/115/sql/adzddtsfixout.sql

No comments:

Post a Comment