Dictionary Corrupted while running ADOP Prepare phase: TS mismatch error
Error:
While running adop prepare getting below error
prepare phase
[UNEXPECTED]Dictionary Corrupted:
[START 2023/02/12 18:35:14] Data Dictionary Corruption Details
Solution:
shutdown immediate
startup upgrade
@?/rdbms/admin/utlirp.sql
shutdown immediate
startup
@?/rdbms/admin/utlrp.sql (Recompile invalid objects)
You can run the script “ADZDDBCC.sql” from $AD_TOP which is the online patching database compliance checker to make sure we are all set to call adop.
$AD_TOP/sql/ADZDDBCC.sql
Or run ADZDDTFIX.sql from the patch 17268684.
For me, the output for Timestamp issue is as below showing no rows selected.
Elapsed: 00:00:10.47
DOC> **********************************************************************
DOC> SECTION-2
DOC> **********************************************************************
DOC> Timestamp mismatch or missing parent in data-dictionary
DOC>
DOC> – P1: If these checks return any rows, please follow the instructions in
DOC> “Fix data dictionary corruption” section of My Oracle Support Knowledge Document 1531121.1.
DOC>
DOC> Note: Online Patching cycles must not be attempted until all
DOC> errors in this section are resolved.
DOC>#
no rows selected
Now run adop phase=prepare again.
Post a Comment
Post a Comment