Friday, August 26, 2011

Connect Oracle in python

1, download cx_Oracle module


[windows] double click the .msi file


1,download .rpm file,

2, install alien tool in Ubuntu

3, install rpm by command “sudo alien -i cx_Oracle-5.1-10g-py27-1.i386.rpm ”

4, mv cx_Oracle related stuff (cx_Oracle-5.1-py2.7.egg-info & from site-packages/ to dist-packages/

5, add “export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib” in .bashrc

6, source .bashrc


2, install oracle client, express version is enough

[Windows]set system variable: “ORACLE_HOME” to the path of where express client installed, e.g. D:\XEClient, (this step help cx_Oracle locate some DLLs under Client/bin folder)

[Ubuntu] download and install oracle-xe-client_10.2.0.1-1.0_i386.deb


4, make sure you can import cx_Oracle in python correctly now.

python –c ‘import cx_Oracle’


5, start coding in python

conn = cx_Oracle.connect(‘username’, “password”, cx_Oracle.makedsn(‘’, 1521, ‘servicename’)) #connect to db

cur = conn.cursor()

cur.execute(“select * from xxxtable”);

rows = cur.fetchall()

for r in rows:

print r


No comments:

Post a Comment