Connection problem with Oracle client and pooled connections

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem with my ASP.Net project using an Oracle database. The error I am receiving is below:

Timeout expired. 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.

This application has been deployed at many sites, using SQL Server and Oracle databases, and we have never seen this error before. I am 99% certain that our application is not leaking connections. The only major difference between this installation and others is that the Oracle database is running on a HPUX server. This error can occur within two clicks of restarting IIS, so the connection pool would be nowhere near full.

Does any body have any suggestions to diagnose what's happening?

Thanks,

Martin.
 
Martin said:
I am having a problem with my ASP.Net project using an Oracle database. The
error I am receiving is below:

Timeout expired. 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.

This application has been deployed at many sites, using SQL Server and
Oracle databases, and we have never seen this error before. I am 99%
certain that our application is not leaking connections. The only major
difference between this installation and others is that the Oracle database
is running on a HPUX server. This error can occur within two clicks of
restarting IIS, so the connection pool would be nowhere near full.

Does any body have any suggestions to diagnose what's happening?
Click to expand...

If you're using the .NET Oracle client, this is a known issue. Call PSS to
get the fix.

FB
 
If you're using the .NET Oracle client, this is a known issue. Call PSS to
get the fix.
Click to expand...

Thanks for the reply Frans. I am indeed using the .Net Oracle provider. What is "PSS", and where do I find the contact details?

Many thanks,

Martin.
 
Hi,

We are running our web site on Win2k3 machine with .NET Framework 1.1 SP1
version 1.1.4322.573.

The actual file on server that is specified in the article is
System.data.oracleclient.dll version 1.1.4322.2300

We are encountering oracle error codes that are not in this article such as
ORA-01436, ORA-06550, ORA-01017. Upon encountering one or more of these
errors the connection pool problem starts.

Do you think we still need to install that fix to resolve the issue?

Please help.
Som
 
Back
Top