 | | | ORA-12540: TNS:internal limit restriction exceeded | ORA-12540: TNS:internal limit restriction exceeded 2004-02-04 - By Paul Drake
Back
--- Mladen Gogala <mladen@(protected)> 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 (See http://ORA-12540.ora-code.com): 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|