Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-29532: Java call terminated by uncaught Java exception:java.lang.ExceptionInInitializerError

2607204Sep 30 2014 — edited Sep 30 2014

DB version : 10.2.0.3.0

Host: SunOS 5.10 Generic_148888-01 sun4u sparc SUNW,SPARC-Enterprise

When I login on server directly into DB, I m able to gather table stats without any issue...

sqlplus app_dba/password

SQL> show user
USER is "APP_DBA"
SQL>
SQL>  exec DBMS_STATS.gather_table_stats('tableowner','tablename');

PL/SQL procedure successfully completed.

However. it fails with java error, when I run following using tns entry --- Why??

sqlplus app_dba/password@dbname

SQL> show user

USER is "APP_DBA"

SQL> exec DBMS_STATS.gather_table_stats('tableowner','tablename');

BEGIN DBMS_STATS.gather_table_stats('tableowner','tablename'); END;

ERROR at line 1:

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

java.lang.ExceptionInInitializerError

ORA-06512: at "SYS.DBMS_STATS", line 13182

ORA-06512: at "SYS.DBMS_STATS", line 13202

ORA-06512: at line 1

Can someone pls help me understand what is the issue, here?

Here are java perms in DB

SEQ KIND GRANTEE NAME ENABLED

---------- -------- ------------------------------ --------------------------------------------------------------------------- --------

128 GRANT APP_DBA \matt1.gif ENABLED

126 GRANT APP_DBA hostname ENABLED

127 GRANT APP_DBA * ENABLED

75 GRANT EJBCLIENT createClassLoader ENABLED

76 GRANT EJBCLIENT getClassLoader ENABLED

74 GRANT EJBCLIENT * ENABLED

67 GRANT JAVADEBUGPRIV Debug ENABLED

43 GRANT JAVASYSPRIV <<ALL FILES>> ENABLED

42 GRANT JAVASYSPRIV * ENABLED

45 GRANT JAVASYSPRIV createClassLoader ENABLED

46 GRANT JAVASYSPRIV getClassLoader ENABLED

SEQ KIND GRANTEE NAME ENABLED

---------- -------- ------------------------------ --------------------------------------------------------------------------- --------

51 GRANT JAVASYSPRIV readFileDescriptor ENABLED

47 GRANT JAVASYSPRIV setContextClassLoader ENABLED

48 GRANT JAVASYSPRIV setFactory ENABLED

50 GRANT JAVASYSPRIV setFileDescriptor ENABLED

49 GRANT JAVASYSPRIV setIO ENABLED

52 GRANT JAVASYSPRIV writeFileDescriptor ENABLED

44 GRANT JAVASYSPRIV * ENABLED

78 GRANT JAVASYSPRIV setLog ENABLED

37 GRANT JAVAUSERPRIV <<ALL FILES>> ENABLED

39 GRANT JAVAUSERPRIV accessClassInPackage.* ENABLED

40 GRANT JAVAUSERPRIV defineClassInPackage.* ENABLED

SEQ KIND GRANTEE NAME ENABLED

---------- -------- ------------------------------ --------------------------------------------------------------------------- --------

38 GRANT JAVAUSERPRIV getProtectionDomain ENABLED

41 GRANT JAVAUSERPRIV stopThread ENABLED

36 GRANT JAVAUSERPRIV * ENABLED

17 GRANT JAVA_ADMIN 0:java.awt.AWTPermission#* ENABLED

7 GRANT JAVA_ADMIN 0:java.io.FilePermission#* ENABLED

6 GRANT JAVA_ADMIN 0:java.io.SerializablePermission#* ENABLED

11 GRANT JAVA_ADMIN 0:java.lang.RuntimePermission#* ENABLED

12 GRANT JAVA_ADMIN 0:java.lang.reflect.ReflectPermission#* ENABLED

8 GRANT JAVA_ADMIN 0:java.net.NetPermission#* ENABLED

9 GRANT JAVA_ADMIN 0:java.net.SocketPermission#* ENABLED

13 GRANT JAVA_ADMIN 0:java.security.AllPermission#* ENABLED

SEQ KIND GRANTEE NAME ENABLED

---------- -------- ------------------------------ --------------------------------------------------------------------------- --------

10 GRANT JAVA_ADMIN 0:java.security.SecurityPermission#* ENABLED

77 GRANT JAVA_ADMIN 0:java.sql.SQLPermission#* ENABLED

5 GRANT JAVA_ADMIN 0:java.util.PropertyPermission#* ENABLED

15 GRANT JAVA_ADMIN 0:java.util.logging.LoggingPermission#* ENABLED

18 GRANT JAVA_ADMIN 0:javax.net.ssl.SSLPermission#* ENABLED

