DevOps, CI/CD and Automation

Hello all,

I am trying to send email from PL/SQL as I have always done, using utl_smtp, however, on 11g I am now getting:

ERROR at line 1:
ORA-20100: OLD_ERR=ORA-24247: network access denied by access control list
(ACL)

The system is SusE:

Linux wtsuse 2.6.22.5-31-default #1 SMP 2007/09/21 22:29:00 UTC x86_64 x86_64 x86_64 GNU/Linux

I have tried following the instructions for the new ACL in Oracle 11:


as SYSTEM:

BEGIN


dbms_network_acl_admin.create_acl (acl => 'plj.xml',
description => 'Network permissions for abc.com',
principal => 'ABC',
is_grant => TRUE,
privilege => 'connect');

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'abc.xml',
principal => 'ABC',
is_grant => TRUE,
privilege => 'resolve');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'abc.xml',
host => 'mail.abc.net');

END;
/

commit;

But this does not help.

Same error when trying to send mail as ABC using UTL_SMTP.

Can send mail (using postfix) from the linux command line, no problem.


What do I need to do? It is not at all clear from the doc.

I notice that Oracle refers to a directory /sys/acls where an xml file is stored with the same name (abc.xml)
However, on SuSE this directory does not exist by default

Does Oracle create the XML file? and if so, where is the default location on SuSE - or should I create the directory? and if so as who (oracle?)

Any help will be greatly appreciated.

Paul