zabbix无法直接监控oracle,因此我们需要借助第三方插件orabbix,oracle提供了众多的数据库性能监控。
环境
系统环境:centos7
zabbix版本:3.4.2
Orabbix版本:1.2.3
Oracle:oracle 11g
数据库端
开通监控账号配置
#su - oracle
#export ORACLE_SID=test
#sqlplus /nolog
#conn /as sysdba
执行以下sql
create user zabbix identified by "zabbix" default tablespace system temporary tablespace temp profile default account unlock;
grant alter session to zabbix;
grant create session to zabbix;
grant connect to zabbix;
alter user zabbix default role all;
grant select on v_$instance to zabbix;
grant select on dba_users to zabbix;
grant select on v_$log_history to zabbix;
grant select on v_$parameter to zabbix;
grant select on sys.dba_audit_session to zabbix;
grant select on v_$lock to zabbix;
grant select on dba_registry to zabbix;
grant select on v_$librarycache to zabbix;
grant select on v_$sysstat to zabbix;
grant select on v_$parameter to zabbix;
grant select on v_$latch to zabbix;
grant select on v_$pgastat to zabbix;
grant select on v_$sgastat to zabbix;
grant select on v_$librarycache to zabbix;
grant select on v_$process to zabbix;
grant select on dba_data_files to zabbix;
grant select on dba_temp_files to zabbix;
grant select on dba_free_space to zabbix;
grant select on v_$system_event to zabbix;
Oracle 11g或以上,所以还需要添加以下命令:
execdbms_network_acl_admin.create_acl(acl => 'resolve.xml',description =>'resolve acl', principal =>'ZABBIX', is_grant => true, privilege =>'resolve');
exec dbms_network_acl_admin.assign_acl(acl=> 'resolve.xml', host =>'*');
commit;
服务器端
安装Java环境
到官方http://www.oracle.com/technetwork/java/javase/downloads/ 下载jre或jdk 安装即可,使用命令java –version有版本号码。