在Linux系统上实现用Python远程访问Oracle数据库

1、下载oracle软件

http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

oracle-instantclient-basic-10.2.0.4-1.i386.rpm

oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm

oracle-instantclient-devel-10.2.0.4-1.i386.rpm

2、安装rpm包

rpm -ivh oracle-instantclient-basic-10.2.0.4-1.i386.rpm

rpm -ivh oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm

rpm -ivh oracle-instantclient-devel-10.2.0.4-1.i386.rpm

3、配置文件

#vi /etc/ld.so.conf

在最后加入/usr/lib/oracle/10.2.0.4/client/lib

重启ldconfig

ldconfig

vi /root/.bash_profile

增加如下两行：

export ORACLE_HOME=/opt/instantclient_10_2
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME
运行source /root/.bash_profile使改动生效

#vi /etc/profile最后加入

export ORACLE_HOME=/usr/lib/oracle/10.2.0.4/client

export LD_LIBRARY_PATH=:$ORACLE_HOME/lib:/usr/local/lib:$LD_LIBRARY_PATH:.

export TNS_ADMIN=$ORACLE_HOME

export PATH=$PATH:$ORACLE_HOME/bin:.

Oracle安装完成

此时就可以用sqlplus访问远端Oracle数据库了 # sqlplus 用户名/密码@数据库服务器名:端口号/SERVICE

4,下载安装cx_Oracle（源码安装）

python setup.py build

python setup.py install

>>> import cx_Oracle
>>>

搞定。