UTL_HTTP Fails With Ora-28750 And The Trace Contains "C_SetCertBER() returned error 1793" (Doc ID 2229645.1)

Last updated on FEBRUARY 23, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The UTL_HTTTP code is failing with the following error in 11.2.0.4 database but the same SHA-2 type certificate is working fine with 12c database.

ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1720
ORA-28750: unknown error
ORA-06512: at line 1

And the trace file shows following error

C_SetCertBER() returned error 1793 

Changes

 New SHA256 type certificates are installed to external site. Earlier it was using SHA-1 certificates.

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