Managed Oracle Client with Oracle Advanced Security Options

.net entity-framework-6 odp.net oracle oracle12c

Question

The most recent version of Oracle's Oracle Managed Client, which was advertised as supporting Network Data Encryption, was released on October 14.

http://www.oracle.com/technetwork/topics/dotnet/tech-info/odac12cr4ds-2704217.pdfhttps://www.nuget.org/packages/Oracle.ManagedDataAccess/

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:

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

Accepted Answer

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:

http://docs.oracle.com/cd/E63277_01/win.121/e63268/featConnecting.htm#CJAGFFCA

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/5/2018 9:38:45 PM


Related Questions





Related

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