16 GRANT JAVA_ADMIN 0:javax.security.auth.AuthPermission#* ENABLED

81 GRANT JAVA_ADMIN 0:oracle.aurora.rdbms.HandlePermission#* ENABLED

4 GRANT JAVA_ADMIN 0:oracle.aurora.rdbms.security.PolicyTablePermission#* ENABLED

14 GRANT JAVA_ADMIN 0:oracle.aurora.security.JServerPermission#* ENABLED

33 GRANT JAVA_DEPLOY bin/chmod ENABLED

31 GRANT JAVA_DEPLOY javavm/admin/* ENABLED

SEQ KIND GRANTEE NAME ENABLED

---------- -------- ------------------------------ --------------------------------------------------------------------------- --------

32 GRANT JAVA_DEPLOY javavm/deploy/* ENABLED

35 GRANT JAVA_DEPLOY readFileDescriptor ENABLED

34 GRANT JAVA_DEPLOY writeFileDescriptor ENABLED

82 GRANT JAVA_DEPLOY * ENABLED

30 GRANT JAVA_DEPLOY Deploy ENABLED

29 GRANT JAVA_DEPLOY LoadClassInPackage.oracle.aurora.deploy.* ENABLED

121 GRANT MDSYS md/lib/* DISABLED

123 GRANT MDSYS md\lib\* ENABLED

122 GRANT MDSYS sdo/demos/georaster/jlibs/* DISABLED

124 GRANT MDSYS sdo\demos\georaster\jlibs\* ENABLED

125 GRANT MDSYS getClassLoader ENABLED

SEQ KIND GRANTEE NAME ENABLED

---------- -------- ------------------------------ --------------------------------------------------------------------------- --------

102 GRANT ORDSYS getClassLoader ENABLED

21 GRANT PUBLIC createSecurityManager ENABLED

20 GRANT PUBLIC exitVM ENABLED

72 RESTRICT PUBLIC loadLibrary.* ENABLED

22 GRANT PUBLIC modifyThread ENABLED

23 GRANT PUBLIC modifyThreadGroup ENABLED

24 GRANT PUBLIC preferences ENABLED

2 GRANT PUBLIC * ENABLED

19 GRANT PUBLIC user.language ENABLED

73 RESTRICT PUBLIC 0:java.lang.RuntimePermission#loadLibrary.* ENABLED

84 GRANT PUBLIC DUMMY DISABLED

SEQ KIND GRANTEE NAME ENABLED

---------- -------- ------------------------------ --------------------------------------------------------------------------- --------

25 GRANT PUBLIC LoadClassInPackage.* ENABLED

26 RESTRICT PUBLIC LoadClassInPackage.java.* ENABLED

27 RESTRICT PUBLIC LoadClassInPackage.oracle.aurora.* ENABLED

28 RESTRICT PUBLIC LoadClassInPackage.oracle.jdbc.* ENABLED

58 GRANT SYS * ENABLED

1 GRANT SYS createClassLoader ENABLED

61 GRANT SYS loadLibrary.corejava ENABLED

64 GRANT SYS loadLibrary.corejava_d ENABLED

62 GRANT SYS loadLibrary.jox10oraawt ENABLED

63 GRANT SYS loadLibrary.oraioser ENABLED

65 GRANT SYS loadLibrary.orajaas ENABLED

SEQ KIND GRANTEE NAME ENABLED

---------- -------- ------------------------------ --------------------------------------------------------------------------- --------

66 GRANT SYS loadLibrary.ordim10 ENABLED

60 GRANT SYS loadLibrary.xaNative ENABLED

57 GRANT SYS * ENABLED

53 GRANT SYS * ENABLED

59 GRANT SYS * ENABLED

54 GRANT SYS * ENABLED

56 GRANT SYS * ENABLED

79 GRANT SYS control ENABLED

55 GRANT SYS * ENABLED

80 GRANT SYS * ENABLED

83 GRANT SYS * ENABLED

SEQ KIND GRANTEE NAME ENABLED

---------- -------- ------------------------------ --------------------------------------------------------------------------- --------

3 GRANT SYS 0:oracle.aurora.rdbms.security.PolicyTablePermission#* ENABLED

68 GRANT SYS * ENABLED

69 GRANT SYS LoadClassInPackage.java.* ENABLED

70 GRANT SYS LoadClassInPackage.oracle.aurora.* ENABLED

71 GRANT SYS LoadClassInPackage.oracle.jdbc.* ENABLED

101 GRANT SYSTEM <<ALL FILES>> ENABLED

94 rows selected.

-Yogi

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2014

Added on Sep 30 2014

#general-database-discussions

2 comments

1,862 views