adop phase prepare failed-[UNEXPECTED]Data dictionary corruption - timestamp mismatch

adop phase prepare failed-[UNEXPECTED]Data dictionary corruption - timestamp mismatch



bash-5.0$ adop phase=prepare

adop phase prepare failed-[UNEXPECTED]Data dictionary corruption - timestamp mismatch

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:


Validating credentials.


Initializing.

    Run Edition context  : /erp_appl/apps/fs2/inst/apps/ERPDEV_node1/appl/admin/ERPDEV_node1.xml

    Patch edition context: /erp_appl/apps/fs1/inst/apps/ERPDEV_node1/appl/admin/ERPDEV_node1.xml

    Patch file system free space: 508.37 GB


Validating system setup.

    Node registry is valid.

    [WARNING]   SYS.DUAL table has incorrect privileges

                Shut down the application tier services and then run the following commands in the order shown

                   sqlplus apps/<APPS_Password> @ $AD_TOP/patch/115/sql/ADFIXUSER.sql

                   sqlplus apps/<APPS_Password> @ $AD_TOP/sql/adutlrcmp.sql


Checking for existing adop sessions.

    No pending session exists.

    Starting new adop session.


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

ADOP (C.Delta.12)

Session ID: 67

Node: node1

Phase: prepare

Log: /erp_appl/apps/fs_ne/EBSapps/log/adop/67/20230913_115355/adop.log

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


Validating configuration on node: [node1].

    Log: /erp_appl/apps/fs_ne/EBSapps/log/adop/67/20230913_115355/prepare/validate/node1

        [WARNING]: Either some of the required entries in /etc/hosts file might be missing (e.g. localhost or hostname) OR the file /etc/hosts could not be read.


Verifying data dictionary.

    [UNEXPECTED]Data dictionary corrupted:

    [UNEXPECTED]Data dictionary corruption - timestamp mismatch


Solution


SQL>  @$AD_TOP/patch/115/sql/adzddtsfix.sql

then

execute the output of above script in apps schema



appsdbahelp

17+ years of experience in Oracle Database, Oracle Cloud Infrastructure(OCI), Oracle EBS on Cloud, Oracle E-Business Suite, DevOps tools, Oracle WebLogic, Oracle Application Server, Oracle Access Manager and various Operating System flavors including Redhat Linux, UNIX (Solaris, HP-UX) and Windows. Expert in Oracle9i/10g/11g/12c/19c database administration, upgrade, configuration and tuning. Experience in Oracle E-Business Suite technological stack, including architecture, installation, configuration, maintenance, tuning, cloning and patching procedures. Expert in Oracle Cloud Infrastructure(OCI), Oracle EBS On Cloud and Oracle EBS Cloud Manager Experience with Oracle Cloud Solution and Expert of Oracle ERP/Oracle HCM Cloud deployment Experience in Terraform, JSON and chef cloud infrastructure automation framework Knowledge of ASM, Data Guard, Real Application Cluster, Exadata and Exalogic Knowledge of Oracle Enterprise Manager(OEM) Grid Control, Oracle WebLogic, Oracle Internet Directory, Oracle Access Manager and Apache Ability to analyze problem, develops solutions and bring program/project execution to completion.

Post a Comment

Previous Post Next Post