zabbix下的oracle监控
来源:互联网 发布:java float和Float 编辑:程序博客网 时间:2024/06/05 09:45
原文地址:http://waringid.blog.51cto.com/65148/1579107
1
2
wget http:
//download
.oracle.com
/otn-pub/java/jdk/7u72-b14/jre-7u72-linux-x64
.rpm
rpm –ivh jre-7u72-linux-x64.rpm
1
2
mkdir
–p
/opt/orabbix
cd
/opt/orabbix
1
2
3
4
5
wget http:
//192
.168.0.201:8080/%e5%b8%b8%e7%94%a8%e8%bd%af%e4%bb%b6/%e5%b7%a5%e5%85%b7
/zabbix/orabbix-1
.2.3.zip
unzip orabbix-1.2.3.zip
cp
init.d
/orabbix
/etc/init
.d/
chmod
+x run.sh
chmod
+x
/etc/init
.d
/orabbix
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
CREATE USER ZABBIX
IDENTIFIED BY <REPLACE WITH PASSWORD>
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
2
3
4
5
6
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;
1
select
utl_inaddr.get_host_name(
'127.0.0.1'
) from dual;
1
2
3
cd
conf
cp
config.props.sample config.props
vim config.progs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
ZabbixServerList=ZabbixServer
ZabbixServer.Address=192.168.0.189
ZabbixServer.Port=10051
OrabbixDaemon.PidFile=./logs/orabbix.pid
OrabbixDaemon.Sleep=300
OrabbixDaemon.MaxThreadNumber=100
DatabaseList=CRMDB
DatabaseList.MaxActive=10
DatabaseList.MaxWait=100
DatabaseList.MaxIdle=1
CRMDB.Url=jdbc:oracle:thin:@192.168.0.209:1521:orcl
CRMDB.User=ZABBIX
CRMDB.Password=zabbix
CRMDB.MaxActive=10
CRMDB.MaxWait=100
CRMDB.MaxIdle=1
CRMDB.QueryListFile=./conf/query.props
1
2
3
4
chkconfig –add orabbix
chkconfig –level 345 orabbix on
service orabbix start
tail
–f
/opt/orabbix/log/orabbix
.log
阅读全文
0 0
- zabbix下的oracle监控
- zabbix 监控windows下Oracle
- RHEL6.3下Zabbix监控实践之Zabbix的安装
- RHEL6.3下Zabbix监控实践之Zabbix的安装
- zabbix 监控 oracle 数据库
- 用zabbix 监控 oracle
- Zabbix监控oracle数据库
- Zabbix监控oracle数据库
- [Zabbix] Oracle 监控
- 11.zabbix学习笔记:zabbix监控oracle
- zabbix利用orabbix监控oracle
- Zabbix通过Orabbix监控Oracle
- CentOS下Zabbix监控MySQL
- zabbix 监控windows下tomcat
- zabbix 监控 windows下Mysql
- zabbix 监控windows下redis
- zabbix 监控windows下kafka
- Zabbix 监控 Windows下MySQL
- X11/Xlib.h: No such file or directory X11/xpm.h: No such file or directory
- SharedPreferences详解
- JavaScript基本概念
- 蓝桥杯 第100001个素数
- 史上最清晰的红黑树讲解(上)
- zabbix下的oracle监控
- LeetCode 56 Merge Intervals(Python实现及详解)
- 简单了解Dubbo
- 笔记 树状数组--区间查询+区间修改
- 其他语言无法比拟的Python特性
- android:检查系统是否开启消息通知权限,app应用点击开启通知时跳转到app详情页面开启权限
- rust内存管理
- session的生命周期和有效期
- 现在的计算机内部 一般是采用原码?反码?还是补码?