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 to [Release 11.1 to 11.2]
PL/SQL - Version to [Release 11.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 14-Feb-2014


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

        l_url varchar2(32767);
        l_conn utl_http.req;
        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');

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


Support, DataBase Administrators, Developers


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