zabbix 监控oracle 模版

280881254 发表于 2017-5-1 15:37:09

yuky11 发表于 2017-5-15 18:13:51

枫狐狸 发表于 2017-5-16 10:11:15

************************************************************************************
************************************************************************************
***
***                         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

zjhzgl 发表于 2018-1-31 13:35:27

好东西，收藏了

廷忠发表于 2018-3-12 16:53:13

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

EricZho_l3ssA 发表于 2019-1-31 17:00:39

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

ha00012 发表于 2019-2-13 17:45:48

瞅瞅

ha00012 发表于 2019-2-21 16:17:01

多少积分

ha00012 发表于 2019-2-21 18:06:09

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

ha00012 发表于 2019-2-21 18:18:45

没*.sh脚本

页: [1]

运维网's Archiver

zabbix 监控oracle 模版