Re: TNS Errors 12500, 12540, 12560, 00510

In article <MPG.f202ecd2d54e192989688_at_news.online.no>, Rasmus Langaard jr. <rasmus.langaard_at_nsa.no> wrote:
>Hmm - that last error message (from Solaris) makes me wonder... "Not
>enough space" - could you be out of virtual memory, by any chance? Check
>that you've got at least as much swap space as you've got real RAM. Might
>be a kernel parameter too, though - something to do with memory limits
>per user...

Check the /tmp disk while you are at it.

>
>Good luck! - rasmus
>
>
>In article <68uock$q2b$1_at_news.iinet.net.au>, vaughan_at_unforgettable.com
>says...
>> 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
>>
>>
>>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!