Occasional OracleConnection.Open() NullReferenceException

[Guest]

I am experiencing a very intermittent crash in my web service where OracleConnection.Open() gets a NullReferenceException with this call stack
System.NullReferenceException: Object reference not set to an instance of an object
at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction
at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction
at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact
at System.Data.OracleClient.OracleConnection.Open(

Once this occurrs, the aspnet_wp.exe process goes into a spin and the web service becomes unresponsive to any further requests until the aspnet_wp process is restarted. I am using the System.Data.OracleClient provider to connect to an Oracle 8.0.6.3.0 database. This code handles hundreds of transactions between failures

Any ideas on the cause or how to debug it

Thanks
Ros

 

[Miha Markic [MVP C#]]

Hi Ross,

MS' Oracle managed provider supports Oracle 8.1.6 (recommened at least
8.1.7) and newer clients.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

I am experiencing a very intermittent crash in my web service where

OracleConnection.Open() gets a NullReferenceException with this call stack:

System.NullReferenceException: Object reference not set to an instance of an object.
at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction)
at

System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(Str
ing encryptedConnectionString, OracleConnectionString options,
OracleConnection owningObject, Boolean& isInTransaction)

at

System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionStrin
g parsedConnectionString, Object transact)

at System.Data.OracleClient.OracleConnection.Open()

Once this occurrs, the aspnet_wp.exe process goes into a spin and the web

service becomes unresponsive to any further requests until the aspnet_wp
process is restarted. I am using the System.Data.OracleClient provider to
connect to an Oracle 8.0.6.3.0 database. This code handles hundreds of
transactions between failures.