Symptoms:
The JAVAVM Component has become invalid in the database.
Check the status of all the components in the database.
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
------------ ----------------------------------- ------------ ------------
MGD Oracle Machine Generated Data 11.2.0.4.0 VALID
AMD OLAP Catalog 11.2.0.4.0 VALID
EM Oracle Enterprise Manager 11.2.0.4.0 VALID
XDB Oracle XML Database 11.2.0.4.0 VALID
CONTEXT Oracle Text 11.2.0.4.0 VALID
SDO Spatial 11.2.0.4.0 VALID
ORDIM Oracle Multimedia 11.2.0.4.0 VALID
CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID
CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID
JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 INVALID
CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID
XML Oracle XDK 11.2.0.4.0 VALID
RAC Oracle Real Application Clusters 11.2.0.4.0 VALID
APS OLAP Analytic Workspace 11.2.0.4.0 VALID
XOQ Oracle OLAP API 11.2.0.4.0 VALID
15 rows selected.
Cause:
JVM objects not created/upgraded correctly.
Solution:
Change the Registry entry for CATJAVA and JAVAVM
select comp_name,version,status from dba_registry where comp_name like '%JAVA%';
COMP_NAME VERSION STATUS
---------------------------- ------------- -------
JServer JAVA Virtual Machine 11.2.0.4.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.
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
------------ ----------------------------------- ------------ ------------
MGD Oracle Machine Generated Data 11.2.0.4.0 VALID
AMD OLAP Catalog 11.2.0.4.0 VALID
EM Oracle Enterprise Manager 11.2.0.4.0 VALID
XDB Oracle XML Database 11.2.0.4.0 VALID
CONTEXT Oracle Text 11.2.0.4.0 VALID
SDO Spatial 11.2.0.4.0 VALID
ORDIM Oracle Multimedia 11.2.0.4.0 VALID
CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID
CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID
JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID
CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID
XML Oracle XDK 11.2.0.4.0 VALID
RAC Oracle Real Application Clusters 11.2.0.4.0 VALID
APS OLAP Analytic Workspace 11.2.0.4.0 VALID
XOQ Oracle OLAP API 11.2.0.4.0 VALID
15 rows selected.
The JAVAVM component is Valid now!