check_oracle_health

不正狼

　　1、下载check_oracle_health，从http://labs.consol.de/wp-content/uploads/2009/09/check_oracle_health-1.6.3.tar.gz下载源文件。
　　#tar -zxvf check_oracle_health-1.6.3.tar.gz
　　#cd check_oracle_health-1.6.3
　　#./configure --prefix=/opt/amstar/nagios --with-nagios-user=amstar --with-nagios-group=amstar --with-mymodules-dir=/opt/amstar/nagios/libexec --with-mymodules-dyn-dir=/opt/amstar/nagios/libexec
　　#make all
　　#make install
　　#cd /opt/amstar/nagios/libexec/
　　#./check_oracle_health -h
　　查看一下使用语法
　　Copyright (c) 2008 Gerhard Lausser
　　Check various parameters of Oracle databases
　　Usage:
　　check_oracle_health [-v] [-t ] --connect=
　　--username= --password= --mode=
　　--tablespace=
　　check_oracle_health [-h | --help]
　　check_oracle_health [-V | --version]
　　Options:
　　--connect
　　the connect string
　　--username
　　the oracle user
　　--password
　　the oracle user's password
　　--warning
　　the warning range
　　--critical
　　the critical range
　　--mode
　　the mode of the plugin. select one of the following keywords:
　　tnsping                          (Check the reachability of the server)
　　connection-time                  (Time to connect to the server)
　　connected-users                  (Number of currently connected users)
　　sga-data-buffer-hit-ratio        (Data Buffer Cache Hit Ratio)
　　sga-library-cache-hit-ratio      (Library Cache Hit Ratio)
　　sga-dictionary-cache-hit-ratio   (Dictionary Cache Hit Ratio)
　　sga-latches-hit-ratio            (Latches Hit Ratio)
　　sga-shared-pool-reload-ratio     (Shared Pool Reloads vs. Pins)
　　sga-shared-pool-free             (Shared Pool Free Memory)
　　pga-in-memory-sort-ratio         (PGA in-memory sort ratio)
　　invalid-objects                  (Number of invalid objects in database)
　　stale-statistics                 (Find objects with stale optimizer statistics)
　　tablespace-usage                 (Used space in tablespaces)
　　tablespace-free                  (Free space in tablespaces)
　　tablespace-remaining-time        (Remaining time until a tablespace is full)
　　tablespace-fragmentation         (Free space fragmentation index)
　　tablespace-io-balance            (balanced io of all datafiles)
　　tablespace-can-allocate-next     (Segments (of a tablespace) can allocate next extent)
　　datafile-io-traffic              (io operations/per sec of a datafile)
　　soft-parse-ratio                 (Percentage of soft parses)
　　switch-interval                  (Time between redo log file switches)
　　retry-ratio                      (Redo buffer allocation retries)
　　redo-io-traffic                  (Redo log io bytes per second)
　　roll-header-contention           (Rollback segment header contention)
　　roll-block-contention            (Rollback segment block contention)
　　roll-hit-ratio                   (Rollback segment hit ratio (gets/waits))
　　roll-wraps                       (Rollback segment wraps (per sec))
　　roll-extends                     (Rollback segment extends (per sec))
　　roll-avgactivesize               (Rollback segment average active size)
　　seg-top10-logical-reads          (user objects among top 10 logical reads)
　　seg-top10-physical-reads         (user objects among top 10 physical reads)
　　seg-top10-buffer-busy-waits      (user objects among top 10 buffer busy waits)
　　seg-top10-row-lock-waits         (user objects among top 10 row lock waits)
　　event-waits                      (processes wait events)
　　event-waiting                    (time spent by processes waiting for an event)
　　enqueue-contention               (percentage of enqueue requests which must wait)
　　enqueue-waiting                  (percentage of time spent waiting for the enqueue)
　　latch-contention                 (percentage of latch get requests which must wait)
　　latch-waiting                    (percentage of time a latch spends sleeping)
　　sysstat                          (change of sysstat values over time)
　　sql                              (any sql command returning a single number)
　　list-tablespaces                 (convenience function which lists all tablespaces)
　　list-datafiles                   (convenience function which lists all datafiles)
　　list-enqueues                    (convenience function which lists all enqueues)
　　list-latches                     (convenience function which lists all latches)
　　list-events                      (convenience function which lists all events)
　　list-background-events           (convenience function which lists all background events)
　　list-sysstats                    (convenience function which lists all statistics from v$sysstat)
　　--name
　　the name of the tablespace, datafile, wait event,
　　latch, enqueue, or sql statement depending on the mode.
　　--name2
　　if name is a sql statement, this statement would appear in
　　the output and the performance data. This can be ugly, so
　　name2 can be used to appear instead.
　　--regexp
　　if this parameter is used, name will be interpreted as a
　　regular expression.
　　--units
　　one of %, KB, MB, GB. This is used for a better output of mode=sql
　　and for specifying thresholds for mode=tablespace-free
　　Tablespace-related modes check all tablespaces in one run by default.
　　If only a single tablespace should be checked, use the --name parameter.
　　The same applies to datafile-related modes.
　　tablespace-remaining-time will take historical data into account. The number
　　of days in the past can be given with the --lookback parameter. (Default: 30)
　　In mode sql you can url-encode the statement so you will not have to mess
　　around with special characters in your Nagios service definitions.
　　Instead of
　　--name="select count(*) from v$session where status = 'ACTIVE'"
　　you can say
　　--name=select%20count%28%2A%29%20from%20v%24session%20where%20status%20%3D%20%27ACTIVE%27
　　For your convenience you can call check_oracle_health with the --encode
　　option and it will encode the standard input.
　　Send email to gerhard.lausser@consol.de if you have questions
　　regarding use of this software.
　　Please include version information with all correspondence (when possible,
　　use output from the --version option of the plugin itself).
　　特别注意使用该插件需要先安装perl访问oracle的cpan，DBD::Oracle。安装方法：见上一篇文章
　　几个示范命令行：
　　查询表空间使用情况
　　全部表空间
　　#./check_oracle_health --connect=ismp --user=usr_ismp --password=111111--mode=tablespace-usage
　　指定表空间
　　#./check_oracle_health --connect=ismp --user=usr_ismp --password=111111--mode=tablespace-usage --tablespace=TSP_ISMP
　　tsnping：
　　#./check_oracle_health --connect=ismp --user=usr_ismp --password=111111--mode=tnsping
　　貌似这个插件很好很强大，可以替换掉自带check_oracle插件了。
　　btw：
　　如果执行命令提示：
　　Can't locate Time/HiRes.pm in @INC (@INC contains: /usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi
　　就是缺少了HiRes.pm，下载安装就好了。
　　#wget http://www.perl.com/CPAN/modules/by-module/Time/Time-HiRes-01.02.tar.gz
　　#cd Time-HiRes-01.02
　　#perl Makefile.PL
　　#make all
　　#make install