Hmmm ...not sure what's going on, but ORA-12545 is a network connectivity
problem. The fact that it's intermittent would lead me to ask you if you
perhaps have some type of network connectivity issue, likely below the
level of Oracle?
-Mark
On Thu, Jun 10, 2021, 18:22 Panchanathan Suresh <suresh.gm@xxxxxxxxx> wrote:
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
