linux - Oracle数据库警报日志脚本错误

Question

我编写了警报日志脚本，以及一些它如何不起作用并且在执行脚本时没有抛出任何错误的原因我怀疑 sed 部分无法正常工作。你能告诉我哪里做错了吗？

这是一段代码

#!/bin/sh



## Heading #########################################################################################
#---------------------------------------------------------------------------------------#
# script usage                                                                          #
#---------------------------------------------------------------------------------------#

_usage() {
  echo "Usage: $0 ORACLE_SID "
} # _usage

    ORACLE_SID="$1"
    setenv ()
    {
        eval "$1=$2"
        export "$1"
    } # setenv

    unsetenv ()
    {
        while [ $# -gt 0 ]
        do
            unset "$1"
            shift
        done
    } # unsetenv

if [ $# -ne 1 ]; then
   _usage
   exit 1
fi

Env=/u01/app/oracle/config
HN=`uname -n`
ERROR_FILE=/tmp/${ORACLE_SID}_error.log
HN=`hostname`
DBA_MAIL="oracle.mail@company"
DBA_PAGE=""



#+--------------------------------------------------------------------------------------+
#|  get oracle environment variables from our common env dir                            |
#+--------------------------------------------------------------------------------------+

if [ -r $Env/${ORACLE_SID}.env ]
then
    . $Env/${ORACLE_SID}.env
else
    ORACLE_SID=""
fi

#+--------------------------------------------------------------------------------------+
#|  just checking for Oracle Env variables for connecting database                      |
#+--------------------------------------------------------------------------------------+

if [ "$ORACLE_SID" = "" ]
then
        echo "ORACLE_SID is invalid"
        exit 1
fi
if [ "$ORACLE_HOME" = "" ]
then
        echo "The environment variable ORACLE_HOME must be set"
        exit 1
fi
if [ "$ORACLE_BASE" = "" ]
then
        echo "The environment variable ORACLE_BASE must be set"
        exit 1
fi

_AlertLogLoc ()
{
ALERTLOG=`$ORACLE_HOME/bin/sqlplus -s "/as sysdba" << EOF
set head off pause off term on feed off timing off
select value from v\\$parameter where name like 'background_dump_dest';
exit;
EOF`
}
_AlertLogLoc
echo $ALERTLOG
export ALERTLOG


if [ -f $ALERTLOG/alert_${ORACLE_SID}.log ]; then
        echo "Found Database Alert log"
else
        echo "Alert log not found .. exit from  script"
fi

if [ -f $ALERTLOG/alert_${ORACLE_SID}.skip ]; then
        echo " ORACLE_SID skip error file found"
        SKIP_ERR=`cat $ALERTLOG/alert_$ORACLE_SID.skip|xargs|sed -e 's/ /|/g'`
        echo $SKIP_ERR
else
        echo "No errors will be excluded"
fi
REC_CUR_ALSIZE=/oraworkspace/OSE/logs/alert_${ORACLE_SID}.size  # file to record current alert log lines
#---------------------------------------------------------------------------------------------------------#
# let Capture ORA- error from the alert log                                                               #
#---------------------------------------------------------------------------------------------------------#

if [ -f $REC_CUR_ALSIZE ]; then
        ALSIZE=`cat $REC_CUR_ALSIZE|sed -e 's/^[ \t]*//'`
                ALSIZE=`expr $ALSIZE + 1`
else
ALSIZE=0
fi


if [ $ALSIZE -eq 0 ]; then
        echo "PROBABLY RUNNUNG THE SCRIPT FIRST TIME"
        sed -n  $ALSIZE',$p' $ALERTLOG/alert_${ORACLE_SID}.log |egrep -v "$SKIP_ERR"|grep -i 'ORA-' > /tmp/${ORACLE_SID}_error.log
        #`wc -l $ALERTLOG/alert_${ORACLE_SID}.log > $REC_CUR_ALSIZE
        cat $ALERTLOG/alert_${ORACLE_SID}.log|wc -l > /oraworkspace/OSE/logs/alert_${ORACLE_SID}.size
        #ALSIZE=`cat $ALERTLOG/alert_${ORACLE_SID}.log |wc -l`
else
        sed -n  ${ALSIZE}',$p'  $ALERTLOG/alert_${ORACLE_SID}.log |egrep -v "$SKIP_ERR"|grep -i 'ORA-' > /tmp/${ORACLE_SID}_error.log
        #wc -l $ALERTLOG/alert_${ORACLE_SID}.log >> $REC_CUR_ALSIZE
        cat $ALERTLOG/alert_${ORACLE_SID}.log |wc -l > /oraworkspace/OSE/logs/alert_${ORACLE_SID}.size
fi



#---------------------------------------------------------------------------------------------------------#
# Notify if any errors are found                                                                          #
#---------------------------------------------------------------------------------------------------------#

ERR_CNT=`cat /tmp/${ORACLE_SID}_error.log |wc -l`

if [ $ERR_CNT -ne 0 ]; then
        echo "Errors found in the alert log. send email notification"
        mailx -s "${HN}:${ORACLE_SID} ORA error Found in the alert log" ${DBA_MAIL} < $ERROR_FILE
        #mailx -s "${HN}:${ORACLE_SID} ORA error Found in the alert log" ${DBA_MAIL}  < $ERROR_FILE
else
        echo " No errors found in the alert log"
fi

Answer 1

如果 $ALERTLOG/alert_$ORACLE_SID.skip 不存在或为空(大约第 94 行)，egrep -v "$SKIP_ERR" 将从 sed 输出中排除所有行，因此它将没有机会看到任何剩余的 ORA- 错误。

ALSIZE=1
SKIP_ERR=""
sed -n  $ALSIZE',$p' $ALERTLOG/alert_${ORACLE_SID}.log |\
  egrep -v "$SKIP_ERR"|wc -l

0

SKIP_ERR="dummy"
sed -n  $ALSIZE',$p' $ALERTLOG/alert_${ORACLE_SID}.log |\
  egrep -v "$SKIP_ERR"|wc -l

15165

因此，当 SKIP_ERR 未设置或为空时(如果您的跳过文件为空)，您需要将其设置为某些内容。您没有说是否是这种情况或显示了脚本输出，但它似乎除此之外还可以工作。

另外，如果 ALSIZE 为零，sed 会不满意，至少在 RHEL 5 中是这样:

ALSIZE=0
SKIP_ERR="dummy"
sed -n  $ALSIZE',$p' $ALERTLOG/alert_${ORACLE_SID}.log |\
  egrep -v "$SKIP_ERR"|wc -l

sed: -e expression #1, char 4: invalid usage of line address 0
0

当您测试文件在第 91 行是否存在时，您会显示一条消息，说明这一点并建议您在此停止，但在第 94 行之后没有 exit；似乎与这里无关，但似乎是一个疏忽？