Re: is instance up???

I dont seem to have any problems with oiconnect over SqlNet, as long as the tnsnames.ora is complete.
Enclosing the oiconnect command in a wrappter script will prevent the password from appearing from the Command line. Obviously this file has to be Well protected.

Kenneth C Stahl wrote:

> #!/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 - 13:49:59 CDT