RE: Truncated Listener Log/backing up?

If admin restrictions are on, you can turn it off in the listener.ora,
then do a reload (lsnrctl> reload).  After you rename the log file, edit
the listener.ora again to turn admin restrictions back on, and reload
again.
 
Jay

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Joel.Patterson_at_crowley.com
Sent: Friday, January 12, 2007 8:48 AM
To: niall.litchfield_at_gmail.com; cemail_219_at_hotmail.com
Cc: oracle-l_at_freelists.org
Subject: RE: Truncated Listener Log/backing up?



Yes, set log_file command to work, it requires
ADMIN_RESTRICTIONS_LISTENER=OFF in the listener.ora file.  (I believe
that is the default, but if it is ON you can't rename).

 

Example:

lsnrctl set log_file ${ORACLE_HOME}/network/log/listener_${DATE}.log

 

find ${ORACLE_HOME}/network/log -name "listener*.log" -mtime
+${NUMBER_KEEPDAYS} -exec ls -ltr {} \;

find ${ORACLE_HOME}/network/log -name "listener*.log" -mtime
+${NUMBER_KEEPDAYS} -exec rm {} \;

 

####################### Cleanup old log files
###########################################

find ${LOGGEDDIR} -name "cleanup_listener*.log" -mtime
+${NUMBER_KEEPDAYS} -exec ls -ltr {} \;

find ${LOGGEDDIR} -name "cleanup_listener*.log" -mtime
+${NUMBER_KEEPDAYS} -exec rm {} \;

 

 

Joel Patterson 
Database Administrator 
joel.patterson_at_crowley.com 
x72546 
904  727-2546 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Thursday, January 11, 2007 10:39 AM
To: cemail_219_at_hotmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Truncated Listener Log/backing up?

 

You'll need to change the current log from within lsnrctl using set
log_file <newname>, you can then maintain the old one as you feel like. 

On 1/11/07, J. Dex <cemail_219_at_hotmail.com> wrote:

Our listener log has grown too large and I want to back it up.  It is my
understanding that it can't be truncated because it is an open file.
What
are other people doing to resolve this issue?   This is on a W2K server 
where the listener is password protected and security patches have been
applied.   I want to add whatever type of process can be used into a
script.

_________________________________________________________________ 


 



**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.

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