My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.