shell status checking

[Quoted] I'm new to oracle but have lots of experience to Informix. We've lots of ways to check the status of an Informix database with shell accessible tools like onstat and dbaccess, but I dont see them available in /oracle/bin or /oracle/rdbms/admin.

Im looking for something relativley simple like: #!/bin/ksh
while :
do
STAT=`onstat -`
grep 'online' $STAT 1>/dev/null 2>&1
if [ $? != 0 ]
then

    echo "DB Down!!" | mailx sysadmin
fi
sleep 60
done

Thanks, Eric Priebe

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * [Quoted] The fastest and easiest way to search and participate in Usenet - Free!