MDSYS issues upgrading from Oracle 11G to 19C

Rocketdog
Rocketdog Member Posts: 1 Green Ribbon

I'm trying to run in 19C upgrade using dbua from oracle 11G to 19C and getting issues with MDSYS.

In brief -

No issues shown from preupgrdiag.sql - Oracle Multimedia shows valid at 11G

dbua fails with catupgrd0.log ORA-01918 user MDSYS does not exist

Tried restore and running ordinst.sql and imimdloc.sl -ref Doc ID 26130291 left 2 invalid objects sorted by grant execute on sys.dbms_lob to public

dbua fails again with

12:25:01 SQL> alter table mdsys.sdo_coord_ref_sys enable constraint COORD_REF_SYS_FOREIGN_PROJ;

alter table mdsys.sdo_coord_ref_sys enable constraint COORD_REF_SYS_FOREIGN_PROJ

*

ERROR at line 1:

ORA-02430: cannot enable constraint (COORD_REF_SYS_FOREIGN_PROJ) - no such

Constraint

12:25:02 SQL> alter table mdsys.sdo_coord_ref_sys enable constraint COORD_REF_SYS_FOREIGN_LEGACY;

alter table mdsys.sdo_coord_ref_sys enable constraint COORD_REF_SYS_FOREIGN_LEGACY

*

ERROR at line 1:

ORA-02430: cannot enable constraint (COORD_REF_SYS_FOREIGN_LEGACY) - no such

Constraint

 

12:25:02 SQL> alter table mdsys.sdo_coord_ref_sys enable constraint COORD_REF_SYS_FOREIGN_GEOG;

alter table mdsys.sdo_coord_ref_sys enable constraint COORD_REF_SYS_FOREIGN_GEOG

*

ERROR at line 1:

ORA-02430: cannot enable constraint (COORD_REF_SYS_FOREIGN_GEOG) - no such

constraint


12:25:02 SQL> alter table mdsys.sdo_coord_ref_sys enable constraint COORD_REF_SYS_FOREIGN_HORIZ;

alter table mdsys.sdo_coord_ref_sys enable constraint COORD_REF_SYS_FOREIGN_HORIZ

*

ERROR at line 1:

ORA-02430: cannot enable constraint (COORD_REF_SYS_FOREIGN_HORIZ) - no such

constraint


12:25:02 SQL> alter table mdsys.sdo_coord_ref_sys enable constraint COORD_REF_SYS_FOREIGN_VERT;

alter table mdsys.sdo_coord_ref_sys enable constraint COORD_REF_SYS_FOREIGN_VERT

*

ERROR at line 1:

ORA-02430: cannot enable constraint (COORD_REF_SYS_FOREIGN_VERT) - no such

constraint


ORA-02298: cannot validate (MDSYS.COORD_REF_SYS_FOREIGN_PROJ) - parent keys not

found

ORA-06512: at line 25

Restored database and currently testing upgrade to 12C then 19C to see if there is any difference as we have already successsfully upgraded a similar database from 11G to 12C with no MDSYS user present.

Has anyone had anything similar with any suggestions for fixes please.