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