Re: Daily Heath report script
- From: "Norman Dunbar" <norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <dba.orcl@xxxxxxxxx>
- Date: Thu, 03 Nov 2005 10:27:28 +0000
Morning Sami,
<QUOTE>
>>> Sami Seerangan <dba.orcl@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
