linux安装cx_Oracle并连接oracle

1.百度下载oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm直接双击安装

2.百度下载oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm直接双击安装


3.百度下载cx_Oracle-5.2.tar.gz，解压cx_Oracle-5.2.tar.gz到cx_Oracle-5.2，进入此文件后执行命令python setup.py bulid ;  python setup.py install


4.安装gcc yum install gcc


5.安装python的dev   sudo install python3-devel

注：此为安装python2上面oracle模块，若python3则需将上面命令换成python3

测试：


db=cx_Oracle.connect("用户名/密码@数据库地址/数据库名称")
cr=db.cursor()
cr.execute('select * from 表名')
rs=cr.fetchall()
for i in rs:
    print(i)

cr.close
db.close