Page 1 of 1

check_oracle_health tablespace monitoring issues

Posted: Wed Sep 04, 2013 2:06 pm
by bojha
Hi All,

We are using check_oracle_health plugin from console lab and installed all the modules like instant client, DBI and DBD::Oracle module and able to monitor all the table space,
i am trying to monitor only a single tablespace from the nagios command prompt we are getting the output as desired like below
[nagios@nagiosvm01 libexec]$ ./check_oracle_health --connect xxxxxxxx --user nagios --password Nagios --mode tablespace-usage --name D2_LRG_DATA

WARNING - tbs D2_LRG_DATA usage is 94.00% | 'tbs_d2_lrg_data_usage_pct'=94.00%;90;98 'tbs_d2_lrg_data_usage'=1880MB;1800;1960;0;2000 'tbs_d2_lrg_data_alloc'=2000MB;;;0;2000

but when we are trying to set up the service in UI only getting the output like below with the same command the alert mail also showing the below output
WARNING - tbs D2_LRG_DATA usage is 94.00%

Could anyone please let us know how can we show the output including percentage , and data usages in MB like we are getting from command prompt ?


With Regards,

Bijay Ojha

Re: check_oracle_health tablespace monitoring issues

Posted: Wed Sep 04, 2013 2:14 pm
by slansing
The data you are seeing at the end there is performance data that will show up in your service graphs, it is not returned to your service details status. Just a heads up though, that plugin should have already been present in XI as it is used by one of our Wizards.

Re: check_oracle_health tablespace monitoring issues

Posted: Thu Sep 12, 2013 2:05 am
by bojha
Hi slansing,

Yes these plugin is present in Nagios exchange this is the url (http://exchange.nagios.org/directory/Pl ... th/details).
but i didn't configured it through the wizard, instead i configured through creating own service and command and all are running fine.
and my requirement is to see the percentage as well as how much MB used or free in the alert . is there any way we can do this please suggest me .



With Regards,

Bijay Ojha

Re: check_oracle_health tablespace monitoring issues

Posted: Thu Sep 12, 2013 9:56 am
by slansing
This is something that would probably need to be modified in the plugin itself, it is only returning the percentage to you and the other two values after the "|" are for performance data so those are out of reach. You could start by tracking down that specific --mode check string in the plugin and seeing if you can add an additional line or two to the status info which is returned to nagios.

Re: check_oracle_health tablespace monitoring issues

Posted: Wed Oct 09, 2013 6:58 am
by bojha
Hi slansing,

Thank you very much for the information and help, finally i am able to include the other information to the alert by modifying the plugin..


With Regards,

Bijay Ojha