Re: Oracle monitoring help

GerryS wrote:
> I work for a company that is having financial difficulty (who isn't
> right now) and has decided to terminate the off-site daily DBA
> monitoring services in order to save money. Personally I don't agree
> with the decision, but I was overridden and have to deal with the
> situation.
>
> That being said, I was hoping to get some guidance as to what to
> monitor and possibly scripts or tools to use to monitor the database.
> We are running version 7.3.4. I am a programmer (please don't hold
> that against me) by training and have had some Oracle training, but
> that was several years ago. Hopefully, my DBA duties will be
> short-lived and I will be able to hand it back to someone who knows
> what they are doing, but any help you can provide in the mean time
> will be greatly appreciated.
>
> Thanks in advance,
>
> Gerry

What operating system are you going to do your checking from? If Unix, you can schedule several cron jobs to run shell scripts periodically and do something simple like:

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.

Since these tasks are operating specific, you won't find much help from most Oracle manuals (which tend to be generic). Received on Tue Jan 28 2003 - 12:32:49 CST