在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
>>>
搞定。