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

Issue:

ERROR at line 1:
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 267
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
ORA-06512: at line 30

Solution:

1.run the following query to check if an ACL exists:
SELECT * FROM dba_network_acls;

SELECT * FROM dba_network_acl_privileges where principal='MAN';

SELECT * FROM dba_network_acl_privileges where principal='APPS';

In order to use UTL_TCP, UTL_HTTP, UTL_SMTP, and UTL_MAIL the user will need the connect privilege:

begin
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => '/sys/acls/OracleEBS.xml',
principal => 'MAN',
is_grant => true,
privilege => 'connect');
end;

If you need to resolve a host name from a host IP you will need the resolve grant as well.

begin
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => '/sys/acls/OracleEBS.xml',
principal => 'MAN',
is_grant => true,
privilege => 'resolve');
end;