— 安装Zabbix Server
[root@fgedu ~]# yum install -y zabbix-server-mysql zabbix-web-mysql
— 安装Zabbix Agent
[root@fgedu ~]# yum install -y zabbix-agent
— 配置Zabbix Server
[root@fgedu ~]# vi /etc/zabbix/zabbix_server.conf
DBHost=fgedu.localhost
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
— 配置Zabbix Agent
[root@fgedu ~]# vi /etc/zabbix/zabbix_agentd.conf
Server=192.168.1.100
ServerActive=192.168.1.100
Hostname=fgedu.net.cn
— 启动Zabbix服务
[root@fgedu ~]# systemctl start zabbix-server
[root@fgedu ~]# systemctl start zabbix-agent
[root@fgedu ~]# systemctl start httpd

配置DM数据库监控：

— 创建监控用户
[dm@fgedu ~]$ disql SYSDBA/SYSDBA
SQL> CREATE USER fgedu_monitor IDENTIFIED BY “Fgedu123”;
SQL> GRANT SELECT ON V$TABLES TO fgedu_monitor;
SQL> GRANT SELECT ON V$SESSIONS TO fgedu_monitor;
SQL> GRANT SELECT ON V$TRANSACTIONS TO fgedu_monitor;
SQL> GRANT SELECT ON V$LOCKS TO fgedu_monitor;
SQL> GRANT SELECT ON V$SQLSTAT TO fgedu_monitor;
— 创建监控脚本
[root@fgedu ~]# vi /usr/local/bin/dm_monitor.sh
#!/bin/bash
# dm_monitor.sh 学习交流加群风哥QQ113257174
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: http://www.fgedu.net.cn
DM_HOME=/dm/app
DISQL=$DM_HOME/bin/disql
USER=fgedu_monitor
PASS=Fgedu123
HOST=192.168.1.101
PORT=5236
# 采集连接数
$DISQL $USER/$PASS@$HOST:$PORT -s “SELECT COUNT(*) FROM V\$SESSIONS” > /tmp/dm_sessions.txt
# 采集事务数
$DISQL $USER/$PASS@$HOST:$PORT -s “SELECT COUNT(*) FROM V\$TRANSACTIONS” > /tmp/dm_transactions.txt
# 采集锁等待
$DISQL $USER/$PASS@$HOST:$PORT -s “SELECT COUNT(*) FROM V\$LOCKS WHERE BLOCKED=1” > /tmp/dm_locks.txt
# 采集慢查询
$DISQL $USER/$PASS@$HOST:$PORT -s “SELECT COUNT(*) FROM V\$SQLSTAT WHERE EXEC_TIME > 1000” > /tmp/dm_slowquery.txt
— 设置执行权限
[root@fgedu ~]# chmod +x /usr/local/bin/dm_monitor.sh
— 配置定时任务
[root@fgedu ~]# crontab -e
*/1 * * * * /usr/local/bin/dm_monitor.sh

— 查看监控数据
[root@fgedu ~]# cat /tmp/dm_sessions.txt
COUNT(*)
———-
50 更多视频教程www.fgedu.net.cn
— 查看Zabbix监控
[root@fgedu ~]# zabbix_get -s 192.168.1.101 -k dm.sessions
50
— 查看Zabbix Web界面
— 访问 http://192.168.1.100/zabbix
— 登录用户名：Admin，密码：zabbix
— 查看监控数据

测试告警触发：

— 配置告警规则
— 在Zabbix Web界面中配置告警规则
— 触发器：dm.sessions > 100
— 告警级别：严重
— 告警通知：发送邮件
— 模拟告警
[dm@fgedu ~]$ disql SYSDBA/SYSDBA
SQL> CREATE TABLE fgedu.fgedu_test AS SELECT * FROM fgedu.fgedu_account;
SQL> INSERT INTO fgedu.fgedu_test SELECT * FROM fgedu.fgedu_test;
SQL> INSERT INTO fgedu.fgedu_test SELECT * FROM fgedu.fgedu_test;
SQL> INSERT INTO fgedu.fgedu_test SELECT * FROM fgedu.fgedu_test;
SQL> INSERT INTO fgedu.fgedu_test SELECT * FROM fgedu.fgedu_test;
— 查看告警
— 在Zabbix Web界面中查看告警
— 查看邮件通知