Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ORA-29273: HTTP request failed

Damola AzeezSep 11 2021 — edited Sep 11 2021

I have an oracle database running on a Linux server. The server initially had just one interface (eth0). So i added a new interface and configured the linux server as a proxy client. After configuration, i can reach all desired network when i do a curl.

But when i try running
"select apex_web_service.make_rest_request(p_url => 'http://10.10.10.24:8012', p_http_method => 'GET') from dual;"
I get the error

ERROR:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-12543: TNS:destination host unreachable
ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1017
ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1523
ORA-06512: at "APEX_180200.WWV_FLOW_WEBSERVICES_API", line 369
ORA-06512: at line 1

But a curl http://10.10.10.24:8012 is successful.
I disabled the proxy configuration and tried the connection from the database just to be sure it isnt a proxy issue and i still cant get the database to connect to the url.

I have ACL setup on the database

SQL> SELECT host, lower_port, upper_port, privilege, status
FROM user_network_acl_privileges; 2

HOST
--------------------------------------------------------------------------------
LOWER_PORT UPPER_PORT PRIVILE STATUS
---------- ---------- ------- -------
*
connect GRANTED

*
resolve GRANTED

10.10.10.24
8012 8012 connect GRANTED

What could be the issue? Any assistance would be highly appreciated

Comments
Post Details
Added on Sep 11 2021
1 comment
7,992 views