Change threshold for Invalid object in check_oracle_health

[gembalig]

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

[Jos3D]

Hi how did you solve this problem?

[eadarsh400]

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

[tmcdonald]

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!