[ale] OT: Oracle Monitoring Tools

[Ryan Fish]

I'd like to be alerted if the db becomes unavailable, runs short on table
space and all of the other "normal" things (btw, I'm no DBA by any means).
There are currently scripts in place to look for errors in the logs, etc.
but I need to get more in depth than that as cheaply as possible.

 

I do already have Nagios running on the environment to monitor standard
things (disk space, load avgs, processes, etc.) and would be interested in
finding a way to use it in the monitoring effort.  However, I'm also not a
script writer (although I should be) so I'd be looking for a set of plug-ins
to use if they exist.

 

Thank you.

-Ryan

 

  _____  

From: ale-bounces at ale.org [mailto:ale-bounces at ale.org] On Behalf Of Jeff
To: ale at ale.org
Lightner
Sent: Wednesday, August 09, 2006 2:05 PM
To: Atlanta Linux Enthusiasts
Subject: Re: [ale] OT: Oracle Monitoring Tools

 

Of course some people doing monitoring are not DBAs self respecting or
otherwise.  In many organizations the monitors are required by management
and managed by System Admins.

 

Here we do Nagios monitoring from a Management standpoint but it's fairly
minimal.  Just check whether tnsping to the instance works from another
server, whether the LSRN and PMON are up and whether concurrent manager is
running.   The DBAs here (presumably self respecting - I've never asked) of
course have additional monitoring they've configured.

 

So the question becomes how deeply are you trying to "monitor" the DB?

 

In other environments I've used Patrol which has prebuilt probes for Oracle
and other products.   However it is not cheap either.

 

  _____  

From: ale-bounces at ale.org [mailto:ale-bounces at ale.org] On Behalf Of Sid Lane
To: ale at ale.org
Sent: Wednesday, August 09, 2006 11:03 AM
To: Atlanta Linux Enthusiasts
Subject: Re: [ale] OT: Oracle Monitoring Tools

 

"license for the monitoring package of EM is a bit steep"

it's also a steaming piece of poo - no self respecting DBA uses it.  there
is NO substitute for knowing your data dictionary, v$ views, etc. 

I've written my own stuff with PERL (/DBI), etc.

if you want something "canned" I'm pretty sure Big Brother has some Oracle
plugins but I don't know how robust they are though it's pretty easy to
write your own modules and hook them in. 

On 8/8/06, Ryan Fish <FishR at bellsouth.net> wrote:

Do any of you know of any cheap/free monitoring tools for Oracle?  The
license for the monitoring package of EM is a bit steep so I'm looking for
alternatives if they exist.

 

Thank you.

-Ryan

 

I tried sending this same message earlier but it never hit the list for some
reason.


_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale

 

-------------- next part --------------
An HTML attachment was scrubbed...