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


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 line 5
  • add dns servers to /etc/resolv.conf
  • Access Contol List
  • Compile with SYS:
SELECT host, lower_port, upper_port, acl,
DECODE(DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE_ACLID(aclid, 'ANAR', 'connect'), 1, 'GRANTED', 0, 'DENIED', null) privilege
FROM dba_network_acls;

 On user - DBA privilege:
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => '/sys/acls/utl_mail.xml',
description => '/sys/acls/utl_mail.xml',
principal => 'ANAR',
is_grant => true,
privilege => 'connect');
commit;
end;
/
begin
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL
(
acl => '/sys/acls/utl_mail.xml',
host => '172.30.1.9',
LOWER_PORT => '',
UPPER_PORT => ''
);
commit;
end;
/
begin
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => '/sys/acls/utl_mail.xml',
principal => 'ANAR',
is_grant => true,
privilege => 'resolve');
commit;
end;
/
grant execute on utl_smtp to ANAR;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: