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.

Windows Services using managed provider 4.121.2.0 throw exception when tnsnames.ora exists in applic

user10616170May 11 2015 — edited May 14 2015

Hello,

We recently noticed that the Oracle Data Provider for .NET, Managed Driver Version : 4.121.2.0 is throwing an exception when using the tnsnames.ora within the application directory for a Windows Service.  The same service using the Oracle Data Provider for .NET, Managed Driver Version : 4.121.1.0 doesn't have this issue.  Has anyone else seen this problem? 

Below is the trace for a Windows Application:

2015-05-11 10:14:01.868464 TID:1   (CFG) (ENV)      Machine Name : WS-295

2015-05-11 10:14:01.884065 TID:1   (CFG) (ENV)      User Name : jason

2015-05-11 10:14:01.884065 TID:1   (CFG) (ENV)      OS Version : Microsoft Windows NT 6.1.7601 Service Pack 1

2015-05-11 10:14:01.884065 TID:1   (CFG) (ENV)      64-bit OS : True

2015-05-11 10:14:01.884065 TID:1   (CFG) (ENV)      64-bit Process : False

2015-05-11 10:14:01.884065 TID:1   (CFG) (ENV)      .NET Runtime Version : 4.0.30319.34209

2015-05-11 10:14:01.884065 TID:1   (CFG) (VER)      Oracle Data Provider for .NET, Managed Driver Version : 4.121.2.0

2015-05-11 10:14:01.884065 TID:1   (CFG) (VER)      Oracle Data Provider for .NET, Managed Driver Informational Version : 4.121.2.20150317 ODAC RELEASE 3

2015-05-11 10:14:01.884065 TID:1   (CFG) (.NET)     TraceLevel : 1

2015-05-11 10:14:01.884065 TID:1   (CFG) (.NET)     TraceFileLocation : C:\Temp

2015-05-11 10:14:01.884065 TID:1   (CFG) (TNSNAMES) vm-qa-ora-03.prod : (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vm-qa-ora-03)(PORT=1521))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=PROD)))

2015-05-11 10:14:01.899666 TID:1   (CFG) (SQLNET)   FilePath : (null)

2015-05-11 10:14:01.899666 TID:1   (CFG) (TNSNAMES) FilePath : D:\Packages\bin\tnsnames.ora

The exact same code but run as a Windows Service, we get the below exception.  If we use 4.121.1.0 no exception occurs.

2015-05-11 10:14:08.513008 TID:4   (CFG) (ENV)      Machine Name : WS-295

2015-05-11 10:14:08.528608 TID:4   (CFG) (ENV)      User Name : jason

2015-05-11 10:14:08.528608 TID:4   (CFG) (ENV)      OS Version : Microsoft Windows NT 6.1.7601 Service Pack 1

2015-05-11 10:14:08.528608 TID:4   (CFG) (ENV)      64-bit OS : True

2015-05-11 10:14:08.528608 TID:4   (CFG) (ENV)      64-bit Process : False

2015-05-11 10:14:08.528608 TID:4   (CFG) (ENV)      .NET Runtime Version : 4.0.30319.34209

2015-05-11 10:14:08.528608 TID:4   (CFG) (VER)      Oracle Data Provider for .NET, Managed Driver Version : 4.121.2.0

2015-05-11 10:14:08.528608 TID:4   (CFG) (VER)      Oracle Data Provider for .NET, Managed Driver Informational Version : 4.121.2.20150317 ODAC RELEASE 3

2015-05-11 10:14:08.528608 TID:4   (CFG) (.NET)     TraceLevel : 1

2015-05-11 10:14:08.528608 TID:4   (CFG) (.NET)     TraceFileLocation : C:\Temp

2015-05-11 10:14:08.544209 TID:4   (CFG) (SQLNET)   FilePath : (null)

2015-05-11 10:14:08.544209 TID:4   (CFG) (TNSNAMES) FilePath : (null)

2015-05-11 10:14:08.544209 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.ctor()

2015-05-11 10:14:08.544209 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.ctor()

2015-05-11 10:14:08.544209 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:08.544209 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:08.544209 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:08.544209 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:08.544209 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:08.544209 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:08.544209 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:08.544209 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:08.544209 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:08.544209 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:08.544209 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:08.544209 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:08.544209 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:08.544209 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:08.544209 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:08.544209 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:08.544209 TID:4   (PUB) (ENT) OracleConnection.ctor()

2015-05-11 10:14:08.559810 TID:4   (PUB) (EXT) OracleConnection.ctor()

2015-05-11 10:14:08.575411 TID:4   (PUB) (ENT) OracleConnection.Open() (conid=24418296) (state=Closed) (sessid=0) (implid=0) (pooling=F) (txnid=n/a)

