Nagios Support Forum

Hi Guys,

Can someone help me in changing threshold of Invalid object in check_oracle_health.
I was not able to find the logic where its looking for threshold in check_oracle_health perl script.

Thanks in advance.

-Ganesh

Hi how did you solve this problem?

Hi Ganesh,

You can define your own thresholds in the latest version (I am not aware whether it is not possible in previous versions but I am using the latest version from nagios exchange)

Service definition:

define service{
use local-service
host_name server
service_description Invalid Objects
check_command check_oracle_health!invalid-objects!20!10
}

Command definition:

define command{
command_name check_oracle_health
command_line /usr/lib/nagios/plugins/check_oracle_health -t 360 --environment ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/X.X.X/client/ --connect testdb --username nagios --password nagiosadmin --mode $ARG1$ --warning $ARG2$ --critical $ARG3$
}

X.X.X refers client version
ORACLE_HOME directory/variable may change depends on your environment (mentioned path is the default/usual on all kind of systems)

Hope it helps

Thanks,
Addy

Thanks for the post, eadarsh400!

I don't believe the OP is coming back, looking at the original post date. @Jos3D, let us know how the posted solution works out for you!