ORA-24247 When Executing UTL_HTTP UTL_INADDR Packages (Doc ID 453786.1)

Last updated on NOVEMBER 22, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
PL/SQL - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 14-Feb-2014


Symptoms

When executing DBMS_LDAP, UTL_INADDR (or) UTL_HTTP (or) any UTL packages after upgrading to 11gR1, fails with following error.

SQL> DECLARE
        l_url varchar2(32767);
        l_conn utl_http.req;
     BEGIN
        l_url := 'http://www.oracle.com';
        l_conn := utl_http.begin_request(url => l_url, method => 'POST', http_version=> 'HTTP/1.0');
        dbms_output.put_line('Anonymous Block Executed Successfully');
     END;
      /

declare
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-6512: at "SYS.UTL_HTTP", line 1029
ORA-24247: network access denied by access control list (ACL)
ORA-6512: at line 6

SQL> select utl_inaddr.get_host_address('www.oracle.com') from dual;
select utl_inaddr.get_host_address('www.oracle.com') from dual
       *
ERROR at line 1:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_INADDR", line 19
ORA-06512: at "SYS.UTL_INADDR", line 40
ORA-06512: at line 1

Changes

Support, DataBase Administrators, Developers

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms