DBforbix3监控多个Oracle数据库和RAC数据库
Zabbix4.2使用DBforbix3监控多个Oracle11gR2数据库
查看数据库信息
su - oracle sqlplus / as sysdba select name from v$database; select instance_name from v$instance; select global_name from global_name;
添加数据库用户并授权
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;
配置ACL
exec dbms_network_acl_admin.create_acl(acl => 'resolve.xml',description => 'resolve acl', principal =>'ZABBIX',is_grant => true, privilege => 'resolve'); exec dbms_network_acl_admin.assign_acl(acl => 'resolve.xml', host =>'*'); commit;
配置DBforBIX多数据库监控
vim /opt/dbforbix/conf/config.properties 修改为 #MaxThreadNumber should be >= than the number of your databases DBforBIXDaemon.MaxThreadNumber=100 增加最大线程数 # List of comma separated databases # This names also should be defined in your Template/Host macros {$DSN} in Zabbix Web Interface # See zabbix templates attached for further details ZabbixServer.Zabbix1.DBList=ORADB1,ORADB2 使用逗号隔开,添加ORADB2 添加ORADB2参数 DB.ORADB2.Type=oracle DB.ORADB2.Instance=etlcdr DB.ORADB2.Url=jdbc:oracle:thin:@10.37.10.134:1521:etlcdr DB.ORADB2.User=zabbix DB.ORADB2.Password=zabbix DB.ORADB2.MaxActive=10 DB.ORADB2.MaxWaitMillis=10000 DB.ORADB2.QueryTimeout=15 DB.ORADB2.MaxIdle=1
配置DBforBIX RAC监控
DB.ORADB3.Type=oracle DB.ORADB3.Instance=etlcrm DB.ORADB3.Url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.11.201)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.11.202)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=etlcrm))) DB.ORADB3.User=zabbix DB.ORADB3.Password=zabbix DB.ORADB3.MaxActive=10 DB.ORADB3.MaxWaitMillis=10000 DB.ORADB3.QueryTimeout=15 DB.ORADB3.MaxIdle=1 DB.ORADB4.Type=oracle DB.ORADB4.Instance=etlocs DB.ORADB4.Url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.10.201)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.10.202)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=etlocs))) DB.ORADB4.User=zabbix DB.ORADB4.Password=zabbix DB.ORADB4.MaxActive=10 DB.ORADB4.MaxWaitMillis=10000 DB.ORADB4.QueryTimeout=15 DB.ORADB4.MaxIdle=1
Zabbix配置
新建主机,设置主机名,添加到群组,设置agent代理地址和选择agent代理程序
宏选项里输入ORADB2,可以删除掉当时配置的全局宏
重启Zabbix服务
systemctl restart dbforbix.service
过几分钟,图形中就会有数据了
本站所有文章均可随意转载,转载时请保留原文链接及作者。