check_oracle_health監控oracle一、準備工作

1.在資料庫上建立使用者并賦予權限(DBA配合操作；使用者、密碼待定；隻是監控本機資料庫TNS、SID）

CREATE USER nagios IDENTIFIED BY XXXX; 

GRANT CREATE SESSIONTO nagios;

GRANT SELECT anydictionary TO nagios;

GRANT SELECT ONV_$SYSSTAT TO nagios;

GRANT SELECT ONV_$INSTANCE TO nagios;

GRANT SELECT ON V_$LOGTO nagios;

GRANT SELECT ONSYS.DBA_DATA_FILES TO nagios;

GRANT SELECT ONSYS.DBA_FREE_SPACE TO nagios;

GRANT SELECT ONsys.dba_tablespaces TO nagios;

GRANT SELECT ONdba_temp_files TO nagios;

GRANT SELECT ONsys.v_$Temp_extent_pool TO nagios;

GRANT SELECT ONsys.v_$TEMP_SPACE_HEADER  TO nagios;

GRANT SELECT ONsys.v_$session TO nagios;

  2.将nagios加入oinstall組

 usermod -a -G oinstall nagios

二、檢視被監控是否安裝了perl?并且被監控機安裝DBI和DBD

   1.[root@D-MDB-90 ~]# perl -v

This is perl, v5.10.1 (*) built forx86_64-linux-thread-multi

Copyright 1987-2009, Larry Wall

Perl may be copied only under theterms of either the Artistic License or the

GNU General Public License, which maybe found in the Perl 5 source kit.

Complete documentation for Perl,including FAQ lists, should be found on

this system using "manperl" or "perldoc perl". If you have access to the

Internet, point your browser athttp://www.perl.org/, the Perl Home Page.

  2.下載下傳DBI

  3.解壓DBI

     [root@D-MDB-90 src]#tar zxvf DBI-1.636.tar.gz

  4.安裝DBI

     [root@D-MDB-90 src]# cd DBI-1.636

     [root@D-MDB-90 DBI-1.636]# perlMakefile.PL

     [root@D-MDB-90 DBI-1.636]# make all

     [root@D-MDB-90 DBI-1.636]# make install

  5.下載下傳安裝DBD-Oracle

    [root@D-MDB-90 src]# tar zxvf DBD-Oracle-1.74.tar.gz

     [root@D-MDB-90 src]# cd DBD-Oracle-1.74

     [[email protected]]# perl Makefile.PL

  6.這裡會碰到安裝錯誤

    切換到oracle使用者：su - oracle

    檢視ORACLE_HOME路徑：echo $ORACLE_HOME

[root@D-MDB-90libexec]# echo $ORACLE_HOME /oracle/app/oracle/products/11.2.0.3/db   #記住這條oracle_home環境

7.重新切回root：ctrl+d或su - root設定環境變量[[email protected]]#export ORACLE_HOME=/oracle/app/oracle/products/11.2.0.3/db

  [[email protected]]#make && make install

三、下載下傳安裝check_oracle_health

     2.[root@D-MDB-90 src]# tar -zxvfcheck_oracle_health-2.1.3.5.tar.gz

     3.[root@D-MDB-90 src]#cd check_oracle_health-2.1.3.5

     4. ./configure --prefix=/usr/local/nagios--with-nagios-user=nagios --with-nagios-group=nagios--with-mymodules-dir=/usr/local/nagios/libexec --with-mymodules-dyndir=/usr/local/nagios/libexec

     5. [root@D-MDB-90 src]make all

     6.[root@D-MDB-90 src]make install

     7.chown nagios:nagios/usr/local/nagios/libexec/check_oracle_health

     8.chmod 775/usr/local/nagios/libexec/check_oracle_health

四、測試

   1.安裝完成後執行指令：/usr/local/nagios/libexec/check_oracle_health --connect=oracle_SID    --user=oracle使用者 --password=oracle使用者密碼 --mode=connected-users

   如果提示錯誤：如

<a href="http://s3.51cto.com/wyfs02/M00/8D/11/wKioL1iFbESCeFQcAABIgHYEqos850.png" target="_blank"></a>

 解決方法：

[root@D-MDB-90libexec]# ldd /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so （安裝缺少檔案路徑找）

發現沒有libclntsh.so.11.1

[root@D-MDB-90libexec]# locate  libclntsh.so.11.1

[root@D-MDB-90 libexec]# ln -s /oracle/app/oracle/products/11.2.0.3/db/lib/libclntsh.so.11.1（空格）/lib/libclntsh.so.11.1

[root@D-MDB-90 libexec]# vim /etc/ld.so.conf

添加

include ld.so.conf.d/*.conf

/oracle/app/oracle/products/11.2.0.3/db/lib  #這裡的路徑與libclntsh.so.11.1 的路徑有關

[root@D-MDB-90 libexec]# ldconfig

<a href="http://s1.51cto.com/wyfs02/M01/8D/14/wKiom1iFbTTw82oOAACs9Sm41q8862.png-wh_500x0-wm_3-wmp_4-s_1636605833.png" target="_blank"></a>

[root@D-MDB-90 libexec]# ldd/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so

<a href="http://s1.51cto.com/wyfs02/M01/8D/11/wKioL1iFbVPSLsknAAA5e3uBkzE450.png" target="_blank"></a>

2.[root@D-MDB-90 libexec]#/usr/local/nagios/libexec/check_oracle_health --connect=pomoho --user=nagios --password=oradbmon --mode=tnsping

結果輸出OK - connection established to pomoho.

3.修改/usr/local/nagios/etc/nrpe.cfg

  在allowed_hosts後加上本機與監控主機的IP

  最後加一行command[check_oracle_health]=/usr/local/nagios/libexec/check_oracle_health --connect=oracle_SID    --user=oracle使用者 --password=oracle使用者密碼 --mode=tnsping

4.重新開機nrpe

5./usr/local/nagios/libexec/check_nrpe -H你的被監控機IP位址 -c check_oracle_health

如果結果同樣為OK - connectionestablished to pomoho，則OK

五、修改監控主機的/usr/local/nagios/etc/objects/services.cfg

###################XX-XXX-XXcheck_oracle_health#####################################

define service{

       host_name               XX-XXX-XX

       service_description    check_oracle_health_tnsping

       check_command          check_nrpe!check_oracle_health

        max_check_attempts      5

       normal_check_interval   5

       retry_check_interval    2

       check_period            24x7

       notification_interval   10

       notification_period     24x7

       notification_options    w,u,c,r

       contact_groups          yunwei

}

 檢查配置是否正确 /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg

 重新加載nagios ： service nagios reload

      本文轉自YU文武貝 51CTO部落格，原文連結：http://blog.51cto.com/linuxerxy/1893831，如需轉載請自行聯系原作者