1.pip install cx-oracle
2.下载oracle客户端并解压,添加环境变量<The Instant Client directory must occur in PATH
before any other Oracle directories>,下载链接:
Instant Client for Microsoft Windows (x64) 64-bit
3.将oracle客户端主目录下的oci,oraocci11,oraociei11的3个DLL文件复制到python安装目录<D:\python27>
4.测试链接
import cx_Oracle conn = cx_Oracle.connect("user/password@ip:port/orcl") cur = connection.cursor() cur.execute("select 'hello world!' from dual") while True: row = cur.fetchone() if row is None: break print(row) cur.close()
conn.close()
报错:<DatabaseError: DPI-1047: 64-bit Oracle Client library cannot be loaded: %1不是有效的win32程序>
报错原因: win7跟python都是 64位,oracle客户端是32位;
解决方法:重新下载对应oracle64位客户端,将oci,oraocci11,oraociei11的3个DLL文件复制到python安装目录<D:\python27>;
#记录留痕
#<cx_Oracle6.0.2><python2.7><win7x64>