Hello,

when I log in as sysdba to my db (Oracle 19c SE2 running on Oracle Linux) and run the following query

Code:
Select status from dba_registry where comp_id ='JAVAVM';
it returns "INVALID".

I followed this instruction https://smarttechways.com/2019/10/07...acle-database/ to re-compile java components and finally ran the utlrp.sql script but without success.

I also tried

Code:
alter package sys.DBMS_JAVA compile body;
This returned:

Code:
Warning: Package Body altered with compilation errors.
When I then ran

Code:
show errors;
it returns a long list with many errors but I have no idea what these errors mean and I couldn't find a solution on internet:

Code:
LINE/COL ERROR
-------- -----------------------------------------------------------------
19/7     PL/SQL: Statement ignored
19/14    PLS-00201: identifier 'DBMS_JAVA_DEFINERS.COMPILE_CLASS_' must be
         declared

27/7     PL/SQL: Statement ignored
27/14    PLS-00201: identifier 'DBMS_JAVA_DEFINERS.COMPILE_METHOD_' must
         be declared

36/7     PL/SQL: Statement ignored
36/14    PLS-00201: identifier 'DBMS_JAVA_DEFINERS.UNCOMPILE_CLASS_' must
         be declared

45/7     PL/SQL: Statement ignored
45/14    PLS-00201: identifier 'DBMS_JAVA_DEFINERS.UNCOMPILE_CLASS_' must
         be declared

55/7     PL/SQL: Statement ignored
55/14    PLS-00201: identifier 'DBMS_JAVA_DEFINERS.UNCOMPILE_METHOD_' must
         be declared

67/7     PL/SQL: Statement ignored
67/14    PLS-00201: identifier 'DBMS_JAVA_DEFINERS.UNCOMPILE_METHOD_' must
         be declared

90/5     PL/SQL: Statement ignored
90/14    PLS-00201: identifier
         'DBMS_JAVA_DEFINERS.GET_NTH_NATIVE_COMPILER_OPTION' must be
         declared

103/7    PL/SQL: Statement ignored
103/16   PLS-00201: identifier
         'DBMS_JAVA_DEFINERS.GET_NTH_NATIVE_COMPILER_OPTION' must be
         declared

110/7    PL/SQL: Statement ignored
110/7    PLS-00201: identifier
         'DBMS_JAVA_DEFINERS.SET_NATIVE_COMPILER_OPTION_' must be declared

119/7    PL/SQL: Statement ignored
119/7    PLS-00201: identifier
         'DBMS_JAVA_DEFINERS.UNSET_NATIVE_COMPILER_OPTION_' must be
         declared
Please can you help me and tell me what I have to do to resolve the issue?


Thanks a lot!