Re: Is Database Up?

Bob Jones wrote:
> "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.

You're absolutely right. Disregard that posting, please! :-o

Charles R. Whealton
Charles Whealton @ pleasedontspam.com Received on Tue Aug 29 2006 - 05:11:25 CDT