Re: Listner Problems (tcp)

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Mon, 26 Oct 1998 12:49:13 +0100
Message-ID: <711nn1$k3k$1@sunrise.pg.gda.pl>

Dave Bevan wrote in message <36354471.3107116_at_news.demon.co.uk>...
>My listener seems a bit hard of hearing !
>
>Running workgroup server 7.3 on a SCO OS5 server, it will start up
>fine, and allow connections from client PCs running Windows 95.
>
>However, after a little while, the message 'End of file on
>communication channel' comes up if you try to connect.
>
>Running lsntrctl and doing a status, it looks like everything is OK,
>however, in order to connect, I have to stop the listener and start it
>again. Then everything is fine until the next time it gives a rude
>message, which can be enything from 10 minutes to 3 hours.
>

That's not the problem with sql*net listener but rather with server processes probably aborted with coredump. See alert log for more info. Check especially for ORA-07445 and ORA-00600. Unfortunetally it is quite typical with that RDBMS version & platform...

Regards,
Piotr Kolodziej
pkol_at_otago.gda.pl Received on Mon Oct 26 1998 - 05:49:13 CST