RE: truncating listener.log on Windows

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Wed, 27 Jul 2011 17:49:53 +0100
Message-ID: <7C4BF3B32B80CC44AE37D31B172415937DC7F1025F_at_GVW1337EXC.americas.hpqcorp.net>

Why not just turn off logging, delete or reduce the file size, and then re-start logging?

set log_status off

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter (ESS) Sent: Tuesday, July 26, 2011 4:40 PM
To: oracle-l_at_freelists.org
Subject: truncating listener.log on Windows

Oracle 10.2.0.3.0 on Windows Server 2003 sp2.

How do you truncate the listener log file without bouncing the listener?

I know how to do this on UNIX, but when I try "echo > listener.log" I get "cannot access the file because it is being used by another process". The other option, appears to be to use the lsnrctl "set log" command followed by "save config", but, according to MOS, this may crash the listener.

Any other options?

Thanks,
Peter Schauss
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 27 2011 - 11:49:53 CDT

This message: [ Message body ]
Next message: Bill Ferguson: "Re: all time worst question I have been ever asked as a DBA"
Previous message: Douglas Cowles: "Anonymous block performing much worse then separated statements"
In reply to: Schauss, Peter (ESS): "truncating listener.log on Windows"
Next in thread: Niall Litchfield: "Re: RE: truncating listener.log on Windows"
Reply: Niall Litchfield: "Re: RE: truncating listener.log on Windows"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message