在使用oracle過程中，有時(shí)候需要集成JAVA函數(shù)來發(fā)送socket包（作為異步處理，一般是是通知類的UDP包，可能對(duì)包的安全性有所影響，主要是可能有丟包發(fā)生）。在這里主要是處理發(fā)生udp包的事件。
但在調(diào)用函數(shù)的時(shí)候發(fā)生錯(cuò)誤信息。
ORA-29532: Java call terminated by uncaught
Java exception: java.security.AccessControlException: the
Permission (java.net.SocketPermission localhost:10000
listen,resolve) has not been granted to RADIUS. The PL/SQL to grant
this is dbms_java.grant_permission( 'RADIUS',
'SYS:java.net.SocketPermission', 'localhost:10000',
'listen,resolve' )
ORA-06512: at
"RADIUS.UDP_SEND", line
0
ORA-06512: at
"RADIUS.WEB800CALLBACKITEMLIST_INS",
line 20
ORA-04088: error during execution of trigger
'RADIUS.WEB800CALLBACKITEMLIST_INS'
ORA-06512: at
"RADIUS.SF_CREATE800PHONECALLBACKNEW",
line 25
ORA-06512: at line 1
堅(jiān)決辦法是將用戶radius權(quán)限提升。
解決辦法：
1.打開 PL/SQL Develop 登陸數(shù)據(jù)庫使用system管理員賬號(hào)。
2.打開命令窗口
sql>exec
dbms_java.grant_permission( 'RADIUS',
'SYS:java.net.SocketPermission', 'localhost:10000',
'listen,resolve' );
sql>commit;
sql>exec
dbms_java.grant_permission( 'RADIUS',
'SYS:java.net.SocketPermission', '192.168.0.123:8056',
'connect,resolve' );
sql>commit;
sql>exec
dbms_java.grant_permission( 'RADIUS',
'SYS:java.net.SocketPermission', 'localhost:11000',
'listen,resolve' );
sql>commit;
sql>exec
dbms_java.grant_permission( 'RADIUS',
'SYS:java.net.SocketPermission','192.168.0.123:10010','connect,resolve');
sql>commit;
這里要注意接收包的地址和發(fā)送包的地址要進(jìn)行認(rèn)證。
