Re: ORA-12540: TNS:internal limit restriction exceeded

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Wed, 4 Feb 2004 16:06:49 -0800 (PST)
Message-ID: <20040205000649.5513.qmail@web20422.mail.yahoo.com>

• Mladen Gogala <mladen_at_wangtrading.com> wrote:
  > You've hit the number of concurrently open TCP
  > connections on the box.
  > You may try cman and connection pooling, but it
  > would involve
  > restarting the database and setting "POOL" parameter
  > for the
  > dispatchers. The machine itself doesn't need to be
  > restarted.
  >
  >
  > On 02/04/2004 05:23:42 PM, Jordi Adame V wrote:
  > > When running a Pro*C application (64 bits) i get
  > this error:
  > >
  > > ORA-12540: TNS:internal limit restriction exceeded
  > >
  > > My system:
  > > HP-UX B.11.11
  > > Oracle 9.2.0.1.0
  > >
  > > is there any way to solve this without changing
  > kernel parameters?
  > >
  > > regards,
  > >
  > > Jordi
  

any chance that you have a relatively larger number of dead connections that might not be terminated in a timely fashion?

check v$session for entries in which the last_call_et value is high (say larger than 3600).

According to the documentation, dead connection detection works on your platform.
check the value of the sqlnet.ora parameter expire_timeout

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/troubleshooting.htm#635996

hth.

Pd

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Feb 04 2004 - 18:06:49 CST