centos6.5下用orabbix监控oracle

zabbix监控oracle

一.orabbix简介

本文档主要介绍zabbix通过orabbix来监控oracle

Orabbix是zabbix监控oracle的插件，其具备多实例采集机制，进而提供信息的监控和性能指标。

Orabbix监控的内容

  1、数据库版本

  2、归档日志与生产趋势

  3、触发器，表/过程命中率

  4、逻辑IO性能

  5、物理IO性能

  6、PGA

  7、SGA

  8、共享池

  9、Session

  10、数据库大小

二.orabbix部署步骤

实验环境

OS：centos6.5

server端：10.45.30.228

agent端（oracle rac的某一节点）:10.45.25.111

b. 确保jre

[root@zabbix-srv ~]# java -version

java version "1.6.0_24"

OpenJDK Runtime Environment (IcedTea6 1.11.1) (rhel-1.45.1.11.1.el6-x86_64)

OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mod

c.安装orabbix

将下载的orabbix-1.2.3.zip

拷贝至server端的/opt/orabbix/下（建议目录，否则会影响后续脚本执行）

#mkdir /opt/orabbix

#cd /opt/orabbit

#unzip orabbix-1.2.3.zip 

d.配置orabbix

1.给orabbix目录下附权限

#chmod a+x /opt/orabbix -R

2.创建orabbix配置文件

#cp /opt/orabbix/conf/config.props.sample config.props

3.编辑config.props

ZabbixServerList=ZabbixServer1   

ZabbixServer1.Address=10.45.30.228                             #此处地址为zabbixserver的地址

ZabbixServer1.Port=10051                            

OrabbixDaemon.PidFile=./logs/orabbix.pid                       #java进程路径

#frequency of item's refresh

OrabbixDaemon.Sleep=300

#MaxThreadNumber should be >= than the number of your databases

OrabbixDaemon.MaxThreadNumber=100

#put here your databases in a comma separated list

#DatabaseList=DB1,DB2,DB3

DatabaseList=yfcdas01                                                   #此处名称需和oracle db端的hostname一致

#Configuration of Connection pool

#if not specified Orabbis is going to use default values (hardcoded)

#Maximum number of active connection inside pool

DatabaseList.MaxActive=10

#The maximum number of milliseconds that the pool will wait 

#(when there are no available connections) for a connection to be returned 

#before throwing an exception, or <= 0 to wait indefinitely. 

DatabaseList.MaxWait=100

DatabaseList.MaxIdle=1

#define here your connection string for each database

#DB1.Url=jdbc:oracle:thin:@server.domain.example.com:<LISTENER_PORT>:DB1

yfcdas01.Url=jdbc:oracle:thin:@10.45.25.111:1521:yfcdas1       # yfcdas01和之前databaselist一致，10.45.25.111是oracle db 的ip，1521是端口，yfcdas1是oracle_sid

yfcdas01.User=ZABBIX                                                   #该用户oracle数据库用户，需具备connect和resource权限 ，也可以创建zabbix用户，后面会有sql语句

yfcdas01.Password=zabbix

#Those values are optionals if not specified Orabbix is going to use the general values

yfcdas01.MaxActive=10

yfcdas01.MaxWait=100

yfcdas01.MaxIdle=1

yfcdas01.QueryListFile=./conf/query.props

e.创建oracle数据库zabbix用户

该步骤在oracle db端执行

export XXX(oracle_sid)

sqlplus / as sysdba

CREATE USER ZABBIX

IDENTIFIED BY ZABBIX

DEFAULT TABLESPACE SYSTEM

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

GRANT CONNECT TO ZABBIX;

GRANT RESOURCE TO ZABBIX;

ALTER USER ZABBIX DEFAULT ROLEALL;

GRANT SELECT ANY TABLE TOZABBIX;

GRANT CREATE SESSION TO ZABBIX;

GRANT SELECT ANY DICTIONARY TOZABBIX;

GRANT UNLIMITED TABLESPACE TOZABBIX;

GRANT SELECT ANY DICTIONARY TOZABBIX;

f.启动服务和进程

#cp -a /opt/orabbix/init.d/orabbix /etc/init.d/orabbix

#chmod 755 /etc/init.d/orabbix

#/etc/init.d/orabbix start

日志文件在/opt/orabbix/logs/orabbix.log中 tail -f 跟踪日志分析部署过程中的问题。

三.zabbix web端添加模板

将orabbix server端/opt/orabbix/template/orabbix_export_full.xml上传到本地， 

然后再zabbix web端configuration—》Templates—》Import中将模板添加

然后再已添加好的hosts中增加该oracle template，enable相应所需要监控的内容即可。