ubantu16下的Python 连接oracle安装、环境、测试

一安装oracle for python

pip install cx_oracle

二安装oracle client

下载https://download.csdn.net/download/viviliving/10745136中的

oracle-instantclient12.1-basic_12.1.0.2.0-2_amd64.deb

或者官网下载oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm

sudo apt-get install alien 
sudo alien oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm  #将rpm转换位deb，完成后会生成一个同名的xxxx.deb 
sudo dpkg -i oracle-instantclient12.1-basic_12.1.0.2.0-2_amd64.deb #安装 

三设置oracle环境
sudo sh -c "echo /usr/lib/oracle/12.2/client64/lib > /etc/ld.so.conf.d/oracle-instantclient.conf"
sudo ldconfig

export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib:$LD_LIBRARY_PATH

sudo mkdir -p /usr/lib/oracle/12.2/client64/lib/network/admin

四连接测试

python

>>>

import cx_Oracle
dsnStr = cx_Oracle.makedsn("10.1.1.210", "1521", "orcl")
conn = cx_Oracle.connect(user="test", password="test", dsn=dsnStr)
c=conn.cursor()
x=c.execute('select sysdate from dual    ')
print (x.fetchone())
c.close()
conn.close()