I agree in the criticism on existing plugins
(at least they never did what we needed years ago when nagios was
introduced).
so we defined a VIEW which is a select on a pipelined FUNCTION.
this function calls several other functions, based on config tables/values.
by this construct we (DBAs) can monitor whatever we want (and can write in
SQL & PL/SQL)
and Nagios can collect & report the numbers, values, text, ... we create.
it's not perfect, but better than anything we found available.
2017-10-28 8:32 GMT+02:00 Patrick Jolliffe <jolliffe@xxxxxxxxx>:
Mark,
Yes we are using Nagios extensively for database monitoring.
We have perl wrapper that executes on Nagios host, connects to database
and calls pl/sql functions to do the actual check (return 0 for success, 1
for warning etc)
For sure, it is not as feature rich as other solutions, but much much
simpler.
There are some plugins available, but they never do exactly what you want,
so end up having to make modifications, or code new ones.
Patrick
On 28 October 2017 at 05:40, Mark J. Bobak <mark@xxxxxxxxx> wrote:
Hi guys,
Is anyone monitoring their Oracle instances w/ Nagios?
We have Nogios installed, and for system-level monitoring (host up/down,
file system space, etc) it does a reasonably good job.
But, I've had no luck finding plugins for Oracle monitoring that are
worth anything. (tablespace, ASM DG space, etc) Does anyone out there
monitor Oracle w/ Nagios? What plugin(s) do you use? I've found a few,
but have not had any luck getting them to work.
Help? Suggestions?
I'm also looking at OEM and Cloudwatch (we're all on AWS here), but there
seems to be some resistance to OEM, and CloudWatch looks like a bit of an
intimidating learning curve....
Thanks,
-Mark
