ORA-29538:Java not installed

the developer meets the error message as trying to create a java object using sqlplus:

*****************************************
ORA-29538: Java not installed
*****************************************

//I double that the jvm components is not installed in oracle,check it out..

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> set linesize 160
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> select host_name,instance_name from v$instance;

HOST_NAME                                                  INSTANCE_NAME
---------------------------------------------------            ----------------
RLJXDBSCBG                                                      orcl

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

no rows selected

//check the installed components

SQL> select comp_name, version, status from dba_registry;
 COMP_NAME                          VERSION                       STATUS
 ------------------------- ------------------------------ ----------------------
 Oracle Enterprise Manager                  11.2.0.1.0                   VALID
 Oracle Workspace Manager                   11.2.0.1.0                   VALID
 Oracle Database Catalog Views              11.2.0.1.0                  VALID
 Oracle Database Packages and Types          11.2.0.1.0                  VALID

//find another db based on 10205 and check the name ‘dbms_java’ in dba_source view

SQL> select distinct owner,name from dba_source where lower(NAME)=’dbms_java’;

OWNER NAME
————————–      ——————————
SYS                                    DBMS_JAVA
// the dbms_java has been installed

//check the installed components

SQL> select comp_name,version,status from dba_registry;

COMP_NAME                              VERSION                    STATUS
------------------------------------ ---------------------    ----------------
Oracle Database Catalog Views         10.2.0.5.0                  VALID
Oracle Database Packages and Types    10.2.0.5.0                  VALID
Oracle Workspace Manager              10.2.0.5.0                  VALID
JServer JAVA Virtual Machine          10.2.0.5.0                  VALID
Oracle XDK                            10.2.0.5.0                  VALID
Oracle Database Java Packages         10.2.0.5.0                  VALID
Oracle Expression Filter              10.2.0.5.0                  VALID
Oracle Data Mining                    10.2.0.5.0                  VALID
Oracle Text                           10.2.0.5.0                  VALID
Oracle XML Database                   10.2.0.5.0                  VALID
Oracle Rules Manager                  10.2.0.5.0                  VALID

COMP_NAME                                  VERSION            STATUS
-------------------------              ----------------     ----------------------
Oracle interMedia                       10.2.0.5.0               VALID
OLAP Analytic Workspace                 10.2.0.5.0               VALID
Oracle OLAP API                         10.2.0.5.0               VALID
OLAP Catalog                            10.2.0.5.0               VALID
Spatial                                 10.2.0.5.0               VALID
Oracle Enterprise Manager               10.2.0.5.0               VALID

Continue reading “ORA-29538:Java not installed”