zabbix 监控oracle 模版

280881254

zabbix 监控oracle 模版

yuky11

赞

枫狐狸

************************************************************************************
************************************************************************************
***                                                                              
***                           Orabbix  安装方法                                 
***                                                                              
************************************************************************************
************************************************************************************
======================================================================
上传orabbix.tar到/home/zabbix/目录
tar -xvf zabbix_orabbix.tar
cd orabbix
cp init.d/orabbix /etc/init.d/
chmod 755 /etc/init.d/orabbix
chkconfig --add orabbix
chkconfig orabbix on
##数据库添加zabbix用户，并赋权
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 DBA_SEGMENTS 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 sys.dba_tablespaces TO ZABBIX;
GRANT SELECT ON dba_data_files TO ZABBIX;
GRANT SELECT ON V_$session TO ZABBIX;
GRANT SELECT ON V_$parameter TO ZABBIX;
GRANT SELECT ON V_$locked_object TO ZABBIX;
GRANT SELECT ON dba_objects TO ZABBIX;
GRANT SELECT ON V_$LOG_HISTORY TO ZABBIX;
GRANT SELECT ON V_$archived_log TO ZABBIX;
GRANT SELECT ON V_$asm_diskgroup TO ZABBIX;
GRANT SELECT ON V_$BACKUP_FILES to ZABBIX;
GRANT create view to zabbix;
GRANT SELECT ON dba_autotask_client TO ZABBIX;
create view zabbix.asm_diskgroup as
select name,
       total_mb,
       free_mb,
       round((total_mb-free_mb) / total_mb, 3) * 100 "used %"
  from v$asm_diskgroup;
  
drop view zabbix.BACKUP_FILES;
create view zabbix.BACKUP_FILES as  
select 'DATAFILE' as name,
       TO_CHAR(sum(bytes)) as bytes,
       substr(fname, 1, instr(fname, '/', 1, 3) - 1) as fname,
       TO_CHAR(completion_time,'yyyy/mm/dd') as time
  from V$BACKUP_FILES
where status = 'AVAILABLE'
   and backup_type = 'BACKUP SET'
   and OBSOLETE = 'NO'
   and bs_type = 'DATAFILE'
group by substr(fname, 1, instr(fname, '/', 1, 3) - 1),TO_CHAR(completion_time,'yyyy/mm/dd')
union
select 'ARCHIVED' as name,
       TO_CHAR(sum(bytes)) as bytes,
       substr(fname, 1, instr(fname, '/', 1, 3) - 1) as fname,
       TO_CHAR(completion_time,'yyyy/mm/dd') as time
  from V$BACKUP_FILES
where status = 'AVAILABLE'
   and backup_type = 'BACKUP SET'
   and OBSOLETE = 'NO'
   and bs_type = 'ARCHIVED LOG'
group by substr(fname, 1, instr(fname, '/', 1, 3) - 1),TO_CHAR(completion_time,'yyyy/mm/dd');

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;

##########################################################################
## 修改conf/config.props内容
#comma separed list of Zabbix servers
ZabbixServerList=ZabbixServer1
ZabbixServer1.Address=10.238.0.180
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=1
#put here your databases in a comma separated list
DatabaseList=xxxxxx
#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
xxxxxx.Url=jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:xxxdb1  #单实例方式
#xxxxxx.Url=jdbc:oracle:thin:@//xxx.xxx.xxx.xxx:1521/xxxDB   #RAC方式
xxxxxx.User=zabbix
xxxxxx.Password=zabbix
#Those values are optionals if not specified Orabbix is going to use the general values
xxxxxx.MaxActive=10
xxxxxx.MaxWait=100
xxxxxx.MaxIdle=1
xxxxxx.QueryListFile=./conf/query.props


##########################################################################
## 添加 zabbix_Oracle 监控项
cat >> /etc/zabbix/zabbix_agentd.conf <<END
UserParameter=ora.tab.discovery,/home/zabbix/orabbix/scripts/oracle_discovery.sh 2>/dev/null
UserParameter=tablespace

,/home/zabbix/orabbix/scripts/oracle_check.sh \$1 \$2
END
cat >> /etc/zabbix/zabbix_agentd.conf <<END
UserParameter=ora.asm.discovery,/home/zabbix/orabbix/scripts/oracle_asm_discovery.sh 2>/dev/null
UserParameter=asmspace

,/home/zabbix/orabbix/scripts/oracle_asm_check.sh \$1 \$2
END
cat >> /etc/zabbix/zabbix_agentd.conf <<END
UserParameter=ora.bak.discovery,/home/zabbix/orabbix/scripts/oracle_bak_discovery.sh 2>/dev/null
UserParameter=bak

,/home/zabbix/orabbix/scripts/oracle_bak_check.sh \$1 \$2
END
service zabbix_agentd restart


zbx_export_oracle.rar (5.27 KB, 下载次数: 9)

2017-5-16 10:04 上传

点击文件名下载附件

orabbix.part1.rar (1.5 MB, 下载次数: 2)

2017-5-16 10:07 上传

点击文件名下载附件

orabbix.part2.rar (1.5 MB, 下载次数: 2)

2017-5-16 10:07 上传

点击文件名下载附件

orabbix.part3.rar (1.5 MB, 下载次数: 2)

2017-5-16 10:07 上传

点击文件名下载附件

orabbix.part4.rar (100.81 KB, 下载次数: 2)

2017-5-16 10:07 上传

点击文件名下载附件

zjhzgl

好东西，收藏 了

廷忠

居然要积分 好东西能不能免积分共享

EricZho_l3ssA

居然要积分 好东西能不能免积分共享

ha00012

瞅瞅

ha00012

多少积分

ha00012

orabbix1，2，3，4部分怎么使用

ha00012

没*.sh脚本