Managed Oracle Client with Oracle Advanced Security Options

.net entity-framework-6 oracle oracle12c


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 usORA-12570: Network Session: Unexpected packet read error exception includedThe 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:

    <setting name="SQLNET.AUTHENTICATION_SERVICES" value="NTS" />
    <setting name="NAMES.DIRECTORY_PATH" value="LDAP,tnsnames" />
11/13/2015 4:14:46 PM

Accepted Answer

Upgrading to ODP.NET 12.2 or later managed. There, 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

5/5/2018 9:38:45 PM

Related Questions


Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow