nagios監控插件 nagios_oracle_health+check_linux_stats.pl怎么用

發布時間：2021-11-23 09:59:51 來源：億速云閱讀：141 作者：小新欄目：移動開發

這篇文章給大家分享的是有關nagios監控插件 nagios_oracle_health+check_linux_stats.pl怎么用的內容。小編覺得挺實用的，因此分享給大家做個參考，一起跟隨小編過來看看吧。

一.安裝nagios_oracle_health插件

項目地址：https://labs.consol.de/nagios/check_mysql_health/

1.查看perl包有沒有安裝。

[root@DB02 ~]# rpm -qa|grep perl
perl-Test-Simple-0.92-136.el6.x86_64
perl-ExtUtils-MakeMaker-6.55-136.el6.x86_64
perl-version-0.77-136.el6.x86_64
perl-ExtUtils-ParseXS-2.2003.0-136.el6.x86_64
perl-libs-5.10.1-136.el6.x86_64
perl-5.10.1-136.el6.x86_64
perl-CGI-3.51-136.el6.x86_64
perl-devel-5.10.1-136.el6.x86_64
perl-Pod-Escapes-1.04-136.el6.x86_64
perl-Pod-Simple-3.13-136.el6.x86_64
perl-Test-Harness-3.17-136.el6.x86_64
perl-Module-Pluggable-3.90-136.el6.x86_64

[root@DB02 ~]# perl -v

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

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl". If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

從執行上面的兩個命令好，可以看到perl包安裝正常

2.安裝DBI

tar -zxvf DBI-1.636.tar.gz

cd DBI-1.636

perl Makefile.PL

make all

make install

3.安裝DBD-Oracle

tar -zxvf DBD-Oracle-1.74.tar.gz

cd DBD-Oracle-1.74

perl Makefile.PL

執行命令報錯如下：

[root@DB01 DBD-Oracle-1.74]# perl Makefile.PL

Multiple copies of Driver.xst found in: /usr/local/lib64/perl5/auto/DBI/ /usr/lib64/perl5/auto/DBI/ at Makefile.PL line 39

Using DBI 1.636 (for perl 5.010001 on x86_64-linux-thread-multi) installed in /usr/local/lib64/perl5/auto/DBI/

Configuring DBD::Oracle for perl 5.010001 on linux (x86_64-linux-thread-multi)

Remember to actually *READ* the README file! Especially if you have any problems.

Trying to find an ORACLE_HOME

Your LD_LIBRARY_PATH env var is set to ''

The ORACLE_HOME environment variable is not set and I couldn't guess it.

It must be set to hold the path to an Oracle installation directory

on this machine (or a machine with a compatible architecture).

See the appropriate README file for your OS for more information.

ABORTED!

解決方法：在root的bash_profile里面添加下面的代碼#這里是現網的數據庫的環境變量的配置

ORACLE_BASE=/u01/oracle/app

ORACLE_HOME=$ORACLE_BASE/product/11g/dbhome_1

ORACLE_SID=kdzfw

LD_LIBRARY_PATH=$ORACLE_HOME/lib

PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin:$ORACLE_HOME/OPatch

export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH

source .bash_profile

重新執行命令perl Makefile.PL

make all

make install

登錄數據庫，建個nagios帳號，并授予一些權限。

create user nagios identified by oradbmon;grant create session to nagios;grant select any dictionary to nagios;grant select on V_$SYSSTAT to nagios;grant select on V_$INSTANCE to nagios;grant select on V_$LOG to nagios;grant select on SYS.DBA_DATA_FILES to nagios;grant select on SYS.DBA_FREE_SPACE to nagios;

4.安裝check_oracle_health

tar -zxvf check_oracle_health-2.1.3.5.tar.gz

cd check_oracle_health-2.1.3.5

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

make all

make install

5.使用oracle用戶運行測試腳本：如下的輸出說明插件工作正常。

./check_oracle_health --connect=orcl --username=nagios --password= oradbmon --mode=tnsping

OK - connection established to orcl.

6.把oracle下面的環境變量復制到root下的bash_profile里面，并執行source bash_profile使配置立即生效。

7.在被監控機上定義一個服務，監控表空間，在客戶機的nrpe.cfg里配置監控命令。

