Re: TNS internal limit error

If I remember correctly, you've basically run out of resources on the database server.
Once the number of users which can connect to the server is reached (based
upon memory primarily), this is the error you see. If you believe you should be able to connect more users than you currently can, it may be that the SORT_AREA_SIZE initialization parameter is set too high. The number defined here is the amount of memory allocated per user connection,
so the math of SGA + (#users * SORT_AREA_SIZE) tells you (roughly) how much
memory you are using. Once you add anything else running on the system to
the amount used, you'll probably notice you've ran out of memory. I seem to recall that the amount of memory required for SORT_AREA will not be paged. Of course, this is all off the top of my head and I could be wrong.

drsmith_at_ug.eds.com wrote:
>
> We are using oracle 7.3 running on a digital alpha. From time to time users
> may receive error message ORA-12223 TNS internal limit exceeded. This of
> course prevents a connnection. The manual indicated to wait for other
> connections to close then try again. My question - what is the TNS internal
> limit and is it somehow fixed or can it be altered?
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Jul 24 1998 - 16:03:39 CEST