ubuntu cx_Oracle安装手记

ubuntu cx_Oracle安装手记
(1)$sudo apt-get install python-dev  //对于缺少python.h的某些版本
(2) http://cx-oracle.sourceforge.net/ 下载Source Code only.我下的版本是
cx_Oracle-5.0.tar.gz.
$tar zxvf cx_Oracle-5.0.tar.gz
$cd cx_Oracle-5.0
$setup python build
$setup python install   //这一步提示权限不够
改成root用户#setup python install
(3)>>>import cx_Oracle
ImportError: libclntsh.so.10.1: cannot open shared object file: No such file or directory

$locate libclntsh.so.10.1
/home/oracle/ora10/lib/libclntsh.so.10.1

查看BUILD.txt文档可知，需要设置环境变量ORACLE_HOME and LD_LIBRARY_PATH.
在.bashrc文件里面添加:
export ORACLE_HOME=/home/oracle/ora10/
export LD_LIBRARY_PATH=/home/oracle/ora10/lib:$LD_LIBRARY_PATH

$source .bashrc
问题解决

注意:
    我是在本地的机子上安装的oracle和python,所以不存在安装客户端的问题.需要在oracle网站上下载instantclient basic版本,然后ln -s libclntsh.so.x.x libclntsh.so(这个没试过)

转载于:https://www.cnblogs.com/gobird/archive/2011/01/13/1934978.html