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 NOVEMBER 10, 2016

Applies to:

PL/SQL - Version 10.2.0.3 and later
Advanced Networking Option - Version 10.2.0.3 and later
Information in this document applies to any platform.
Checked for relevance on 06-JUN-2013


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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms