AutoUpgrade Fails with PLS-00905: MDSYS.DBMS_REGISTRY Invalid After Post-Patching Step
(Doc ID 3062313.1)
Last updated on DECEMBER 09, 2024
Applies to:
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/A
Gen 2 Exadata Cloud at Customer - Version N/A to N/A [Release All Releases]
Information in this document applies to any platform.
Symptoms
Examine the errors logged in this file autoupgrade_err.log:
Patch 36233263 apply (pdb CDB$ROOT): WITH ERRORS
logfile: <ORACLE_BASE>//sqlpatch/36233263/25638263/36233263_apply_XYZDatabase_CDBROOT_Timestamp.log (errors)
-> Error at line 125819: script md/admin/catsem.sql
- ORA-06550: line 10, column 22:
- PLS-00905: object MDSYS.DBMS_REGISTRY is invalid
- ORA-06550: line 10, column 5:
- PL/SQL: Statement ignored
- ORA-06550: line 11, column 22:
- PLS-00905: object MDSYS.DBMS_REGISTRY is invalid
- ORA-06550: line 11, column 5:
- PL/SQL: Statement ignored
-> Error at line 125849: script md/admin/catsem.sql
- SP2-1506: START, @ or @@ command has no arguments
-> Error at line 125860: script md/admin/catsem.sql
- SP2-1506: START, @ or @@ command has no arguments
ru_logfile: <ORACLE_BASE>/sqlpatch/36233263/25638263/36233263_ru_apply_XYZDatabase_CDBROOT_Timestamp.log (errors)
-> Error at line 574: script dbmscr.sql
- ORA-06550: line 4, column 33:
- PL/SQL: ORA-00942: table or view does not exist
- ORA-06550: line 4, column 3:
- PL/SQL: SQL Statement ignored
-> Error at line 807: script dbmscr.sql
- ORA-06550: line 4, column 33:
- PL/SQL: ORA-00942: table or view does not exist
- ORA-06550: line 4, column 3:
- PL/SQL: SQL Statement ignored
-> Error at line 1093: script dbmscr.sql
- Warning: Package created with compilation errors.
-> Error at line 1108: script dbmscr.sql
- PLS-00201: identifier 'REGISTRY$.VERSION' must be declared
-> Error at line 1213: script dbmscr.sql
- Warning: Package created with compilation errors.
-> Error at line 1225: script dbmscr.sql
- PLS-00710: Pragma SUPPLEMENTAL_LOG_DATA cannot be specified here
-> Error at line 1228: script dbmscr.sql
- PLS-00710: Pragma SUPPLEMENTAL_LOG_DATA cannot be specified here
-> Error at line 1236: script dbmscr.sql
- PLS-00710: Pragma SUPPLEMENTAL_LOG_DATA cannot be specified here
-> Error at line 1244: script dbmscr.sql
- PLS-00710: Pragma SUPPLEMENTAL_LOG_DATA cannot be specified here
-> Error at line 1247: script dbmscr.sql
- PLS-00710: Pragma SUPPLEMENTAL_LOG_DATA cannot be specified here
-> Error at line 1255: script dbmscr.sql
- PLS-00710: Pragma SUPPLEMENTAL_LOG_DATA cannot be specified here
-> Error at line 1258: script dbmscr.sql
- PLS-00710: Pragma SUPPLEMENTAL_LOG_DATA cannot be specified here
-> Error at line 1266: script dbmscr.sql
- PLS-00710: Pragma SUPPLEMENTAL_LOG_DATA cannot be specified here
-> Error at line 1274: script dbmscr.sql
- PLS-00710: Pragma SUPPLEMENTAL_LOG_DATA cannot be specified here
From 36233263_apply_XYZDatabase_CDBROOT_Timestamp.log:
line 121214:
SQL> CREATE OR REPLACE PACKAGE BODY mdsys.sdo_util wrapped
2 a000000
...
line 111008:
Warning: Package Body created with compilation errors.
Elapsed: 00:00:00.22
SQL> SHOW ERRORS;
Errors for PACKAGE BODY MDSYS.SDO_UTIL:
LINE/COL
--------------------------------------------------------------------------------
ERROR
--------------------------------------------------------------------------------
2137/10
PL/SQL: Statement ignored
2137/36
PLS-00302: component 'RECTIFY_GEOM_13350' must be declared
LINE/COL
--------------------------------------------------------------------------------
ERROR
--------------------------------------------------------------------------------
SQL> /
Warning: Package Body created with compilation errors.
Elapsed: 00:00:00.11
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 |