Python installation oracle extension and database connection method-Python Tutorial-php.cn

Python installation oracle extension and database connection method

高洛峰

Release： 2017-02-24 14:56:36

Original

1854 people have browsed it

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 http://www.php.cn/ here)

Set environment variables

vi /root/.bash_profile

Copy after login

Add the following two lines:

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

Copy after login

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

Copy after login

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(&#39;user/psw@114.242.113.91:1521/orcl&#39;)
>>> print db
<cx_Oracle.Connection to user@114.242.113.91:1521/orcl>
>>> cr=db.cursor()
>>> cr.execute("select * from LOGININFO")
<__builtin__.OracleCursor on <cx_Oracle.Connection to user@114.242.113.91:1521/orcl>>
>>> rs=cr.fetchall()
>>> print rs
[(&#39;40288a8542746fd90142746fdbb50001&#39;, &#39;cccccc&#39;, 1, 1, None, None, None), (&#39;40288a85427474b601427474b8270001&#39;, &#39;eeee&#39;, 1, 1, None, None, None), (&#39;40288a854273bce0014273bee6310002&#39;, &#39;dddddd&#39;, 0, 0, None, None, None), (&#39;40288a854274532d014274532f600001&#39;, &#39;cccccc&#39;, 1, 1, None, None, None), (&#39;40288a8542747c750142747c77ac0001&#39;, &#39;eeee&#39;, 1, 1, None, None, None), (&#39;40288a8542744fb30142744fb5e90001&#39;, &#39;cccccc&#39;, 1, 1, None, None, None)]
>>>

Copy after login

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