Devart Forums

Hello,

We are evaluating CoreLab oracle provider for use with our web services. (ASP.NET 2.0 to Oracle 10g). So, we did a stress test using ACT tool and got good results, but there were some errors.

The test created 100 concurrent connections for 2 minutes.
We averaged at about 460 requests per second, but around 5% were errors:

ORA-12516: TNS:listener could not find available handler with matching protocol stack

Here is our connection string:
User Id=usr;Password=psw;Data Source=dbname;Pooling=true

Since we are using Connection Pooling I would not expect this error.

Could you please provide any insight on how to avoid this?

Thank you,

Evgueni

Please describe in detail how to reproduce the problem.

I am submitting my application with the same problem after conducting a series of connections this type of error, im using oracleXE, it makes a few connections and start with this issue

This probem happens on the Oracle server side. Possibly one of described solutions will help to solve this problem (http://forums.oracle.com/forums/thread. ... 9&tstart=0).
You can reproduce this problem with OraDirect .NET pooling because not all connections are used at once and peak of maximum created connections can come some time later after starting the process.