ASP.NET Hangs While Opening A Connection To An Oracle Database

[s_valmont]

Just wondering if anyone's heard of this issue.

It relates to accessing an Oracle 9i database from ASP.NET 1.1. The
first time you do this (e.g., run a sproc) it works fine. However
doing this multiple times causes ASP.NET to freeze permanently. Its
memory consumption increases and its CPU usage hangs at around 50%.
The only way to proceed afterward is to use the Windows Task Manager
to close the ASP process.

In code, the reason behind the freeze is that when Open() is called on
a System.Data.OracleClient.OracleConnection object, a null reference
exception is thrown - even though the object does not appear to be
null!

Is this familiar to anyone? If so, are you aware of any causes or
solutions?

 

[John Timney \(MVP\)]

Connection pooling with Oracle doesn't appear to be that reliable and it may
be connected to that as the provider can run out of connection threads. I
have heard of people manually setting the pool to be off using pooling=false
inthe connection string, and ensuring they close the connection at the end
of each page request.

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog