zabbix oracle locks,Zabbix 添加Oracle监控

Zabbix 添加Oracle监控

Oracle监控也参考zabbix wiki上如下的方法(调用zabora工具)：

1、下载oracle监控程序zabora到oracle所在的主机上，修改所在host的agentd.conf，添加监控项，按如下格式：

UserParameter=oracle.name,DIR/zabora pattern sid

监控oracle数据库状态：

UserParameter=oracle.checkactive,/usr/local/zabora checkactive OracleSID

监控oralce数据库连接用户总数

UserParameter=oracle.usercount,/usr/local/zabora usercount OracleSID

更多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.

保存配置，重启agentd

2、在zabbix web页面上创建对应的items和triggers

创建监控oracle数据库状态的item，item key不要select，直接在key栏输入在agent上的UserParameter name

例如监控数据库状态的：oracle.checkactive

创建trigger，选择之前创建的item，最后一次采集值不为0，即为状态有问题。

(注：不确定每个zabora方法的返回值时，可直接在agent上运行获取结果)