RE: Maintenance of listener.log files

From: Adams, Matthew (GEA, MABG, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Fri, 23 Aug 2002 09:58:34 -0800
Message-ID: <F001.004BE639.20020823095834@fatcity.com>

Here is what we do on a nightly basis,
it works just fine with no problems.

(modify as you see fit. The important lines to answer
your question are the two 'cp' commands)

cat /etc/oratab | grep -v ^# |grep ':Y'| grep -v ^\* \   | cut -d: -f2 | sort -u | while read O_HOME do
 if [ -f ${O_HOME}/network/log/listener.log ]  then
   cp -p ${O_HOME}/network/log/listener.log \

                 ${O_HOME}/network/log/listener.log.`date +%Y%m%d%H%M`

   cp /dev/null ${O_HOME}/network/log/listener.log  fi
done

---

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com My computer beat me at chess, but I won
when it came to kick boxing.

-----Original Message-----
Sent: Friday, August 23, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L

Hello all,

I have an 8.1.7.4 database on 11.0 HP-UX server with a listener.log file and it records information as long as the listener is up. The problem is that the listener is always up and the file is getting larger and larger. I am looking for a way to periodically copy the data from the listener.log to another file (that would be around for two weeks and then purged) without having to bring the listener down. It seems like one of those tricks of replacing a tire on a car while it is still being driven.

TIA, Bryan Rodrigues
DBA
Elcom, Inc.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adams, Matthew (GEA, MABG, 088130)
  INET: MATT.ADAMS_at_APPL.GE.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Fri Aug 23 2002 - 12:58:34 CDT