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
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!