2015-05-11 10:14:09.819875 TID:4   (PUB) (ERR) OracleConnection.Open() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12541: TNS: No listener ---> OracleInternal.Network.NetworkException (0x80004005): ORA-12541: TNS: No listener ---> System.Net.Sockets.SocketException (0x80004005): No connection could be made because the target machine actively refused it 127.0.53.53:1521

   at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

   at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult)

   at OracleInternal.Network.TcpTransportAdapter.Connect(ConnectionOption conOption)

   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)

   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, 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-05-11 10:14:09.819875 TID:4   (PUB) (ERR) OracleConnection.Open() (txnid=n/a) OracleInternal.Network.NetworkException (0x80004005): ORA-12541: TNS: No listener ---> System.Net.Sockets.SocketException (0x80004005): No connection could be made because the target machine actively refused it 127.0.53.53:1521

   at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

   at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult)

   at OracleInternal.Network.TcpTransportAdapter.Connect(ConnectionOption conOption)

   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)

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

2015-05-11 10:14:09.819875 TID:4   (PUB) (ERR) OracleConnection.Open() (txnid=n/a) System.Net.Sockets.SocketException (0x80004005): No connection could be made because the target machine actively refused it 127.0.53.53:1521

   at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

   at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult)

   at OracleInternal.Network.TcpTransportAdapter.Connect(ConnectionOption conOption)

2015-05-11 10:14:09.819875 TID:4   (PUB) (EXT) OracleConnection.Open() (conid=24418296) (state=Closed) (sessid=0) (implid=0) (pooling=F) (txnid=n/a)

2015-05-11 10:14:10.428306 TID:2   (PUB) (ENT) OracleConnection.Finalize()

2015-05-11 10:14:10.428306 TID:2   (PUB) (ENT) OracleConnection.Dispose()

2015-05-11 10:14:10.428306 TID:2   (PUB) (EXT) OracleConnection.Dispose()

2015-05-11 10:14:10.428306 TID:2   (PUB) (EXT) OracleConnection.Finalize()

2015-05-11 10:14:10.428306 TID:2   (PUB) (ENT) OracleConnection.Dispose()

2015-05-11 10:14:10.428306 TID:2   (PUB) (EXT) OracleConnection.Dispose()

2015-05-11 10:14:12.508217 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.ctor()

2015-05-11 10:14:12.508217 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.ctor()

2015-05-11 10:14:12.508217 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:12.508217 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:12.508217 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:12.508217 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:12.508217 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:12.508217 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:12.508217 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:12.508217 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:12.508217 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:12.508217 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:12.508217 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:12.508217 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:12.508217 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:12.508217 TID:4   (PUB) (ENT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:12.508217 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.ContainsKey()

2015-05-11 10:14:12.508217 TID:4   (PUB) (EXT) OracleConnectionStringBuilder.TryGetValue()

2015-05-11 10:14:12.508217 TID:4   (PUB) (ENT) OracleConnection.ctor()

2015-05-11 10:14:12.508217 TID:4   (PUB) (EXT) OracleConnection.ctor()

2015-05-11 10:14:12.508217 TID:4   (PUB) (ENT) OracleConnection.Open() (conid=15452120) (state=Closed) (sessid=0) (implid=0) (pooling=F) (txnid=n/a)

2015-05-11 10:14:13.538870 TID:4   (PUB) (ERR) OracleConnection.Open() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12541: TNS: No listener ---> OracleInternal.Network.NetworkException (0x80004005): ORA-12541: TNS: No listener ---> System.Net.Sockets.SocketException (0x80004005): No connection could be made because the target machine actively refused it 127.0.53.53:1521

   at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

   at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult)

   at OracleInternal.Network.TcpTransportAdapter.Connect(ConnectionOption conOption)

   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)

   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, 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-05-11 10:14:13.538870 TID:4   (PUB) (ERR) OracleConnection.Open() (txnid=n/a) OracleInternal.Network.NetworkException (0x80004005): ORA-12541: TNS: No listener ---> System.Net.Sockets.SocketException (0x80004005): No connection could be made because the target machine actively refused it 127.0.53.53:1521

   at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

   at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult)

   at OracleInternal.Network.TcpTransportAdapter.Connect(ConnectionOption conOption)

   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)

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

2015-05-11 10:14:13.538870 TID:4   (PUB) (ERR) OracleConnection.Open() (txnid=n/a) System.Net.Sockets.SocketException (0x80004005): No connection could be made because the target machine actively refused it 127.0.53.53:1521

   at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

   at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult)

   at OracleInternal.Network.TcpTransportAdapter.Connect(ConnectionOption conOption)

2015-05-11 10:14:13.538870 TID:4   (PUB) (EXT) OracleConnection.Open() (conid=15452120) (state=Closed) (sessid=0) (implid=0) (pooling=F) (txnid=n/a)

2015-05-11 10:14:17.635082 TID:2   (PUB) (ENT) OracleConnection.Finalize()

2015-05-11 10:14:17.635082 TID:2   (PUB) (ENT) OracleConnection.Dispose()

2015-05-11 10:14:17.635082 TID:2   (PUB) (EXT) OracleConnection.Dispose()

2015-05-11 10:14:17.635082 TID:2   (PUB) (EXT) OracleConnection.Finalize()

2015-05-11 10:14:17.635082 TID:2   (PUB) (ENT) OracleConnection.Dispose()

2015-05-11 10:14:17.635082 TID:2   (PUB) (EXT) OracleConnection.Dispose()

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 11 2015
Added on May 11 2015
#odp-net
3 comments
1,566 views