w*m
发帖数: 1806 | 1 20 伪币
call dbms_java.grant_permission('PUBLIC, 'java.net.SocketPermission',
'*', 'connect')
ERROR ORA-29532: java call terminated by uncaught Java exception:
java.lang.Error: policy table query failed
then I tried call dbms_java.grant_policy_permission('PUBLIC', 'SYS', 'java.
net.SocketPermission,'*');
failed again.
高手们看看是何问题？thanks | v*****r
发帖数: 1119 | 2 Did you log into as SYS with SYSDBA option to run dbms_java.grant_permission
?
If not, the failure could be due to the login user can't query/update the
java policy dictionary table.
【在 w*m 的大作中提到】
: 20 伪币
: call dbms_java.grant_permission('PUBLIC, 'java.net.SocketPermission',
: '*', 'connect')
: ERROR ORA-29532: java call terminated by uncaught Java exception:
: java.lang.Error: policy table query failed
: then I tried call dbms_java.grant_policy_permission('PUBLIC', 'SYS', 'java.
: net.SocketPermission,'*');
: failed again.
: 高手们看看是何问题？thanks
| w*m
发帖数: 1806 | 3 yes, I login as sys with sysdba.
permission
【在 v*****r 的大作中提到】
: Did you log into as SYS with SYSDBA option to run dbms_java.grant_permission
: ?
: If not, the failure could be due to the login user can't query/update the
: java policy dictionary table.
| w*m
发帖数: 1806 | 4 http://forums.oracle.com/forums/thread.jspa?threadID=571997&tstart=315
看到这个link,可能要运行 catpatch.sql,问题是oraclehome下找不到这个catpatch呀？
oracle: 10.2.0.4@solaris
permission
【在 v*****r 的大作中提到】
: Did you log into as SYS with SYSDBA option to run dbms_java.grant_permission
: ?
: If not, the failure could be due to the login user can't query/update the
: java policy dictionary table.
| v*****r
发帖数: 1119 | 5 Then I would suspect there is something wrong with Oracle JVM component,
either not installed at all or not installed/patched properly. To verify:
1. run this query:
SQL> select comp_name, version, status from dba_registry;
the result should be something like this:
COMP_NAME VERSION STATUS | v*****r
发帖数: 1119 | 6 that is unlikely the cause if your dba has followed the proper procedure on
major version upgrade (from 9i to 10g).
See my previous post, check the installation of Oracle JVM in your db first.
呀？
【在 w*m 的大作中提到】
: http://forums.oracle.com/forums/thread.jspa?threadID=571997&tstart=315
: 看到这个link,可能要运行 catpatch.sql,问题是oraclehome下找不到这个catpatch呀？
: oracle: 10.2.0.4@solaris
:
: permission
| w*m
发帖数: 1806 | 7 thanks.
just checked,
JServer JAVA Virtual Machine 10.2.0.4.0 VALID
SYS VALID 15519
everything seems fine.
I also googled, and fine this link
http://forums.oracle.com/forums/thread.jspa?messageID=2128897
so my question is where is catpatch.sql in Oracle10? I can't find it.
【在 v*****r 的大作中提到】
: Then I would suspect there is something wrong with Oracle JVM component,
: either not installed at all or not installed/patched properly. To verify:
: 1. run this query:
: SQL> select comp_name, version, status from dba_registry;
: the result should be something like this:
: COMP_NAME VERSION STATUS
| v*****r
发帖数: 1119 | 8 Catpatch.sql is the upgrade script for 9i.
10g should not have this script and the corresponding script is catupgrd.sql
. If your db hasn't been upgraded from 9i, you shouldn't worry about this.
As sys, could you query java$policy$ table?
【在 w*m 的大作中提到】
: thanks.
: just checked,
: JServer JAVA Virtual Machine 10.2.0.4.0 VALID
: SYS VALID 15519
: everything seems fine.
: I also googled, and fine this link
: http://forums.oracle.com/forums/thread.jspa?messageID=2128897
: so my question is where is catpatch.sql in Oracle10? I can't find it.
| w*m
发帖数: 1806 | 9 ok, thanks you all. problem fixed.
I have no idea how oracle dba fixed this problem. He said he just executed
the same command, then it works.
.....
sql
【在 v*****r 的大作中提到】
: Catpatch.sql is the upgrade script for 9i.
: 10g should not have this script and the corresponding script is catupgrd.sql
: . If your db hasn't been upgraded from 9i, you shouldn't worry about this.
: As sys, could you query java$policy$ table?
| v*****r
发帖数: 1119 | 10 Your original post has a typo on the procedure call, but I don't think that
will cause the error you are complaining.
If you re-run this call, are you still getting the error, if not, then your
dba must did something :->
Anyway, thanks for the 伪币，I am richer now.
【在 w*m 的大作中提到】
: ok, thanks you all. problem fixed.
: I have no idea how oracle dba fixed this problem. He said he just executed
: the same command, then it works.
: .....
:
: sql
|
|
