GETTING ORA-24247 WHEN PERFORMING UTL_HTTP.READ_TEXT (Doc ID 1587176.1)

Last updated on MARCH 06, 2016

Applies to:

PL/SQL - Version 11.2.0.1 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

While trying to access websites through Oracle Wallets, getting the below error after the connection is established and in the middle of the reads.
----------
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1474
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "APPS.C3_MAKE_WS_REQUEST", line 160
ORA-06512: at line 13
ORA-06512: at line 68
----------

Socket tracing would show something like below:

 

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