Re: Is Database Up?

From: Chuck Whealton <chuck_whealton_at_yahoo.com>
Date: 28 Aug 2006 16:59:17 -0700
Message-ID: <1156809557.746757.212930@p79g2000cwp.googlegroups.com>

amerar_at_iwc.net wrote:
> Hi All,
>
> I want to write a Unix shell script that will check to see if a
> database, on a remote machine, is up. Is this possible without writing
> some long telnet routine or something?
>
> I was hoping for some simple command that I can grep for some string to
> tell me the status of the remote database........
>
> Thanks!!!

If you're using some centralized system to check on all your database, but don't want to use OEM as other's have suggested, couldn't you just use tnsping?

Now this assumes you've at least got the client installed on the system you're checking from, and that you've built a TNSNAMES.ORA file, then you could just:

$ tnsping yourremotedb

Charles R. Whealton
Charles Whealton @ pleasedontspam.com Received on Mon Aug 28 2006 - 18:59:17 CDT