Re: My 10 liner alert log monitoring WORKING shell Script !!! Comments Please !!!!

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 2 Nov 2006 22:32:38 +0100

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@xxxxxxxxxxx ;;
  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.
--
//www.freelists.org/webpage/oracle-l


Other related posts: