1. 安装oracle client
linux:
https://www.cnblogs.com/chenjianhong/archive/2013/06/08/4144771.html
(1)下载client
https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
我用11.2版本作示例
(2)解压后,把 libclntsh.so.11.1 复制并重命名为 libclntsh.so
所需文件:https://wws.lanzous.com/iAWZuktckkb
(3)将所有文件复制到 /usr/lib
-- 若报错 无libaio.so.1文件
-- apt-get update 再 apt-get install libaio1 libaio-dev
-- 或 yum install libaio
win10:
把文件复制到lib路径
-- 查看lib路径
-- import sys
-- sys.path
所需文件:https://wws.lanzous.com/iTtcqktcmng
2. 安装cx_oracle
linux:
pip install cx-Oracle
win10:
当时pip安装报错
改成到官方下载whl文件,再安装
-- pip install xxx.whl
-- pip uninstall xxx.whl
https://pypi.org/project/cx-Oracle/#history
import cx_Oracle
conn = cx_Oracle.connect('c##admin/admin@192.168.3.102/orcl')
# conn = cx_Oracle.connect('user/passwd@host/instance')