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:<LISTENER_PORT>:DB2
#DB2.User=zabbix
#DB2.Password=zabbix_password
#DB2.QueryListFile=./conf/query.props
 
#DB3.Url=jdbc:oracle:thin:@server3.domain.example.com:<LISTENER_PORT>:DB3
#DB3.User=zabbix
#DB3.Password=zabbix_password
#DB3.QueryListFile=./conf/query.props

启动服务

./run.sh

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

模板选择ORACLE即可