ubuntu python install oracle module cx_Oracle

最新推荐文章于 2023-09-01 16:13:54 发布

原创最新推荐文章于 2023-09-01 16:13:54 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#devops

devops 专栏收录该内容

5 篇文章

订阅专栏

本文介绍如何在Linux环境下使用apt-get等工具安装Oracle客户端，并通过alien转换rpm包为deb包，最后利用pip安装cx_Oracle库，实现Python连接Oracle数据库的功能。

apt-get install build-essential unzip python-dev libaio-dev
sudo apt-get install alien
axel -n 10 "http://download.oracle.com/otn/linux/instantclient/122010/oracle-instantclient12.2-basic-12.2.0.1.0-1.i386.rpm?AuthParam=1495872565_a046f44ac7d5a2d7f47f29746e57282d"

sudo alien -i oracle-instantclient12.2-basic-12.2.0.1.0-1.i386.rpm

axel -n 10 "http://download.oracle.com/otn/linux/instantclient/122010/oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm?AuthParam=1495872755_9542a241664febd3f7ab2b8bb7ee894d"

axel -n 10 "http://download.oracle.com/otn/linux/instantclient/122010/oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm?AuthParam=1495873553_cfbb390cd8691a945e872bb030357843"
alien -i oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm

#export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib/
#export ORACLE_HOME=/usr/lib/oracle/12.2/
#export LD_RUN_PATH=/usr/lib/oracle/12.2/
sudo pip install cx_oracle

简单测试

import cx_Oracle
db=cx_Oracle.connect('1','1','1:1521/ora11g')
print db.version
cursor = db.cursor() 
cursor.execute("select * from xxx")
result = cursor.fetchall()
db.close()