ORA-29538: Java not installed处理过程

1.问题描叙

创建Java Class时出现：

create or replace and compile java source named edp.HTTPSSLGET 
as
import java.net.URL;
...... 代码略
ORA-29538: Java not installed
29538. 00000 -  "Java not installed"
*Cause:    An attempt was made to use a Java command when Java is not installed.
*Action:   Install Java, or do not use the command.

2. 确认jvm组件是否安装

SQL> select comp_id,comp_name,version,status from dba_registry;

COMP_ID                        COMP_NAME                                VERSION                        STATUS
------------------------------ ---------------------------------------- ------------------------------ --------------------------------------------
CATALOG                        Oracle Database Catalog Views            10.2.0.5.0                     VALID
CATPROC                        Oracle Database Packages and Types       10.2.0.5.0                     VALID

3.安装jvm组件

3.1 安装过程

遇到system表空间无法扩展

 @$ORACLE_HOME/javavm/install/initjvm.sql

可能会遇到system表空间无法扩展的问题：
create or replace java system
begin if initjvmaux.startstep(‘CREATE_JAVA_SYSTEM’) then
*
ERROR at line 1:
ORA-01653: unable to extend table SYS.IDL_UB1$ by 1024 in tablespace SYSTEM
ORA-06512: at “SYS.INITJVMAUX”, line 23
ORA-06512: at line 5

ERROR:
ORA-03113: end-of-file on communication channel

3.2 扩展system表空间

SQL> select file_id from dba_data_files where tablespace_name='SYSTEM';

   FILE_ID
----------
         1
SQL> alter database datafile 1 resize 400m;

Database altered.

3.3 移除失败安装的jvm组件

@$ORACLE_HOME/javavm/install/rmjvm.sql

记得重启数据库，否则无法继续安装

SQL> shutdown immediate

SQL> startup

3.4 再次安装

@$ORACLE_HOME/javavm/install/initjvm.sql
PL/SQL procedure successfully completed

4.确认安装成果

SQL> select comp_id,comp_name,version,status from dba_registry;

COMP_ID                        COMP_NAME                                VERSION                        STATUS
------------------------------ ---------------------------------------- ------------------------------ --------------------------------------------
CATALOG                        Oracle Database Catalog Views            10.2.0.5.0                     VALID
CATPROC                        Oracle Database Packages and Types       10.2.0.5.0                     VALID
JAVAVM                         JServer JAVA Virtual Machine             10.2.0.5.0                     VALID

5.re-recreate java class

create or replace and compile java source named edp.HTTPSSLGET 
as
...... 代码略
Java source HTTPSSLGET 已編譯