Python installation oracle extension and database connection method

The example in this article describes the installation of Oracle extension and database connection method in Python. Share it with everyone for your reference, the details are as follows:

Download:

cx_Oracle download address: http://cx-oracle.sourceforge.net/instantclient -basic

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

Window environment:

python27 oracle10

Required software:

cx_Oracle- 5.1.2-10g.win32-py2.7.msi
instantclient-basic-win32-10.2.0.4.zip

1. Double-click the msi file directly to install cx_Oracle;

2. Unzip instantclient-basic-win32-10.2.0.4.zip and copy all the obtained .dll files to the F:\Python27\Lib\site-packages directory

linux environment :

python26 orracle10

Required software:

##cx_Oracle-5.1.2-10g- py26-1.x86_64.rpmbasic-10.2.0.4.0-linux-x86_64.zip

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

2. (Refer to //m.sbmmt.com/ here)

Set environment variables

vi /root/.bash_profile

Add the following two lines:

export ORACLE_HOME=/usr/local/instantclient_10_2
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME

Run source /root/.bash_profile to make the changes take effect

Create a symbolic link to this link library

cd $ORACLE_HOME
ln -s libclntsh.so.x.x libclntsh.so

Reinstall cx_Oracle

Be careful to add the --nodeps parameter, otherwise the above error will be reported

[root@BJ-UPDATE-01 ~]# rpm -ivh --nodeps cx_Oracle-5.0 .1-10g-py24-1.x86_64.rpm

#5.0.3 version does not need to add the --nodeps parameter

Test:

#Python
>>> import cx_Oracle
>>> db = cx_Oracle.connect('user/psw@114.242.113.91:1521/orcl')
>>> print db

>>> cr=db.cursor()
>>> cr.execute("select * from LOGININFO")
<__builtin__.OracleCursor on >
>>> rs=cr.fetchall()
>>> print rs
[('40288a8542746fd90142746fdbb50001', 'cccccc', 1, 1, None, None, None), ('40288a85427474b601427474b8270001', 'eeee', 1, 1, None, None, None), ('40288a854273bce0014273bee6310002', 'dddddd', 0, 0, None, None, None), ('40288a854274532d014274532f600001', 'cccccc', 1, 1, None, None, None), ('40288a8542747c750142747c77ac0001', 'eeee', 1, 1, None, None, None), ('40288a8542744fb30142744fb5e90001', 'cccccc', 1, 1, None, None, None)]
>>>

For more articles related to Python installation oracle extensions and database connection methods, please pay attention to the PHP Chinese website!