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.
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 )
Do you want to learn Oracle SQL, then read the following articles.
4,306 views last month, 4 views today