Preupgrade fixups script Fails with ORA-06512 SYS.DBMS_SPACE_ADMIN ORA-04063 SYS.DBMS_PREUP
(Doc ID 3069041.1)
Last updated on FEBRUARY 06, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.1.0.2 [Release 12.2 to 12.1]Information in this document applies to any platform.
Symptoms
Database upgrade from 12c to 19c preupgrade fixup script fails
$ORACLE_HOME/jdk/bin/java -jar $ORACLE_19_HOME/rdbms/admin/preupgrade.jar FILE TEXT DIR /opt/stage/19c/preupgrade-utility-logs
INFORMATION - 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.
+++ execPreUpgrade_catCon0.log +++
SQL> SET FEEDBACK OFF
SQL> SET TERMOUT OFF
ORA-06512: at "SYS.DBMS_PREUP", line 4179
ORA-06512: at "SYS.DBMS_PREUP", line 11285
ORA-06512: at line 8
declare
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_SPACE_ADMIN" has errors
ORA-06512: at line 56
ORA-06512: at "SYS.DBMS_PREUP", line 4179
ORA-06512: at "SYS.DBMS_PREUP", line 11285
ORA-06512: at line 8
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 |
| Cause |
| Solution |
| References |