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

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

Postby popsovy » Wed 03 Oct 2007 21:49

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
popsovy
 
Posts: 3
Joined: Wed 03 Oct 2007 21:21

Postby Alexey » Thu 04 Oct 2007 10:02

Please describe in detail how to reproduce the problem.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

ORA-12516

Postby Dexon » Thu 20 Dec 2007 14:54

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
Dexon
 
Posts: 4
Joined: Thu 20 Dec 2007 14:49

Postby Paul » Mon 24 Dec 2007 13:29

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.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle