|
发表于 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
zbx_export_oracle.rar
(5.27 KB, 下载次数: 9)
orabbix.part1.rar
(1.5 MB, 下载次数: 2)
orabbix.part2.rar
(1.5 MB, 下载次数: 2)
orabbix.part3.rar
(1.5 MB, 下载次数: 2)
orabbix.part4.rar
(100.81 KB, 下载次数: 2)
|
|