Listener out of resources

From: David Nixon <djn_at_csc.liv.ac.uk>
Date: 28 Oct 2002 12:41:37 GMT
Message-ID: <apjba1$a93$1@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 - 06:41:37 CST