I agree, also this is a case where Wireshark can be useful. Just filter on
the target host and port, it may help you diagnostic
fre. 11. jun. 2021 kl. 07:16 skrev Mark J. Bobak <mark@xxxxxxxxx>:
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?
On Thu, Jun 10, 2021, 18:22 Panchanathan Suresh <suresh.gm@xxxxxxxxx>
DB - 12c EE 64 bit (22.214.171.124)
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:
v_req := utl_http.begin_request(v_mulesoft_url,
'POST', ' HTTP/1.1');
utl_http.set_header(v_req, 'client_id', v_client_id);
v_response := utl_http.get_response(v_req);
A sample v_mulesoft_url looks like
In the last month or so we are frequently seeing the below errors in our
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?