6 Replies Latest reply on Sep 26, 2019 4:28 PM by Alex Keh - Product Manager-Oracle

    OraBufWriter:ReadResetResponse - Unexpected Packet received

    6b87a72d-3a22-4774-a76e-a5b5dae0607e

      Using Oracle.ManagedDataAccess.Core 2.19.31 to manage the connection to an onsite Oracle database.

       

      I'm able to run queries when i build my .net core application on the IDE, but when publishing it to my local IIS server running Kestral it gives the following error:

       

      Exception: OraBufWriter:ReadResetResponse - Unexpected Packet received.

      • OracleInternal.ConnectionPool.PoolManager<PM, CP, PR>.CreateNewPR(int reqCount, bool bForPoolPopulation, ConnectionString csWithDiffOrNewPwd, OracleConnection connRefForCriteria, string instanceName, List<string> switchFailedInstNames)

      • OracleInternal.ConnectionPool.PoolManager<PM, CP, PR>.Get(ConnectionString csWithDiffOrNewPwd, bool bGetForApp, OracleConnection connRefForCriteria, string affinityInstanceName, bool bForceMatch)

      • OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, bool bGetForApp, OracleConnection connRefForCriteria, string affinityInstanceName, bool bForceMatch)

      • OracleInternal.ConnectionPool.OracleConnectionDispenser<PM, CP, PR>.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)

      • Oracle.ManagedDataAccess.Client.OracleConnection.Open()

       

      The only relevant issue that I could find for reference is this one: OraBufWriter:ReadResetResponse - Unexpected Packet received

       

       

      I've also tried turning on tracing, but nothing seems to be generating. These are the trace options I configured with OracleConfiguration before opening my OracleConnection:

                      OracleConfiguration.TraceOption = 1;

                      OracleConfiguration.TraceFileLocation = @"C:\logs";

                      OracleConfiguration.TraceLevel = 7;

       

      Any help would be appreciated. Thanks

        • 1. Re: OraBufWriter:ReadResetResponse - Unexpected Packet received
          Alex Keh - Product Manager-Oracle

          What operating system, OS version, and .NET Core version are you using?

          • 2. Re: OraBufWriter:ReadResetResponse - Unexpected Packet received
            6b87a72d-3a22-4774-a76e-a5b5dae0607e

            The operating system is Windows 10 Pro Version 1809 (OS Build 17763.652)

            IIS version  is 10.0.17763.1

            I'm currently current .Net core 2.2

            • 3. Re: OraBufWriter:ReadResetResponse - Unexpected Packet received
              Alex Keh - Product Manager-Oracle

              Nothing appears out of the ordinary with the OS and .NET Core versions being used.

               

              The trace file would be very useful for debugging. My guess why you can't write a trace file is due to the C:\ being a Windows-protected drive that requires admin privileges. Try using another directory that doesn't require admin privileges to write to.

              • 4. Re: OraBufWriter:ReadResetResponse - Unexpected Packet received
                6b87a72d-3a22-4774-a76e-a5b5dae0607e

                Thanks for you help,

                 

                I got trace files  to come up and this is the error it is returning:

                 

                2019-08-21 17:16:18.632990 TID:6   (PRI) (ENT) TTCAuthenticate.ReceiveOAuthResponse()

                2019-08-21 17:16:18.643241 TID:6   (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()

                2019-08-21 17:16:18.643287 TID:6   (PRI) (EXT) TTCAuthenticate.ReceiveOAuthResponse()

                2019-08-21 17:16:18.643359 TID:6   (PRI) (TTC) (EXT) TTCAuthenticate.ReceiveOAuthResponse()

                2019-08-21 17:16:18.643384 TID:6   (PRI) (ENT) OracleConnectionImpl.DoAuthentication()

                2019-08-21 17:16:18.643478 TID:6   (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()

                   at OracleInternal.ServiceObjects.OracleConnectionImpl.DoAuthentication(String userId, SecureString securePassword, String proxyUserId, SecureString secureProxyPassword, SecureString secureNewPassword, Boolean bDoExternalAuth, Boolean bOpenEndUserSession)

                2019-08-21 17:16:18.643499 TID:6   (PRI) (EXT) OracleConnectionImpl.DoAuthentication()

                2019-08-21 17:16:18.643536 TID:6   (PRI) (SVC) (EXT) OracleConnectionImpl.DoAuthentication()

                2019-08-21 17:16:18.643552 TID:6   (PRI) (ENT) OracleConnectionImpl.Connect()

                2019-08-21 17:16:18.643614 TID:6   (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()

                   at OracleInternal.ServiceObjects.OracleConnectionImpl.DoAuthentication(String userId, SecureString securePassword, String proxyUserId, SecureString secureProxyPassword, SecureString secureNewPassword, Boolean bDoExternalAuth, Boolean bOpenEndUserSession)

                   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)

                2019-08-21 17:16:18.643631 TID:6   (PRI) (EXT) OracleConnectionImpl.Connect()

                2019-08-21 17:16:18.643677 TID:6   (PRI) (SVC) (EXT) OracleConnectionImpl.Connect() (oper=open) (aff=n/a) (inst=) (affmatch=n/a) (pr.service=) (pr.pdb=) (pr.edition=) (sessid=-1:-1) (F;F;F;;N) (pmid=13500861)

                2019-08-21 17:16:18.643712 TID:6   (PRI) (EXT) (CP) PoolManager.CreateNewPRThreadFunc()

                2019-08-21 17:16:18.643749 TID:7   (PRI) (ENT) PoolManager.CreateNewPR()

                2019-08-21 17:16:18.643831 TID:7   (PRI) (ERR) (CP) PoolManager.CreateNewPR() (txnid=n/a) System.Exception: OraBufWriter:ReadResetResponse - Unexpected Packet received.

                   at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd, OracleConnection connRefForCriteria, String instanceName, List`1 switchFailedInstNames)

                2019-08-21 17:16:18.643859 TID:7   (PRI) (EXT) PoolManager.CreateNewPR()

                2019-08-21 17:16:18.643906 TID:7   (PRI) (EXT) (CP) PoolManager.CreateNewPR() (aff=n/a) (inst=) (affmatch=n/a) (pr.service=) (pr.pdb=) (pr.edition=) (sessid=-1:-1) (F;F;F;;N) (pmid=13500861)

                2019-08-21 17:16:18.643932 TID:7   (PRI) (EXT) (CP) PoolManager.Get() (txnid=n/a) PM.Get(aff=;force=F) returning (null)

                2019-08-21 17:16:18.643952 TID:7   (PRI) (ENT) OraclePoolManager.Get()

                2019-08-21 17:16:18.644101 TID:7   (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, OracleConnection connRefForCriteria, String instanceName, List`1 switchFailedInstNames)

                   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)

                   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)

                2019-08-21 17:16:18.644122 TID:7   (PRI) (EXT) OraclePoolManager.Get()

                2019-08-21 17:16:18.644166 TID:7   (PRI) (EXT) (CP) OraclePoolManager.Get() (txnid=n/a)

                2019-08-21 17:16:18.645535 TID:7   (PRI) (ENT) OracleConnectionDispenser.Get()

                2019-08-21 17:16:18.645608 TID:7   (PRI) (ERR) (CP) OracleConnectionDispenser.Get() (txnid=n/a) System.Exception: OraBufWriter:ReadResetResponse - Unexpected Packet received.

                   at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd, OracleConnection connRefForCriteria, String instanceName, List`1 switchFailedInstNames)

                   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)

                   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)

                   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)

                2019-08-21 17:16:18.645635 TID:7   (PRI) (EXT) OracleConnectionDispenser.Get()

                2019-08-21 17:16:18.645675 TID:7   (PRI) (EXT) (CP) OracleConnectionDispenser.Get() (txnid=n/a)

                2019-08-21 17:16:18.645698 TID:7   (PRI) (ENT) OracleConnection.Open()

                2019-08-21 17:16:18.645832 TID:7   (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, OracleConnection connRefForCriteria, String instanceName, List`1 switchFailedInstNames)

                   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)

                   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)

                   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)

                   at Oracle.ManagedDataAccess.Client.OracleConnection.Open()

                2019-08-21 17:16:18.645852 TID:7   (PRI) (EXT) OracleConnection.Open()

                2019-08-21 17:16:18.645906 TID:7   (PUB) (EXT) OracleConnection.Open() (conid=4476320) (state=Closed) (sessid=0) (implid=0) (pooling=F) (txnid=n/a)

                2019-08-21 17:16:18.646802 TID:7   (PUB) (ENT) OracleConnection.Dispose()

                2019-08-21 17:16:18.646834 TID:7   (PUB) (EXT) OracleConnection.Dispose()

                 

                 

                In the response header just before this error comes up on the trace. The last couple of lines in the header is this:

                 

                ORA-04088: error during execution of trigger 'SYSTEM.LOGONTRG'.ORA-00604: errorred at recursive SQL level 1.

                ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

                ORA-06512: at "SYSTEM.LOG_SESSION_INFO", line 38.ORA-06512: at line 2.

                 

                which is what i'm guessing is causing the error.

                • 5. Re: OraBufWriter:ReadResetResponse - Unexpected Packet received
                  Alex Keh - Product Manager-Oracle

                  There is no existing ODP.NET bug that matches these symptoms. Can you publish your test case or email it to dotnet_us (at) oracle.com? We can try reproducing the issue in house to isolate the root cause.