Any better way to Monitor DB server & Listener?
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?
/bin/rm -f lsnr.exist
ps -ef | grep LISTENER | grep -v grep > lsnr.exist
if [ ! -s lsnr.exist ]
echo "." | mailx -s "ALERT!!! Oracle listener on `hostname` is down since `date`" email@example.com