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:
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);
A sample v_mulesoft_url looks like
https://eisit.us.icf.com:443/ea10015-bts-oracleacebts-v1/api/exp/oracleacebts/v1/notifications
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.
Can someone please help?
Thank you