(Another post written for personal documentation)
Download these three packages from Oracle for the proper operating system (32 bit for me):
- Instant Client Basic-Lite
- Instant Client SDK
- Instand Client SQLPlus
Unzip and copy to /opt/oracle/11_2/instantclient
#Oracle client LD_LIBRARY_PATH setting /opt/oracle/11_2/instantclient
sudo ldconfig -v
Symbolic Link to Library
ln -s libclntsh.so.10.1 libclntsh.so
Install Python Library
The library is called cx-oracle. Use your favorite installation method. (Don’t forget about your virtual environment!)
Hope I remembered everything.
Found another post that outlines the procedure maybe a little better than I did, and includes notes on setting up
tnsnames.ora. See Install Oracle Instant Client 11.1 and cx_Oracle 4.4 on Ubuntu 8.04 on Technoblog.