1、下载zabora-master.zip
https://github.com/sergiotocalini/zabora
2、解压
unzip zabora-master.zip
3、ORACLE先要增加用户和权限
CREATE USER monitor IDENTIFIED BY 'xxxxxxx' DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO monitor;
GRANT RESOURCE TO monitor;
ALTER USER monitor DEFAULT ROLE ALL;
GRANT SELECT ANY TABLE TO monitor;
GRANT CREATE SESSION TO monitor;
GRANT SELECT ANY DICTIONARY TO monitor;
GRANT UNLIMITED TABLESPACE TO monitor;
GRANT SELECT ANY DICTIONARY TO monitor;
GRANT SELECT ON V_$SESSION TO monitor;
GRANT SELECT ON V_$SYSTEM_EVENT TO monitor;
GRANT SELECT ON V_$EVENT_NAME TO monitor;
GRANT SELECT ON V_$RECOVERY_FILE_DEST TO monitor;
注意:如果是ORACLE 19,默认不能建monitor这种用户,需要在前面加C##,例如:C##monitor
4、安装
cd zabora-master
./deploy_zabbix.sh "monitor" "xxxxxxxx"
5、检查一下zabora.sh权限
ls -l /etc/zabbix/scripts/agentd/zabora
检查zabora.sh权限,如果没有可执行权限,需要赋权
chmod +x /etc/zabbix/scripts/agentd/zabora/zabora.sh
6、创建一个ORACLE运行变量环境文件 zabora.oraenv:
内容根据ORACLE服务器安装目录而定
cat zabora.oraenv
#ORACLE_SID=orcl ORACLE_VER=11.2.0 ORACLE_HOME=/home/oracle/u01/app/oracle/product/11.2.0/db ORACLE_BASE=BASE=/home/oracle/u01/app/oracle ORACLE_TERM=xterm PATH=/usr/bin:/usr/sbin/:$ORACLE_HOME/bin NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export ORACLE_SID ORACLE_HOME ORACLE_BASE ORACLE_TERM PATH NLS_LANG
配置完了,测试一下:
./zabora.sh -o ORACLE_SID -s tb_list -a 1 -j ORACLE_TBS
正常返回所有的表空间名
7、ZABBIX SERVER模板
下载模板
https://github.com/sergiotocalini/zabora/blob/master/template_db_oracle-3.2.xml
导入上面的模板
配置主机链接到模板
7、在主机的“宏”里添加{$ORACLE_SID}和对应的SID
查询SID可以用:select instance_name from V$instance;
(未完,待续.....)