Re: Is Database Up?

From: Bob Jones <email_at_me.not>
Date: Tue, 29 Aug 2006 00:15:41 GMT
Message-ID: <NGLIg.17629$kO3.13653@newssvr12.news.prodigy.com>

"Chuck Whealton" <chuck_whealton_at_yahoo.com> wrote in message news:1156809557.746757.212930_at_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
>

That only checks the listener. Received on Mon Aug 28 2006 - 19:15:41 CDT