Re: Oracle monitoring help

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:l1AZ9.14$XS4.2487554_at_newssvr15.news.prodigy.com...
>
> 1. To make sure your database server is alive: 'ping servername'.
>
> 2. To make sure your Oracle listener is alive: 'tnsping dbalias'.
>
> 3. To make sure your database is reachable: 'select sysdate from dual'.
>
> You can have the scripts email you if there's a problem. If you have
> Windows instead of Unix, you'll have a bit tougher time.

You can do the above from Windows, too.

--
Later,
Brian E Dick
See my resume at http://members.cox.net/bdick/