Home > Oracle, RDBMS > How to install Java in Oracle Database – ORA-29538.

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

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 šŸ™‚

Advertisements
  1. Justin
    2015-12-02 at 10:47

    I am using Oracle 11g XE. I could not find initjvm.sql in XE. Please help me on this.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: