Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12520: TNS:listener could not find available handler for requested type

556560Feb 12 2007 — edited May 9 2007
Hello,
I'm trying to run some load tests my application's framework. I've created a Unit Test that inserts, selects and deletes 1000 records. Everything works perfectly until I try and increase the workload to 2000 records.

When I try to increase to 2000, I start getting "ORA-12520: TNS:listener could not find available handler for requested type of server" around 1600 in the loop. The point in the loop at which it starts failing isn't consistant, but it always occurs when trying to open the connection:
myOracleConnection.Open();

Have I just hit a limitation of ODP.NET or of Oracle 10g Express? Does anyone know of any settings I could change to improve Oracle's performance? I'd really appreciate some help,

Mycole

Btw, I made sure I'm calling Dispose() on my OracleDataReader, OracleConnection and OracleCommand.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2007
Added on Feb 12 2007
7 comments
8,156 views