Re: UTL_HTTP post receives ORA-29273: HTTP request failed/ORA-12545 target host or object does not exist

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_at_bobak.net>:

> 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_at_gmail.com>
> 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
>>
>>

-- 
Øyvind Isene
+47 90864882

--
http://www.freelists.org/webpage/oracle-l