SYS.DBMS_JAVA objects becoming invalid after 18C -> 19C SE2 DB upgrade
Hi.
After successful unplug & plug of PDB from Oracle SE2 18.3 to SE2 Version 19.18.0.0.0, the PDB upgrade procedure fails due to SYS.DBMS_JAVA objects becoming invalid.
Some of the errors:
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
ORA-04063: package body "SYS.DBMS_JAVA" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_JAVA"
ORA-06512: at line 1
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Status of of JAVA objects:
OBJECT_NAME OBJECT_TYPE STATUS
---------------------------------------------------------------
DBMS_JAVA PACKAGE VALID
DBMS_JAVA PACKAGE BODY INVALID
DBMS_JAVA SYNONYM INVALID
DBMS_JAVASCRIPT PACKAGE INVALID
DBMS_JAVASCRIPT PACKAGE BODY INVALID
DBMS_JAVASCRIPT SYNONYM INVALID
DBMS_JAVA_DUMP PACKAGE BODY INVALID
---------------------------------------------------------------
Looked in support pages, could not find workaround or solution for this specific error and this DB version.