My Oracle Support Banner

Upgrade Error : ORA-06508:"MDSYS.MDPRVT_IDX" While Upgrading To 18c or 19c (Doc ID 2564118.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Spatial and Graph - Version 18.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

While upgrading a database to 18.0.0.0 or 19.0.0.0.0, the following errors occurred:

Identifier ORDIM 19-04-26 04:16:55
SCRIPT  = [/oracle/db/18.0.0.0/md/admin/prvtimd.plb]
ERROR  = [ORA-04067: not executed, package body "MDSYS.MDPRVT_IDX" does not exist
ORA-06512: at line 206
ORA-06508: PL/SQL: could not find program unit being called: "MDSYS.MDPRVT_IDX"
ORA-06512: at "MDSYS.SDO_INDEX_METADATA_UPDATE", line 4
ORA-04088: error during execution of trigger 'MDSYS.SDO_INDEX_METADATA_UPDATE'
ORA-06512: at line 199
]

...
...

Component                               Current         Full     Elapsed Time
Name                                    Status          Version  HH:MM:SS

Oracle Server
...
...
Oracle Multimedia
   ORA-04067: not executed, package body "MDSYS.MDPRVT_IDX" does not exist
   ORA-06512: at line 206
   ORA-06508: PL/SQL: could not find program unit being called:"MDSYS.MDPRVT_IDX"
   ORA-06512: at "MDSYS.SDO_INDEX_METADATA_UPDATE", line 4
   ORA-04088: error during execution of trigger 'MDSYS.SDO_INDEX_METADATA_UPDATE'
   ORA-06512: at line 199
Oracle Multimedia                       INVALID      18.3.0.0.0  00:02:57

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


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