Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Truncated Listener Log/backing up?
Now your getting fancy. You also could have two files, one with and
one without and simply cp without listener.ora ... cp with listener.ora.
:-) (don't read that as better)... but easier if one didn't wish or know how to code the edit.
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 Hostetter, Jay M
Sent: Friday, January 12, 2007 9:09 AM
To: oracle-l_at_freelists.org
Subject: 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-lReceived on Fri Jan 12 2007 - 14:10:37 CST
![]() |
![]() |