My Oracle Support Banner

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 MARCH 05, 2019

Applies to:

PL/SQL - Version and later
Advanced Networking Option - Version 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!

In this Document

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