| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Perl DBA Tools
If you are keeping any kind of statistics on connections using the
listener.log, you have the potential of missing records between the time you
copy it and empty it to /dev/null. With my method, you won't loose
any records. The choice is yours.
HTH,
John
>>> lerobe_at_acxiom.co.uk 04/25/01 12:55AM
>>>
John,
Im my script for managing the
listener.log, I copy the listener to an archive area and then cat /dev/null to
to current one. Will this have the same effect as moving as in your example ? Do
I need also to force the listener to point to a different log file
?
Maybe I need to test some more
!!
Regards
Lee Robertson
<FONT face=Tahoma
size=2>-----Original Message-----From: John Carlson
[mailto:jcarlson_at_cj.com]Sent: 24 April 2001 19:47To:
Multiple recipients of list ORACLE-LSubject: Re: Perl DBA
Tools
How about wrapping this is a script of your
choice:
ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log
lsnrctl set log_file listener2.logmv listener.log
$ARCHIVE_LISTENER_FILENAMEmv listener2.log listener.loglsnrctl set
log_file listener.loggzip $ARCHIVE_LISTENER_FILENAME
This way, you don't have to stop the listener and you don't loose
anything. Remember, in Unix, when you rename a file, any program that
has it open still points to it.
Regards,
John
>>> jkstill_at_cybcon.com 04/24/01 10:20AM >>>On
Tuesday 24 April 2001 06:15, Rachel Carmichael wrote:> truncating
listener logs -- or even starting a secondary listener, stopping> the
one with the log that is too large and removing the log, then>
restarting the original listener....>Good idea. Thanks
RachelJared-- Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author: Jared
Still INET: jkstill_at_cybcon.comFat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).<FONT size=3>The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem. Received on Wed Apr 25 2001 - 15:42:28 CDT
 |
 |