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即可