zabbix 监控oracle 各种脚本

 

监控归档日志脚本

#!/bin/bash
source ~/.bash_profile
function check {
sqlplus -S "/ as sysdba" <<  EOF
spool /tmp/archived.log                     # spool 将执行的结果输出到文件当中
select * from v\$flash_recovery_area_usage;
spool off
quit
EOF
};check &>/dev/null

# 如果不使用oracle用户执行的话，是下面这个样子的
#!/bin/bash
source ~/.bash_profile
function check {
sudo su - oracle << EOF
sqlplus -S "/ as sysdba"
spool /tmp/archived.log                     
select * from v\$flash_recovery_area_usage;
spool off
quit
EOF
};check &>/dev/null

 执行结果

取值脚本

#!/bin/bash
# Get archive log and backup set usage
# version: 1
# ctime: 
# mtime:
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

执行结果

UserParameter配置文件

[SZSqxf@ecs-da85 ~]$ cat /usr/local/zabbix-agent/etc/zabbix_agentd.conf.d/archived_log.conf 
UserParameter=