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
Cloning into 'Pyora'...
remote: Counting objects: 17, done.
remote: Compressing objects: 100% (14/14), done.
remote: Total 17 (delta 2), reused 16 (delta 1)
Unpacking objects: 100% (17/17), done.
然后在/etc/zabbix_agentd.conf 中添加
UserParameter=pyora[*],/home/zabbix/scripts/pyora.py --username $1 --password $2 --address $3 --database $4 $5 $6 $7 $8
我是通过zabbix-server端的zabbix-agent监控其他机器的oracle数据库，导入模板zabbix-template/Pyora.xml到你的主机
{$ADDRESS} 192.168.0.1
{$DATABASE} MY_ORACLE_DATABASE
{$USERNAME} zabbix
{$PASSWORD} zabbix
{$ARCHIVE} VGDATA
{$HIGH} 90。