Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: My 10 liner alert log monitoring WORKING shell Script !!! Comments Please !!!!
> Actually its 20 lines,
> I did some initial tests, seems to be working fine.
> Appreciate your comments and feedback, suggestions
[...]
Just another point of view: I would use a kind of daemon.
tail -f alert.log | while read error; do
case "$error" in
ORA-*) printf "%s\n" "$ORACLE_SID" "$(date)" "$error" | mailx -s
"$ORACLE_SID : ${error:0:8}" email_at_address.edu ;;
esac
done
Just remember to restart the daemon if you remove/move the log :)
Regards
Dimitre
P.S. The ${var:start:lenght} syntax is a valid for ksh93 and bash > 2.0, if I recall correctly.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 02 2006 - 15:32:38 CST
![]() |
![]() |