oracle apex发邮件的时候出现错误：
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博客

ORA-24247: network access denied by access control list (ACL)

最新文章