Re: Listener out of resources

From: Svend Jensen <svend.jensenKILLSPAM_at_it.dk>
Date: Mon, 28 Oct 2002 21:30:40 +0000
Message-ID: <3DBDAC80.8060900@it.dk>

Have U checked the listener.log, found in $ORACLE_HOME/network/log? If there is no indications or help here, try setting trace on the listener.

rgds
/Svend

David Nixon wrote:

> I am running Server release 8.1.7.4.0 on HP-UX and have hit a problem with
> the Oracle listener that seems related to some sort of resource limit.
>
> When the number of already connected users
> gets up to about 140, the listener returns the following error
> to sqlplus on the remote (Linux) client:
>
> ORA-03113: end of file on communication channel
>
> Restarting the listener allows a few more connections to be established
> but it soon reverts to returning the above errror. Can anyone indicate
> resource limit adjustments, Kernel (maxfiles_lim?) or Oracle, with which
> to investigate this problem ?
>
> Thanks in advance,
> DaveN - University of Liverpool, Computer Science
>
>
Received on Mon Oct 28 2002 - 15:30:40 CST