Home  >  Article  >  Backend Development  >  Python installation oracle extension and database connection method

Python installation oracle extension and database connection method

高洛峰
高洛峰Original
2017-02-24 14:56:361808browse

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

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
<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)]
>>>

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn