Friday, June 7, 2013

Database MONITOR script

Please refer this first-To Understand the flow of script.

#!/bin/bash
#below line added to provide oracle user env if scriptis executed remotely thru ssh
source /home/oracle/.bash_profile
echo "exit" | sqlplus -L dbowner/dbownerpwd@dbname | grep Connected > /dev/null

No comments:

Post a Comment