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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
popsovy
Posts: 3
Joined: Wed 03 Oct 2007 21:21

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

Post by 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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 04 Oct 2007 10:02

Please describe in detail how to reproduce the problem.

Dexon
Posts: 4
Joined: Thu 20 Dec 2007 14:49

ORA-12516

Post by 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

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by 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.

Post Reply