Errors NativeErr = 7550 SSL Negotiation Failed Using DG4DRDA and a Self Signed Certificate (Doc ID 1393223.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.1 and later
Oracle Database Gateway for SQL Server - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms


Using DG4DRDA 11.2 with SSL (Secure Sockets Layer) connections and a self signed certificate gives the error -

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC DB2 Wire Protocol driver]SSL passed certificate is self signed and the same certificate cannot be found in the list of trusted certificates. {HY000,NativeErr = 7550}[Oracle][ODBC DB2 Wire Protocol driver]SSL Negotiation failed. {08001}
ORA-02063: preceding 2 lines from DB_LINK


A DG4DRDA debug trace shows the following -

Entered hgopoer at 2012/01/09-18:26:19
hgopoer, line 233: got native error 7550 and sqlstate HY000; message follows...
[Oracle][ODBC DB2 Wire Protocol driver]SSL passed certificate is self signed and the same certificate cannot be found in the list of trusted certificates. {HY000,NativeErr = 7550}[Oracle][ODBC DB2 Wire Protocol driver]SSL Negotiation failed. {08001}
Exiting hgopoer, rc=0 at 2012/01/09-18:26:19
hgocont, line 2752: calling SqlDriverConnect got sqlstate HY000
Exiting hgocont, rc=28500 at 2012/01/09-18:26:19 with error ptr FILE:hgocont.c LINE:2772 FUNCTION:hgocont() ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2012/01/09-18:26:19 with error ptr FILE:hgolgon.c LINE:781 FUNCTION:hgolgon() ID:Calling hgocont
Entered hgoexit at 2012/01/09-18:26:19
Exiting hgoexit, rc=0


The connection works successfully using a different SSL certificate.

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