Re: Oracle 8.17 listener crash ?

From: Peter van Rijn <pgm.van.rijnRM_at_THIShccnet.nl>
Date: Mon, 5 May 2003 13:39:51 +0200
Message-ID: <b95ihs$3j7$1@news.hccnet.nl>

> Hello,
> We use Oracle 8.17 / SUN server. When we try to connect on a database with
a
> NT Client the first time it work but the second time server doesn't
respond.
> If we stop the listener and start it again we can connect with the
oracle's
> client.
> We have to stop and start listener we need to connect to the database does
> someone has any idea on this trouble ?
> Best regards
>

Did you check the listener.log file on the server? (default location $ORACLE_HOME/network/log).
If this doesn't tell you anything interesting you might try enabling tracing for the listener.
If I understand you well the listener doesn't really crash (i.e. process is stopped) but it doesn't function properly anymore. Or does it indeed crash?

Something worth while checking might be some system parameters like max open files, or max. no. of processes, be it on a user level or system wide.

regards,
Peter Received on Mon May 05 2003 - 06:39:51 CDT