Forum Stats

  • 3,814,069 Users
  • 2,258,812 Discussions
  • 7,892,521 Comments

Discussions

ORA-01017 with Managed Provider 4.112.3.60. Bug with ODP on Win 2008 R2?

24

Answers

  • Lannie Liberty
    Lannie Liberty Member Posts: 224 Blue Ribbon

    Thanks for the reply.

    I see the password in debugging display of variable values, so it is being passed without error.

    Oracle Connection String Builder variable looks normal in debugger as well.

    I will work on the app.config problem and rerun with TRACE.  The problem is VS2010 auto creates the app.config when you create a WPF project and I always have trouble compiling it.  The main reason I need app.config is to enabled the ODP trace functionality and declare the location of tnsnames.ora.  I do not need it to define connection information, etc.  Connection information is gathered by an application dialog box to build Oracle connection credentials.

    Does use of the Managed Driver WRITE to the Windows Registry?

    If so, that would be good to add that information to the driver documentation.

    In production environments, often writing to registry (and even the EVENT LOG) is not allowed by Group Policy.

    I use the XCOPY version of ODP.NET and manually place the managed data access client dll into the application, thus machine.config and GAC are not used.

    I would prefer to force the application to use sqlnet.ora and tnsnames.ora placed in the application folder for portability around various machines all calling the same database family.  I see in the trace file that my sqlnet.ora and tnsnames.ora information are being loaded.

    I watched the application with Microsoft Process Monitor to exclude other OS system level errors that would halt the application.

    But so far, all logs and traces point to conn.open() as the place of failure.

    Expect more information from me by Monday.

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 3,052 Employee

    We don't use the Registry. We attempt to write to the event log to indicate where the trace files are created, but the application will not be disrupted if ODP.NET managed driver can not write to the event log.

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 3,052 Employee

    My dev team did some further investigation. Is your application run from a network share or is the app.config/web.config read from a network share? If so, this KB article may be the source of the problem. This .NET 4 bug seems to fit your symptoms.

  • Lannie Liberty
    Lannie Liberty Member Posts: 224 Blue Ribbon

    App does not run in share drive, runs on operating system D:drive (However, I do access the Win 2008 via Citrix Desktop)

    Removed the canned tags created by Visual Studio from app.config which removed the app.config error noted earlier,

    recompiled, and ran app from test directory with this app.config and then app failed with this trace file

    As reminder:

    No installation of Managed Driver, so machine config should be clear of managed driver settings.

    Used XCOPY version of .60 beta, keeping the tnsnames.ora and sqlnet.ora copied from server Oracle Client > network > admin folder

    along with the three managed driver files in the test application folder.

    Not using transactional services.

    App is just simple test of managed driver calling list of tables with SELECT table_name FROM all_tab_cols and placing in List

    App environment is WPF .NET Classic 4.0

    OS is 64-bit Windows 2008R2

    Is the SQLNET NAMES.DEFAULT_DOMAIN : (WORLD) supported?

    From trace file, looks like YES as I submit the SID MYDB to the connection string builder and Managed Driver adds (as it should) the domain name .WORLD

    Also as reminder, this app works just fine with UNMANAGED driver compile in same environment.

    +++++++++++++++++++++++++++++

      <?xml version="1.0"?>

      <configuration>

       <configSections>

           <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler,Oracle.ManagedDataAccess" />

         </configSections>

    <system.data>

       <DbProviderFactories>

         <remove invariant="Oracle.ManagedDataAccess.Client" />

         <add name="ODP.NET,Managed Driver"  invariant="Oracle.ManagedDataAccess.Client"   description="Oracle Data Provider for .NET, Managed Driver"   type="Oracle.ManagedDataAccess.Client.OracleClientFactory,
    Oracle.ManagedDataAccess, Version=4.112.3.60, Culture=neutral, PublicKeyToken=89b483f429c47342" />

       </DbProviderFactories>

    </system.data>

    <oracle.manageddataaccess.client>

       <version number="*">

         <settings>

           <setting name="TNS_ADMIN" value="D:\ME\testapp"/>

           <setting name="TraceFileLocation" value=" D:\ME\testapp"/>

           <setting name="TraceLevel" value="7" />

           <setting name="TraceOption" value="1"/>

       </settings>

       </version>

      <version number="4.112.3.60">

        <settings></settings>

       </version>

    </oracle.manageddataaccess.client>

    </configuration>

    +++++++++++++++++++++++++++++++++++++++++++++

    2013-07-22 11:08:32.006660 TID:1   (CFG) (ENV)      Machine Name : Win2008Svr

    2013-07-22 11:08:32.022285 TID:1   (CFG) (ENV)      User Name : ME

    2013-07-22 11:08:32.022285 TID:1   (CFG) (ENV)      OS Version : Microsoft Windows NT 6.1.7601 Service Pack 1

    2013-07-22 11:08:32.022285 TID:1   (CFG) (ENV)      64-bit OS : True

    2013-07-22 11:08:32.022285 TID:1   (CFG) (ENV)      64-bit Process : True

    2013-07-22 11:08:32.022285 TID:1   (CFG) (ENV)      .NET Runtime Version : 4.0.30319.1008

    2013-07-22 11:08:32.022285 TID:1   (CFG) (VER)      Oracle Data Provider for .NET, Managed Driver Version : 4.112.3.60

    2013-07-22 11:08:32.022285 TID:1   (CFG) (.NET)     TraceOption : 1

    2013-07-22 11:08:32.022285 TID:1   (CFG) (.NET)     TraceFileLocation : D:\Me\testapp

    2013-07-22 11:08:32.022285 TID:1   (CFG) (.NET)     TNS_ADMIN : D:\Me\testapp

    2013-07-22 11:08:32.022285 TID:1   (CFG) (.NET)     TraceLevel : 7

    2013-07-22 11:08:32.037911 TID:1   (CFG) (SQLNET)   SQLNET.AUTHENTICATION_SERVICES : (NTS)

    2013-07-22 11:08:32.037911 TID:1   (CFG) (SQLNET)   NAMES.DEFAULT_DOMAIN : (WORLD)

    2013-07-22 11:08:32.037911 TID:1   (CFG) (SQLNET)   mydb.world : (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(Host = 10.10.10.30)(Port = 1521))(CONNECT_DATA = (SERVICE_NAME = MYDB)))

    2013-07-22 11:08:32.037911 TID:1   (PUB) (ENT) OracleConnectionStringBuilder.ctor()

    2013-07-22 11:08:32.053536 TID:1   (PUB) (EXT) OracleConnectionStringBuilder.ctor()

    2013-07-22 11:08:32.053536 TID:1   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

    2013-07-22 11:08:32.069161 TID:1   (PUB) (ENT) OracleConnection.ctor()

    2013-07-22 11:08:32.084786 TID:1   (PRI) (CP) (ENT) ConnectionString.GetCS()

    2013-07-22 11:08:32.084786 TID:1   (PRI) (CP) (ENT) ConnectionString.ctor()

    2013-07-22 11:08:32.100412 TID:1   (PRI) (CP) (ENT) ConnectionString.Parse()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (CP) (ENT) ConnectionString.SetProperty()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (CP) (EXT) ConnectionString.SetProperty()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (CP) (ENT) ConnectionString.SetProperty()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (CP) (EXT) ConnectionString.SetProperty()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (CP) (ENT) ConnectionString.SetProperty()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (CP) (EXT) ConnectionString.SetProperty()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (CP) (ENT) ConnectionString.SetProperty()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (CP) (EXT) ConnectionString.SetProperty()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (CP) (EXT) ConnectionString.Parse()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (CP) (EXT) ConnectionString.ctor()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (CP) (EXT) ConnectionString.GetCS()

    2013-07-22 11:08:32.116037 TID:1   (PUB) (EXT) OracleConnection.ctor()

    2013-07-22 11:08:32.116037 TID:1   (PUB) (ENT) OracleCommand.ctor()

    2013-07-22 11:08:32.116037 TID:1   (PUB) (EXT) OracleCommand.ctor()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (ENT) OracleParameterCollection.ctor()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (EXT) OracleParameterCollection.ctor()

    2013-07-22 11:08:32.116037 TID:1   (PUB) (ENT) OracleParameterCollection.Clear()

    2013-07-22 11:08:32.116037 TID:1   (PUB) (EXT) OracleParameterCollection.Clear()

    2013-07-22 11:08:32.116037 TID:1   (PUB) (ENT) OracleParameterCollection.Add()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (SVC) (ENT) OracleParameter.ctor()

    2013-07-22 11:08:32.116037 TID:1   (PRI) (SVC) (EXT) OracleParameter.ctor()

    2013-07-22 11:08:32.116037 TID:1   (PUB) (ENT) OracleParameter.ctor()

    2013-07-22 11:08:32.116037 TID:1   (PUB) (EXT) OracleParameter.ctor()

    2013-07-22 11:08:32.116037 TID:1   (PUB) (ENT) OracleParameterCollection.Add()

    2013-07-22 11:08:32.116037 TID:1   (PUB) (EXT) OracleParameterCollection.Add()

    2013-07-22 11:08:32.116037 TID:1   (PUB) (EXT) OracleParameterCollection.Add()

    2013-07-22 11:08:32.131662 TID:1   (PUB) (ENT) OracleConnection.Open() (conid=17792110) (state=Closed) (sessid=0) (implid=0) (oper=open)

    2013-07-22 11:08:32.131662 TID:1   (PRI) (CP) (ENT) OracleConnectionDispenser`3..cctor()

    2013-07-22 11:08:32.131662 TID:1   (PRI) (CP) (EXT) OracleConnectionDispenser`3..cctor()

    2013-07-22 11:08:32.131662 TID:1   (PRI) (CP) (ENT) OracleConnectionDispenser`3.Get()

    2013-07-22 11:08:32.147288 TID:1   (PRI) (CP) (ENT) PoolManager`3.ctor()

    2013-07-22 11:08:32.147288 TID:1   (PRI) (CP) (EXT) PoolManager`3.ctor()

    2013-07-22 11:08:32.147288 TID:1   (PRI) (CP) (ENT) PoolManager`3.Initialize() (pmid=18437496) (txnctxid=18437496)  (constr=PERSIST SECURITY INFO=True;USER ID=ME;DATA SOURCE=MYDB.WORLD;)

    2013-07-22 11:08:32.147288 TID:1   (PRI) (CP) (ENT) ConnectionString.Secure()

    2013-07-22 11:08:32.147288 TID:1   (PRI) (CP) (EXT) ConnectionString.Secure()

    2013-07-22 11:08:32.147288 TID:1   (PRI) (CP) (EXT) PoolManager`3.Initialize() (pmid=18437496)

    2013-07-22 11:08:32.147288 TID:1   (PRI) (BUF) (OBP.CTOR) (poolid:31719739) (OracleConnectionDispenser`3.GetPM)

    2013-07-22 11:08:32.162913 TID:1   (PRI) (TUN) Tuning thread started.

    2013-07-22 11:08:32.162913 TID:1   (PRI) (TUN) OracleTuningAgent::Register(): Registered pool PERSIST SECURITY INFO=True;USER ID=ME;DATA SOURCE=MYDB.WORLD;PASSWORD=

    2013-07-22 11:08:32.162913 TID:1   (PRI) (CP) (ENT) OraclePoolManager.Get()

    2013-07-22 11:08:32.178538 TID:1   (PRI) (CP) (ENT) PoolManager`3.Get()

    2013-07-22 11:08:32.178538 TID:1   (PRI) (CP) (ENT) PoolManager`3.CreateNewPR()

    2013-07-22 11:08:32.194164 TID:1   (PRI) (SVC) (ENT) OracleConnectionImpl.Connect() (oper=connect) (pmid=18437496) (sessid=-1) (implId=19162058) (intxn=False) (app=False) (dtc=False) (put=False)

    2013-07-22 11:08:32.194164 TID:1   (PRI) (BUF) (COBP.CTOR) (poolid:1) (parentpoolid:31719739) (OracleConnectionImpl.Connect)

    2013-07-22 11:08:32.241039 TID:1   (PRI) (BUF) (ALLOCATION) (bufid:1)

    2013-07-22 11:08:32.303541 TID:1   (PRI) (BUF) (ALLOCATION) (bufid:2)

    2013-07-22 11:08:32.303541 TID:1   (NET)      NS Handshake completed successfully

    2013-07-22 11:08:32.303541 TID:1   (NET)      Negotiated SDU size = 8192

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (ALLOCATION) (bufid:3)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (OBP.GET) (poolid:31719739) (key:8192) (bufid:3) (count:0) (ConOraBufPool.Init)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (COBP.PUT) (poolid:1) (key:8192) (bufid:3) (count:1) (OracleConnectionImpl.Connect)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (ALLOCATION) (bufid:4)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (OBP.GET) (poolid:31719739) (key:8192) (bufid:4) (count:0) (ConOraBufPool.Init)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (COBP.PUT) (poolid:1) (key:8192) (bufid:4) (count:2) (OracleConnectionImpl.Connect)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (ALLOCATION) (bufid:5)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (OBP.GET) (poolid:31719739) (key:8192) (bufid:5) (count:0) (ConOraBufPool.Init)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (COBP.PUT) (poolid:1) (key:8192) (bufid:5) (count:3) (OracleConnectionImpl.Connect)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (ALLOCATION) (bufid:6)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (OBP.GET) (poolid:31719739) (key:8192) (bufid:6) (count:0) (ConOraBufPool.Init)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (COBP.PUT) (poolid:1) (key:8192) (bufid:6) (count:4) (OracleConnectionImpl.Connect)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (ALLOCATION) (bufid:7)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (OBP.GET) (poolid:31719739) (key:8192) (bufid:7) (count:0) (ConOraBufPool.Init)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (COBP.PUT) (poolid:1) (key:8192) (bufid:7) (count:5) (OracleConnectionImpl.Connect)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (ALLOCATION) (bufid:8)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (OBP.GET) (poolid:31719739) (key:8192) (bufid:8) (count:0) (ConOraBufPool.Init)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (COBP.PUT) (poolid:1) (key:8192) (bufid:8) (count:6) (OracleConnectionImpl.Connect)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (ALLOCATION) (bufid:9)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (OBP.GET) (poolid:31719739) (key:8192) (bufid:9) (count:0) (ConOraBufPool.Init)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (COBP.PUT) (poolid:1) (key:8192) (bufid:9) (count:7) (OracleConnectionImpl.Connect)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (ALLOCATION) (bufid:10)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (OBP.GET) (poolid:31719739) (key:8192) (bufid:10) (count:0) (ConOraBufPool.Init)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (COBP.PUT) (poolid:1) (key:8192) (bufid:10) (count:8) (OracleConnectionImpl.Connect)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (BUF) (COBP.GET) (poolid:1) (key:8192) (bufid:10) (count:7) (OraBufWriter.Initialize)

    2013-07-22 11:08:32.319166 TID:1   (PRI) (SVC) (ENT) OracleConnectionImpl.DoProtocolNegotiation()

    2013-07-22 11:08:32.334791 TID:1   (PRI) (TTC) (ENT) TTCProtocolNegotiation.WriteMessage()

    2013-07-22 11:08:32.334791 TID:1   (PRI) (TTC) (ENT) TTCMessage.WriteTTCCode()

    2013-07-22 11:08:32.334791 TID:1   (PRI) (TTC) (EXT) TTCMessage.WriteTTCCode()

    2013-07-22 11:08:32.334791 TID:1   (PRI) (TTC) (EXT) TTCProtocolNegotiation.WriteMessage()

    2013-07-22 11:08:32.334791 TID:1   (PRI) (TTC) (ENT) TTCProtocolNegotiation.ReadResponse()

    2013-07-22 11:08:32.334791 TID:1   (PRI) (BUF) (COBP.GET) (poolid:1) (key:8192) (bufid:9) (count:6) (OraBufReader.GetDataFromNetwork)

    2013-07-22 11:08:32.366042 TID:1   (PRI) (ENT) TTCProtocolNegotiation.ReadResponse()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (TTC) (ERR) TTCProtocolNegotiation.ReadResponse() OracleInternal.Network.NetworkException (0x80004005):

       ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An existing connection was forcibly closed by the remote host

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.TTC.OraBufReader.GetDataFromNetwork()

       at OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData)

       at OracleInternal.TTC.MarshallingEngine.UnmarshalUB1(Boolean bIgnoreData)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (ENT) OracleException.ctor()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (ENT) OracleError.ctor()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (EXT) OracleError.ctor()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (EXT) TTCProtocolNegotiation.ReadResponse()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (EXT) TTCProtocolNegotiation.ReadResponse()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (TTC) (EXT) TTCProtocolNegotiation.ReadResponse()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (ENT) OracleConnectionImpl.DoProtocolNegotiation()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (SVC) (ERR) OracleConnectionImpl.DoProtocolNegotiation() Oracle.ManagedDataAccess.Client.OracleException (0x80004005):

    ORA-03135: Connection lost contact ---> OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact --->

    System.Net.Sockets.SocketException (0x80004005): An existing connection was forcibly closed by the remote host

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.TTC.OraBufReader.GetDataFromNetwork()

       at OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData)

       at OracleInternal.TTC.MarshallingEngine.UnmarshalUB1(Boolean bIgnoreData)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at Oracle.ManagedDataAccess.Client.OracleException.HandleError(OracleTraceLevel level, OracleTraceTag tag, Exception ex)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.DoProtocolNegotiation()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (EXT) OracleConnectionImpl.DoProtocolNegotiation()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (SVC) (EXT) OracleConnectionImpl.DoProtocolNegotiation()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (ENT) OracleConnectionImpl.Connect()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (SVC) (ERR) OracleConnectionImpl.Connect() Oracle.ManagedDataAccess.Client.OracleException (0x80004005):

    ORA-03135: Connection lost contact ---> OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact --->

    System.Net.Sockets.SocketException (0x80004005): An existing connection was forcibly closed by the remote host

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.TTC.OraBufReader.GetDataFromNetwork()

       at OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData)

       at OracleInternal.TTC.MarshallingEngine.UnmarshalUB1(Boolean bIgnoreData)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at Oracle.ManagedDataAccess.Client.OracleException.HandleError(OracleTraceLevel level, OracleTraceTag tag, Exception ex)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.DoProtocolNegotiation()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession)

    2013-07-22 11:08:32.366042 TID:1   (PRI) (EXT) OracleConnectionImpl.Connect()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (SVC) (EXT) OracleConnectionImpl.Connect() (oper=connect) (pmid=18437496) (sessid=-1) (implId=19162058) (intxn=False) (app=False) (dtc=False) (put=False) (pooling=True)

    2013-07-22 11:08:32.366042 TID:1   (PRI) (ENT) PoolManager`3.CreateNewPR()

    2013-07-22 11:08:32.366042 TID:1   (PUB) (CP) (ERR) PoolManager`3.CreateNewPR() Oracle.ManagedDataAccess.Client.OracleException (0x80004005):

    ORA-03135: Connection lost contact ---> OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact --->

    System.Net.Sockets.SocketException (0x80004005): An existing connection was forcibly closed by the remote host

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.TTC.OraBufReader.GetDataFromNetwork()

       at OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData)

       at OracleInternal.TTC.MarshallingEngine.UnmarshalUB1(Boolean bIgnoreData)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at Oracle.ManagedDataAccess.Client.OracleException.HandleError(OracleTraceLevel level, OracleTraceTag tag, Exception ex)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.DoProtocolNegotiation()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession)

       at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd)

    2013-07-22 11:08:32.366042 TID:1   (PRI) (EXT) PoolManager`3.CreateNewPR()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (CP) (EXT) PoolManager`3.CreateNewPR() (pmid=18437496) (total=0)

    2013-07-22 11:08:32.366042 TID:1   (PRI) (ENT) PoolManager`3.Get()

    2013-07-22 11:08:32.366042 TID:1   (PUB) (CP) (ERR) PoolManager`3.Get() Oracle.ManagedDataAccess.Client.OracleException (0x80004005):

    ORA-03135: Connection lost contact ---> OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact --->

    System.Net.Sockets.SocketException (0x80004005): An existing connection was forcibly closed by the remote host

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.TTC.OraBufReader.GetDataFromNetwork()

       at OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData)

       at OracleInternal.TTC.MarshallingEngine.UnmarshalUB1(Boolean bIgnoreData)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at Oracle.ManagedDataAccess.Client.OracleException.HandleError(OracleTraceLevel level, OracleTraceTag tag, Exception ex)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.DoProtocolNegotiation()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession)

       at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd)

       at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd)

    2013-07-22 11:08:32.366042 TID:1   (PRI) (EXT) PoolManager`3.Get()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (CP) (EXT) PoolManager`3.Get()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (ENT) OraclePoolManager.Get()

    2013-07-22 11:08:32.366042 TID:1   (PUB) (CP) (ERR) OraclePoolManager.Get() Oracle.ManagedDataAccess.Client.OracleException (0x80004005):

    ORA-03135: Connection lost contact ---> OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact --->

    System.Net.Sockets.SocketException (0x80004005): An existing connection was forcibly closed by the remote host

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.TTC.OraBufReader.GetDataFromNetwork()

       at OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData)

       at OracleInternal.TTC.MarshallingEngine.UnmarshalUB1(Boolean bIgnoreData)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at Oracle.ManagedDataAccess.Client.OracleException.HandleError(OracleTraceLevel level, OracleTraceTag tag, Exception ex)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.DoProtocolNegotiation()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession)

       at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd)

       at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd)

       at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword)

    2013-07-22 11:08:32.366042 TID:1   (PRI) (EXT) OraclePoolManager.Get()

    2013-07-22 11:08:32.366042 TID:1   (PRI) (CP) (EXT) OraclePoolManager.Get() (pmid=18437496)

    2013-07-22 11:08:32.366042 TID:1   (PRI) (ENT) OracleConnectionDispenser`3.Get()

    2013-07-22 11:08:32.381667 TID:1   (PUB) (CP) (ERR) OracleConnectionDispenser`3.Get() Oracle.ManagedDataAccess.Client.OracleException (0x80004005):

    ORA-03135: Connection lost contact ---> OracleInternal.Network.NetworkException (0x80004005): ORA-03135:

    Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An existing connection was forcibly closed by the remote host

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.TTC.OraBufReader.GetDataFromNetwork()

       at OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData)

       at OracleInternal.TTC.MarshallingEngine.UnmarshalUB1(Boolean bIgnoreData)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at Oracle.ManagedDataAccess.Client.OracleException.HandleError(OracleTraceLevel level, OracleTraceTag tag, Exception ex)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.DoProtocolNegotiation()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession)

       at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd)

       at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd)

       at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword)

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

    2013-07-22 11:08:32.381667 TID:1   (PRI) (EXT) OracleConnectionDispenser`3.Get()

    2013-07-22 11:08:32.381667 TID:1   (PRI) (CP) (EXT) OracleConnectionDispenser`3.Get()

    2013-07-22 11:08:32.381667 TID:1   (PRI) (ENT) OracleConnection.Open()

    2013-07-22 11:08:32.381667 TID:1   (PUB) (ERR) OracleConnection.Open() Oracle.ManagedDataAccess.Client.OracleException (0x80004005):

    ORA-03135: Connection lost contact ---> OracleInternal.Network.NetworkException (0x80004005):

    ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An existing connection was forcibly closed by the remote host

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.Network.ReaderStream.Read(OraBuf OB)

       at OracleInternal.TTC.OraBufReader.GetDataFromNetwork()

       at OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData)

       at OracleInternal.TTC.MarshallingEngine.UnmarshalUB1(Boolean bIgnoreData)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at Oracle.ManagedDataAccess.Client.OracleException.HandleError(OracleTraceLevel level, OracleTraceTag tag, Exception ex)

       at OracleInternal.TTC.TTCProtocolNegotiation.ReadResponse()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.DoProtocolNegotiation()

       at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession)

       at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd)

       at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd)

       at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword)

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

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

    2013-07-22 11:08:32.381667 TID:1   (PRI) (EXT) OracleConnection.Open()

    2013-07-22 11:08:32.381667 TID:1   (PUB) (EXT) OracleConnection.Open() (conid=17792110) (state=Closed) (sessid=0) (implid=0) (oper=open)

    2013-07-22 11:08:32.381667 TID:1   (PUB) (ENT) OracleCommand.Dispose()

    2013-07-22 11:08:32.381667 TID:1   (PUB) (EXT) OracleCommand.Dispose()

    2013-07-22 11:08:32.381667 TID:1   (PUB) (ENT) OracleConnection.Dispose()

    2013-07-22 11:08:32.381667 TID:1   (PUB) (EXT) OracleConnection.Dispose()

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 3,052 Employee

    Would it be possible to generate a SERVER SIDE Net trace (level 16) also? Or at a minimum, check the server RDBMS logs and alert.log for relevant error(s)? If the server encountered an error, it would normally log it.

  • I do not see any network traces included in your trace. Did you removed it manually before posting the traces here?

    If not then please verify that you are using the TraceLevel 7. We need to see the network traces to investigate what is going wrong in your environment.

  • Lannie Liberty
    Lannie Liberty Member Posts: 224 Blue Ribbon

    Yes

    I removed the binary section since I could not confirm what sensitive information might be contained there.  TraceLevel7 enabled in the app.config.

    I will see what I can get from the .NET and Oracle Network/Alert side.

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 3,052 Employee

    If you feel any information is confidential that can be shared with Oracle, but not on this forum, you can also email it to me: alex.keh [at] oracle.com.

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 3,052 Employee

    Eidercom,

    My team has done some extensive investigation and has several follow up questions to identify the root cause. Those questions depend on your setup and it may be more expedient just to have a con call directly with you, rather than the back and forth of the discussion forum. Can you email me (alex.keh [at] oracle.com) and we can set a time up to discuss?

  • Lannie Liberty
    Lannie Liberty Member Posts: 224 Blue Ribbon

    Finally got someone to extract alert log info

    alert log shows:

    line_no 36978 --> Thu Jul 25 11:41:01 2013

    line_no 36983 --> Fatal NI connect error 12679, connecting
    to:

    line_no 36984 -->  (LOCAL=NO)

    line_no 36985 -->

    line_no 36986 -->   VERSION INFORMATION:

    line_no 36987 -->     TNS for Linux: Version 11.2.0.2.0 - Production

    line_no 36988 -->      Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production

    line_no 36989 -->      TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production

    line_no 36990 -->   Time: 25-JUL-2013 11:41:01

    line_no 36991 -->   Tracing not turned on.

    line_no 36992 -->   Tns error struct:

    line_no 36993 -->     ns main err code: 12679

    line_no 36994 -->    

    line_no 36995 --> TNS-12679: Native services disabled by other process but required

    line_no 36996 -->     ns secondary err code: 0

    line_no 36997 -->     nt main err code: 0

    line_no 36998 -->     nt secondary err code: 0

    line_no 36999 -->     nt OS err code: 0

    line_no 37000 --> opiodr aborting process unknown ospid (23571) as a result of ORA-609

    brief description of the  server side error generated.

    $ oerr TNS 12679

      12679, 00000, "Native services disabled by other process but required"

    // *Cause:  The remote process has disabled native services but the local

    //          process requires them.

    // *Action: Enable native services on the remote process or disable them

    //     locally.

    $ oerr ora 609

    00609, 00000, "could not attach to incoming connection"

    // *Cause:  Oracle process could not answer incoming connection

    // *Action: If the situation described in the next error on the stack

    //         can be corrected, do so; otherwise contact Oracle Support.

    $

This discussion has been closed.