Preupgrade Script Fails. ORA-04023: Object select count(1) from DBA_TAB_STATISTICS could not be validated or authorized
(Doc ID 2875464.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.13.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Preupgrade.jar fails with:
Preupgrade was executed, but there are some errors in some pluggable databases, please review *.lst and *.log files
ERROR - Unable to run the preupgrade due to: Please review the preupgrade logs (*.log and/or *.lst files) for further information.
ERROR - Unable to run the preupgrade due to: Please review the preupgrade logs (*.log and/or *.lst files) for further information.
preupgrade_fixups.sql
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if
if
execPreUpgrade_catCon0.log
check "dictionary_stats" raised the following exception and did not complete.
ORA-04023: Object select count(1)
from DBA_TAB_STATISTICS
where table_name ='SEQ$'
and last_analyzed > sysdate -1 could not be validated or authorized
ORA-06512: at "SYS.DBMS_PREUP", line 7543
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 5482
ORA-04023: Object select count(1)
from DBA_TAB_STATISTICS
where table_name ='SEQ$'
and last_analyzed > sysdate -1 could not be validated or authorized
ORA-06512: at "SYS.DBMS_PREUP", line 7543
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 5482
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 |
| References |