Re: Monitoring Oracle with Nagios?

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_at_gmail.com
> <mailto:jolliffe_at_gmail.com>>:
>
> 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_at_bobak.net
> <mailto:mark_at_bobak.net>> 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_at_gmail.com <mailto:martin.a.berger_at_gmail.com>
> _at_martinberx <https://twitter.com/martinberx>
> ^∆xhttp://berxblog.blogspot.com

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


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