JServer JAVA Virtual Machine Component is in the LOADING state ~ Oracle DBA Secrets

Sunday, April 07, 2024

JServer JAVA Virtual Machine Component is in the LOADING state

After upgrading the database from Oracle 12c to 19c, Java packages show the status "LOADING".JServer JAVA Virtual Machine Component is in the LOADING state.

Symptoms:

The JAVAVM Component is in the LOADING state in the database.

Check the status of all the components in the database.

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 LOADING

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.

Solution:

Need to recompile the above packages as shown in the fix. Change the Registry entry for 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 LOADING

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

PL/SQL procedure successfully completed.

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