RE: Changing multiple listener log names
- To: <lawrence.wolfson@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 May 2006 15:09:18 -0400
Larry,
Are you running multiple listener processes on the same machine?
Use the "set current_listener" command to change the name of the
listener log. Something like:
LOG="listener.`date '+%m%b%e%a' | tr ' ' '0'`"
Echo "set current_listener listener_ra2p" > lisncmd.lsn
Echo "set log_file $LOG" >> lisncmd.lsn
Echo "exit" >> lisncmd.lsn
Lsnrctl < lisncmd.lsn
The above worked on an NT machine for me. Haven't tried it on Unix.
One thing you probably know - you can set the name of the log file - but
if you stop and start the listener, I think it gets reset to the default
name. So you probably want to do the above a different way:
1). Change the name of the log file to something temporary.
2). Rename the existing log file with to a dated name like you are doing
3). Change the name of the log file back to its default.
Personally, I turn listener logging off so that I don't have to deal
with this issue. I turn database logon auditing on to track
connections.
Good Luck!
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wolfson Larry -
lwolfs
Sent: Tuesday, May 02, 2006 2:47 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Changing multiple listener log names
We usually like to change the name of the listener log daily.
This is an easy way to see fluctuations in an application or server and
easier to scan when it isn't 5G.
With something like
# Below generates listener.10oct10fri and .log is appended to that.
LOG="listener.`date '+%m%b%e%a' | tr ' ' '0'`"
lsnrctl set log_file "$LOG"
Lots of times we've been told everyday is the same
and still see 2.5 times as many connections every Friday.
Same day sales team has to have orders in.
Below you can see a database that is busier on Saturdays
and for some reason Thursday Mar 30th.
We've a number of servers with multiple log names but haven't been able
to figure out how to get their names changed.
Like these 2 here:
11907403 May 2 13:24 listener_ra2p.log
13546692 May 2 13:24 listener_trgp.log
Would like something like ==> listener_trgp05.may02tue.log
How easy is it?
Thanks
Larry
130915068 Mar 30 23:59 listener.03mar30thu.log
67752705 Mar 31 23:59 listener.03mar31fri.log
67920937 Apr 1 23:59 listener.04apr01sat.log
2925123 Apr 2 23:59 listener.04apr02sun.log
2355382 Apr 3 23:59 listener.04apr03mon.log
1727084 Apr 4 23:59 listener.04apr04tue.log
1698174 Apr 5 23:59 listener.04apr05wed.log
1406888 Apr 6 23:59 listener.04apr06thu.log
3292066 Apr 7 23:59 listener.04apr07fri.log
26687833 Apr 8 23:59 listener.04apr08sat.log
1865193 Apr 9 23:59 listener.04apr09sun.log
2948930 Apr 10 23:59 listener.04apr10mon.log
1614107 Apr 11 23:59 listener.04apr11tue.log
1367328 Apr 12 23:59 listener.04apr12wed.log
1043434 Apr 13 23:59 listener.04apr13thu.log
1085030 Apr 15 00:00 listener.04apr14fri.log
27346263 Apr 16 00:00 listener.04apr15sat.log
573629 Apr 16 23:59 listener.04apr16sun.log
202423 Apr 17 23:59 listener.04apr17mon.log
206806 Apr 18 23:59 listener.04apr18tue.log
250578 Apr 19 23:59 listener.04apr19wed.log
249310 Apr 20 23:58 listener.04apr20thu.log
217346 Apr 21 23:57 listener.04apr21fri.log
41947152 Apr 22 23:59 listener.04apr22sat.log
202267 Apr 23 23:59 listener.04apr23sun.log
765846 Apr 24 23:59 listener.04apr24mon.log
1032184 Apr 25 23:59 listener.04apr25tue.log
1102964 Apr 26 23:59 listener.04apr26wed.log
1064385 Apr 27 23:59 listener.04apr27thu.log
1133838 Apr 28 23:59 listener.04apr28fri.log
26614410 Apr 29 23:59 listener.04apr29sat.log
1074149 May 1 00:00 listener.04apr30sun.log
1063498 May 1 23:59 listener.05may01mon.log
443306 May 2 13:27 listener.05may02tue.log
************************************************************************
*
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
************************************************************************
*
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
