Re: is instance up???

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Wed, 23 Jun 1999 13:21:55 -0400
Message-ID: <377117B3.26688F0@lucent.com>

#!/usr/bin/ksh
tnsping mysid >/dev/null 2>&1;
if [ $? -eq 0 ];then

print -u2 "Oracle is up";
else

print -72 "Oracle is down";
fi

Just adapt to your own needs. You'll need to make sure that sqlnet v2 is set up properly. The "mysid" referenced above is the tnsnames.ora database alias for the instance that you want to check.

Ken

Ed Lufker wrote:

> Hi All:
>
> Does anyone have a script for unix that will check to see if an
> instance is up. I need to run the script from a central location to check
> many instances.
>
> thanks in advance for any help
> eddie lufker
Received on Wed Jun 23 1999 - 12:21:55 CDT