Hi,
Hoping someone can point me in the right direction with the following blocking point. We have attempted multiple configuration combinations and tests before reaching this point of reaching out to the forum.
We are experiencing a problem with the Oracle 12.2c Managed Driver. We have an application which uses a combination of unmanaged and managed clients. Enabling encryption at the database connection level causes a problem. An article updated on 26 October 2015 indicates encryption is supported in the Oracle 12.2c Managed Driver. It in turn points to an article https://apex.oracle.com/pls/apex/f?p=18357:39:18138408495219::NO::P39_ID:28201 which declares the supportability of encyption in the driver.
The version of the current driver in our product is 4.121.2.0 and we also downloaded the driver from http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html.
The sqlnet.ora settings on the server are the following:
SQLNET.ENCRYPTION_SERVER = required
SQLNET.CRYPTO_SEED = 'xxxx'
SQLNET.ENCRYPTION_TYPES_SERVER= (AES256)
The message received when attempting to connect before adding configuration settings is:
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12537: Network Session: End of file ---> OracleInternal.Network.NetworkException (0x000030F9): ORA-12537: Network Session: End of file
at OracleInternal.Network.ReaderStream.Read(OraBuf OB)
at OracleInternal.TTC.OraBufReader.GetDataFromNetwork()
at OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData)
at OracleInternal.TTC.MarshallingEngine.UnmarshalUB1(Boolean bIgnoreData)
at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()
at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd, String instanceName)
at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, String affinityInstanceName, Boolean bForceMatch)
at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, String affinityInstanceName, Boolean bForceMatch)
at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword)
at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
The following configuration settings were added in the web config file:
<oracle.manageddataaccess.client>
<version number="4.121.2.0">
<settings>
<setting name="TraceLevel" value="7" />
<setting name="TraceOption" value="1"/>
<setting name="TraceFileLocation" value="C:\temp"/>
<setting name="SQLNET.ENCRYPTION_CLIENT" value="required"/>
<setting name="SQLNET.ENCRYPTION_TYPES_CLIENT" value="AES256" />
</settings>
</version>
</oracle.manageddataaccess.client>
The error messsage after adding the configuration settings listed above is the following:
OracleInternal.Network.NetworkException (0x000030F9): ORA-12537: Network Session: End of file
at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd, String instanceName)
at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, String affinityInstanceName, Boolean bForceMatch)
at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, String affinityInstanceName, Boolean bForceMatch)
at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword)
at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
Thank you in advance.
Cheers,
Charl