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
ORA-12516: TNS:listener could not find available handler with matching protocol stack
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.
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.