RE: delete Listener.log ?

You do not have to stop the listener in order to delete the log files. What you can do is the following
$> lsnrctl

LSNRCTL> set current_listener <listener_name>
LSNRCTL> show log_file
LSNRCTL> set log_file <new log file name>
LSNRCTL> show log_file
LSNRCTL> exit

$> remove or backup the old listener.log

Kind Regards,

Hatzistavrou Yannis
Database Administrator
SchlumbergerSema

-----Original Message-----
Sent: Tuesday, April 22, 2003 7:32 AM
To: Multiple recipients of list ORACLE-L

Hi,

you need to shutdown the listener if you are removing any listener log files, rather than just removing the listener log file. This is because although you may have removed the physical log file it does not actually free up the space as it is still attached to it thinking it s writing to the log file. Hence the space will not be freed up 'til you bounce the listener the log file is related to.

Regards
Dhanvir

-----Original Message-----
Sent: Tuesday, April 22, 2003 08:32
To: Multiple recipients of list ORACLE-L

Guys,

listener.log in %ORACLE_HOME%network/log has grown to 1.7G in size. can i just overwrite it with another blank file named listener.ora ? if YES , can i do it when the DB is quite busy ?

do people delete/move it manually in periodic intervals ? how is it usually managed ?

the environment is 8.1.6/Win2K.

TIA.
Jp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

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).

____________________________________________________________________________
________________________ 


This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rathi Dhanvir
  INET: Dhanvir.Rathi_at_churchill.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hatzistavrou John
  INET: John.Hatzistavrou.sema_at_mail.tellas.gr

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).