ora-24247 网络访问被网络访问控制列表(ACL)拒绝
ora-06512:在“SYS.UTL_INADDR",line.....
第一步:Create ACL
begin
dbms_network_acl_admin.create_acl (
acl => ‘UTL_INADDR.xml‘,
description => ‘utl_inaddr‘,
principal => User, --此为将来要进行操作的用户
is_grant => TRUE,
privilege => ‘resolve‘
);
commit;
end;
/
第二步:Add Privilege
begin
dbms_network_acl_admin.add_privilege (
acl => ‘UTL_INADDR.xml‘,
principal => User, --此为将来要进行操作的用户
is_grant => TRUE,
privilege => ‘connect‘
);
commit;
end;
/
第三步:-- www.baidu.com.cn 是要访问的域名或者IP, 或者允许所有访问*
begin
DBMS_NETWORK_ACL_ADMIN.assign_acl(‘UTL_INADDR.xml‘,‘www.baidu.com.cn‘,80,null);
commit;
end;
/
BEGIN
dbms_network_acl_admin.assign_acl (
acl => 'UTL_INADDR.xml',host =>'*');
COMMIT;
END;
/