"IO Error: Checksum Fail" When Connecting With Thin Driver Over TCPS And ANO Checksumming Is Enabled
(Doc ID 2972259.1)
Last updated on SEPTEMBER 11, 2023
Applies to:
JDBC - Version 21.5 to 23.2 [Release 21]Information in this document applies to any platform.
Symptoms
Unable to connect Database due to "IO Error: Checksum Fail"
When Connecting With Thin Driver Over TCPS And ANO Checksumming Is Enabled
This is because the database instance has Oracle Native Encryption checksumming enabled. From database instance sqlnet.ora:
# Enable native encryption
SQLNET.ENCRYPTION_SERVER = REQUESTED
SQLNET.ENCRYPTION_TYPES_SERVER = (AES256)
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUESTED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA512)
SQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS = TRUE
If from database instance sqlnet.ora If we change the value:
SQLNET.CRYPTO_CHECKSUM_SERVER = ACCEPTED
Then JDBC thin driver connects without issues:
THICK/OCI driver does not have this issue.
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 |