ORA-29273 ORA-06512 ORA-28862 - utl_http.request Always Takes Long Time (3 min) to Give The Error 'SSL connection failed' during SSL Handshake Process (Doc ID 457217.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Symptoms

You intermittently get the below error while trying to access https sites using utl_http.request package

ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-28862: SSL connection failed
ORA-06512: at line 1


Re-submitting the query again works fine. The main problem here is that Oracle Server takes about 3 minutes time to give the above error. You want to reduce this timeout period so that end users can get the error quickly, and then re-submit the query again.

You already have tried using utl_http.set_transfer_timeout  and  SQLNET.OUTBOUND_CONNECT_TIMEOUT sqlnet parameter. But irrespective of this, it always takes 3 minutes time to error out.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.