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@xxxxxxxxxxx 
x72546 
904  727-2546 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Niall Litchfield
Sent: Thursday, January 11, 2007 10:39 AM
To: cemail_219@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx> 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.

_________________________________________________________________ 
Fixing up the home? Live Search can help
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&loca
le=en-US&source=hmemailtaglinenov06&FORM=WLMTAG 

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






-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: