Re: Oracle listener configuration

From: Robert Strickland <pirate_at_mnsinc.com>
Date: 1998/03/01
Message-ID: <6dd25v$gh6$1@news1.mnsinc.com>#1/1

We had the same problem and wasted a lot of time trying to identify the parameter that specified this mysterious limit. In the end it turned out to be a machine resource problem (not enough memory).

Robert

Paul McAtasney wrote in message <6d3ika$mt2$1_at_roch.zetnet.co.uk>...
>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 Sun Mar 01 1998 - 00:00:00 CST