Skip to Main Content
Forums

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle.ManagedDataAccess raise ORA-03135: Connection lost contact

dcfdb547-97e8-4045-85e7-71741ae17454Apr 20 2015 — edited Aug 10 2015

Hi,

I am trying to connect to Oracle RAC using Oracle.ManagedDataAccess.dll 4.121.2.0 (latest release)

All instances fail to run and raise the exception OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

Except one instance it works fine…, I want to know what is the difference that made it run…, also I was able to connect using the unmanaged driver and the old driver and using sqlplus..

The DBA sees the connection with this error:

opiodr aborting process unknown ospid (6904) as a result of ORA-609

Below the code, App.config, and Trace result, I am showing both the bad connection (badConn) and good connection (goodConn)

Code:

string constr1 = "DATA SOURCE=badConn;"; // or GoodConn;

string constr2 = "USER ID=scott;Password=tiger;";

string constr3 = "persist security info=True;Self Tuning=True;Min Pool Size=3;Max Pool Size=12;Incr Pool Size=3;Decr Pool Size=1;Connection Timeout=20;Connection Lifetime=59;";

            Oracle.ManagedDataAccess.Client.OracleConnection conn1;

string constr = constr1 + constr2;// +constr3; I tried with and without the third part

using (conn1 = new Oracle.ManagedDataAccess.Client.OracleConnection(constr))

            {

try

                {

                    conn1.Open();

Console.WriteLine(constr1 + "  connected sucessfully...");

                }

catch (Exception e)

                {

Console.WriteLine(e.Message);

//throw;

                }

            }

Configuration file:

  <oracle.manageddataaccess.client>

    <version number="4.121.2.0">

      <dataSources>

        <dataSource alias="badConn" descriptor="(DESCRIPTION =

          (ADDRESS_LIST =(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.x)(PORT=1593)))

          (CONNECT_DATA =(SERVICE_NAME= oclp1)))"/>

        <dataSource alias="GoodConn" descriptor="(DESCRIPTION = (ADDRESS_LIST =(ADDRESS=(PROTOCOL=TCP)(HOST=address.com)(PORT=1582)))(CONNECT_DATA = (SERVICE_NAME= oclp2)))"/>

      </dataSources>

      <settings>

        <setting name="TNS_ADMIN" value="D:\Oracle\product\product\12.1.0\client_1\Network\Admin\Sample\" />

        <setting name="ORACLE_HOME" value="D:\Oracle\product\product\12.1.0\client_1" />

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

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

      </settings>

    </version>

  </oracle.manageddataaccess.client>

Trace result

Good connection:

