Connection problem with Oracle client and pooled connections

[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.

 

[Frans Bouma [C# MVP]]

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?

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

FB

 

[Guest]

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

get the fix.

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.

 

[Frans Bouma [C# MVP]]

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

See this KB article about the fix I'm talking about. It might be that this
is not the error you're running into, but it's likely.

http://support.microsoft.com/default.aspx?scid=kb;en-us;830173

FB

 

[Guest]

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