zabbix+查询oracle,zabbix[五]zabbix监控oracle

zabbix[5]zabbix监控oracle

zabbix不能直接监控oracle，通过第三方插件orabbix插件进行监控的，

orabbix插件在服务器端运行，远程连接到oracle数据库的指定账号上执行特定的SQL，

将查询结果显示在zabbix web server中

在被监控数据库上创建zabbix用户，赋指定权限

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 ROLE ALL;

GRANT SELECT ANY TABLE TO ZABBIX;

GRANT CREATE SESSION TO ZABBIX;

GRANT SELECT ANY DICTIONARY TO ZABBIX;

GRANT UNLIMITED TABLESPACE TO ZABBIX;

GRANT SELECT ANY DICTIONARY TO ZABBIX;

---oracle 11g execute

BEGIN

-- Only uncomment the following line if ACL "network_services.xml" has already been created

--DBMS_NETWORK_ACL_ADMIN.DROP_ACL('network_services.xml');

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(

acl => 'network_services.xml',

description => 'NETWORK ACL',

principal => 'ZABBIX',

is_grant => true,

privilege => 'connect');

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(

acl => 'network_services.xml',

principal => 'ZABBIX',

is_grant => true,

privilege => 'resolve');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(

acl => 'network_services.xml',

host => '*');

COMMIT;

END;

-- 验证

select utl_inaddr.get_host_name('127.0.0.1') from dual;

下载orabbix-1.2.3.zip，解压到/etc/zabbix目录，修改配置文件

cp conf/config.props.sample conf/config.props

ZabbixServer1.Address=192.168.1.208

ZabbixServer1.Port=10051

#受监控的数据库名称列表

#put here your databases in a comma separated list

DatabaseList=192.168.1.207oracle

#受监控的数据库1

#define here your connection string for each database

192.168.1.207oracle.Url=jdbc:oracle:thin:@192.168.31.207:1521:orcl

192.168.1.207oracle.User=ZABBIX

192.168.1.207oracle.Password=ZABBIX

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

192.168.1.207oracle.MaxActive=10

192.168.1.207oracle.MaxWait=100

192.168.1.207oracle.MaxIdle=1

192.168.1.207oracle.QueryListFile=./conf/query.props

#注掉DB2，DB3

#DB2.Url=jdbc:oracle:thin:@server2.domain.example.com::DB2

#DB2.User=zabbix

#DB2.Password=zabbix_password

#DB2.QueryListFile=./conf/query.props

#DB3.Url=jdbc:oracle:thin:@server3.domain.example.com::DB3

#DB3.User=zabbix

#DB3.Password=zabbix_password

#DB3.QueryListFile=./conf/query.props

启动服务

./run.sh

打开zabbix server，导入orabbix自带的数据库模板，添加一台主机，主机名和DatabaseList=192.168.1.207oracle里配的名字要一致

模板选择ORACLE即可