Lepus监控之Oracle配置

1.安装cx_Oracle

a.官网下载客户端组件包

oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm

b.使用rpm命令安装上面给的三个包

rpm -ivh oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
rpm -ivh oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm
rpm -ivh oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm

c.配置系统环境变量

vi ~/.bash_profile
添加：
export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib/:$LD_LIBRARY_PATH

source ~/.bash_profile ##生效

vi /etc/ld.so.conf.d/oracle.conf
添加：
/usr/lib/oracle/12.2/client64/lib/
执行ldconfig ##生效

vi /etc/profile.d/oracle.sh
添加：
export ORACLE_HOME=/usr/lib/oracle/12.2/client64
export PATH=$PATH:$ORACLE_HOME/bin
export PATH=$PATH:$ORACLE_HOME/lib

chmod +x /etc/profile.d/oracle.sh
/etc/profile.d/oracle.sh ##生效

ln -s /usr/include/oracle/12.2/client64 $ORACLE_HOME/include
ln -s /usr/lib/oracle/12.2/client64/lib/libclntsh.so.12.1 libclntsh.so.11.1 ##否则安装cx_Oracle会报错

检查环境是否配置完成：ls $ORACLE_HOME

d.下载cx_Oracle-5.1.2.tar.gz

tar -xzvf cx_Oracle-5.1.2.tar.gz
cd cx_Oracle-5.1.2
python setup.py install

e.验证

[root@lepus lepus]# python
Python 2.7.5 (default, Jul 13 2018, 13:06:57)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-28)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>>

2.登录被监控数据库创建监控账号

create user lepus_monitor identified by "root123";

grant connect,resource to lepus_monitor;

grant select on v_$parameter to lepus_monitor ;

grant select on v_$sysstat to lepus_monitor ;

grant select on v_$instance to lepus_monitor ;

grant select on v_$database to lepus_monitor ;

grant select on product_component_version to lepus_monitor ;

grant select on v_$session to lepus_monitor ;

grant select on v_$dataguard_stats to lepus_monitor ;

grant select on dba_data_files to lepus_monitor ;

grant select on dba_free_space to lepus_monitor ;

3.Lepus oracle驱动验证

[root@lepus lepus]# python test_driver_oracle.py

Oracle python drivier is ok!

4.登录监控平台，新建Oracle监控

5.监控平台执行验证

[root@lepus lepus]# python check_oracle.py

2018-11-26 13:34:15 [INFO] check oracle controller start.

2018-11-26 13:34:16 [INFO] check oracle controller finished.

[root@lepus lepus]#

附上python连接Oracle测试脚本

方法一：

import cx_Oracle

dsn_tnsstr = cx_Oracle.makedsn('10.1.21.31','1521', 'pdb1')

#dsn_tns = dsn_tnsstr.replace('SID', 'SERVICE_NAME')

username="lepus_monitor"

userpwd="root123"

conn = cx_Oracle.connect(username,userpwd,dsn_tns)

sql="select FILE_NAME,TABLESPACE_NAME from dba_data_files"

curs = conn.cursor()

result = curs.execute(sql)

g = lambda k:"%-8s" % k

i=1

for row in result.fetchmany(2):

	print str(i)+'\t',

	for k in map(g,row):

		print k+'\t',

	print

	i+=1

curs.close()

方法二：

import cx_Oracle

host="10.1.21.31"

port="1521"

dsn="pdb1"

url=host+':'+port+'/'+dsn

#dsn_tnsstr = cx_Oracle.makedsn('10.1.21.31','1521', 'pdb1')

#dsn_tns = dsn_tnsstr.replace('SID', 'SERVICE_NAME')

username="lepus_monitor"

userpwd="root123"

#conn = cx_Oracle.connect(username,userpwd,dsn_tns)

conn=cx_Oracle.connect(username,userpwd,url)

sql="select FILE_NAME,TABLESPACE_NAME from dba_data_files"

curs = conn.cursor()

result = curs.execute(sql)

g = lambda k:"%-8s" % k

i=1

for row in result.fetchmany(2):

	print str(i)+'\t',

	for k in map(g,row):

		print k+'\t',

	print

	i+=1

curs.close()

quit()

巴特西