Archive

Posts Tagged ‘ORA-29538’

How to install Java in Oracle Database – ORA-29538.

2014-02-15 1 comment

Recently, the developer met the following error message while trying to create a java object using SQL Developer:
ORA-29538: Java not installed

Well, first let’s check if the JVM components is really not installed in Oracle – verify installed components:

select comp_name, version, status from dba_registry;

java1

to be double sure, we run another query which should return no rows:

select distinct owner,name from dba_source where lower(NAME)='dbms_java';

So, to install the JVM you should run (sys as sysdba) initjvm.sql located in $ORACLE_HOME\javavm\install:
java2

Now, check if JVM was installed successfully:

select comp_name, version, status from dba_registry;

java3

The problem solved 🙂