Detailed explanation of Oracle installation and database connection methods

This article mainly introduces the installation of Oracle extensions and database connection methods in Python. It analyzes in more detail the installation steps, operating techniques and precautions for downloading Oracle extensions in Python and Windows and Linux environments. Friends in need can refer to the following

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: cx-oracle.sourceforge.net/
instantclient-basic download address ：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.msiinstantclient-basic-win32-10.2 .0.4.
zip

linux environment:

Required software:

basic-10.2.0.4.0 -linux-x86_64.zip
1. rpm -ivh cx_Oracle-5.1.2-10g-py26-1.x86_64.rpm

Set environment variables

vi /root/.bash_profile

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_OracleBe 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

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