Re: Listener out of resources

From: SEJ <sejprv_at_adsl.tele.dk>
Date: Mon, 28 Oct 2002 19:55:57 +0100
Message-ID: <3dbd883d$0$97657$edfadb0f@dspool01.news.tele.dk>

Hi David

There is a similar problem with win2000, generel memory problems and there are a patch available for w2k, unix ? try patch number 8.1.7.4.1

regards

Svend

"David Nixon" <djn_at_csc.liv.ac.uk> wrote in message news:apjba1$a93$1_at_news.liv.ac.uk...
> 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 - 12:55:57 CST