command[check_tablespace]=/usr/local/nagios/libexec/check_oracle_health --connect kdzfw --username nagios --password oradbmon --warning 95 --critical 98 --mode tablespace-usage

注意：把nrpe.cfg配置文件里的dont_blame_nrpe=1，允許命令后可以帶一些參數。

使用腳本在本地測試使用腳本監控表空間，顯示正常，如下所示：

[oracle@DB01 libexec]$ /usr/local/nagios/libexec/check_oracle_health --connect kdzfw --username nagios --password oradbmon --warning 95 --critical 98 --mode tablespace-usage
OK - tbs VIPC usage is 0.00%, tbs USERS usage is 0.90%, tbs UNDOTBS1 usage is 0.05%, tbs TEMP usage is 0.01%, tbs SYSTEM usage is 2.65%, tbs SYSAUX usage is 2.65%, tbs SPTESTREADER usage is 0.00%, tbs SPTESTIM usage is 0.36%, tbs MAINTAIN usage is 0.05%, tbs INDX usage is 29.67%, tbs BTEST usage is 51.32% | 'tbs_vipc_usage_pct'=0.00%;95;98 'tbs_vipc_usage'=1MB;31129;32112;0;32767 'tbs_vipc_alloc'=1024MB;;;0;32767 'tbs_users_usage_pct'=0.90%;95;98 'tbs_users_usage'=294MB;31129;32112;0;32767 'tbs_users_alloc'=310MB;;;0;32767 'tbs_undotbs1_usage_pct'=0.05%;95;98 'tbs_undotbs1_usage'=16MB;31129;32112;0;32767 'tbs_undotbs1_alloc'=825MB;;;0;32767 'tbs_temp_usage_pct'=0.01%;95;98 'tbs_temp_usage'=2MB;31129;32112;0;32767 'tbs_temp_alloc'=1203MB;;;0;32767 'tbs_system_usage_pct'=2.65%;95;98 'tbs_system_usage'=869MB;31129;32112;0;32767 'tbs_system_alloc'=930MB;;;0;32767 'tbs_sysaux_usage_pct'=2.65%;95;98 'tbs_sysaux_usage'=867MB;31129;32112;0;32767 'tbs_sysaux_alloc'=920MB;;;0;32767 'tbs_sptestreader_usage_pct'=0.00%;95;98 'tbs_sptestreader_usage'=1MB;31129;32112;0;32767 'tbs_sptestreader_alloc'=1024MB;;;0;32767 'tbs_sptestim_usage_pct'=0.36%;95;98 'tbs_sptestim_usage'=119MB;31129;32112;0;32767 'tbs_sptestim_alloc'=1024MB;;;0;32767 'tbs_maintain_usage_pct'=0.05%;95;98 'tbs_maintain_usage'=1MB;1945;2007;0;2048 'tbs_maintain_alloc'=1024MB;;;0;2048 'tbs_indx_usage_pct'=29.67%;95;98 'tbs_indx_usage'=9721MB;31129;32112;0;32767 'tbs_indx_alloc'=11024MB;;;0;32767 'tbs_btest_usage_pct'=51.32%;95;98 'tbs_btest_usage'=50451MB;93388;96337;0;98303 'tbs_btest_alloc'=71680MB;;;0;98303

8.服務端使用的是nagiosql管理工具，在里面配置相應的服務。

nagios監控插件 nagios_oracle_health+check_linux_stats.pl怎么用

9.nagios展示的效果：

nagios監控插件 nagios_oracle_health+check_linux_stats.pl怎么用

二.安裝check_linux_stats.pl腳本

1.先安裝perl-UNIVERSAL-require-0.13-1.el6.rf.noarch.rpm，這里是rpm包。

[root@DB02 huaxia]# rpm -ivh perl-UNIVERSAL-require-0.13-1.el6.rf.noarch.rpm
warning: perl-UNIVERSAL-require-0.13-1.el6.rf.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
Preparing... ########################################### [100%]
1:perl-UNIVERSAL-require ########################################### [100%]
[root@DB02 huaxia]# rpm -qa|grep perl-UNIVERSAL-require
perl-UNIVERSAL-require-0.13-1.el6.rf.noarch

2.安裝Sys-Statistics-Linux

