Re: ORA-12540: TNS:internal limit restriction exceeded

  • From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 4 Feb 2004 17:37:16 -0500

You've hit the number of concurrently open TCP connections on the box.
You may try cman and connection pooling, but it would involve  
restarting the database and setting "POOL" parameter for the  
dispatchers. The machine itself doesn't need to be restarted.


On 02/04/2004 05:23:42 PM, Jordi Adame V wrote:
> When running a Pro*C application (64 bits) i get this error:
> 
> ORA-12540: TNS:internal limit restriction exceeded
> 
> My system:
> HP-UX  B.11.11
> Oracle 9.2.0.1.0
> 
> is there any way to solve this without changing kernel parameters?
> 
> regards,
> 
> Jordi
> 
> 
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: