老牛博客,源自生活
让知识服务生活

导航

 

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
>>>

搞定。
posted on 2012-04-25 17:04  GeekyNiu  阅读(708)  评论(0编辑  收藏  举报