oracle instantClient 安装配置及Error: DPI-1047: Cannot locate a 64-bit Oracle Client

4,641 阅读1分钟

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所在目录,如下图

问题顺利解决~