Page 1 of 1
using check_oracle_health : How to get query result history
Posted: Thu Sep 17, 2020 4:26 am
by Frédéric GRANAT
Hi,
I created a service like that :
source /usr/local/nagiosxi/etc/configwizards/oracle/oracle && $USER1$/check_oracle_health $ARG1$
$ARG1$ =
--connect 'xxxxxxxx:1523/Xxxxxxxx' --username 'xxxxxxx' --password 'xxxxxxx' --mode sql --name="select bytes/1024/1024 size_mo from dba_data_files where tablespace_name = 'CIVIROLB'" --warning 1000 --critical 2000
that service help me to monitor the tablespace growth in oracle
My service reached the critical limit and I would like to get my query result history (size_mo), particularly when there were big steps of growing.
How can I get that in NagiosXI ?
Frederic
Re: using check_oracle_health : How to get query result hist
Posted: Thu Sep 17, 2020 5:13 pm
by ssax
If the state never changed you would only see the data as plot points in the graphs (which is averaged).
If the state actually changed you would see the data in the Event Log and State History reports.
You can enable State Stalking on the host/service to log extra, see here:
https://assets.nagios.com/downloads/nag ... lking.html
That's about it other than querying the RRD through the API endpoint.
Re: using check_oracle_health : How to get query result hist
Posted: Fri Sep 18, 2020 1:27 am
by Frédéric GRANAT
Hi,
Event Log and State don't meet my expectations (query value on a range of time).
Please see the attachment.
How can I do to get all the values ?
Re: using check_oracle_health : How to get query result hist
Posted: Fri Sep 18, 2020 5:23 pm
by cdienger
State stalking is the option you would want but it would need to have been enabled prior to the events.
Re: using check_oracle_health : How to get query result hist
Posted: Mon Sep 28, 2020 2:23 am
by Frédéric GRANAT
Hi,
Thanks,
'State stalking is the option you would want but it would need to have been enabled prior to the events.'
How can I activate it ?
Re: using check_oracle_health : How to get query result hist
Posted: Mon Sep 28, 2020 5:29 pm
by benjaminsmith
Hi,
You can enable the stalking options for the host or service in the CCM under the alert settings tab.
stalking.png
Let us know if you have any other questions.
Re: using check_oracle_health : How to get query result hist
Posted: Tue Sep 29, 2020 1:13 am
by Frédéric GRANAT
Thanks,
And the next time I will have an alert, where do I have to go in NagiosXI to see the query values ?
Re: using check_oracle_health : How to get query result hist
Posted: Tue Sep 29, 2020 4:12 pm
by benjaminsmith
Hi,
As Sean mentioned, you can check the Event Log or the State History Reports or if you want to look directly at the nagios.log, go to:
Let us know if you have any other questions.
Regards,
Benjamin
Re: using check_oracle_health : How to get query result hist
Posted: Thu Oct 01, 2020 9:46 am
by Frédéric GRANAT
Hi,
Thanks you can close the post.
Frederic
Re: using check_oracle_health : How to get query result hist
Posted: Thu Oct 01, 2020 10:59 am
by scottwilkerson
Frédéric GRANAT wrote:Hi,
Thanks you can close the post.
Frederic
Great!
Locking thread