TNS:internal limit restriction exceeded

TNS:internal limit restriction exceeded

Post by Peder Sandhol » Fri, 29 Sep 2000 04:00:00

I get this error:

12223, 00000, "TNS:internal limit restriction exceeded"
// *Cause: Too many TNS connections open simultaneously.
// *Action: Wait for connections to close and re-try.

Anybody knows what the reason can be?  (I am not using sql-net)

The problem came as some new websites were made on a NT-server. The
NT-server connects to the UNIX server (IBM AIX 4.2 (rs6000)) which has an
Oracle database in order to take out information. Each website use a
portnumber on the UNIX.. Is there any limitations on portnumbers? Or is it a
memory problem, or???


1. setrlimit incorrectly allows hard limits to exceed soft limits


In 2.4.19 (also 2.5.46) setrlimit code only ever makes a comparison to
check the old soft limit with the new soft limit and the new hard
limit with the old hard limit.  There is never a check to ensure the
new soft limit never exceeds the new hard limit.

Just try "ulimit -H -m 10000" for memory limits that were not
previously set.  You end up with (hard limit = 10000) < (soft limit =

Fix is trivial.

--- sys.c       Sat Aug  3 10:39:46 2002

        if (resource >= RLIM_NLIMITS)
                return -EINVAL;
+       if (new_rlim.rlim_cur > new_rlim.rlim_max)
+               return -EINVAL;
        if(copy_from_user(&new_rlim, rlim, sizeof(*rlim)))
                return -EFAULT;
        old_rlim = current->rlim + resource;

To unsubscribe from this list: send the line "unsubscribe linux-kernel" in

More majordomo info at
Please read the FAQ at

2. Kernel 2.1.101 won't boot

3. Front Page Ext.

4. Limit on number of FTP restrictions

5. Amiga-like X windows desktop?

6. ld: internal error: number of symbols exceeds alloc'd 1348

7. Need help with Portsentry log entry

8. Can't install LILO when Linux > 8 GB limit with PC with BIOS restriction

9. Message size exceeded size of internal buffer

10. Root login restrictions, without complete su restriction?

11. Can Linux exceed hardware limits for HD size?

12. WARNING: /tmp: File system full, swap space limit exceeded