Oracle services :(Return code of 25 is out of bounds)

[abodage]

Hi Team,

We are monitoring oracle parameters,

Oracle.PNG

and I getting "Return code of 25 is out of bounds" error for most parameter.

Please help.
Thanks

[rkennedy]

Can you attempt to run the check over the CLI, and let us know the full input/output? I'd like to see the actual error that is occurring. I've seen this happen in a past when too many queries are directed at one server.

[abodage]

Hi,
Below is the output on CLI

Code: Select all

]
[root@nagiosxi00 ~]# /bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect xxx.xxx.xxx.xxx:1521/JDAQA' --username 'abc123' --password 'anc123' --mode flash-recovery-area-usage --warning 90 --critical 98
Setuid/gid script is writable by world.

[tgriep]

It looks like the plugin is having issues with the superuser bit being enabled. Run the following to remove it and see if that resolves the issue.

Code: Select all

chmod ugo-s /usr/local/nagios/libexec/check_oracle_health
chmod ugo+x /usr/local/nagios/libexec/check_oracle_health

If it still fails, run the following command and post the output.

Code: Select all

ls -l /usr/local/nagios/libexec/check_oracle_health

[abodage]

Hi team,

Its working now after running below commands,

Code: Select all

chmod ugo-s /usr/local/nagios/libexec/check_oracle_health
chmod ugo+x /usr/local/nagios/libexec/check_oracle_health

Thanks.

[mcapra]

Is it ok if we lock this thread and mark the issue as resolved?

[abodage]

Thanx team,

It works for me.