zabbix监控oracle rac,CentOS6.9下zabbix3.4.9通过orabbix1.2.3来监控oracle11gRAC

CentOS6.9下zabbix3.4.9通过orabbix1.2.3来监控oracle11gRAC

0. 关闭selinux和firewalld

[root@centos7_zabbix ~]# vim /etc/selinux/config

SELINUX=disabled

[root@centos7_zabbix ~]# systemctl disable

firewalld.service

Removed symlink

/etc/systemd/system/multi-user.target.wants/firewalld.service.

Removed symlink

/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

[root@centos7_zabbix ~]# iptables -L

[root@centos7_zabbix ~]# iptables -F

1. 在被监控的数据库上创建用户并授权

[root@jinhu-db01 ~]# su - oracle

[oracle@jinhu-db01 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Tue May 15 19:41:09

2018

Copyright (c) 1982, 2013, Oracle. All rights

reserved.

SQL> conn / as sysdba;

Connected.

SQL> SELECT name,open_mode FROM gv$database;

NAME  OPEN_MODE

--------- --------------------

ORCL  READ WRITE

ORCL  READ WRITE

SQL> SELECT

username,account_status,default_tablespace

FROM

dba_users

WHERE

username = 'ZABBIX';

no rows selected

CREATE USER zabbix IDENTIFIED BY zabbix9527 DEFAULT TABLESPACE

USERS 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_$LOG 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;

GRANT SELECT ON V_$locked_object TO zabbix;

GRANT SELECT ON dba_objects TO zabbix;

GRANT SELECT ON dba_tablespaces TO zabbix;

GRANT SELECT ON v_$SESSION TO zabbix;

SQL> exec dbms_network_acl_admin.create_acl(acl =>

'resolve.xml',description=> 'resolve acl', principal

=>'ZABBIX', is_grant => true, privilege =>

'resolve');

PL/SQL procedure successfully completed.

SQL> exec dbms_network_acl_admin.assign_acl(acl =>

'resolve.xml', host =>'*');

PL/SQL procedure successfully completed.

SQL> commit;

2. 在orabbix的配置文件中，增加监控数据库

[root@zaibei-db zabbix]# vim

/usr/local/orabbix/conf/config.props

DatabaseList=db_cq_duporcl_68,db_cq_orcl_1121

db_cq_orcl_1121.Url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.20.11)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.20.21)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

db_cq_orcl_1121.User=zabbix

db_cq_orcl_1121.Password=zabbix9527

db_cq_orcl_1121.MaxActive=10

db_cq_orcl_1121.MaxWait=100

db_cq_orcl_1121.MaxIdle=1

db_cq_orcl_1121.QueryListFile=./conf/query.props

3. 在zabbix页面，新增一个"db_cq_orcl_1121"主机，并进行相关配置后，查看状态。

!!!The end!!!