Hi,
Please help - I'm having problems connecting to the database (Oracle EE 11.2.0.4.0 with AEO for Linux) from a ASP.NET MVC5 app.
I'm using the Oracle Managed Driver (downloaded via nuget) v. 12.1.2400 with EF 6.1.3.
All works fine when the application is run from the Visual Studio 2013 debugger, but when placed on a Windows 2012 server (connection string pointing to the same database), the application returns this exception:
OraBufWriter:ReadResetResponse - Unexpected Packet received
The only thing I've found via Google that comes close was related to a bug when using the advanced encryption option, but that bug was supposedly fixed.
Connection String: No tnsnames.ora file used. I've tried both EZConnect & full descriptor in web.config, both of which work on the development machine. I can successfully connect to the database from the Windows 2012 server using SQL*Plus with same credentials and EZConnect.
Here is a snippet from the trace file where the error takes place after turning on TraceLevel 7 in web.config:
2016-04-19 12:55:19.718608 TID:13 (NET) (REC) AA A9 A8 AD 00 00 |...... |
2016-04-19 12:55:19.718608 TID:13 (PRI) (ENT) TTCAuthenticate.ReceiveOAuthResponse()
2016-04-19 12:55:19.718608 TID:13 (PRI) (TTC) (ERR) TTCAuthenticate.ReceiveOAuthResponse() (txnid=n/a) System.Exception: OraBufWriter:ReadResetResponse - Unexpected Packet received.
at OracleInternal.TTC.MarshallingEngine.ProcessReset()
at OracleInternal.TTC.TTCAuthenticate.ReceiveOAuthResponse(Boolean bVerifyResponseFromServer)
2016-04-19 12:55:19.718608 TID:13 (PRI) (EXT) TTCAuthenticate.ReceiveOAuthResponse()
2016-04-19 12:55:19.718608 TID:13 (PRI) (TTC) (EXT) TTCAuthenticate.ReceiveOAuthResponse()
2016-04-19 12:55:19.718608 TID:13 (PRI) (ENT) OracleConnectionImpl.DoAuthentication()
2016-04-19 12:55:19.718608 TID:13 (PRI) (SVC) (ERR) OracleConnectionImpl.DoAuthentication() (txnid=n/a) System.Exception: OraBufWriter:ReadResetResponse - Unexpected Packet received.
at OracleInternal.TTC.MarshallingEngine.ProcessReset()
at OracleInternal.TTC.TTCAuthenticate.ReceiveOAuthResponse(Boolean bVerifyResponseFromServer)
at OracleInternal.ServiceObjects.OracleConnectionImpl.DoAuthentication(String userId, String password, String proxyUserId, String proxyPassword, String newPassword, Boolean bDoExternalAuth, Boolean bOpenEndUserSession)
2016-04-19 12:55:19.718608 TID:13 (PRI) (EXT) OracleConnectionImpl.DoAuthentication()
2016-04-19 12:55:19.718608 TID:13 (PRI) (SVC) (EXT) OracleConnectionImpl.DoAuthentication()
2016-04-19 12:55:19.718608 TID:13 (PRI) (ENT) OracleConnectionImpl.Connect()
2016-04-19 12:55:19.718608 TID:13 (PRI) (SVC) (ERR) OracleConnectionImpl.Connect() (txnid=n/a) System.Exception: OraBufWriter:ReadResetResponse - Unexpected Packet received.
at OracleInternal.TTC.MarshallingEngine.ProcessReset()
at OracleInternal.TTC.TTCAuthenticate.ReceiveOAuthResponse(Boolean bVerifyResponseFromServer)
at OracleInternal.ServiceObjects.OracleConnectionImpl.DoAuthentication(String userId, String password, String proxyUserId, String proxyPassword, String newPassword, Boolean bDoExternalAuth, Boolean bOpenEndUserSession)
at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, String instanceName)
2016-04-19 12:55:19.718608 TID:13 (PRI) (EXT) OracleConnectionImpl.Connect()
2016-04-19 12:55:19.718608 TID:13 (PRI) (SVC) (EXT) OracleConnectionImpl.Connect() (oper=open) (aff=n/a) (inst=) (affmatch=n/a) (sessid=-1:-1) (F;F;F;;N) (pmid=14509711)
2016-04-19 12:55:19.718608 TID:10 (PRI) (ENT) PoolManager`3.CreateNewPR()
2016-04-19 12:55:19.718608 TID:10 (PRI) (ERR) (CP) PoolManager`3.CreateNewPR() (txnid=n/a) System.Exception: OraBufWriter:ReadResetResponse - Unexpected Packet received.
at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd, String instanceName)
2016-04-19 12:55:19.718608 TID:10 (PRI) (EXT) PoolManager`3.CreateNewPR()
2016-04-19 12:55:19.718608 TID:10 (PRI) (EXT) (CP) PoolManager`3.CreateNewPR() (aff=n/a) (inst=) (affmatch=n/a) (sessid=-1:-1) (F;F;F;;N) (pmid=14509711)
2016-04-19 12:55:19.718608 TID:10 (PRI) (EXT) (CP) PoolManager`3.Get() (txnid=n/a) PM.Get(aff=;force=F) returning (null)
2016-04-19 12:55:19.718608 TID:10 (PRI) (ENT) OraclePoolManager.Get()
2016-04-19 12:55:19.718608 TID:10 (PRI) (ERR) (CP) OraclePoolManager.Get() (txnid=n/a) System.Exception: OraBufWriter:ReadResetResponse - Unexpected Packet received.
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)
2016-04-19 12:55:19.718608 TID:10 (PRI) (EXT) OraclePoolManager.Get()
2016-04-19 12:55:19.718608 TID:10 (PRI) (EXT) (CP) OraclePoolManager.Get() (txnid=n/a)
2016-04-19 12:55:19.734228 TID:10 (PRI) (ENT) OracleConnectionDispenser`3.Get()
2016-04-19 12:55:19.734228 TID:10 (PRI) (ERR) (CP) OracleConnectionDispenser`3.Get() (txnid=n/a) System.Exception: OraBufWriter:ReadResetResponse - Unexpected Packet received.
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)
2016-04-19 12:55:19.734228 TID:10 (PRI) (EXT) OracleConnectionDispenser`3.Get()
2016-04-19 12:55:19.734228 TID:10 (PRI) (EXT) (CP) OracleConnectionDispenser`3.Get() (txnid=n/a)
2016-04-19 12:55:19.734228 TID:10 (PRI) (ENT) OracleConnection.Open()
2016-04-19 12:55:19.734228 TID:10 (PUB) (ERR) OracleConnection.Open() (txnid=n/a) System.Exception: OraBufWriter:ReadResetResponse - Unexpected Packet received.
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()
2016-04-19 12:55:19.734228 TID:10 (PRI) (EXT) OracleConnection.Open()
2016-04-19 12:55:19.734228 TID:10 (PUB) (EXT) OracleConnection.Open() (conid=58152443) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a)
2016-04-19 12:55:19.749850 TID:10 (PUB) (ENT) OracleConnection.Dispose()
2016-04-19 12:55:19.749850 TID:10 (PUB) (EXT) OracleConnection.Dispose()
2016-04-19 12:55:19.781095 TID:13 (PRI) (EXT) (CP) PoolManager`3.CreateNewPRThreadFunc()