Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: shell script to parse alert log looking for certain ora- errors
In article <74jqio$dd2$1_at_nntpd2.cxo.dec.com>,
"Pat Soehl" <pat.soehl_at_cxo.dec.com> wrote:
> I'm pretty new to writing shell scripts, being mostly familiar with VMS.
> I'm now a DBA on a Sun Solaris system. I need a script that
> parses through the alert logs looking for certain ora errors: such as
> 600... etc.
>
> Is there some samples somewhere that I could use?
>
> Thanks in advance,
>
>
Here is what i use:
The $ALERT_FILE is a variable you can either hard code or get the bdump
directory from the v$parameter
COUNT=`grep -c "ORA-00600" $ALERT_FILE/alert*`
if [ $COUNT -gt 0 ]
then
# @(#) 0003 - check_database.sh - Look at ALERT LOG FOR instance...00600
/usr/local/bin/call_pager.sh $PAGER_NUMBER
(MACHINE_NUMBER}${INSTANCE_NUMBER}0003
fi
We then call the call_pager.sh script to call a numeric pager with the error code.
hth, joe
http://www.oracle.dba.com
mailto:oracle_news_at_oracle-dba.com
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 09 1998 - 06:54:47 CST