NullReferenceException calling OracleConnection.Open()

[Andy Fish]

Hi,

I have an asp.net application which intermittently throws the following
exception trying to open an oracle connection

System.NullReferenceException: Object reference not set to an instance of an
object.
System.Data.OracleClient
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()

When this happens, the w3wp process goes into 100% cpu and future attempts
to open an oracle connection result in an error "The timeout period elapsed
prior to obtaining a connection from the pool. This may have occurred
because all pooled connections were in use and max pool size was reached".

It seems this can happen at any time and is not related to the server being
under heavy load. The only thing I can do is iisreset and then it all starts
working, and will run for hours or days before the problem happens again.

The app is running on .net framework 1.1 and the oracle server is version
9.2.0.1.0. The same application runs 24x7 on SQL Server and MySql so I don't
think there is a problem with the appplication code itself.

Any ideas?

TIA

Andy

 

[Guest]

Hello Andy,

We are also facing the same problem on our production web server since last
three months. Every time we reset the app pool and the application start
to work.

I appreciate if you can let me know if you find any solution. I will do the
same if we find any solution.

Thanks,

Sreedhar Oruganty