插件官方：http://www.smartmarmot.com/product/orabbix/ #### 部署dbforbix（1.2.3版） #### 現狀 smartmarmot里面的插件可以監控所有常見數據庫，但2016年之前很久沒有更新， 2016年底升級到2.2版本，整合了之前零散的數據庫監控插件，但我并沒有監控成功，留待以后再試吧。 #### 前提條件 安裝jdk1.6以上版本（1.6.45） 配置Zabbix客戶端3.0.4 #### 上傳到/opt目錄下 ```shell 復制/opt/dbforbix/conf/config.properties.sample到config.properties，并編輯 ``` #### 樣例 ```shell #comma separed list of Zabbix servers ZabbixServerList=ZabbixServer1 ZabbixServer1.Address=192.168.0.220 ZabbixServer1.Port=10051 #pidFile OrabbixDaemon.PidFile=./logs/orabbix.pid #frequency of item's refresh OrabbixDaemon.Sleep=300 #MaxThreadNumber should be >= than the number of your databases OrabbixDaemon.MaxThreadNumber=100 #put here your databases in a comma separated list DatabaseList=Monitor-Client6,Monitor-Client5 #Configuration of Connection pool #if not specified Orabbis is going to use default values (hardcoded) #Maximum number of active connection inside pool DatabaseList.MaxActive=10 #The maximum number of milliseconds that the pool will wait #(when there are no available connections) for a connection to be returned #before throwing an exception, or <= 0 to wait indefinitely. DatabaseList.MaxWait=100 DatabaseList.MaxIdle=1 #define here your connection string for each database Monitor-Client6.Url=jdbc:oracle:thin:@192.168.0.237:1521:orcl Monitor-Client6.User=zabbix Monitor-Client6.Password=zabbix Monitor-Client6.MaxActive=10 Monitor-Client6.MaxWait=100 Monitor-Client6.MaxIdle=1 Monitor-Client6.QueryListFile=./conf/query.props Monitor-Client5.Url=jdbc:oracle:thin:@192.168.0.236:1521:orcl Monitor-Client5.User=zabbix Monitor-Client5.Password=vT77$mEdY Monitor-Client5.MaxActive=10 Monitor-Client5.MaxWait=100 Monitor-Client5.MaxIdle=1 Monitor-Client5.QueryListFile=./conf/query.props ``` ##### 坑：閑的沒事把QueryListFile=./conf/query.props給刪了，就不好用了，原來人家那么重要，所有監控數據都要從里面的語句來執行，天啊，我干了什么！！！ 備注1：Monitor-Client5要和zabbix中的主機名一致 備注2： ```shell Oracle = jdbc:oracle:thin:@<host>:<LISTENER_PORT>:<instance> PostgreSQL = jdbc:postgresql://<host>:<port>/<database> MS Sql Server = jdbc:jtds:sqlserver://<host>:<port>/<instancename> MySQL Server = jdbc:mysql://[host:port],[host:port].../[database] DB2 = jdbc:db2://<servername>:<port>/<installation> ``` ### 根據需求修改/conf/query.props 可以根據自己的需求，在里面增加key和對應語句，然后在模板中增加Item ### 數據庫添加權限 標準授權 ```shell CREATE USER ZABBIX IDENTIFIED BY vT77$mEdY DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; --Roles for ZABBIX GRANT CONNECT TO ZABBIX; GRANT RESOURCE TO ZABBIX; ALTER USER ZABBIX DEFAULT ROLE ALL; --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; ``` 最小授權 ```shell CREATE USER ZABBIX IDENTIFIED BY vT77$mEdY 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; ``` ### 1.1.4 監控Oracle11需要在comment中執行 ```shell 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; ``` Oracle12中我并沒有執行這個語句，也沒問題。 ### 1.1.5 配置啟動腳本 ```shell /opt/orabbix/init.d/orabbix to /etc/init.d/orabbix ``` ### 1.1.6 增加服務自啟動 ```shell chkconfig -add orabbix ``` ### 1.1.7 zabbix添加主機和模板