The most recent version of Oracle's Oracle Managed Client, which was advertised as supporting Network Data Encryption, was released on October 14.
However, despite attempting several configurations, we were unable to make it function for some reason. The infamous continue to plague us
ORA-12570: Network Session: Unexpected packet read error
The provider did not return a ProviderManifestToken string
The alert log has the following mistake.
TNS-12599: TNS:cryptographic checksum mismatch
We did ensure that we were utilizing the approved encryption algorithm with the DBA.
My only current additional settings are as follows:
<settings> <setting name="SQLNET.AUTHENTICATION_SERVICES" value="NTS" /> <setting name="NAMES.DIRECTORY_PATH" value="LDAP,tnsnames" /> </settings>
Upgrading to ODP.NET 12.2 or later managed. There, https://docs.oracle.com/cd/E85694_01/ODPNT/featConnecting.htm#ODPNT8536 support for data integrity techniques was introduced.
Data integrity algorithms were not yet supported by ODP.NET, Managed Driver 12.1, or earlier:
This brings up TNS-12599: Your database alert log contains a TNS:cryptographic checksum mismatch error, which in turn results in a number of client-side issues, including ORA-12570: ORA-12537: Network Session: End of File, also known as Network Session: Unexpected Packet Read Error.
You can resolve this if you must use ODP.NET managed version 12.1 and are unable to update to version 12.2 or later by altering the database-side SQLNET.ORA settings such that checksums are NOT REQUIRED:
crypto checksum client = ACCEPTED in sqlnet
crypto checksum server = ACCEPTED in sqlnet