centos 6.5 64位使用python连接oracle 11g
1.安装oracle客户端
yum install oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
yum install oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
2.配置root用户ORACLE_HOME
export ORACLE_HOME=/usr/lib/oracle/11.2/client64/lib/
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME
3.安装cx_Oracle模块
pip install cx_oracle
4.使用python连接oracle库做查询
#!/usr/bin/python
# -*- coding: UTF-8 -*-
import cx_Oracle as db
import os
os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'
def queryOracle(sql):
username = "dbaro"
passwd = "xxxxxxxxxx"
host = "192.168.2.21"
port = "1521"
sid = "slave"
dsn = db.makedsn(host, port, sid)
con = db.connect(username, passwd, dsn)
cur = con.cursor()
cur.execute(sql)
result = cur.fetchall()
cur.close()
con.close()
return result
if __name__=="__main__":
sql = "select sysdate from dual"
result = queryOracle(sql)
print result
centos 6.5 64位使用python连接oracle 11g
最新推荐文章于 2024-04-25 12:50:57 发布