OraBufWriter:ReadResetResponse - Unexpected Packet received — oracle-tech

    Forum Stats

  • 3,715,657 Users
  • 2,242,821 Discussions
  • 7,845,481 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

OraBufWriter:ReadResetResponse - Unexpected Packet received

6b87a72d-3a22-4774-a76e-a5b5dae0607e
edited September 2019 in ODP.NET

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

Answers

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,751 Employee
    edited August 2019

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

  • 6b87a72d-3a22-4774-a76e-a5b5dae0607e
    edited August 2019

    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

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,751 Employee
    edited August 2019

    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.

  • 6b87a72d-3a22-4774-a76e-a5b5dae0607e
    edited August 2019

    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.

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,751 Employee
    edited August 2019

    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.

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,751 Employee
    edited September 2019

    Bug 30355981 has been filed to track this issue.

    Alex Keh-Oracle
Sign In or Register to comment.