Re: Daily Heath report script

Morning Sami,

<QUOTE>
>>> Sami Seerangan <dba.orcl_at_gmail.com> 11/02/05 06:08pm >>>
We want to setup daily email notification about database issues/alerts &
warning levels.

Say for example % free space in each tablespace, hanging sessions, replication queue count, broken jobs,locked accounts, and many other things.
</QUOTE>

<SNIP>

A colleague here is setting up a database, weblogic, apache and probably Unix server monitoring system using Nagios (www.Nagios.org I think) which runs on a Linux PC (Windows is possible too, as are other Unixes) with assorted plugins to monitor just about anything.

Most of our work is done without installing anything on the monitored servers - whihc we like - but to monitor Unix disc space, I believe a daemon is required.

Oracle testing at the moment is simple, is the listener running ?, is the database up?, what are the percentages used on the tablespaces in all the production databases with a warning at 80% and a critical alert at 90%. It works.

The DBAs get emails for Oracle problems, the WebLogic gurus get WL alerts, and so on. Maintenance slots can be assigned so that alerts don't go out during those hours and alerts can be acknowleged to indicate that we know about this problem, please don't alert me again. Etc etc.

We are running perl DBI modules, but you can run shell scripts, C programs etc. It's such a nice system, I'm starting to look into it at home for future use on other contracts - if needed.

The output is on a web browser, so can be viewed from anywhere and there are authorised users and different views depending on which group you are in.

My colleague raves about it, has used it in past contracts at very large world wide companies with on and offshore support etc and from my own experience of it, slightly brief, it looks fine. If there is anyhting missing, just write a script and add it in !

Hope this helps.

Cheers,
Norman.

Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.

Internal : 7 28 2051
External : 0113 231 2051

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.

We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

--
http://www.freelists.org/webpage/oracle-l