Install Oracle (cx_Oracle) module for Python

cx_Oracle 5.0

Oracle Database connector module for Python

I came across several (CodingNaked WebSite & Pedro Emanuel de Castro Faria Blog ) howTo's on the internet explaining how to compile and install previous versions of this connector. I decided to write my own howTo describing the latest version of the module (as of writing cx_Oracle 5.0).

(I am assuming you have the Xcode developers tools already installed since you will need the GCC compiler)

You need the follwing software:

Oracle Instant Client
cx_Oracle Module 5.0

Download the following packages from the Oracle Instant client site:

Instant Client Package - Basic
Instant Client Package - SQL*Plus
Instant Client Package - SDK

Extact all of these, then place their contents into a single directory

In my case I created a director called /opt/oracle/instantclient_10_2, and place all of the contents from all three archives in this directory.

Then run the following commands (assuming you created the same directory)

cd /opt/oracle/instantclient_10_2

ln -s libclntsh.dylib.10.1libclntsh.dylib

Now you need to edit you profile:

sudo nano -w /etc/profile

Copy and paste the below (Please note the paths and adjust accordingly)

ORACLE_HOME="/opt/oracle"

export ORACLE_HOME

 

DYLD_LIBRARY_PATH="$ORACLE_HOME/instantclient_10_2"

export DYLD_LIBRARY_PATH

 

SQLPATH="$ORACLE_HOME/instantclient_10_2"

export SQLPATH

 

export PATH="$PATH:$ORACLE_HOME/instantclient_10_2"

now run the following commands (you need to do this or the build will fail).

cd /opt/oracle/

ln -s libclntsh.dylib.10.1libclntsh.dylib

I extracted the cx_Oracle module to /opt/oracle/cx_Oracle-5.0. All you have to do now is run these commands at the module will be built and installed.

cd /opt/oracle/cx_Oracle-5.0

sudo python setup.py build

sudo python setup.py install

原文转自:  http://wiki.unixcraft.com/display/MainPage/Install+Oracle+(cx_Oracle)+module+for+Python