Re: TNS Errors 12500, 12540, 12560, 00510

The way I handled this situation was in the oracle profile and in shared memory.

In the Oracle users profile add ulimit -n 1024. in the Shared memory set the oracle SGA to use no more than 80% or real system memory ( not real+swap ) this will fix it. If you are running multiple instances configure the sum of the SGA's to be no more than 80% or real system memory.

Njål A. Ekern wrote:

> Vaughan Castine 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
>
> Today we got the same messages as above, but instead of your Solaris
> error we got:
> HPUX Error: 11: Resource temporarily unavailable
>
> > Solaris Error: 12: Not enough space
>
> I'm not into UNIX, but the HP was set up to handle too few processes,
> they had to increase that value and boot the machine. I'm not sure if
> they had to rebuild the kernel or what. Now we have no problems.
>
> Regards,
> Njål
Received on Wed Jan 14 1998 - 00:00:00 CST