[UNEXPECTED]Data dictionary corruption - timestamp mismatch
Issue:
Log: /obin/oracle/EBSCNV2E/fs_ne/EBSapps/log/adop/55/20200719_042953/adop.log
===========================================================================
Validating configuration on node: [appsserver1].
Log: /obin/oracle/EBSCNV2E/fs_ne/EBSapps/log/adop/55/20200719_042953/prepare/validate/appsserver
[WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
[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
APPS RCV_LCM_WEB_SERVICE V_20190112_0223 APPS INL_INTEGRATION_GRP V_20190112_0223 TS mismatch: 18-MAR-19 03:10:47 07-JUL-20 23:09:30
APPS INV_RULE_GEN_PVT V_20191026_0338 APPS GMI_RESERVATION_UTIL V_20191026_0338 TS mismatch: 26-OCT-19 06:18:01 07-JUL-20 23:11:40
APPS GMI_MO_PURGE V_20191026_0338 APPS GMI_RESERVATION_UTIL V_20191026_0338 TS mismatch: 26-OCT-19 06:18:01 07-JUL-20 23:11:40
APPS GMI_PICK_RELEASE_PUB V_20191026_0338 APPS GMI_RESERVATION_UTIL V_20191026_0338 TS mismatch: 26-OCT-19 06:18:01 07-JUL-20 23:11:40
APPS PA_PURGE_COSTING V_20190112_0223 APPS PAAPIMP_PKG V_201
SOLUTION:
SQL> !vi $AD_TOP/patch/115/sql/adzddtsfix.sql
SQL> @$AD_TOP/patch/115/sql/adzddtsfix.sql
exec dbms_utility.invalidate(5666082,NULL,0);
exec dbms_utility.invalidate(6541212,NULL,0);
SQL> !vi adzddtsfixout.sql
SQL> @adzddtsfixout.sql
PL/SQL procedure successfully completed.
SQL> @$ORACLE_HOME/rdbms/admin/utlrp
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2020-07-19 04:43:19
and Re-check the issue, it will be done :) Enjoy
