Home » RDBMS Server » Server Administration » JavaVM invalid (Oracle 19c, Linux)
JavaVM invalid [message #686235] Wed, 06 July 2022 23:51 Go to next message
bluefoxxp
Messages: 7
Registered: November 2020
Junior Member
Hello,

I have the following issue:

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

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

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

I also tried

alter package sys.DBMS_JAVA compile body;
but his returned:
Warning: Package Body altered with compilation errors.
When I then ran
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:

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!
Re: JavaVM invalid [message #686236 is a reply to message #686235] Thu, 07 July 2022 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have a look at MOS notes:
How to properly remove the JVM from 11gR2 and newer standalone database instances (Doc ID 2541088.1)
How to Install, Remove, Reload, Validate and Repair the JVM Component in an Oracle Database (Doc ID 2149019.1)

And this page.

Re: JavaVM invalid [message #686237 is a reply to message #686235] Thu, 07 July 2022 13:17 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Is this Multitenant? I had what may have been a similar problem, and eventually fixed it by unplugging and plugging in to a new CDB with the latest RU, and upgrading.

--correction: not "upgrading", just running datapatch

[Updated on: Thu, 07 July 2022 13:18]

Report message to a moderator

Previous Topic: flush single SQL plan on RAC
Next Topic: Parse statistic values don't seem to add up
Goto Forum:
  


Current Time: Thu Mar 28 07:25:29 CDT 2024