11 Replies Latest reply on Jul 22, 2013 3:11 PM by Kirill Loifman

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

    628610
      Hi All,

      I am sending a mail thru OWB 11g ( and using database 11g) after successful or failure of process. My process is completing successfully but am not able to send mail. At the time of sending mail it is giving me error as below

      ORA-24247: network access denied by access control list (ACL)
      ORA-06512: at "SYS.UTL_TCP", line 17
      ORA-06512: at "SYS.UTL_TCP", line 246
      ORA-06512: at "SYS.UTL_SMTP", line 115
      ORA-06512: at "SYS.UTL_SMTP", line 138
      ORA-06512: at line 8

      I have created ACL using the following code

      BEGIN
      dbms_network_acl_admin.create_acl(acl => 'oramail.xml',
      description => 'Network permissions for mail.oracle.com',
      principal => 'OWF_MGR', is_grant => TRUE, privilege => 'connect');

      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'oramail.xml',
      principal => 'OWF_MGR',
      is_grant => true,
      privilege => 'resolve');

      DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'oramail.xml',
      host => '141.146.46.30');

      END;
      /

      commit;

      where 141.146.46.30 is my mail server IP. I am still not able to send mail by OWB. Please let me know if I have missed any steps in this.

      Thanks.