EBS 12.2 ADOP Prepare Phase Fails with Error: [UNEXPECTED]Data dictionary corruption - timestamp mismatch
(Doc ID 2981244.1)
Last updated on JANUARY 30, 2024
Applies to:
Oracle Applications DBA - Version 12.2.3 to 12.2.12 [Release 12.2Cloud to 12.2]Information in this document applies to any platform.
Symptoms
When trying to run ADOP prepare phase, the following error occurs.
ERROR:
Below error can be found in the adopshowlog.out.
Verifying data dictionary.
[UNEXPECTED]Data dictionary corrupted:
[UNEXPECTED]Data dictionary corruption - timestamp mismatch
APPS <DEPENDENT CUSTOM OBJECT> V_20230219_1819 APPS <PARENT CUSTOM OBJECT> ORA$BASE TS mismatch: 14-NOV-22 08:59:51 28-JUL-23 20:13:00
APPS <DEPENDENT CUSTOM OBJECT> V_20230328_2121 APPS <PARENT CUSTOM OBJECT> ORA$BASE TS mismatch: 08-MAY-23 17:37:58 28-JUL-23 20:13:00
[UNEXPECTED] Follow the instructions in the "Fix data dictionary corruption"
[UNEXPECTED] section of My Oracle Support Knowledge Document 1531121.1 .
[UNEXPECTED]Data dictionary corrupted:
[UNEXPECTED]Data dictionary corruption - timestamp mismatch
APPS <DEPENDENT CUSTOM OBJECT> V_20230219_1819 APPS <PARENT CUSTOM OBJECT> ORA$BASE TS mismatch: 14-NOV-22 08:59:51 28-JUL-23 20:13:00
APPS <DEPENDENT CUSTOM OBJECT> V_20230328_2121 APPS <PARENT CUSTOM OBJECT> ORA$BASE TS mismatch: 08-MAY-23 17:37:58 28-JUL-23 20:13:00
[UNEXPECTED] Follow the instructions in the "Fix data dictionary corruption"
[UNEXPECTED] section of My Oracle Support Knowledge Document 1531121.1 .
STEPS:
- Connect to Application tier as applmgr user and source the environment file.
- Run ADOP Prepare phase
$ adop phase=prepare
Changes
No known changes.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |