zabbix通过pyora监控oracle数据库

Zabbix 通过pyora监控oracle

1.oracle客户端的安装

从oracle官方网站上下载客户端，devel和sqlplus程序或者从以下网址下载/s/1mgx8Fsk

以root用户安装

rpm –ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

rpm –ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

rpm –ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

vim /root/.bashrc添加

export ORACLE_HOME=/usr/lib/oracle/11.2/client64

export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib

export TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin

export PATH=$PATH:$ORACLE_HOME/bin

设置好环境变量之后执行

source /root/.bashrc

创建文件/etc/ld.so.conf.d/oracle.conf添加

/usr/lib/oracle/11.2/client64/lib

执行命令ldconfig

创建连接文件

在ORACLE_HOME目录下创建以下目录network/admin,并创建文件tnsnames.ora,内容如下:

vim /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora

orcl =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

测试

执行

[root@Monitor ~]# sqlplus system/admin@orcl

SQL*Plus: Release 11.2.0.4.0 Production on Thu May 8 14:25:07 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL>

测试成功！

注：

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

说明环境变量没有生效！

SQL> conn system/oracle@depdb1

ERROR:

ORA-21561: OID generation failed

检查自己的/etc/hosts文件，修改/etc/hosts

127.0.0.1 localhost localhost.localdomain

192.168.0.10 orcl orcl

192.168.0.110 Monitor Monitor

2. python库cx_Oracle的安装

下载/project/cx-oracle/5.1.1/cx_Oracle-5.1.1-1.src.rpm 或者从/s/1gdeLYEJ

[root@devel ~]# rpm -ivh cx_Oracle-5.1.1-1.src.rpm

1:cx_Oracle

########################################### [100%]

[root@devel ~]# cd ~/rpmbuild/SPECS

[root@devel ~]# ORACLE_HOME=/usr/lib/oracle/11.2/client64/ rpmbuild -ba cx_Oracle.spec

[root@devel ~]# cd ../RPMS/x86_64

[root@devel ~]# rpm -ivh cx_Oracle-5.1.1-1.x86_64.rpm

Preparing...

########################################### [100%] 1:cx_Oracle

########################################### [100%]

注：

因为我的系统的python版本是2.6 所以要将Oracle.spec中的python2.4改为python2.6

3.pyora下载安装

利用pyora监控oracle数据库需要用到cx_Oracle和oracle客户端，安装pyora 之前请确保前两个软件安装完毕

下载pyora

[root@Monitor ~]# cd /tmp/

[root@Monitor tmp]#git clone https:///bicofino/Pyora.git