Skip to content

cx_Oracle.DatabaseError: DPI-1047 #597

@Priyanka493-My

Description

@Priyanka493-My
  1. What versions are you using?
    python 3.7.6 64 bit (AMD64)

Give your database version.
sqldeveloper-21.4.1.349.1822-x64

Also run Python and show the output of:

import sys
import platform

print("platform.platform:", platform.platform())
print("sys.maxsize > 2**32:", sys.maxsize > 2**32)
print("platform.python_version:", platform.python_version())

platform.platform: Windows-10-10.0.18362-SP0
sys.maxsize > 2**32: False
platform.python_version: 3.7.2

And:

import cx_Oracle
print("cx_Oracle.version:", cx_Oracle.version)
print("cx_Oracle.clientversion:", cx_Oracle.clientversion())

cx_Oracle.version: 8.3.0
Then getting this error print("cx_Oracle.clientversion:", cx_Oracle.clientversion())
cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 32-bit Oracle Client library: "The specified module could not be found".

-->

  1. Describe the problem

cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 32-bit Oracle Client library: "The specified module could not be found".
Even installed instantclient-basiclite-windows.x64-21.3.0.0.0 . Mine is a 64 bit laptop. Kindly help.
3. Include a runnable Python script that shows the problem.

import cx_Oracle

Connect as user "hr" with password "welcome" to the "orclpdb1" service running on this computer.

connection = cx_Oracle.connect(user="c##scott", password="XXXXXX",
dsn="localhost:1521/orcl")
print(connection.version)

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions