简介:
python 连接Oracle 过程总结(Linux)
下载Oracle客户端:
需要注册
下面几个(py27代表python2.7版本):
instantclient-basic-linux.x64-12.1.0.2.0.zip
instantclient-sdk-linux.x64-12.1.0.2.0.zip
安装过程:
1.安装包$unzip instantclient-basic-linux.x64-12.1.0.1.0.zip
$sudo cp -r instantclient_12_1 /opt
unzip instantclient-sdk-linux.x64-12.1.0.2.0.zip
cp sdk instantclient_12_1
$vi /etc/profile
export ORACLE_HOME=/opt/instantclient_12_1
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME
$source /etc/profile
2.用PIP安装pip install cx_Oracle
连接方法:import cx_Oracle
con = cx_Oracle.connect( "username", "passwd","(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.2.4)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = mips)))")
curs=con.cursor ()
sql='SELECT * FROM all_users'
rr=curs.execute (sql)
row=curs.fetch()
print row
Oracle 用例PL/SQL(windows):
下载PL/SQL(需要注册)
安装Oralce 客户端
问题:
1.ImportError: libaio.so.1: cannot open shared object file: No such file or directory
原因:yum install libaio
2。ImportError: libclntsh.so.11.1: cannot open shared object file: No such file or directory
原因:ln -s libclntsh.so.12.1 libclntsh.so.11.1
3. /bin/ld: cannot find -lclntsh
原因:
cd/apps/lib/instantclient_12_1
ln -s libclntsh.so.12.1 libclntsh.so
参考资料: