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