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

Posted by ErmanArslansOracleBlog on Feb 24, 2017; 6:23am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-24247-network-access-denied-by-access-control-list-ACL-tp2203p2205.html

Hello,

İt is very clear that it is an ACL error.
Create and assign ACL for the server that you need to reach via http.

Example:

SELECT host, acl, lower_port lport, upper_port uport
FROM DBA_NETWORK_ACLS ;

We check the output and we 'll see that there is no ACLs defined for enabling access to the server that we are trying reach.

Then, we create our ACL and associate it with the relevant user to make that user access the desired IP/host from our Oracle Database;

BEGIN
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl         => 'mailserver.xml',
                                    description => 'mailserver icin xml',
                                    principal   => 'APPS',
                                    is_grant    => true,
                                    privilege   => 'connect');

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

  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl  => 'mailserver.xml',
                                    host => '.....ip or hostname here....');
END;
/
COMMIT;