Forum Stats

  • 3,757,128 Users
  • 2,251,200 Discussions
  • 7,869,736 Comments

Discussions

ORA-29273: HTTP request failed

Damola Azeez
Damola Azeez Member Posts: 5 Red Ribbon
edited Sep 11, 2021 11:53PM in SQL & PL/SQL

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

Tagged: