oracle中配置rmi调用，调试

feiyang10086

oracle中配置rmi调用，调试

--向外连接

begin

  --dbms_network_acl_admin.create_acl(acl => '/sys/acls/rmi.xml',description => 'rmi',principal => null,is_grant => true,privilege =>'connect' );
  --dbms_network_acl_admin.assign_acl(acl => '/sys/acls/rmi.xml',host => '10.0.32.9',lower_port => 1099,upper_port => 1099);
  --dbms_network_acl_admin.add_privilege(acl => 'rmi.xml',principal => 'P1',is_grant => true,privilege => 'connect');
    dbms_network_acl_admin.add_privilege(acl => 'rmi.xml',principal => 'P1',is_grant => true,privilege => 'resolve');

end;

--java socket
begin
  dbms_java.grant_permission( 'P1', 'SYS:java.net.SocketPermission', '10.0.32.9:1099', 'connect,resolve' );
  dbms_java.grant_permission( 'P1', 'SYS:java.net.SocketPermission', '10.0.32.9:3278', 'connect,resolve' );
end;


--查看
select * from dba_network_acls  
select * from dba_network_acl_privileges


--日志调试
set serveroutput on size 1000000;
call dbms_java.set_output(1000000);

select aa from dual;

如果有一天21

谢谢分享