Oracle-L: Re: Listener Hangs

From: Chuck Hamilton <chuckh_at_softhome.net>
Date: Tue, 04 Mar 2003 13:19:58 -0800
Message-ID: <F001.0055FFCA.20030304131958@fatcity.com>

It's possible. I've heard of this happening before and the recommendation was to clear out the listener.log file. There are a couple of ways to clear out that file. One is to stop the listener and delete it. The other is to cat /dev/null to it (i.e. cat /dev/null > listener.log). The latter doesn't require the listener to be stopped. This works in Unix. On windows I think the only option is to stop the listener and delete the file.

Original Message ----- From: Sam Bootsma To: Multiple recipients of list ORACLE-L Sent: Tuesday, March 04, 2003 12:04 PM Subject: Listener Hangs

We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0.

Yesterday morning our LISTENER process hung. "ERROR: ORA-12203: TNS:unable to connect to destination". We resolved the problem using the following steps:

Stop Listener using LSNRCTL utility (this hung - did not succeed in stopping the listener)
Issue UNIX command kill -9 <process id> to kill the corresponding Listener process.
Start the listener using the LSNRCTL utility

I checked the alert log and listener log. I found nothing in either file pointing to what the problem might have been. However, I did note that the listener.log file was 200 MB in size. Would the large size of the listener.log file contribute to the Listener hanging? This problem has occurred 6 to 8 times in the past couple of weeks. I do plan on starting a new listener.log file.

Thanks,

Sam Bootsma

sbootsma_at_gbrownc.on.ca

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Chuck Hamilton
INET: chuckh_at_softhome.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Mar 04 2003 - 15:19:58 CST