I used Nagios only to look for certain critical events, like the running
out of space, ORA-00600, ORA-07445 or ORA-01555. For the performance
analysis, I wrote my own tool, based on PHP. It's still available on
mgogala.freehostia.com, but not maintained in the last 5 years. One
thing that I know to no longer be functional is trace file analysis,
since TRCA is deprecated in Oracle 12c. I will put SAP Hana version of
the SCOTT/TIGER account this weekend. At the moment, I am on the O'Hare
airport, waiting for my flight. Writing a monitoring tool is not as
complex as it looks. I would need to completely rewrite it using PHP 7,
but I am fairly busy and don't have time. Maybe, when I retire...
Regards
On 10/28/2017 01:27 PM, Martin Berger wrote:.
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 <mailto: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
<mailto: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
--
Martin Berger +43 660 2978929 <tel:+436602978929>
martin.a.berger@xxxxxxxxx <mailto:martin.a.berger@xxxxxxxxx> @martinberx <https://twitter.com/martinberx>
^∆xhttp://berxblog.blogspot.com