tar -zxvf Sys-Statistics-Linux-0.66.tar.gz

cd Sys-Statistics-Linux-0.66

[root@DB02 Sys-Statistics-Linux-0.66]# perl Makefile.PL
Checking if your kit is complete...
Looks good
Warning: prerequisite Time::HiRes 0 not found.#報錯！
Writing Makefile for Sys::Statistics::Linux

解決方法：yum -y install perl-Time-HiRes

重新執行：

[root@DB02 Sys-Statistics-Linux-0.66]# perl Makefile.PL
Writing Makefile for Sys::Statistics::Linux

make all

make install

3.下載check_linux_stats.pl監控腳本，并把腳本放到/usr/local/nagios/libexec的插件目錄里

執行./check_linux_stats.pl，可以看到該腳本可以監控很多參數。

[oracle@DB02 libexec]$ ./check_linux_stats.pl --help
check_linux_stats v1.3.1
Usage: ./check_linux_stats.pl -C|-P|-M|-N|-D|-I|-L|-F|-S|-W|-U -p <pattern> -w <warning> -c <critical> [-s <sleep>] [-u <unit>] [-V] [-h]
-h, --help
     print this help message
-C, --cpu=CPU USAGE
-P, --procs
-M, --memory=MEMORY USAGE
-N, --network=NETWORK USAGE
-D, --disk=DISK USAGE
-I, --io=DISK IO USAGE
-L, --load=LOAD AVERAGE
-F, --file=FILE STATS
-S, --socket=SOCKET STATS
-W, --paging=PAGING AND SWAPPING STATS
-U, --uptime
-p, --pattern
  eth0,eth2...sda1,sda2.../usr,/tmp
-w, --warning
-c, --critical
-s, --sleep
-u, --unit
               %, KB, MB or GB left on disk usage, default : MB
        REQS OR BYTES on disk io statistics, default : REQS
-V, --version
  version number

ex :
Memory usage                    : perl check_linux_stats.pl -M -w 90 -c 95
Cpu usage                       : perl check_linux_stats.pl -C -w 90 -c 95 -s 5
Disk usage                      : perl check_linux_stats.pl -D -w 95 -c 100 -u % -p /tmp,/usr,/var
Load average                    : perl check_linux_stats.pl -L -w 10,8,5 -c 20,18,15
Paging statistics  : perl check_linux_stats.pl -W -w 10,1000 -c 20,2000 -s 3
Process statistics              : perl check_linux_stats.pl -P -w 100 -c 200
I/O statistics on disk device   : perl check_linux_stats.pl -I -w 10 -c 5 -p sda1,sda4,sda5,sda6
Network usage                   : perl check_linux_stats.pl -N -w 10000 -c 100000000 -p eth0
Processes virtual memory        : perl check_linux_stats.pl -T -w 9551820 -c 9551890 -p /var/run/sendmail.pid
Uptime    : perl check_linux_stats.pl -U -w 5

[oracle@DB02 libexec]$ ./check_linux_stats.pl -M -w 90 -c 95#測試了下內存，顯示正常。
MEMORY CRITICAL : Mem used: 97.96%, Swap used: 0.96% |MemUsed=97.96%;90;95 SwapUsed=0.96;; MemCached=91.65 SwapCached=0.21 Active=60.85

4.在客戶機的nrpe.cfg里面加入幾項監控的服務。

command[check_HA_servhamachine]=/usr/local/nagios/libexec/check_procs -w $ARG1$ -c $ARG2$ -C $ARG3$
command[check_linux_stats_root]=/usr/local/nagios/libexec/check_linux_stats.pl -D -w $ARG1$ -c $ARG2$ -p $ARG3$
command[check_linux_stats_load]=/usr/local/nagios/libexec/check_linux_stats.pl -L -w $ARG1$ -c $ARG2$
command[check_linux_stats_cpu]=/usr/local/nagios/libexec/check_linux_stats.pl -C -w $ARG1$ -c $ARG2$ -s $ARG3$
command[check_linux_stats_mem]=/usr/local/nagios/libexec/check_linux_stats.pl -M -w $ARG1$ -c $ARG2$

5.服務器端用的是nagiosql,在里面把這幾個監控項加一下。

nagios監控插件 nagios_oracle_health+check_linux_stats.pl怎么用