Home > Article > Backend Development > 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
2. (Refer to http://www.php.cn/ here)
Set environment variables
vi /root/.bash_profileAdd the following two lines:
export ORACLE_HOME=/usr/local/instantclient_10_2 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOMERun 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 [('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!