Re: ORA-12540 TNS:internal limit restriction exceeded
From: Charles Dye <cdye_at_dnt.dialog.com>
Date: 1996/06/07
Message-ID: <4p9hgb$5jc_at_iserv.dnt.dialog.com>#1/1
Date: 1996/06/07
Message-ID: <4p9hgb$5jc_at_iserv.dnt.dialog.com>#1/1
Kee Yang,
You have to increase the value of PROCESSES in the init.ora file.
The max number of TNS listener connections is directly proportional to this param.
Regards,
Chas.
-- Chas. Dye Oracle Database Administrator Charles_Dye_at_krinfo.com In article <4p8f12$2cgg_at_sheraton.asianconnect.com>, keeyang_at_narwhal.sns.com.sg (Boo Kee Yang) writes:Received on Fri Jun 07 1996 - 00:00:00 CEST
> 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
>