UTL_HTTP post receives ORA-29273: HTTP request failed/ORA-12545 target host or object does not exist
Date: Thu, 10 Jun 2021 15:22:18 -0700
Message-ID: <CACh5xi_kk6hvD36MDguOJZLB3DioWGdk4Nc1=8D6tpj2uqxP6A_at_mail.gmail.com>
Hi Everyone,
DB - 12c EE 64 bit (12.1.0.2)
We make http POST requests from our database server to another server
belonging to Mulesoft, by calling their API url.
This below is a snippet from our package:
A sample v_mulesoft_url looks like
In the last month or so we are frequently seeing the below errors in our
side:
ORA-29273: HTTP request failed
ORA-12545: Connect failed because target host or object does not exist
What is puzzling is, when we retry the POST 1 second later, the records are
sent successfully to Mulesoft.
Not sure why it is failing in the first attempt.
utl_http.set_wallet('file:/u01/app/oracle/wallet',
NULL);
v_req := utl_http.begin_request(v_mulesoft_url, 'POST',
' HTTP/1.1');
utl_http.set_header(v_req, 'content-type',
'application/json');
utl_http.set_header(v_req, 'client_id', v_client_id);
utl_http.set_header(v_req, 'client_secret',
v_client_secret);
utl_http.set_header(v_req, 'Content-Length',
length(v_content));
utl_http.write_text(v_req, v_content);
v_response := utl_http.get_response(v_req);
https://eisit.us.icf.com:443/ea10015-bts-oracleacebts-v1/api/exp/oracleacebts/v1/notifications
Can someone please help?
Thank you
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 11 2021 - 00:22:18 CEST