Nagios Support Forum

Hi,

Don't know if this is the right place to ask but I have a problem with NRPE when checking remote hosts ORACLE tablespace.
I have downloaded check_oracle_v3 from nagiosexchange. When running command: It return proper output: But when running command via check_nrpe: (check spaces command is defined in nrpe.cfg as: command[check_spaces]=/usr/local/nagios/libexec/check_oracle_v3 --tablespace PRD ***** ************* PSAPSR3 99 98)
Output is: As you see - it is as if check_nrpe does not see the returned values or does not give proper parameters as valuest to check_oracle_v3 in the first place...

I would be wery glad if You could give me some advice how to proceed with this issue...

Br,
[D_A]

That might actually be some sort of bug in the plugin itself. If the issue was with NRPE you wouldn't be getting any data. For some reason the check plugin is returning empty strings instead of the value. Are the results any different when you use the server's IP address instead of localhost?

Well...

Qot this issue resolved when tried to get another plugin to work...
(Using SuSe, Oracle 10.2)
Principle what I did was:
To add:
export ORACLE_SID=SID
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/SID/102_64
export LD_LIBRARY_PATH=/usr/sap/SID/SYS/exe/run:/oracle/SID/102_64/lib
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin

to profiles of:
nagiosuser
nrpe daemon

And to add nagiosuser to dba group.

And also:
chmod -R a+rX $ORACLE_HOME/bin
chmod -R a+rX $ORACLE_HOME/lib32
was needed.

Tried this from step one - did not help - when aplied all steps - success - plugin and other oracle plugins started to work normally again.
Hope that this will help somebody else in the future....