orabbix方式新增oracle监控

1.oracle数据库创建监控账户

 CREATE USER ZABBIX
 IDENTIFIED BY <REPLACE WITH PASSWORD>
 DEFAULT TABLESPACE SYSTEM
 TEMPORARY TABLESPACE TEMP
 PROFILE DEFAULT
 ACCOUNT UNLOCK;

 – 2 Roles for ZABBIX
 GRANT CONNECT TO ZABBIX;
 GRANT RESOURCE TO ZABBIX;
 ALTER USER ZABBIX DEFAULT ROLE ALL;

 – 5 System Privileges for ZABBIX
 GRANT SELECT ANY TABLE TO ZABBIX;
 GRANT CREATE SESSION TO ZABBIX;
 GRANT SELECT ANY DICTIONARY TO ZABBIX;
 GRANT UNLIMITED TABLESPACE TO ZABBIX;
 GRANT SELECT ANY DICTIONARY TO ZABBIX;

如果想最小化权限控制，那么使用如下的创建语句：

CREATE USER ZABBIX
IDENTIFIED BY <REPLACE WITH PASSWORD>
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_$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;

如果数据库版本为11g，那么还需要执行以下命令：

 exec dbms_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;

2.验证本地运行状态

select utl_inaddr.get_host_name('127.0.0.1') from dual;

3.将orabbix的template目录下的模板导入zabbix

4.servcer端部署好orabbix

 /etc/init.d/orabbix
 /opt/orabbix/run.sh

修改/etc/hosts文件
192.168.205.156 ops-zabbix-01

修改servcer 端的orabbix配置文件,天剑需要监控的数据库主机和配置信息

vi /opt/orabbix/conf/config.props
#配置server端的主机名：
ZabbixServerList=ops-zabbix-01
#配置server端的ip和端口
ops-zabbix-01.Address=192.168.205.156
ops-zabbix-01.Port=10051

配置需要监控的数据库
DatabaseList=prod-nc-db-rac-adg,uat-nc-db-02
uat-nc-db-02.Url=jdbc:oracle:thin:@192.168.201.152:1521:gjorcl
uat-nc-db-02.User=zabbix
uat-nc-db-02.Password=zabbix
uat-nc-db-02.MaxActive=10
uat-nc-db-02.MaxWait=100
uat-nc-db-02.MaxIdle=1
uat-nc-db-02.QueryListFile=./conf/query.props

启动和停止orabbix：
/etc/init.d/orabbix start
/etc/init.d/orabbix start

5.自定义配置

Query List File

6.client端配置和修改zabbix_agent2

rpm -ivh zabbix-agent2-6.0.4-1.el7.x86_64.rpm

vi /etc/zabbix/zabbix_agent2.conf
Server=ops-zabbix-01
ListenPort=10050

启动
systemctl restart zabbix-agent2.service