ora 29532 java调用_ORA-29538、ORA-29532、ORA-29913问题解决

问题一：

ERROR at line 1: ORA-29538: Java not installed

解决方法

1.检查有没有安装JAVA组件

select * from v$option t where t.PARAMETER='Java';

如果返回行说明已安装，如果没有返回行，运行Oracle Universal Installer安装JAVA组件

2.如果在第1步返回行，则检查oracle中有没有dbms_java.

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

如果没有返回行，执行第3步

3.在sqlplus下以sys登陆，执行$ORACLE_HOME/javavm/install/initjvm.sql

SQL>@?/javavm/install/initjvm.sql;

问题二：

ERROR at line 1:

ORA-29532: Java call terminated by uncaught Java exception:

java.security.AccessControlException: the Permission (java.io.FilePermission

/home/accmgrctl/src/server read) has not been granted to SQLVIEW. The PL/SQL to

grant this is dbms_java.grant_permission( 'SQLVIEW',

'SYS:java.io.FilePermission&#