Oracle-L: RE: Listener Hangs

From: <Govind.Arumugam_at_alltel.com>
Date: Tue, 04 Mar 2003 11:22:29 -0800
Message-ID: <F001.0055FDA3.20030304112229@fatcity.com>

This is how you can clean up listener.log w/o taking the listener down.

You can copy the listener.log to an archive location, then do the following:

cat "/dev/null" and redirect to listener.log file. This will zero the current file and allow other updates to the log from the listener to continue.

eg: cp listener.log wherever.log
cat /dev/null > listener.log

ls -l listener.log
-rw-r--r-- 1 oracle 0 Apr 5 13:22 listener.log
lsnrctl status
ls -l listener.log
-rw-r--r-- 1 oracle 160 Apr 5 13:22 listener.log

Here you can see the listener.log files gets emptied. Doing a 'status' command on the listener you can see the current tnslsnr process continues to write to the file.

By redirecting the output of an empty file '/dev/null' or using a file that may contain the last 100 lines of the Listener and redirecting to the "listener.log", you keep the same inode value that tnslsnr process uses to write to the "listener.log".

The key is not to remove or move the current "listener.log" while the tnslsnr process is running. It is ok to copy the file for historical records.

-----Original Message-----

Sent: Tuesday, March 04, 2003 12:05 PM
To: Multiple recipients of list ORACLE-L

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: <Govind.Arumugam_at_alltel.com
INET: Govind.Arumugam_at_alltel.com

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 - 13:22:29 CST