#Script used to monitor the database alert log file
LOGFILE=/tmp/database_alert_$ORACLE_SID.log
RETURN_CODE=`grep ORA- /[bdump]/alert.log | wc -l`
if [ $RETURN_CODE -eq 0 ]
then
exit 0
else
echo "$ORACLE_SID - There are $RETURN_CODE errors in Alert log" >
$LOGFILE
exit 1
fi

تم تعديل 11 أغسطس 200916 سنة بواسطة islamic_boy600

Hello

This is a simple Windows Batch file that will do the same function as the Unix Shell Script you send

1- Open a text file in Windows

2- Copy these 2 lines to the text file and rename it to Read_Alert.bat

set filename="D:\oracle\product\10.2.0\orcl\bdump\orcl_alert.log"
find /n "ORA-" %filename% >Alert_log_errors.txt

3- Replace D:\oracle\product\10.2.0\orcl\bdump\orcl_alert.log with the path of your database Alert Log File and then save the batch file

4- Run the batch file you will get another file in your current folder called Alert_log_errors.txt it has all ORA errors found in your Alert Log File and thier Line Numbers.

hope this will help