JServer JAVA Virtual Machine Component Invalid

      No Comments on JServer JAVA Virtual Machine Component Invalid

JServer JAVA Virtual Machine Component Invalid

Symptoms:

The JAVAVM Component has become invalid in the database.
Check the status of all the components in the database.


SQL> col comp_id for a10
col version for a11
col status for a10
col comp_name for a37
select comp_id,comp_name,version,status from dba_registry;

COMP_ID    COMP_NAME                             VERSION     STATUS
---------- ------------------------------------- ----------- ----------
CATALOG    Oracle Database Catalog Views         19.0.0.0.0  VALID
CATPROC    Oracle Database Packages and Types    19.0.0.0.0  VALID
RAC        Oracle Real Application Clusters      19.0.0.0.0  OPTION OFF
JAVAVM     JServer JAVA Virtual Machine          19.0.0.0.0  INVALID
XML        Oracle XDK                            19.0.0.0.0  VALID
CATJAVA    Oracle Database Java Packages         19.0.0.0.0  VALID
XDB        Oracle XML Database                   19.0.0.0.0  VALID
OWM        Oracle Workspace Manager              19.0.0.0.0  VALID

8 rows selected.

Cause:

JVM objects not created/upgraded correctly.

Solution:

Change the Registry entry for CATJAVA and JAVAVM

Follow The bellow steps to make it fix-

SQL> select comp_name,version,status from dba_registry where comp_name like '%JAVA%';

COMP_NAME                             VERSION     STATUS
------------------------------------- ----------- ----------
JServer JAVA Virtual Machine          19.0.0.0.0  INVALID

SQL> execute sys.dbms_registry.loaded('JAVAVM')

PL/SQL procedure successfully completed.

SQL> execute sys.dbms_registry.loaded('CATJAVA');

PL/SQL procedure successfully completed.

SQL> execute sys.dbms_registry.valid('JAVAVM');

PL/SQL procedure successfully completed.

SQL> execute sys.dbms_registry.valid('CATJAVA');

PL/SQL procedure successfully completed.



Check the status of the component.

SQL> set pages 1000;
col comp_id for a12;
col comp_name for a35;
col version for a12;
col status for a12;
select comp_id,comp_name,version,status from dba_registry;

COMP_ID      COMP_NAME                           VERSION      STATUS
------------ ----------------------------------- ------------ ------------
CATALOG      Oracle Database Catalog Views       19.0.0.0.0   VALID
CATPROC      Oracle Database Packages and Types  19.0.0.0.0   VALID
RAC          Oracle Real Application Clusters    19.0.0.0.0   OPTION OFF
JAVAVM       JServer JAVA Virtual Machine        19.0.0.0.0   VALID
XML          Oracle XDK                          19.0.0.0.0   VALID
CATJAVA      Oracle Database Java Packages       19.0.0.0.0   VALID
XDB          Oracle XML Database                 19.0.0.0.0   VALID
OWM          Oracle Workspace Manager            19.0.0.0.0   VALID

8 rows selected.

Now The JAVAVM component is Valid

Leave a Reply

Your email address will not be published. Required fields are marked *