Nagios监控Oralce
一、本文说明：
本文是监控本地的Oracle，其实监控远端的Oracle也是跟下面的步骤差不多的。
二、安装Nagios、Nagios插件、NRPE软件：
安装步骤可以参考《Linux下Nagios的安装与配置》
注意点：
1、由于nagios脚本需要读取oracle相关文件。所在运行nagios的用户需要定义为Oracle服务用户。并且修改/etc/xinted.d/nrpe中配置。
[oracle@rhel5 libexec]$ cat /etc/xinetd.d/nrpe # default: on # description: NRPE (Nagios Remote Plugin Executor) service nrpe { flags = REUSE socket_type = stream port = 5666 wait = no user = oracle group = oinstall server = /usr/local/nagios/bin/nrpe server_args = -c /usr/local/nagios/etc/nrpe.cfg --inetd log_on_failure += USERID disable = no only_from = 127.0.0.1 192.168.11.149 }
2、修改check_oracle脚本，将$ORACLE_HOME以及$PATH手动加入。
[oracle@rhel5 libexec]$ cat /usr/local/nagios/libexec/check_oracle #! /bin/sh # # latigid010@yahoo.com # 01/06/2000 # # This Nagios plugin was created to check Oracle status # ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 PATH=$PATH:/u01/app/oracle/product/11.2.0/db_1/bin
三、配置nrpe服务：
修改/usr/local/nagios/etc/nrpe.cfg文件。加入以下内容：
[oracle@rhel5 libexec]$ cat /usr/local/nagios/etc/nrpe.cfg #Check Oracle command[check_oracle_tns]=/usr/local/nagios/libexec/check_oracle --tns orcl jack jack command[check_oracle_db]=/usr/local/nagios/libexec/check_oracle --db orcl command[check_oracle_login]=/usr/local/nagios/libexec/check_oracle --login orcl jack jack command[check_oracle_cache]=/usr/local/nagios/libexec/check_oracle --cache orcl system oracle 80 90 command[check_oracle_tablespace]=/usr/local/nagios/libexec/check_oracle --tablespace orcl jack jack jack 90 80
具体参数写法参考 check_oracle -help
[oracle@rhel5 libexec]$ ./check_oracle -help Usage: check_oracle --tns <Oracle Sid or Hostname/IP address> check_oracle --db <ORACLE_SID> check_oracle --login <ORACLE_SID> check_oracle --cache <ORACLE_SID> <USER> <PASS> <CRITICAL> <WARNING> check_oracle --tablespace <ORACLE_SID> <USER> <PASS> <TABLESPACE> <CRITICAL> <WARNING> check_oracle --oranames <Hostname> check_oracle --help check_oracle --version
添加nrpe端口号
[oracle@rhel5 libexec]$ tail -4 /etc/services iqobject 48619/tcp # iqobject iqobject 48619/udp # iqobject # Local services nrpe 5666/tcp #nrpe
配置完成后，重启xinetd服务
[oracle@rhel5 libexec]$ service xinetd restart
四、配置Nagios：
1、在nagios服务器端添加nrpe命令配置。修改/usr/local/nagios/etc/objects/command.cfg文件：
[oracle@rhel5 etc]$ tail -10 objects/commands.cfg define command{ command_name process-service-perfdata command_line /usr/bin/printf "%b" "$LASTSERVICECHECK$\t$HOSTNAME$\t$SERVICEDESC$\t$SERVICESTATE$\t$SERVICEATTEMPT$\t$SERVICESTATETYPE$\t$SERVICEEXECUTIONTIME$\t$SERVICELATENCY$\t$SERVICEOUTPUT$\t$SERVICEPERFDATA$\n" >> /usr/local/nagios/var/service-perfdata.out } #'check_nrpe' command definition define command{ command_name check_nrpe command_line $USER1$/check_nrpe -H $HOSTADDRESS$ -c $ARG1$ }
2、添加hosts.cfg和services.cfg
[oracle@rhel5 etc]$ cat hosts.cfg define host{ use linux-server2 host_name oracle alias Nagios-node2 address 192.168.11.149 } define hostgroup{ hostgroup_name bsmart-servers alias bsmart servers members oracle }
[oracle@rhel5 etc]$ cat services.cfg define service { use generic-service host_name oracle service_description TNS Check check_command check_nrpe!check_oracle_tns } define service { use generic-service host_name oracle service_description DB Check check_command check_nrpe!check_oracle_db } define service { use generic-service host_name oracle service_description Login Check check_command check_nrpe!check_oracle_login } define service { use generic-service host_name oracle service_description Cache Check check_command check_nrpe!check_oracle_cache notifications_enabled 0 } define service { use generic-service host_name oracle service_description Tablespace Check check_command check_nrpe!check_oracle_tablespace }
3、在templates.cfg中添加如下内容：
define host{ name linux-server2 ; The name of this host template use generic-host ; This template inherits other values from the generic-host template check_period 24x7 ; By default, Linux hosts are checked round the clock check_interval 5 ; Actively check the host every 5 minutes retry_interval 1 ; Schedule host check retries at 1 minute intervals max_check_attempts 10 ; Check each Linux host 10 times (max) check_command check-host-alive ; Default command to check Linux hosts notification_period workhours ; Linux admins hate to be woken up, so we only notify during the day ; Note that the notification_period variable is being overridden from ; the value that is inherited from the generic-host template! notification_interval 120 ; Resend notifications every 2 hours notification_options d,u,r ; Only send notifications for specific host states contact_groups admins ; Notifications get sent to the admins by default register 0 ; DONT REGISTER THIS DEFINITION - ITS NOT A REAL HOST, JUST A TEMPLATE! }
五、重点说明：
由于nagios的用户是oracle，所以在nagios启动的命令应该使用：
[oracle@rhel5 etc]$ /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
关闭命令使用：
[oracle@rhel5 etc]$ killall nagios
[oracle@rhel5 etc]$ ll 总计 148 -rw-rw-r-- 1 oracle oinstall 11437 09-27 19:26 cgi.cfg -rw-r--r-- 1 oracle oinstall 11408 09-27 19:20 cgi.cfg.bak -rw-r--r-- 1 oracle oinstall 382 09-27 19:59 hosts.cfg -rw-r--r-- 1 oracle oinstall 44 09-27 17:17 htpasswd -rw-r--r-- 1 oracle oinstall 44 09-27 19:20 htpasswd.bak -rw-rw-r-- 1 oracle oinstall 43863 09-27 20:18 nagios.cfg -rw-r--r-- 1 oracle oinstall 43774 09-27 19:20 nagios.cfg.bak -rw-r--r-- 1 oracle oinstall 7834 09-27 21:12 nrpe.cfg drwxrwxr-x 2 oracle oinstall 4096 09-27 21:35 objects -rw-rw---- 1 oracle oinstall 1340 09-27 16:42 resource.cfg -rw-r----- 1 oracle oinstall 1340 09-27 19:20 resource.cfg.bak -rw-r--r-- 1 oracle oinstall 805 09-27 21:16 services.cfg [oracle@rhel5 etc]$ ll objects/ 总计 100 -rw-rw-r-- 1 oracle oinstall 7891 09-27 19:44 commands.cfg -rw-r--r-- 1 oracle oinstall 7716 09-27 19:19 commands.cfg.bak -rw-rw-r-- 1 oracle oinstall 2153 09-27 19:24 contacts.cfg -rw-r--r-- 1 oracle oinstall 2166 09-27 19:19 contacts.cfg.bak -rw-rw-r-- 1 oracle oinstall 5386 09-27 19:22 localhost.cfg -rw-r--r-- 1 oracle oinstall 5403 09-27 19:19 localhost.cfg.bak -rw-rw-r-- 1 oracle oinstall 3124 09-27 16:42 printer.cfg -rw-r--r-- 1 oracle oinstall 3124 09-27 19:19 printer.cfg.bak -rw-rw-r-- 1 oracle oinstall 3293 09-27 16:42 switch.cfg -rw-r--r-- 1 oracle oinstall 3293 09-27 19:19 switch.cfg.bak -rw-rw-r-- 1 oracle oinstall 12360 09-27 20:00 templates.cfg -rw-r--r-- 1 oracle oinstall 10812 09-27 19:19 templates.cfg.bak -rw-rw-r-- 1 oracle oinstall 3208 09-27 16:42 timeperiods.cfg -rw-r--r-- 1 oracle oinstall 3208 09-27 19:20 timeperiods.cfg.bak -rw-rw-r-- 1 oracle oinstall 4019 09-27 16:42 windows.cfg -rw-r--r-- 1 oracle oinstall 4019 09-27 19:20 windows.cfg.bak
七、nagios网页截图：
