We have recently tried to roll our product out to a client who uses ASO, and are receiving an error we have not encountered before and haven't been able to find much guidance online. We are getting a core error of "ORA-12537: Network Session: End of file" when we try to execute any commands.
The only relevant article I could find was Burelson's article: http://www.dba-oracle.com/t_ora_12537_tns_error.htm
However, the path shouldn't be causing problems:
"C:\Oracle_ODAC\product\12.1.0\client_1"
We aren't using TNS Names, using an inline connections string copied from a known working Data Source address:
"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=[SERVER])(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST))); User ID=[USER];Password=[PASSWORD];Connection Timeout=60;"
The Data Source isn't really any longer then other ones we use in other environments
We are using the new ODAC 12C Release 4 via Nuget.
Any help or suggestions would be greatly appreciated!
Full exception details:
System.Data.Entity.Core.ProviderIncompatibleException: An error occurred accessing the database. This usually means that the connection to the database failed. Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application's config file. See http://go.microsoft.com/fwlink/?LinkId=386386 for information on DbContext and connections. See the inner exception for details of the failure. ---> System.Data.Entity.Core.ProviderIncompatibleException: The provider did not return a ProviderManifestToken string. ---> Oracle.ManagedDataAccess.Client.OracleException: ORA-12570: Network Session: Unexpected packet read error ---> OracleInternal.Network.NetworkException: ORA-12570: Network Session: Unexpected packet read error ---> OracleInternal.Network.NetworkException: ORA-12537: Network Session: End of file
at OracleInternal.Network.ReaderStream.ReadIt(OraBuf OB, Int32 len)
at OracleInternal.Network.ReaderStream.ReadwithCrypto(OraBuf OB)
--- End of inner exception stack trace ---
at OracleInternal.Network.ReaderStream.ReadwithCrypto(OraBuf OB)
at OracleInternal.Network.ReaderStream.Read(OraBuf OB)
at OracleInternal.TTC.OraBufReader.GetDataFromNetwork()
at OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData)
at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()
--- End of inner exception stack trace ---
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()
at Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices.GetDbProviderManifestToken(DbConnection connection)
at System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)
--- End of inner exception stack trace ---
at System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)
at System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection)
--- End of inner exception stack trace ---
at System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection)
at System.Data.Entity.Infrastructure.DefaultManifestTokenResolver.<>c__DisplayClass1.<ResolveManifestToken>b__0(Tuple`3 k)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
at System.Data.Entity.Infrastructure.DefaultManifestTokenResolver.ResolveManifestToken(DbConnection connection)
at System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest& providerManifest)
at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
at System.Data.Entity.Internal.InternalContext.ForceOSpaceLoadingForKnownEntityTypes()
at System.Data.Entity.DbContext.System.Data.Entity.Infrastructure.IObjectContextAdapter.get_ObjectContext()
at ______.DataAccess.______Context..ctor()
at ______.Presentation.Web.Authorization.LoadRolesAsAdmin()
at ______.Presentation.Web.Login.AuthorizeAdmin()
at ______.Presentation.Web.Login.Login_Click(Object sender, EventArgs e)
<connectionStrings>
<add
name="Entities"
connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=[SERVER])(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST))); User ID=[USER];Password=[PASSWORD];Connection Timeout=60;"
providerName="Oracle.ManagedDataAccess.Client" />
</connectionStrings>