Hi,

I got ” ORA-29273: HTTP Request Failed ” error in Oracle database.

ORA-29273: HTTP Request Failed

Details of error are as follows.

SQL> select utl_http.request('https://www.ittutorial.org') from dual;
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at line 1

Cause:    The UTL_HTTP package failed to execute the HTTP request.

Action:   Use get_detailed_sqlerrm to check the detailed error message.
           Fix the error and retry the HTTP request.

The ORA-29273: HTTP Request Failed error is related with the connection or listener database.

check tnsping test as follows.

tnsping TNS_ALIAS

If tnsping is not OK, then check your network or listener settings.

HTTP Request Failed | ACL ( Access Control List )

Check your ACL if it is running properly or not. Give the related permissions for the users as follows.

grant execute on utl_http to username;
grant execute on utl_smtp to username;
grant execute on  utl_tcp to username;

You can read the following post to learn more details about Oracle ACL ( Access Control List )

https://ittutorial.org/oracle-acl-ora-24247-what-is-the-access-control-list-acl-and-how-to-create-and-grant-an-acl-in-oracle-database/

Do you want to learn Oracle SQL, then read the following articles.

Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course