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 已編譯