2015-04-20 19:51:38.231722 TID:11  (PRI) (ENT) (CP) PoolManager`3.CreateNewPRThreadFunc()

2015-04-20 19:51:38.235722 TID:11  (PRI) (SVC) (ENT) OracleConnectionImpl.Connect() (oper=open) (aff=n/a) (inst=) (affmatch=n/a) (sessid=-1:-1) (F;F;F;;N) (pmid=23686174)

2015-04-20 19:51:38.237722 TID:11  (PRI) (BUF) (COBP.CTOR) (poolid:1) (parentpoolid:31609076) (OracleConnectionImpl.Connect)

2015-04-20 19:51:38.259725 TID:11  (PRI) (BUF) (ALLOCATION) (bufid:1)

…

2015-04-20 19:51:38.324731 TID:11  (NET) (REC) 00 00 00 00 00 00 00 00   |........|

2015-04-20 19:51:38.325731 TID:11  (PRI) (BUF) (ALLOCATION) (bufid:2)

2015-04-20 19:51:38.325731 TID:11  (NET)      NS Handshake completed successfully

2015-04-20 19:51:38.325731 TID:11  (NET)      Negotiated SDU size = 8192

2015-04-20 19:51:38.326731 TID:11  (PRI) (BUF) (ALLOCATION) (bufid:3)

2015-04-20 19:51:38.326731 TID:11  (PRI) (BUF) (OBP.GET) (poolid:31609076) (key:8192) (bufid:3) (count:0) (ConOraBufPool.Init)

2015-04-20 19:51:38.327731 TID:11  (PRI) (BUF) (COBP.PUT) (poolid:1) (key:8192) (bufid:3) (count:1) (OracleConnectionImpl.Connect)

…

2015-04-20 19:51:38.328732 TID:11  (PRI) (BUF) (COBP.PUT) (poolid:1) (key:8192) (bufid:10) (count:8) (OracleConnectionImpl.Connect)

2015-04-20 19:51:38.330732 TID:11  (PRI) (BUF) (COBP.GET) (poolid:1) (key:8192) (bufid:10) (count:7) (OraBufWriter.Initialize)

2015-04-20 19:51:38.331732 TID:11  (PRI) (SVC) (ENT) OracleConnectionImpl.DoProtocolNegotiation()

2015-04-20 19:51:38.331732 TID:11  (PRI) (TTC) (ENT) TTCProtocolNegotiation.WriteMessage()

2015-04-20 19:51:38.332732 TID:11  (PRI) (TTC) (ENT) TTCMessage.WriteTTCCode()

2015-04-20 19:51:38.332732 TID:11  (PRI) (TTC) (EXT) TTCMessage.WriteTTCCode()

2015-04-20 19:51:38.332732 TID:11  (PRI) (TTC) (EXT) TTCProtocolNegotiation.WriteMessage()

2015-04-20 19:51:38.333732 TID:11  (NET) (SND) 00 1D 00 00 06 00 00 00   |........|

2015-04-20 19:51:38.333732 TID:11  (NET) (SND) 00 00                     |..      |

2015-04-20 19:51:38.333732 TID:11  (NET) (SND) 01 06 00 4F 44 50 2E 4E   |...ODP.N|

2015-04-20 19:51:38.333732 TID:11  (NET) (SND) 45 54 5F 4D 61 6E 61 67   |ET_Manag|

2015-04-20 19:51:38.333732 TID:11  (NET) (SND) 65 64 00                  |ed.     |

2015-04-20 19:51:38.334732 TID:11  (PRI) (TTC) (ENT) TTCProtocolNegotiation.ReadResponse()

2015-04-20 19:51:38.335732 TID:11  (PRI) (BUF) (COBP.GET) (poolid:1) (key:8192) (bufid:9) (count:6) (OraBufReader.GetDataFromNetwork)

2015-04-20 19:51:38.336732 TID:11  (NET) (REC) New receive packet. Header:

Bad connection: (The yellow part is exactly the same for both connection)

2015-04-20 21:42:09.269759 TID:8   (CFG) (SQLNET)   SQLNET.ENCRYPTION_CLIENT : required

2015-04-20 21:42:09.302763 TID:8   (CFG) (SQLNET)   SQLNET.AUTHENTICATION_SERVICES : (NTS)

2015-04-20 21:42:09.302763 TID:8   (CFG) (SQLNET)   NAMES.DIRECTORY_PATH : (TNSNAMES, EZCONNECT)

2015-04-20 21:42:09.302763 TID:8   (CFG) (SQLNET)   SQLNET.CRYPTO_SEED : ….

2015-04-20 21:42:09.302763 TID:8   (CFG) (SQLNET)   SQLNET.ENCRYPTION_TYPES_CLIENT : (RC4_56, DES40, RC4_40, DES, AES256)

2015-04-20 21:42:09.302763 TID:8   (CFG) (SQLNET)   SQLNET.EXPIRE_TIME : 0

2015-04-20 21:42:09.302763 TID:8   (CFG) (SQLNET)   SQLNET.INBOUND_CONNECT_TIMEOUT : 500

2015-04-20 21:42:09.302763 TID:8   (CFG) (SQLNET)   SSL_VERSION : 1.0

2015-04-20 21:42:09.308763 TID:8   (CFG) (ENV)      Machine Name : abcd

2015-04-20 21:42:09.308763 TID:8   (CFG) (ENV)      User Name : scott

2015-04-20 21:42:09.308763 TID:8   (CFG) (ENV)      OS Version : Microsoft Windows NT 6.1.7601 Service Pack 1

2015-04-20 21:42:09.308763 TID:8   (CFG) (ENV)      64-bit OS : True

2015-04-20 21:42:09.308763 TID:8   (CFG) (ENV)      64-bit Process : True

2015-04-20 21:42:09.308763 TID:8   (CFG) (ENV)      .NET Runtime Version : 4.0.30319.18444

2015-04-20 21:42:09.308763 TID:8   (CFG) (VER)      Oracle Data Provider for .NET, Managed Driver Version : 4.121.2.0

2015-04-20 21:42:09.308763 TID:8   (CFG) (VER)      Oracle Data Provider for .NET, Managed Driver Informational Version : 4.121.2.20141216 ODAC RELEASE 3

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     SQLNET.INBOUND_CONNECT_TIMEOUT : 500

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     PerformanceCounters : 4095

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     SSL_VERSION : 1.0

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     NAMES.DIRECTORY_PATH : (TNSNAMES, EZCONNECT)

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     TraceFileLocation : D:\

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     ORACLE_HOME : D:\Oracle\product\product\12.1.0\client_1

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     SQLNET.ENCRYPTION_TYPES_CLIENT : (RC4_56, DES40, RC4_40, DES, AES256)

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     SQLNET.AUTHENTICATION_SERVICES : (NTS)

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     SQLNET.CRYPTO_SEED : ….

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     TraceLevel : 7

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     TNS_ADMIN : D:\Oracle\product\product\12.1.0\client_1\Network\Admin\Sample\ (I update it)

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     SQLNET.ENCRYPTION_CLIENT : required

2015-04-20 21:42:09.308763 TID:8   (CFG) (.NET)     SQLNET.EXPIRE_TIME : 0

2015-04-20 21:42:09.316764 TID:8   (CFG) (TNSNAMES) OFSP : ….

2015-04-20 21:42:09.350767 TID:8   (CFG) (SQLNET)   FilePath : D:\Oracle\product\product\12.1.0\client_1\Network\Admin\Sample\sqlnet.ora

2015-04-20 21:42:09.350767 TID:8   (CFG) (TNSNAMES) FilePath : D:\Oracle\product\product\12.1.0\client_1\Network\Admin\Sample\tnsnames.ora

2015-04-20 21:42:09.350767 TID:8   (PUB) (ENT) OracleConnection.ctor()

2015-04-20 21:42:09.357768 TID:8   (PRI) (ENT) (CP) ConnectionString.GetCS()

2015-04-20 21:42:09.362769 TID:8   (PRI) (ENT) (CP) ConnectionString.ctor()

2015-04-20 21:42:09.375770 TID:8   (PRI) (ENT) (CP) ConnectionString.Parse()

2015-04-20 21:42:09.388771 TID:8   (PRI) (ENT) (CP) ConnectionString.SetProperty()

2015-04-20 21:42:09.389771 TID:8   (PRI) (EXT) (CP) ConnectionString.SetProperty()

2015-04-20 21:42:09.389771 TID:8   (PRI) (ENT) (CP) ConnectionString.SetProperty()

2015-04-20 21:42:09.389771 TID:8   (PRI) (EXT) (CP) ConnectionString.SetProperty()

2015-04-20 21:42:09.389771 TID:8   (PRI) (ENT) (CP) ConnectionString.SetProperty()

2015-04-20 21:42:09.389771 TID:8   (PRI) (EXT) (CP) ConnectionString.SetProperty()

2015-04-20 21:42:09.389771 TID:8   (PRI) (EXT) (CP) ConnectionString.Parse()

2015-04-20 21:42:09.390771 TID:8   (PRI) (EXT) (CP) ConnectionString.ctor()

2015-04-20 21:42:09.390771 TID:8   (PRI) (EXT) (CP) ConnectionString.GetCS()

2015-04-20 21:42:09.390771 TID:8   (PUB) (EXT) OracleConnection.ctor()

2015-04-20 21:42:09.435776 TID:8   (PUB) (ENT) OracleConnection.Open() (conid=295723) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a)

2015-04-20 21:42:09.441777 TID:8   (PRI) (ENT) (CP) OracleConnectionDispenser`3..cctor()

2015-04-20 21:42:09.442777 TID:8   (PRI) (EXT) (CP) OracleConnectionDispenser`3..cctor()

2015-04-20 21:42:09.443777 TID:8   (PRI) (ENT) (CP) OracleConnectionDispenser`3.Get()

2015-04-20 21:42:09.448777 TID:8   (PRI) (ENT) (CP) PoolManager`3.ctor()

2015-04-20 21:42:09.449777 TID:8   (PRI) (EXT) (CP) PoolManager`3.ctor()

2015-04-20 21:42:09.454778 TID:8   (PRI) (ENT) (CP) PoolManager`3.Initialize() (constr=DATA SOURCE=badConn;USER ID=Scott;)

2015-04-20 21:42:09.457778 TID:8   (PRI) (ENT) (CP) ConnectionString.Secure()

2015-04-20 21:42:09.457778 TID:8   (PRI) (EXT) (CP) ConnectionString.Secure()

2015-04-20 21:42:09.474780 TID:8   (PRI) (EXT) (CP) PoolManager`3.Initialize() (pmid=48657371) (constr=DATA SOURCE=badConn;USER ID=scott;)

2015-04-20 21:42:09.475780 TID:8   (PRI) (BUF) (OBP.CTOR) (poolid:55492274) (OracleConnectionDispenser`3.GetPM)

2015-04-20 21:42:09.482781 TID:8   (PRI) (ENT) (CP) OraclePoolManager.Get()

2015-04-20 21:42:09.499782 TID:8   (PRI) (ENT) (CP) PoolManager`3.Get() (txnid=n/a) (bForceMatch=F)

2015-04-20 21:42:09.505783 TID:8   (PRI) (ENT) (CP) PoolManager`3.CreateNewPR() (txnid=n/a)

2015-04-20 21:42:09.726805 TID:8   (PRI) (ENT) TimeStamp.GetLocalTZOffset()

2015-04-20 21:42:09.726805 TID:8   (PRI) (EXT) TimeStamp.GetLocalTZOffset()

2015-04-20 21:42:09.738806 TID:8   (PRI) (ENT) (CP) ConnectionString.GetStringFromSecureString()

2015-04-20 21:42:09.738806 TID:8   (PRI) (EXT) (CP) ConnectionString.GetStringFromSecureString()

2015-04-20 21:42:09.766809 TID:10  (PRI) (ENT) (CP) PoolManager`3.CreateNewPRThreadFunc()

2015-04-20 21:42:09.780810 TID:10  (PRI) (SVC) (ENT) OracleConnectionImpl.Connect() (oper=open) (aff=n/a) (inst=) (affmatch=n/a) (sessid=-1:-1) (F;F;F;;N) (pmid=48657371)

2015-04-20 21:42:09.782811 TID:10  (PRI) (BUF) (COBP.CTOR) (poolid:1) (parentpoolid:55492274) (OracleConnectionImpl.Connect)

2015-04-20 21:42:09.827815 TID:10  (PRI) (BUF) (ALLOCATION) (bufid:1)

2015-04-20 21:42:09.837816 TID:10  (NET) (SND) 00 3A 00 00 01 00 00 00   |.:......|

…

2015-04-20 21:42:09.922825 TID:10  (NET) (REC) 00 00 00 00 00 00 00 00   |........|

2015-04-20 21:42:09.925825 TID:10  (PRI) (BUF) (ALLOCATION) (bufid:3)

2015-04-20 21:42:09.925825 TID:10  (NET)      NS Handshake completed successfully

2015-04-20 21:42:09.925825 TID:10  (NET)      Negotiated SDU size = 8192

2015-04-20 21:42:09.933826 TID:10  (PRI) (BUF) (ALLOCATION) (bufid:4)

2015-04-20 21:42:09.934826 TID:10  (PRI) (BUF) (OBP.GET) (poolid:55492274) (key:8192) (bufid:4) (count:0) (ConOraBufPool.Init)

….

2015-04-20 21:42:09.944827 TID:10  (PRI) (BUF) (COBP.GET) (poolid:1) (key:8192) (bufid:11) (count:7) (OraBufWriter.Initialize)

2015-04-20 21:42:09.946827 TID:10  (PRI) (SVC) (ENT) OracleConnectionImpl.DoProtocolNegotiation()

2015-04-20 21:42:09.947827 TID:10  (PRI) (TTC) (ENT) TTCProtocolNegotiation.WriteMessage()

2015-04-20 21:42:09.948827 TID:10  (PRI) (TTC) (ENT) TTCMessage.WriteTTCCode()

2015-04-20 21:42:09.948827 TID:10  (PRI) (TTC) (EXT) TTCMessage.WriteTTCCode()

2015-04-20 21:42:09.949827 TID:10  (PRI) (TTC) (EXT) TTCProtocolNegotiation.WriteMessage()

2015-04-20 21:42:09.953828 TID:10  (NET) (SND) 00 1D 00 00 06 00 00 00   |........|

2015-04-20 21:42:09.953828 TID:10  (NET) (SND) 00 00                     |..      |

2015-04-20 21:42:09.953828 TID:10  (NET) (SND) 01 06 00 4F 44 50 2E 4E   |...ODP.N|

2015-04-20 21:42:09.953828 TID:10  (NET) (SND) 45 54 5F 4D 61 6E 61 67   |ET_Manag|

2015-04-20 21:42:09.953828 TID:10  (NET) (SND) 65 64 00                  |ed.     |

2015-04-20 21:42:09.957828 TID:10  (PRI) (TTC) (ENT) TTCProtocolNegotiation.ReadResponse()

2015-04-20 21:42:09.962829 TID:10  (PRI) (BUF) (COBP.GET) (poolid:1) (key:8192) (bufid:10) (count:6) (OraBufReader.GetDataFromNetwork)

2015-04-20 21:42:09.996832 TID:10  (PRI) (ENT) TTCProtocolNegotiation.ReadResponse()

2015-04-20 21:42:09.999832 TID:10  (PRI) (TTC) (ERR) TTCProtocolNegotiation.ReadResponse() (txnid=n/a) OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

   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()

2015-04-20 21:42:09.999832 TID:10  (PRI) (TTC) (ERR) TTCProtocolNegotiation.ReadResponse() (txnid=n/a) System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

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

2015-04-20 21:42:09.999832 TID:10  (PRI) (EXT) TTCProtocolNegotiation.ReadResponse()

2015-04-20 21:42:10.009833 TID:10  (PRI) (TTC) (EXT) TTCProtocolNegotiation.ReadResponse()

2015-04-20 21:42:10.009833 TID:10  (PRI) (ENT) OracleConnectionImpl.DoProtocolNegotiation()

2015-04-20 21:42:10.009833 TID:10  (PRI) (SVC) (ERR) OracleConnectionImpl.DoProtocolNegotiation() (txnid=n/a) OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

   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 OracleInternal.ServiceObjects.OracleConnectionImpl.DoProtocolNegotiation()

2015-04-20 21:42:10.009833 TID:10  (PRI) (SVC) (ERR) OracleConnectionImpl.DoProtocolNegotiation() (txnid=n/a) System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

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

2015-04-20 21:42:10.009833 TID:10  (PRI) (EXT) OracleConnectionImpl.DoProtocolNegotiation()

2015-04-20 21:42:10.018834 TID:10  (PRI) (SVC) (EXT) OracleConnectionImpl.DoProtocolNegotiation()

2015-04-20 21:42:10.018834 TID:10  (PRI) (ENT) OracleConnectionImpl.Connect()

2015-04-20 21:42:10.018834 TID:10  (PRI) (SVC) (ERR) OracleConnectionImpl.Connect() (txnid=n/a) OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

   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 OracleInternal.ServiceObjects.OracleConnectionImpl.DoProtocolNegotiation()

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

2015-04-20 21:42:10.019834 TID:10  (PRI) (SVC) (ERR) OracleConnectionImpl.Connect() (txnid=n/a) System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

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

2015-04-20 21:42:10.019834 TID:10  (PRI) (EXT) OracleConnectionImpl.Connect()

2015-04-20 21:42:10.028835 TID:10  (PRI) (SVC) (EXT) OracleConnectionImpl.Connect() (oper=open) (aff=n/a) (inst=) (affmatch=n/a) (sessid=-1:-1) (F;F;F;;N) (pmid=48657371)

2015-04-20 21:42:10.028835 TID:10  (PRI) (EXT) (CP) PoolManager`3.CreateNewPRThreadFunc()

2015-04-20 21:42:10.045837 TID:8   (PRI) (ENT) PoolManager`3.CreateNewPR()

2015-04-20 21:42:10.045837 TID:8   (PRI) (ERR) (CP) PoolManager`3.CreateNewPR() (txnid=n/a) OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

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

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

2015-04-20 21:42:10.045837 TID:8   (PRI) (ERR) (CP) PoolManager`3.CreateNewPR() (txnid=n/a) System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

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

2015-04-20 21:42:10.045837 TID:8   (PRI) (EXT) PoolManager`3.CreateNewPR()

2015-04-20 21:42:10.056838 TID:8   (PRI) (EXT) (CP) PoolManager`3.CreateNewPR() (aff=n/a) (inst=) (affmatch=n/a) (sessid=-1:-1) (F;F;F;;N) (pmid=48657371)

2015-04-20 21:42:10.056838 TID:8   (PRI) (EXT) (CP) PoolManager`3.Get() (txnid=n/a) PM.Get(aff=;force=F) returning (null)

2015-04-20 21:42:10.056838 TID:8   (PRI) (ENT) OraclePoolManager.Get()

2015-04-20 21:42:10.056838 TID:8   (PRI) (ERR) (CP) OraclePoolManager.Get() (txnid=n/a) OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

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

   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)

2015-04-20 21:42:10.056838 TID:8   (PRI) (ERR) (CP) OraclePoolManager.Get() (txnid=n/a) System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

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

2015-04-20 21:42:10.056838 TID:8   (PRI) (EXT) OraclePoolManager.Get()

2015-04-20 21:42:10.067839 TID:8   (PRI) (EXT) (CP) OraclePoolManager.Get() (txnid=n/a)

2015-04-20 21:42:10.082841 TID:8   (PRI) (ENT) OracleConnectionDispenser`3.Get()

2015-04-20 21:42:10.082841 TID:8   (PRI) (ERR) (CP) OracleConnectionDispenser`3.Get() (txnid=n/a) OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

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

   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)

2015-04-20 21:42:10.082841 TID:8   (PRI) (ERR) (CP) OracleConnectionDispenser`3.Get() (txnid=n/a) System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

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

2015-04-20 21:42:10.082841 TID:8   (PRI) (EXT) OracleConnectionDispenser`3.Get()

2015-04-20 21:42:10.093842 TID:8   (PRI) (EXT) (CP) OracleConnectionDispenser`3.Get() (txnid=n/a)

2015-04-20 21:42:10.093842 TID:8   (PRI) (ENT) OracleConnection.Open()

2015-04-20 21:42:10.093842 TID:8   (PUB) (ERR) OracleConnection.Open() (txnid=n/a) OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

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

   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()

2015-04-20 21:42:10.093842 TID:8   (PUB) (ERR) OracleConnection.Open() (txnid=n/a) System.Net.Sockets.SocketException (0x80004005): An established connection was aborted by the software in your host machine

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

2015-04-20 21:42:10.093842 TID:8   (PRI) (EXT) OracleConnection.Open()

2015-04-20 21:42:10.110843 TID:8   (PUB) (EXT) OracleConnection.Open() (conid=11111) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a)

Cheers,

Muhammad
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2015
Added on Apr 20 2015
#odp-net
3 comments
3,310 views