Changing multiple listener log names

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Tue, 2 May 2006 13:47:04 -0500
Message-ID: <B39B7B7D8C8CEA419D0ED45FD7FA4C5301353C44@CWYMSX06.Corp.Acxiom.net>

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.

---

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

Received on Tue May 02 2006 - 13:47:04 CDT