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