Re: TNS Errors 12500, 12540, 12560, 00510

From: Kaboel Karso <kaboel_at_wau.mis.ah.nl>
Date: 1998/01/07
Message-ID: <34b65795.6856419@waubel.wau.mis.ah.nl>#1/1

Hi Vaughan,

have your sysadmin check the /etc/system and increase the maximum allowable processes. I think it's 'max_nproc'. Check the installation manual to be sure.

On Wed, 7 Jan 1998 10:14:04 +0800, "Vaughan Castine" <vaughan_at_unforgettable.com> wrote:

>Just when we thought Christmas was over our listener.log starts to give us
>all these "gifts".
>
>TNS-12500: TNS:listener failed to start a dedicated server process
> TNS-12540: TNS:internal limit restriction exceeded
> TNS-12560: TNS:protocol adapter error
> TNS-00510: Internal limit restriction exceeded
> Solaris Error: 12: Not enough space
>
>We are running multiple Oracle 8.0.3 instances on a Sun Ultra 1 (Solaris
>2.5.1 with all the patches). When we shut down one instance the TNS problems
>go away... however this is not an acceptable solution.
>
>Oracle Worldwide support have unsuccessfully suggested many things... right
>down to recompiling Oracle and rebuilding all database instances.
>
>Any ideas or assistance would be appreciated....
>
>Thanks in advance
>
>Vaughan
>

Kaboel Karso Received on Wed Jan 07 1998 - 00:00:00 CST