title: Oracle 12c ORA-24247 network access denied by access control list (ACL) when using FTP
body: <p>I am working with <em>Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production</em> and trying to use the an ftp package (UTL_TCP). Here the procedure:</p>
  
  <pre><code>declare 
      l_conn UTL_TCP.connection;
      l_list ftp.t_string_table   := ftp.t_string_table(); 
  begin
      l_conn := ftp.login('ftp.myhost.com', 21, 'user', 'password');
      ftp.nlst(p_conn =&gt; l_conn,p_dir  =&gt; 'outbox',p_list =&gt; l_list);
      ftp.logout(l_conn);
  end;
  </code></pre>
  
  <p>The error is raised for <strong>ftp.nlst</strong>.</p>
  
  <p>I configured the ACLs in this way:<code>select * from dba_network_acls;</code> returns</p>
  
  <pre><code>HOST           | LOWER_PORT | UPPER_PORT | ACL                   | ACLID            | ACL_OWNER
  -----------------------------------------------------------------------------------------------
  ftp.myhost.com |  null      | null       | /myaclspath/myacl.xml | 00000000800027C5 | SYS
  *              |  null      | null       | NETWORK_ACL_5A1900... | 0000000080002724 | SYS
  </code></pre>
  
  <p>and <code>select * from dba_network_acl_privileges</code> returns</p>
  
  <pre><code>ACL                   | ACLID            | PRINCIPAL | PRIVILEGE | IS_GRANT | INVERT | START_DATE | END_DATE | ACL_OWNER
  ------------------------------------------------------------------------------------------------------------------------
  /myaclspath/myacl.xml | 00000000800027C5 | MYDBUSER  | resolve   | true     | false  |            |          |SYS
  /myaclspath/myacl.xml | 00000000800027C5 | MYDBUSER  | connect   | true     | false  |            |          |SYS
  </code></pre>
  
  <p>I read about a similar error <a href="https://stackoverflow.com/questions/15816179/ora-24247-when-sending-through-ftp">here</a> and check the setup of the ACL as <a href="http://blog.whitehorses.nl/2010/03/17/oracle-11g-access-control-list-and-ora-24247/" rel="nofollow noreferrer">here</a> but I can't figure it out why the network access is denied after login.</p>
  
  <p>Thanks in advance fr any suggestion.</p>