ZABBIX之ORACLE監控

標籤：

1，安裝JDK

 2，安裝orabbixwget http://www.smartmarmot.com/downloads/orabbix-1.2.3.zipmkdir /opt/orabbixmv orabbix-1.2.3.zip /opt/orabbixcd /opt/orabbixunzip orabbix-.1.2.3.zip 3, 授權chmod +x /opt/orabbix/run.shchmod +x /opt/orabbix/init.d/orabbix cp /opt/orabbix/conf/config.props.sample config.props 4，配置config.propscat /opt/orabbix/conf/config.props |grep -v "#"            這裡僅取沒有注釋的。ZabbixServerList=ZabbixServer          #zabbix名稱  ZabbixServer.Address=192.168.0.119     #zabbix服務端的IP地址ZabbixServer.Port=10051                #zabbix服務端的連接埠    OrabbixDaemon.PidFile=./logs/orabbix.pidOrabbixDaemon.Sleep=300OrabbixDaemon.MaxThreadNumber=100  DatabaseList=pfs-dev               #這個名稱可以隨便起，但是必須跟監控的主機名稱保持一致。  DatabaseList.MaxActive=10DatabaseList.MaxWait=100DatabaseList.MaxIdle=1  twstcptest.com.Url=jdbc:oracle:thin:@192.168.32.48:1521:pfstest  #這裡主要是通過JDBC來串連用戶端的。rdcms主要是資料庫的執行個體名稱。在用戶端可以通過select instance_name from v$instance來得到執行個體的名稱。twstcptest.com.User=zabbix      #資料庫使用者twstcptest.com.Password=zabbix  #資料庫使用者密碼twstcptest.com.MaxActive=10twstcptest.com.MaxWait=100twstcptest.com.MaxIdle=1twstcptest.com.QueryListFile=./conf/query.props 5, oracle資料庫許可權配置su - oracle       export ORACLE_SID=pfstestsqlplus / as sysdba 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; 6, 啟動orabbix/opt/orabbix/run.shps aux|grep orabbix 

ZABBIX之ORACLE監控