For Lazy DBA's

       Most of DBAs monitor alert.log for production databases.It sucks many times :) . Not only monitoring alert log in shell screen is so boring but also searching ORA- errors in lines. An idea came up my mind , during tailing log file , when founding ORA- error it displays popup dialog message into your screen.It is useful this command when surfing in web :)) .











You should install XManager  http://www.netsarang.com/download/main.html after that you should run XManager Passive.

#export DISPLAY=your_machine_ip:0.0

# tail -f alert.log|while read line ; param=$(grep -m 1 "ORA-" ); do notify-send  " ORA- FOUND " "$param"; done;

0 yorum:

Yorum Gönder