九、监控oracle数据库1、在监控机10.100.10.11上添加一个check_nrpe的命令# vi /usr/local/nagios/etc/objects/commands.cfgdefine command { command_name check_nrpe command_line $USER1$/check_nrpe -H $HOSTADDRESS$ -c $ARG1$}2、在监控机10.11上创建一个监控oracle服务的文件oracle.cfg。# cd /usr/local/nagios/etc/objects# vi oracle6.cfgdefine host {use linux-serverhost_name ledbbackup01alias Oracle 10gaddress 10.100.10.6}define service {use generic-servicehost_nameledbbackup01service_description TNS Checkcheck_command check_nrpe!check_oracle_tns}define service {use generic-servicehost_name ledbbackup01service_description DB Checkcheck_command check_nrpe!check_oracle_db}define service {use generic-servicehost_name ledbbackup01service_description Login Checkcheck_command check_nrpe!check_oracle_login}define service {use generic-servicehost_nameledbbackup01service_description Cache Checkcheck_command check_nrpe!check_oracle_cache}define service {use generic-servicehost_name ledbbackup01service_description Tablespace Checkcheck_command check_nrpe!check_oracle_tablespace}3、在nagios的配置文件里添加上这个监控的文件# cd /usr/loca/nagios/etc# vi nagios.cfgcfg_file=/usr/local/nagios/etc/objects/oracle6.cfg4、在oracle服务器上安装nrpe，具体步骤如上，不再详述。添加几条监控的命令：# vi /usr/local/nagios/etc/nrpe.cfgcommand[check_oracle_tns]=/usr/local/nagios/libexec/check_oracle --tns legold01command[check_oracle_db]=/usr/local/nagios/libexec/check_oracle --db legold01command[check_oracle_login]=/usr/local/nagios/libexec/check_oracle --login legold01command[check_oracle_cache]=/usr/local/nagios/libexec/check_oracle --cache legold01 nagios 123.com 80 90command[check_oracle_tablespace]=/usr/local/nagios/libexec/check_oracle --tablespace legold01 nagios 123.com USERS 90 80具体的命令格式可参考check_oracle的help文档。5、在oracle服务器上将check_oracle插件修改一下：将 $ORACLE_HOME 以及 $PATH 手动加入，避免出现问题。export ORACLE_HOME=/home/oracle/app/product/11.2.0/db_1export PATH=$PATH:$ORACLE_HOME/bin 此时，可以启动nrpe服务了：# service nrped start对了，别忘记了在10.11监控机上将nagios服务重启一下：# service nagios restart6此时，打开浏览器查看：http://10.100.10.11/nagios

好像出错了，仔细察看了一下nagios的错误日志，发现监控机10.11上没有check_nrpe 的插件，所以还要进行如下步骤：7、copy oracle服务器10.6上的check_nrpe 到10.11上# scp check_nrpe root@10.100.10.11:/usr/local/nagios/libexec在10.11上：# cd /usr/local/nagios/libexec# ./check_nrpe./check_nrpe: error while loading shared libraries: libssl.so.6: cannot open shared object file: No such file or directory没有libssl.so.6的库文件，解决方法：在10.6上：# find / -name libssl.so.6/lib64/libssl.so.6/lib/libssl.so.6# scp /lib64/libssl.so.6 root@10.100.0.8:/lib64# scp /lib/libssl.so.6 root@10.100.0.8:/lib8、在10.11上：# cd /usr/local/nagios/libexec# ./check_nrpe./check_nrpe: error while loading shared libraries: libcrypto.so.6: cannot open shared object file: No such file or directory还是缺少库文件，不用怕，继续到10.6上拷贝，这叫越挫越勇！在10.6上：# find / -name libcrypto.so.6/lib64/libcrypto.so.6/lib/libcrypto.so.6# scp /lib/libcrypto.so.6 root@10.100.0.8:/lib# scp /lib64/libcrypto.so.6 root@10.100.0.8:/lib649、好吧，再回到10.11上尝试一下：#./check_nrpeIncorrect command line arguments suppliedNRPE Plugin for NagiosCopyright (c) 1999-2008 Ethan Galstad (nagios@nagios.org)Version: 2.13Last Modified: 11-11-2011License: GPL v2 with exemptions (-l for more info)SSL/TLS Available: Anonymous DH Mode, OpenSSL 0.9.6 or higher requiredUsage: check_nrpe -H <host> [-n] [-u] [-p <port>] [-t <timeout>] [-c <command>] [-a <arglist...>]Options:-n= Do no use SSL-u = Make socket timeouts return an UNKNOWN state instead of CRITICAL<host> = The address of the host running the NRPE daemon[port] = The port on which the daemon is running (default=5666)[timeout]= Number of seconds before connection times out (default=10)[command]= The name of the command that the remote daemon should run[arglist]= Optional arguments that should be passed to the command.Multiple arguments should be separated by a space.If provided, this must be the last option supplied on the command line.此时就说明check_nrpe可以用了！真的好难得哦！# ./check_nrpe -H 10.100.10.6 -p 5666NRPE v2.1310、重新启动nagios服务：# service nagios restart输入ip地址查看一下：http://10.100.10.11/nagios

好了，就先记录到这里吧，作为以后的参考文档。

岁月静好，岁月静好。

(*^__^*) 嘻嘻……