Errors NativeErr = 7550 SSL Negotiation Failed Using DG4DRDA and a Self Signed Certificate
(Doc ID 1393223.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database Gateway for DRDA - Version 11.2.0.1 and laterOracle 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
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
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
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
| Symptoms |
| Cause |
| Solution |
| References |