Connect Oracle (11g) database with Python

Preparation: 1, download the corresponding version of Oracle-instantclient (I here is 11.2.0.1.0)

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

2. Installation

-ivh oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm

3. Configure Environment variables

LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:$LD_LIBRARY_PATHPATH=/usr/lib/oracle/11.2/client64/bin:$PATH

4. Start your development (we use Python) to develop: Python connects Oracle database requires Cx_oracle1, download

http://sourceforge.net/projects/cx-oracle/

2. Installation

I download the RPM package, the installation is very simple

-ivh cx_Oracle-5.1.2-11g-py26-1.x86_64.rpm

3. Start your development.

python 2.6  .6  (r266: 84292 , Jan 22  2014 , 09 : 42 : 36 ) [GCC 4.4  .7   20120313  (Red Hat 4.4  .7 -4 )" On Linux2type ,  " Copyright ", " credits " or  " license " for  more information. >>>  import  cx_oracle>>> 

Connect Oracle (11g) database with Python