OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » JavaVM invalid (Oracle 19c, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

JavaVM invalid [message #686235]

Wed, 06 July 2022 23:51

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!

Report message to a moderator

Re: JavaVM invalid [message #686236 is a reply to message #686235]

Thu, 07 July 2022 01:39

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: JavaVM invalid [message #686237 is a reply to message #686235]

Thu, 07 July 2022 13:17

John Watson
Messages: 8960
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 15 17:21:33 CST 2024