Zabbix监控Oracle归档

1、监控oralce归档日志

#在oracle用户家目录下写一个查询归档日志的脚本
[[email protected] ~]# vim /home/oracle/archived.sh
source ~/.bash_profile
function check {
sqlplus -S "/ as sysdba" <<EOF
spool /tmp/archived.log 	# 查询到的结果写至该文件中
select * from v\$flash_recovery_area_usage;
spool off
quit
EOF
}
check &>/dev/null


[[email protected] ~]# chmod +x /home/oracle/archived.sh

[[email protected] ~]# mkdir /script
[[email protected] ~]# vim /script/archived_log.sh
#!/bin/bash
su - oracle -c /home/oracle/archived.sh	#引用脚本，解决非oracle用户下无法登入查询的问题

check() {             # json格式输出的item变量 
printf "{\n"
printf  '\t'"\"data\":["
     printf '\n\t\t{'
     printf "\"{#STATUS_NAME}\":\"ARCHIVED\"}"
printf  "\n\t]\n"
printf "}\n"
}
 
archived() {             # 过滤归档日志使用率 函数
status=`grep  ^ARCHIVED /tmp/archived.log | awk '{print $3}'`
echo "$status"
}
 
backup() {               # 过滤备份集使用率函数
status=`grep  ^BACKUP /tmp/archived.log | awk '{print $3}'`
echo "$status"
}
$1

[[email protected] ~]# cd /script/
[[email protected] script]# bash archived_log.sh archived
24.36
[[email protected] script]# bash archived_log.sh backup
0
[[email protected] script]# cat /tmp/archived.log

#将脚本完整路径写入到zabbix-agent.conf的配置文件中
[[email protected] ~]# vim /etc/zabbix/zabbix_agentd.conf
296 UserParameter=archived.check,/script/archived_log.sh check
297 UserParameter=archived.status,/script/archived_log.sh archived "$1"
298 UserParameter=backup.piece, /script/archived_log.sh backup "$1"

注：archived.check  archived.status  backup.piece需要在创建zabbix监控项时对应写入的键值，必须保持一致

#重启zabbix-agent
[[email protected] ~]# systemctl restart zabbix-agent

#zabbix-server端检测结果
[[email protected] ~]# zabbix_get -s x.x.x.x -p 10050 -k archived.status
24.36

[[email protected] ~]# zabbix_get -s x.x.x.x -p 10050 -k backup.piece
sh: /home/oracle/script/archived_log.sh: Permission denied    #提示权限被拒绝，解决方案看下面

• 如果执行出现上面执行脚本没有权限的问题，需要修改zabbix-agent配置文件

[[email protected] ~]# vim /etc/zabbix/zabbix_agentd.conf

# 重启zabbix-agent
[[email protected] ~]# systemctl restart zabbix-agent

# 再次进行检查下就可以正常显示结果了

2、配置Zabbix监控

3、给Oracle主机添加模板

• 等待一会，获取到数据库后查看图形