基于CACTI的分布式ORACLE监控系统的设计与实现

Design and Implementation of Distributed Oracle Monitor System Based on CACTI

针对多个ORACLE数据库系统的主动性监控问题,提出一个基于CACTI的分布式监控报警系统。采用"一个管理端+多个代理"的监控模式,CACTI作为监控管理端,在运行ORACLE数据库服务器上添加代理模块,实现对物理位置上分布的多个ORACLE进行不间断的集中式监控。通过在CACTI上对各个ORACLE数据库设置不同的性能报警粒度,实现系统多层次多粒度、灵活多样的监控策略,并对数据库运行过程中的异常状态进行邮件和短信报警。实验结果和型号项目中的实际应用验证了系统的有效性。

In order to guarantee multiple ORACLE database system initiatively, a distributed guarantee warning system is proposed based on CACTI.By using the ＂one-manager-multi-agent＂ mode, CACTI adds agent model to ORACLE database server to enable continous centralized monitoring on a distributed ORACLE database.Multi-level and flexible monitoring strategies are realized by setting different granularity on CACTI for various ORACLE databases.The system alerts abnormal states of mail and message in a database.The experimental results and the practical application in model projects verify the effectiveness of the system.