--- 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 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
