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" inORA-*) 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 DimitreP.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