Re: TNS error 12223 : Internal Limit Restriction exceeded

I hit this problem on my HP 9000 K series / Oracle 7.3.2.3 box. Turns out it was due to a soft limit on the number of processes per user as defined in the HP-UX Kernel.

As usage fluctuates thoughout the day, the problem may be experienced intermittently as the process per user (in this case Oracle) limit is breached.

Try upping the kernel parameter (possibly maxuprc - I have never heard of BaaN) and rebooting your box.

I hope this helps,

Regards,

Steve McAreavey

John O'Sullivan wrote:

> Folks,
>
> We are getting error 12223 "TNS : internal limit restriction exceeded"
> about every 15 minutes in an BaaN / Oracle 7.3.3.2 environment, and have
> been unable to change the TNS settings to help us out in any meaningful
> way. Has anyone out there got this error before (in BaaN or elsewhere)
> and if so, how did you manage to resolve it?
>
> Any help on this is greatly appreciated!!
>
> Thanks,
>
> John O'Sullivan (email osullivan_j_at_sensormatic.com)
Received on Tue Jan 06 1998 - 00:00:00 CST