Re: ORA-12540 TNS:internal limit restriction exceeded

keeyang_at_narwhal.sns.com.sg (Boo Kee Yang) wrote:

>Hi...
 

>I am running the Oracle Server 7.0.16.4 on an AIX platform.
 

>One of my users recently encountered this error.
 

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

>Does anyone know whats the internal limit of number of connections, and is there any
>way to adjust the parameter?
 

>Thanks
 

>Kee Yang

This typically means you've got too many concurrent SQL*Net connections. As Unix user Oracle 'owns' all the dedicated server processes that SQL*Net clients connect to, you need to increase the maximim number of Unix processes for one user. Check your Oracle7 Installation and Configuration Guide for your platform for the specific Unix kernel parameter to change.

Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA The above statements and opinions are my own and do not necessarily represent those of Oracle Corporation. Received on Mon Jun 10 1996 - 00:00:00 CEST