ORA-24247: network access denied by access control list (ACL)
原因:11g数据库为了安全起见, 默认disable一些utility, 用的话需要授权:
Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4
create or replace procedure mailserver_acl(
aacl varchar2,
acomment varchar2,
aprincipal varchar2,
aisgrant boolean,
aprivilege varchar2,
aserver varchar2,
aport number)
is
begin
begin
DBMS_NETWORK_ACL_ADMIN.DROP_ACL(aacl);
dbms_output.put_line('ACL dropped.....');
exception
when others then
dbms_output.put_line('Error dropping ACL: '||aacl);
dbms_output.put_line(sqlerrm);
end;
begin
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(aacl,acomment,aprincipal,aisgrant,aprivilege);
dbms_output.put_line('ACL created.....');
exception
when others then
dbms_output.put_line('Error creating ACL: '||aacl);
dbms_output.put_line(sqlerrm);
end;
begin
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(aacl,aserver,aport);
dbms_output.put_line('ACL assigned.....');
exception
when others then
dbms_output.put_line('Error assigning ACL: '||aacl);
dbms_output.put_line(sqlerrm);
end;
commit;
dbms_output.put_line('ACL commited.....');
end;
/
commit;
show error
begin
mailserver_acl(
'mailserver_acl.xml',
'ACL for used Email Server to connect',
'APEX_030200',
TRUE,
'connect',
'mail_server',
25);
end;
/
commit;
注意: APEX_030200是aepx的user, 不同版本可能名字不同。
'mail_server'是配置在apex中mail server的名字,
25是mail server 端口。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/763776/viewspace-617139/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/763776/viewspace-617139/