RE: LISTENER.LOG file compress

From: Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com>
Date: Wed, 27 Jun 2001 10:13:29 -0700
Message-ID: <F001.0033A2D0.20010627084117@fatcity.com>

Seema,

I just posted a question on this earlier today. If you are on unix I was given this suggestion from John.

#!/bin/ksh
# Script to copy out listener.log and compress it. ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/8.1.6
export ORACLE_HOME

PATH=$ORACLE_HOME/bin:/usr/local/bin:/bin:/usr/bin

export PATH

COMPRESSED_FILE=/u01/app/oracle/product/8.1.6/network/log/listener`date +%Y%m%d%H%M`.log

lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener2.log
mv /u01/app/oracle/product/8.1.6/network/log/listener.log $COMPRESSED_FILE
mv /u01/app/oracle/product/8.1.6/network/log/listener2.log

/u01/app/oracle/product/8.1.6/network/log/listener.log
lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener.log compress $COMPRESSED_FILE

#
# now remove all compressed listener logs older than 10 days
#

find /u01/app/oracle/product/8.1.6/network/log/list*.Z -mtime +10 -print -exec rm {} \;

A suitable crontab entry for the oracle account would be

00 19 * * * /home/oracle/tidy_listener_log.sh >
/home/oracle/tidy_listener_log.log 2>&1

---

**

I am on NT but I believe you can use on of these two methods.

1. -Shut down the listener service (8.1.7 on NT 4.0) -rename the current log -startup the listener service again and this will create a new log listener.log

or

2)      -at a dos prompt type....
        -MSDOS> lsnrctl set log_file listener1.log
        -This can be done without stopping the listener service

Dave

"So many cats...........So few recipes!!"

-----Original Message-----
Sent: Wednesday, June 27, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L

Hi
My Listener.log file big.I want to rename the listener.log file.Can you please suggest the steps.
Thanks
-Seema

---

Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: oracledbam_at_hotmail.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: DFarnsworth_at_Ashleyfurniture.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 Wed Jun 27 2001 - 12:13:29 CDT