oracle instantClient 安装和配置
下载地址:www.oracle.com/database/te…

解压到文件夹后可添加配置文件tnsnames.ora 配置内容如下
l =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.74.0.101)(PORT = 6379))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
也可以自行添加network/admin文件。
添加环境变量
- 变量名: NLS_LANG 变量值: AMERICAN_AMERICA.ZHS16GBK
- 变量名 TNS_ADMIN 变量值: E:\orcaltools\instantclient_19_5 (自己解压的目录)
- 变量名 ORACLE_HOME 变量值: E:\orcaltools\instantclient_19_5
Error: DPI-1047: Cannot locate a 64-bit Oracle Client 错误解决
cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "The specified module could not be found". See oracle.github.io/odpi/doc/in… for help

将instantclient 目录下的dll文件复制到python所在目录,如下图


问题顺利解决~