通过zabora监控oracle

oracle不能装在/home下，否则zabbix用户没有权限操作oracle

1.oraenv配置环境变量

export ORACLE_HOME=/oracle/app/oracle/product/12.1.0/dbhome_1

export ORACLE_SID=orcl

export PATH=/usr/bin:/usr/sbin/:$ORACLE_HOME/bin

#export NLS_LANG=american_cis.cl8mswin1251

2.将zabbix用户添加到dba组中

usermod -a -G dba zabbix

usermod -a -G dba root

3.环境变量

将oracle用户的.bashrc（隐藏文件，/home/oracle/.bashrc）中配置的关于oracle的环境变量配到zabbix用户的.bashrc中

export ORACLE_HOME=/oracle/app/oracle/product/12.1.0/dbhome_1

export ORACLE_SID=orcl

export PATH=/usr/bin:/usr/sbin/:$ORACLE_HOME/bin

4.zabbix配置

复制并赋可执行权限：

zabbix_agentd.conf末尾添加：

UserParameter=oracle.zabora[*],/usr/local/zabbix/plugins/oracle/zabora.sh $1 $2

重启zabbix_agentd

界面上添加监控项：

5.测试

在root与zabbix用户下执行/usr/local/zabbix/bin/zabbix_get -s ip -k oracle.zabora[uptime,orcl]

都能得到返回值

zabora监控项

zabora version: 1.5

usage:

   zabora checkactive [SID]     -- Check Intance is active and open.

   zabora usercount [SID]       -- Count of users connected to Oracle.

   zabora activeusercount [SID] -- Count of active users.

   zabora dbsize [SID]          -- Size of user data (without temp).

   zabora dbfilesize [SID]      -- Size of all datafiles.

   zabora version [SID]         -- Oracle version (Banner).

   zabora dsksortratio [SID]    -- Disk sorts ratio.

   zabora rcachehit [SID]       -- Read Cache hit ratio.

   zabora uptime [SID]          -- Instance Uptime (seconds).

   zabora commits [SID]         -- User Commits.

   zabora rollbacks [SID]       -- User Rollbacks.

   zabora deadlocks [SID]       -- Deadlocks.

   zabora redowrites [SID]      -- Redo Writes.

   zabora tblscans [SID]        -- Table scans (long tables).

   zabora tblrowsscans [SID]    -- Table scan rows gotten.

   zabora indexffs [SID]        -- Index fast full scans (full).

   zabora hparsratio [SID]      -- Hard parse ratio.

   zabora netsent [SID]         -- Bytes sent via SQL*Net to client.

   zabora netresv [SID]         -- Bytes received via SQL*Net from client.

   zabora netroundtrips [SID]   -- SQL*Net roundtrips to/from client.

   zabora logonscurrent [SID]   -- Logons current.

   zabora lastarclog [SID]      -- Last archived log sequence.

   zabora lastapplarclog [SID]  -- Last applied archive log (at standby).Next items requires [timed_statistics = true].

   zabora freebufwaits [SID]    -- free buffer waits.

   zabora bufbusywaits [SID]    -- buffer busy waits.

   zabora logswcompletion [SID] -- log file switch completion.

   zabora logfilesync [SID]     -- log file sync.

   zabora logprllwrite [SID]    -- log file parallel write.

   zabora enqueue [SID]         -- enqueue waits.

   zabora dbseqread [SID]       -- db file sequential read waits.

   zabora dbscattread [SID]     -- db file scattered read.

   zabora dbsnglwrite [SID]     -- db file single write.

   zabora dbprllwrite [SID]     -- db file parallel write.

   zabora directread [SID]      -- direct path read.

   zabora directwrite [SID]     -- direct path write.

   zabora latchfree [SID]       -- latch free.

   zabora zaboraver             -- Version of this script.

currentconnections         

slowsqls         

readbytes          

writebytes