Oracle listener configuration

From: Paul McAtasney <pmcatasney_at_zetnet.co.uk>
Date: 1998/02/26
Message-ID: <6d3ika$mt2$1@roch.zetnet.co.uk>#1/1

We are running an Oracle database (7.3.2) on an Intel based platform using a tcp listener version 2.3.2.1 and have encountered the Oracle error 12223 several times. Output from "oerr ora 12223" is :-

12223,00000,"TNS:internal limit restriction exceeded" //*Cause: Too many TNS connections open simultaneously. // *Action: Wait for connections to close and re-try.

What resource is being exceeded here? Is there a default number of connections allowed if MAX_CLIENTS isn't defined? Or is this a database resource problem?

Any info will be greatly appreciated.

PMcA Received on Thu Feb 26 1998 - 00:00:00 CST