Listener Log Mainteance

Reset the listener log file without shutdown the listener

Copy and Paste the following code in the editor

#! /bin/sh
# Listener log mainteance - without shutting down the Listener
# oracle user home location - /data01/oracle
#/data01/oracle/bash_profile

ORACLE_HOME=/data01/oracle/product
DBLOG=/tmp/listener_logs_mtc.log
ECHO=/bin/echo
LISTENER=`grep "SID_LIST_LISTENER_" $ORACLE_HOME/network/admin/listener.ora| cut -c 10-58`
CURRENT_LISTENER=${LISTENER/=/}

cd $ORACLE_HOME/network/log
$ORACLE_HOME/bin/lsnrctl show log_file>/tmp/tmp.log
LOG_FILE=`grep "listener_" /tmp/tmp.log| cut -c 38-65`
$ECHO " "> $DBLOG

$ECHO "**** Begin process $ORACLE_HOME/network/log/$LOG_FILE `date` **" >> $DBLOG
$ECHO "LOG_FILE= $LOG_FILE" >> $DBLOG
$ECHO "LISTENER= $CURRENT_LISTENER" >> $DBLOG

# ---------------------------------------
# turn off listener log file for archive
# ---------------------------------------
$ECHO " ">> $DBLOG
$ECHO "** turn OFF LISTENER log recording...." >> $DBLOG
$ORACLE_HOME/bin/lsnrctl set log_status off >> $DBLOG
$ECHO " ">> $DBLOG

# archive listener log file turn back on ASAP
# so we do gzip right after mv..
# ---------------------------------------
mv $LOG_FILE $LOG_FILE.`date +%Y%m%d`
$ECHO "Move LISTENER log file $LOG_FILE =====> $LOG_FILE.`date +%Y%m%d` " >> $DBLOG
$ECHO " ">> $DBLOG
$ECHO "$LOG_FILE archive completed." >> $DBLOG
$ECHO " ">> $DBLOG

# ---------------------------------------
# Null out the listener.log file
# ---------------------------------------
cat /dev/null >$LOG_FILE
$ECHO "LISTENER log file =====> $LOG_FILE Created. " >> $DBLOG
$ECHO " ">> $DBLOG

# ---------------------------------------
# turn on listener log file for archive
# ---------------------------------------
$ECHO "** turn ON LISTENER log recording...." >> $DBLOG
$ECHO " ">> $DBLOG
$ORACLE_HOME/bin/lsnrctl set log_status on >> $DBLOG
$ECHO " ">> $DBLOG
#
# now we gzip it - TRADE
# -------------------------------------
/usr/bin/gzip $LOG_FILE.`date +%Y%m%d` >> $DBLOG

$ECHO "**** End process $ORACLE_HOME/network/log/$LOG_FILE `date` **" >> $DBLOG
# ---------------------------------------
# Save a file of log file to $ORACLE_HOME/network/log directory
# ---------------------------------------
cp $DBLOG listener_logs_mtc.sh.log.`date +%Y%m%d`

# ---------------------------------------
# maintain 90 days log file retention
# ---------------------------------------
/usr/bin/find . -name \*.gz -mtime +90 -exec /bin/rm {} \;

# EOF: end of program listener_logs_mtc.sh

Print this code - HP

Quotes: Trade carefully as you can loose your savings

 

Download the toolbar and Stay connected with Live DBA