Java.sql.SQLRecoverableException: IO Error: Unknown Authentication, Encryption Or Data Integrity When Trying to Establish JDBC Connection
(Doc ID 2661210.1)
Last updated on JANUARY 04, 2023
Applies to:
JDBC - Version 18.0.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
While connecting to an Oracle 11.2.0.4 database with an application using JDK 1.8 and ojdbc8.jar (JDBC drivers 19.3), and with the following configuration in the sqlnet.ora file at the database side:
SQLNET.ENCRYPTION_TYPES_SERVER = (AES256,AES192,AES128)
SQLNET.ENCRYPTION_SERVER = accepted
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER= (SHA1)
SQLNET.CRYPTO_CHECKSUM_SERVER = accepted
the following error is received:
java.sql.SQLRecoverableException: IO Error: Unknown Authentication, Encryption or Data Integrity algorithm
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
ERROR
----------------
IO Error: Unknown Authentication, Encryption or Data Integrity algorithm
STEPS
------------------
The issue can be reproduced at will with the following steps:
1. Configure database sqlnet.ora with:
SQLNET.ENCRYPTION_TYPES_SERVER = (AES256,AES192,AES128)
SQLNET.ENCRYPTION_SERVER = accepted
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER= (SHA1)
SQLNET.CRYPTO_CHECKSUM_SERVER = accepted
2. Try to connect from JDBC 19.3.
Changes
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 |
Changes |
Cause |
Solution |
References |