Instance UP/DOWN based on count of SMONs on a server - script sending false alerts
Hi DBAs,
We have one reporting server, where 4 databases are running. We have one background process count script for SMON at os level. its running for every 15 mins and alerting us if any db is down.
In recent days we observed that script sending false alert even all 4 databases are running its shows that only 3 out of 4 are running.
If any body have such a similar script with you, Could you please share with me?
Our script:-
bg_cnt=`ps ax|grep -v grep |grep smon|awk '{print $5}'| grep -i smon | wc -l`
if [ "$bg_cnt" -ne 4 ];then
We have one reporting server, where 4 databases are running. We have one background process count script for SMON at os level. its running for every 15 mins and alerting us if any db is down.
In recent days we observed that script sending false alert even all 4 databases are running its shows that only 3 out of 4 are running.
If any body have such a similar script with you, Could you please share with me?
Our script:-
bg_cnt=`ps ax|grep -v grep |grep smon|awk '{print $5}'| grep -i smon | wc -l`
if [ "$bg_cnt" -ne 4 ];then
0