Installing cx_oracle on Ubuntu

The following instructions were tested on Ubuntu 14.04. The main challenge is installing Oracle Instant Client. It is assumed that no Oracle DB or client were previously installed. Otherwise, you can install cx_oracle with pip straight away.

1. Download oracle instant client both basic and sdk zipped packages from http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html. Example:
   instantclient-basic-linux.x64-12.1.0.2.0.zip
   instantclient-sdk-linux.x64-12.1.0.2.0.zip
2. Create folder /opt/oracle
   sudo mkdir -p /opt/oracle
3. Unzip both the basic and sdk packages to /opt/oracle
   sudo unzip instantclient-basic-linux.x64-12.1.0.2.0.zip -d /opt/oracle
   sudo unzip instantclient-sdk-linux.x64-12.1.0.2.0.zip -d /opt/oracle
4. Set ORACLE_HOME and LD_LIBRARY_PATH to unzipped folder. You can choose to
   • Use export command
     export ORACLE_HOME=/opt/oracle/instantclient_12_1
     export LD_LIBRARY_PATH=/opt/oracle/instantclient_12_1
   • Put the variables into /etc/environment (You may need to log out from the shell and log in again for the settings to take effect)
     ORACLE_HOME=/opt/oracle/instantclient_12_1
     LD_LIBRARY_PATH=/opt/oracle/instantclient_12_1
5. Now you can use pip to install cx_oracle
   pip install cx_oracle

References:

• http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html (Refer to the Installation section at the bottom)
• http://stackoverflow.com/questions/13046624/how-to-permanently-export-a-variable-in-linux