invalid MDSYS objects after applying 19.14 patch
rdbms 19c
windows 2019
After applying the 19.14 patch we see about 45 invalid objects for MDSYS in the PDB (CDB is fine).
Trying to recomile:
SQL> alter package mdsys.sdo_meta compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors
Errors for PACKAGE BODY MDSYS.SDO_META:
LINE/COL ERROR
-------- -----------------------------------------------------------------
37/3 PL/SQL: Statement ignored
37/8 PLS-00905: object MDSYS.SDO_UTIL is invalid
Trying the SDO_UTIL:
SQL> alter package mdsys.sdo_util compile;
Warning: Package altered with compilation errors.
SQL> show errors
Errors for PACKAGE MDSYS.SDO_UTIL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated