DPI-1047:无法加载64位Oracle客户端库 [英] DPI-1047: 64-bit Oracle Client library cannot be loaded

问题描述

我正在尝试在python中运行oracle数据库. 规格: 1. Windows 7 64位 2. Python 32位3.6(在Jupyter上运行(Anaconda Navigator) 3.Visual Studio 2010培训套件模块 4.Oracle Instant Client基本12.2 32位 5.Oracle Instant Client基本SQL * Plus 12.2 32位

I am trying to run oracle database in python. Specifications: 1. Windows 7 64 bit 2. Python 32 bit 3.6 (Running on Jupyter(Anaconda Navigator) 3.Visual studio 2010 training kit module 4.Oracle instant client basic 12.2 32 bit 5.Oracle instant client basic SQL*Plus 12.2 32 bit

我已经通过命令安装了cx_Oracle 导入系统 ！conda install --yes --prefix {sys.prefix} cx_Oracle 导入cx_Oracle

I have installed cx_Oracle via command import sys !conda install --yes --prefix {sys.prefix} cx_Oracle import cx_Oracle

此后，我在连接Jupyter的同一工作目录中安装了Oracle Instant Client Basic 12.2 32位和Oracle Instant Client Basic SQL Plus 12.2 32位. 我已经将安装的Oracle Instant Client Basic和Instant Client Basic SQL Plus复制到同一文件夹中，并给出了同一文件夹的环境路径. 但是，每当我运行命令时，它都会报错: DPI-1047:无法加载64位Oracle客户端库:"C:\ oracle \ product \ 10.2.0 \ client_1 \ bin \ oci.dll不是正确的体系结构".参见 https://oracle.github.io/odpi/doc/installation.html #windows 获取帮助 虽然没有64位，但我搜索的窗口没有关系.

After that I have installed Oracle instant client basic 12.2 32 bit and Oracle instant client basic SQLPlus 12.2 32 bit in the same working directory from where Jupyter is connected. I have copied both installed Oracle instant client basic and instant client basic SQLPlus in same folder and have given environment path of the same folder. But whenever I am running the command it's giving error: DPI-1047: 64-bit Oracle Client library cannot be loaded: "C:\oracle\product\10.2.0\client_1\bin\oci.dll is not the correct architecture". See https://oracle.github.io/odpi/doc/installation.html#windows for help Although there is nothing of 64 bit except windows which I have search doesn't matter.

推荐答案

您需要安装不是32位的64位Instant Client-此错误很明显.运行Python时，请确保Instant Client在Oracle 10.2目录或任何其他Oracle库的PATH环境变量中之前.

You need to install 64-bit Instant Client not 32-bit - the error is clear about this. When you run Python make sure Instant Client is in your PATH environment variable before the Oracle 10.2 directory, or any other Oracle libraries.

这篇关于DPI-1047:无法加载64位Oracle客户端库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！