zabbix自动备份oracle,Zabbix之监控Oracle性能

我会带着你远行 2022-10-21 04:57 193阅读 0赞

Orabbix 是一个用来监控 Oracle 数据库实例的 Zabbix 插件。

下载地址：http://www.smartmarmot.com/product/orabbix/download/

官方参考：http://www.smartmarmot.com/wiki/index.php/Orabbix

Orabbix插件的安装与配置

确保安装jdk环境，java version查看

\[\[email protected\] ~\]\# java -version

java version "1.6.0\_28"

OpenJDK Runtime Environment (IcedTea6 1.13.0pre) (rhel-1.66.1.13.0.el6-x86\_64)

OpenJDK 64-Bit Server VM (build 23.25-b01, mixed mode)

1. 在/opt目录下新建一个orabbix目录：

\[\[email protected\] orabbix\]\#mkdir -p /opt/orabbix

(建议在此目录下，如果放置其他目录稍后需要更改orabbix的启动文件orabbix,启动文件默认写在opt/orabbix目录下 )

2. 解压安装文件

unzip orabbix-1.2.3.zip -d /opt/orabbix

3. 赋予权限

chmod -R a+x orabbix/

4. 通过/opt/orabbix/conf/config.props.sample文件创建一个config.props文件：

cp/opt/orabbix/conf/config.props.sample /opt/orabbix/conf/config.props

5. 编辑orabbix配置文件,具体如下

vi confi/config.props

\#comma separed list of Zabbix servers

\#ZabbixServerList=ZabbixServer1,ZabbixServer2

ZabbixServerList=ZabbixServer1

\#(zabbixserver的名字，下行中address和port都引用到了这个名字，所以下面两行的前缀名字要与这里的名字保持一致)

\#ZabbixServer1.Address=IP\_ADDRESS\_OF\_ZABBIX\_SERVER

\#ZabbixServer1.Port=PORT\_OF\_ZABBIX\_SERVER

ZabbixServer1.Address=172.16.7.30

ZabbixServer1.Port=10051

\#ZabbixServer2.Address=IP\_ADDRESS\_OF\_ZABBIX\_SERVER

\#ZabbixServer2.Port=PORT\_OF\_ZABBIX\_SERVER

\#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=100

\#put here your databases in a comma separated list

\#DatabaseList=DB1,DB2,DB3

DatabaseList=DB1

\#(名称可随意定义，但要与下文保持一致，切记要与监控的主机名称保持一致)

\#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

\#DB1.Url=jdbc:oracle:thin:@server.domain.example.com::DB1

DB1.Url=jdbc:oracle:thin:@172.16.7.10:1521:LC

\#\#确保有jdk环境，因为这里是通过JDBC连接的,LC为数据库实例名称

DB1.User=ZABBIX \#DB的用户和密码并赋予权限，如下文(这里直接用dba权限用户)

DB1.Password=jeffery

\#Those values are optionals if not specified Orabbix is going to use the gener

al values

DB1.MaxActive=10

DB1.MaxWait=100

DB1.MaxIdle=1

DB1.QueryListFile=./conf/query.props

\#注销未无效的DB链接

\#DB2.Url=jdbc:oracle:thin:@server2.domain.example.com::DB2

\#DB2.User=zabbix

\#DB2.Password=zabbix\_password

\#DB2.QueryListFile=./conf/query.props

\#DB3.Url=jdbc:oracle:thin:@server3.domain.example.com::DB3

\#DB3.User=zabbix

\#DB3.Password=zabbix\_password

\#DB3.QueryListFile=./conf/query.props

6. 创建Oracle账户，并赋予权限

A.创建表空间

CREATE TABLESPACE "ZABBIX" DATAFILE

'/opt/oracle/product/11.2.0/dbs/zabbix01.dbf' SIZE 100M

AUTOEXTEND ON NEXT 524288000 MAXSIZE 32767M

LOGGING ONLINE PERMANENT BLOCKSIZE 8192

EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;

B.创建用户并赋予权限

CREATE USER ZABBIX IDENTIFIED BY "jeffery" DEFAULT TABLESPACE ZABBIX TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;

alter user ZABBIX quota unlimited on ZABBIX;

GRANT CONNECT TO ZABBIX;

GRANT RESOURCE TO ZABBIX;

ALTER USER ZABBIX DEFAULT ROLE ALL;

GRANT SELECT ANY TABLE TO ZABBIX;

GRANT CREATE SESSION TO ZABBIX;

GRANT SELECT ANY DICTIONARY TO ZABBIX;

GRANT UNLIMITED TABLESPACE TO ZABBIX;

GRANT SELECT ANY DICTIONARY TO ZABBIX;

C.11g数据库还需要执行下面操作

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;

select utl\_inaddr.get\_host\_name('127.0.0.1') from dual;

7. 创建orabbix启动文件

cp /opt/orabbix/init.d/orabbix /etc/init.d/orabbix

chmod +x /etc/init.d/orabbix

chmod +x /opt/orabbix/run.sh

chkconfig --add orabbix

chkconfig --level 345 orabbix on

8. 到此，安装配置完成，则通过web页面访问直接导入模块即可

Template 存放路径在现在文件的template目录中

Orabbix\_export\_full.xml 全部导入(图表 监控项 触发器)

Orabbix\_export\_graphs.xml 图表

Orabbix\_export\_items.xml 监控项

Orabbix\_export\_triggers.xml 触发器

选中Orabbix\_export\_full.xml直接导入，则可以直接在主机中链接到模版就可以使用全部功能了(主机名称一定要与配置中的 DatabaseList=DB1保持一致)！

![4ff62161469e81be9a4d73f2dd7b2984.png][]

关联模板

![fef57bb5841552d569fcaef78e348b9b.png][]

9. 启动orabbix 看是否能收集到Oracle数据库信息

出现如下信息那么就配置成功了

\[\[email protected\] ~\]\# tailf /opt/orabbix/logs/orabbix.log

2014-07-19 21:17:09,982 \[pool-1-thread-57\] INFO Orabbix - Done with dbJob on database DB1 QueryList elapsed time 126 ms

2014-07-19 21:18:09,881 \[pool-1-thread-58\] INFO Orabbix - Done with dbJob on database DB1 QueryList elapsed time 5 ms

2014-07-19 21:20:09,917 \[pool-1-thread-60\] INFO Orabbix - Done with dbJob on database DB1 QueryList elapsed time 16 ms

常见问题：

若config.props文件未配置，或是配置了错误，无法通过配置的信息正确连进Oracle数据库的，会出现以下错误信息

\[\[email protected\] orabbix\]\# /etc/init.d/orabbix start

Starting Orabbix service:

\[\[email protected\] orabbix\]\# Stopping

java.lang.Exception: ERROR on main - Connections is empty

atcom.smartmarmot.orabbix.Orabbixmon.run(Orabbixmon.java:101)

atcom.smartmarmot.orabbix.bootstrap.main(bootstrap.java:50)

可查看log信息判断解决

\[\[email protected\] orabbix\]\# tail -f /opt/orabbix/logs/orabbix.log

上图：

![1dc3e349c9f28a6f38123be15a845a08.png][]

参考文档：http://www.smartmarmot.com/wiki/index.php/Orabbix

[4ff62161469e81be9a4d73f2dd7b2984.png]: /images/20221021/99e72bdd11d9402190cc965d932a3e2c.png
[fef57bb5841552d569fcaef78e348b9b.png]: /images/20221021/705039e2380d48c09011ca7ac9ba93f8.png
[1dc3e349c9f28a6f38123be15a845a08.png]: /images/20221021/96ad5a91a7b841899edeca38b7cbf0b5.png