Hi, friends!
I'm terribly sorry I'm trying to bring this topic up again, but after trying all hints and tricks I found online I still cannot figure it out.
Some time ago our server was configured to require encryption.
At the time we had following:
ODP:
<package id="Oracle.ManagedDataAccess" version="12.1.021" targetFramework="net45" />
<package id="Oracle.ManagedDataAccess.EntityFramework" version="12.1.021" targetFramework="net45" />
Server:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
Server configuration was set to:
SQLNET.ENCRYPTION_TYPES_SERVER = AES192
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (md5)
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED
SQLNET.ENCRYPTION_SERVER = REQUIRED
Initially connection was failing because encryption is not supported in ODP of that version. We resolved problem by setting:
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUSTED
SQLNET.ENCRYPTION_SERVER = REQUSTED
All cool and dandy! However, new ODP version came out and we would like to use it, because encryption support and other improvements. I bet you understand desire :-)
So, I thought transition will be a no-brainer... We have working config after all and simple binaries replacement should do the trick...
How wrong I was!..
I've installed latest nuget...
Now our ODP is:
<package id="Oracle.ManagedDataAccess" version="12.1.2400" targetFramework="net45" />
<package id="Oracle.ManagedDataAccess.EntityFramework" version="12.1.2400" targetFramework="net45" />
When I attemp to run web app it gives us following exception:
[NetworkException (0x30f9): ORA-12537: Network Session: End of file]
OracleInternal.Network.ReaderStream.Read(OraBuf OB) +388
OracleInternal.TTC.OraBufReader.GetDataFromNetwork() +205
OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData) +52
OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse() +78
[OracleException (0x80004005): ORA-12537: Network Session: End of file]
Hub.Web5.EPVWrappingConnectionFactory.CreateConnection(String nameOrConnectionString) in c:\Chase\Projects\RTSHub\branches\OracleSupport\src\Hub.Web5\Global.asax.cs:52
System.Data.Entity.Internal.LazyInternalConnection.Initialize() +305
System.Data.Entity.Internal.LazyInternalConnection.get_ProviderName() +13
System.Data.Entity.Internal.LazyInternalContext.get_ProviderName() +11
System.Data.Entity.Internal.DefaultModelCacheKeyFactory.Create(DbContext context) +92
System.Data.Entity.Internal.LazyInternalContext.InitializeContext() +515
System.Data.Entity.Internal.InternalContext.ForceOSpaceLoadingForKnownEntityTypes() +50
System.Data.Entity.DbContext.System.Data.Entity.Infrastructure.IObjectContextAdapter.get_ObjectContext() +25
Repository.Hub.HubContext..ctor() in c:\Chase\Projects\RTSHub\branches\OracleSupport\src\Repository.Hub\HubContext.cs:40
lambda_method(Closure , IBuildSession , IContext ) +131
I bet this looks familiar to lot of people here...
I have trying following:
1. Set rejected in settings
2. Disable FIPS compliance for MS AES implementation
Nothing resolved problem!
But, I have an interesting observation - I am able to connect using VS Server Explorer with data source from solution. I guess difference is that VS does not use EF in addition to managed driver.
You know what i mean - just plain ADO.NET.
Please help to sort this out!
Is there something that really need to be checked on server side that may contribute to the same error? I will try to squire some information from DBAs.
Is there any expectation that April release will improve in this area?
Any suggestions will be appreciated!