SQL Developer connection reset when sqlnet data integrity is enabled

Posted on July 19, 2016 by steakandshake

A developer reported getting the following connection reset message box while using SQL Developer 4.1.3.20, and a 12c database in which encryption and sqlnet data integrity (checksumming) had been enabled. Here’s the error from Sql Developer:

"Your database connection has been reset.
Any pending transactions or session state has been lost."

Server sqlnet.ora:

SQLNET.CRYPTO_CHECKSUM_SERVER = REQUESTED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA512, SHA384, SHA256)

The developer reported that the error did not occur while using SQL Developer 4.0.0.13. I was able to reproduce the error with 4.1.3.20.

I commented out the crypto_checksum…server lines from the database server’s sqlnet.ora and reloaded the listener. Sql Developer connected successfully! So it appears that Sql Developer or its jdbc thin driver doesn’t work well with sqlnet data integrity (checksumming).

This entry was posted in Uncategorized. Bookmark the permalink.