check_oracle_health

[rkennedy]

Can you please follow the document I posted above and install the 11.2 client? https://assets.nagios.com/downloads/nag ... ios-XI.pdf

[fmargari]

Hi,
I followed the instructions in the PDF,, the instalation was completed successfully but they have the same error.
Thanks amd Regards

[fmargari]

more information.
If I run command by root user , ran completed ok., but if I run by nagios user, I get this message error.
Thanks

[rkennedy]

Can you show the full input / output when you run it as root, and when you run it as nagios? I'd like to compare the differences. It may be the environmental variables linked to your user that is the issue.

[fmargari]

Run by root user
--------------------
[root@arlxpd60 ~]# /usr/bin/env LD_LIBRARY=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect bowsrv.nextel.com.ar:1562/BOW --mode tnsping
Use of qw(...) as parentheses is deprecated at /usr/local/nagios/libexec/check_oracle_health line 4162.
Use of qw(...) as parentheses is deprecated at /usr/local/nagios/libexec/check_oracle_health line 6166.
OK - connection established to bowsrv.nextel.com.ar:1562/BOW.

Ran by nagios user
----------------------
[root@arlxpd60 ~]# su - nagios
Last login: Fri Mar 4 10:12:38 ART 2016 on pts/0
[nagios@arlxpd60 ~]$
[nagios@arlxpd60 ~]$
[nagios@arlxpd60 ~]$ #10:13_04-03-16^C
[nagios@arlxpd60 ~]$ /usr/bin/env LD_LIBRARY=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect bowsrv.nextel.com.ar:1562/BOW --mode tnsping
Use of qw(...) as parentheses is deprecated at /usr/local/nagios/libexec/check_oracle_health line 4162.
Use of qw(...) as parentheses is deprecated at /usr/local/nagios/libexec/check_oracle_health line 6166.
CRITICAL - cannot connect to bowsrv.nextel.com.ar:1562/BOW. DBI object version 1.627 does not match bootstrap parameter 1.634 at /usr/lib64/perl5/DynaLoader.pm line 213.
BEGIN failed--compilation aborted at /usr/local/lib64/perl5/DBI.pm line 286.
Compilation failed in require at /usr/local/nagios/libexec/check_oracle_health line 4736.

[nagios@arlxpd60 ~]$

Thanks
Regards

[tgriep]

The error you are receiving is caused by permission issues for the perl modules that the plugin needs to run. Plus it works as root.
Login to the XI server as root and run the following.

Code: Select all

chmod -R o+rx /usr/local/lib64/perl5/*
chmod -R o+rx /usr/llib64/perl5/*

Then run the check as the nagios user to see if it works for you.