通过check_nrpe 来检测check_oracle_table

/usr/local/nagios/libexec/check_nrpe -H 10.10.10.10 -c check_oracle_table

报错  NRPE: Unable to read output

在本地直接执行/usr/local/nagios/libexec/check_oracle_table.py 输出结果正常

根据网上博客http://blog.chinaunix.net/uid-25266990-id-3431778.html

提示 修改 /etc/sudoers

添加一行 

nagios ALL=(ALL)  NOPASSWD:/usr/local/nagios/libexec/check_oracle_table.py

注释Defaults    requiretty

然后在远端执行，依旧报错 NRPE: Unable to read output

根据上面博客提示 切换nagios 用户执行脚本

#usermod -s /bin/bash nagiosp

#su - nagios

-bash-4.1$ /usr/local/nagios/libexec/check_oracle_table.py 

File "/usr/local/nagios/libexec/check_oracle_table.py", line 5, in <module>

    import cx_Oracle,sys

ImportError: libclntsh.so.10.1: cannot open shared object file: No such file or directory

将 root 用户的 .bash_profile 复制到 nagios 用户

再次执行

Traceback (most recent call last):

  File "/usr/local/nagios/libexec/check_oracle_table.py", line 55, in <module>

    conn = cx_Oracle.connect('test','test',dsn)

cx_Oracle.InterfaceError: Unable to acquire Oracle environment handle

检测发现没有给 .bash_profile 中ORACLE_HOME=/opt/oracle/product/10.2/db_1 赋权限，

我将 整个目录 赋权 755 

再次执行，成功！

切换到远端

/usr/local/nagios/libexec/check_nrpe -H 10.10.10.10 -c check_oracle_table

显示正常。