Re: Oracle 11G network ACL not working - ORA-24247: network access denied by access control list (ACL)

  • From: Mike Haddon <m.haddon@xxxxxxxxx>
  • To: Oracle Discussion List <ORACLE-L@xxxxxxxxxxxxx>
  • Date: Thu, 27 Jan 2011 20:44:16 -0600

All -

Thanks for the responses. I tried every variation of the ACL using the hostname, localhost and the hostname of the SMTP relay server. Then one of the sys admins told me their reverse lookup was buggy,.. so I used the IP address, something I usually don't like to do and everything worked. I also specified no port range.

SQL> exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('TCP_SMTP_acl.xml','<SMTP Relay Server IP address>');


--
//www.freelists.org/webpage/oracle-l


Other related posts: