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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

aae6db56-55d7-4ae3-a5fd-3031dbf438c6

I have the same problem. Is there any solution?

Christian.Shay -Oracle

Are you trying to use the Oracle Advanced Security Option (ASO) encryption with ODP.NET Managed Driver? It is not yet supported. (It IS supported with the Unmanaged driver).

If you are not, ask your DBA to look in the alert log for errors that occur when you attempt to connect.

Alex Keh-Oracle

If it doesn't turn out to be an encryption issue as Christian points out, I would recommend opening an SR with Oracle Support. Either this is a configuration issue or a bug. If configuration, we'll need to understand your configuration in depth. If it's a bug, Oracle Support will need to collect traces on both the client and server side to debug why the error occurs.

1 - 3
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,095 views