Re: Monitoring Oracle with Nagios?

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>:

> 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> 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 <+436602978929>
martin.a.berger_at_gmail.com _at_martinberx <https://twitter.com/martinberx>
^∆x      http://berxblog.blogspot.com

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