install cx_Oracle on Linux

step 1 : install oracle client library

    url: http://www.oracle.com/technetwork/topics/linuxsoft-082809.html

   or search:  instant clients download for Linux x86

   download:    instantclient-basic-linux-version.zip   # choose your version !!!!

                       instantclient-sdk-linux-version.zip     # header files to compile cx_Oracle

  unzip them to one directory (./libclntsh.so ./include ./admin .....)

 

step 2: config enviroment variables

    export ORACLE_HOME=/path/to/instantclient   # must

    config LD_LIBRARY_PATH ( i used it but failed, so i edit file /etc/ld.so.conf)

    after edit ld.so.conf file, you need run ldconfig (as root)

 

step 3: install cx_Oracle

  prepare: Python.h

           yum install python-devel or  apt-get install python-dev

 cause "/usr/bin/ld: cannot find -lclntsh", you need do this 

           cd $ORACLE_HOME

           ln -s libclntsh.so.version libclntsh.so # repalce version to right num

 

now you can do this:

        pip install cx_Oracle

 

Use Binary Way ( like windows ):

Files: https://pypi.python.org/pypi/cx_Oracle  http://sourceforge.net/projects/cx-oracle/

 

 

Test:

import cx_Oracle

cx_Oracle.connect('username','password','host/service_name',cx_Oracle.SYSDBA)

　　

Good Luck