Categories
MDSYS issues upgrading from Oracle 11G to 19C
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.