Hi DBAs,

I wrote a script to monitor my DB listener(as below), if the listener is down, send an email to me.
I am going to use the same way to monitor DB server process, such as "ora_smon_dev".
Does anyone has better idea to monitor your DB server and listener?

Thanks!

Betty


Check_lsnr.sh
------------------
#!/bin/sh
cd /opt/oracle/scripts
/bin/rm -f lsnr.exist
ps -ef | grep LISTENER | grep -v grep > lsnr.exist
if [ ! -s lsnr.exist ]
then
echo "." | mailx -s "ALERT!!! Oracle listener on `hostname` is down since `date`" name@xyz.com
/opt/oracle/product/9.2.0/bin/lsnrctl start
fi