python Oracle connection issue

[hjsdssz]

1. What is your version of Python? Is it 32-bit or 64-bit?
   Python 32-bit

2. What is your cx_Oracle version?
   6.4.1

3. What exact command caused the problem (e.g. what command did you try to install with)? Who were you logged in as?
   import cx_Oracle
   conn_str = u'postpaid/ppaid4apc@CAMPPR-scan.corp.ads:41521/CAMPPRsv1.WORLD'
   conn=cx_Oracle.connect(conn_str)

4. What error(s) you are seeing?
   DatabaseError: DPI-1047: 32-bit Oracle Client library cannot be loaded: "The specified module could not be found".

5. What OS (and version) is Python executing on?
   Python 3.6

6. What is your version of the Oracle client (e.g. Instant Client)? How was it installed? Where is it installed?
   12.2
   From Oracle website

7. What is your Oracle Database version?
   Oracle Database 11g Enterprise Edition

8. What is the PATH environment variable (on Windows) or LD_LIBRARY_PATH (on Linux) set to? On macOS, what is in ~/lib?
   C:\Oracle\instantclient_12_2

9. What Oracle environment variables did you set? How exactly did you set them?
   PATH2

10. Do you have a small, single Python script that immediately runs to show us the problem?
    no

[anthony-tuininga]

Which package did you install? Did you install a 64-bit package instead of a 32-bit package?

[hjsdssz]

Hi, Anthony:

I installed 32-bit Python and 32-bit Oracle.
Thanks!

[anthony-tuininga]

So did that correct your issue? If so, please close it! Thanks.

[hjsdssz]

Hi, sorry. I provided incorrect information, and looks like my Oracle Server is 64-bit, so I redownloaded 64-bit Python 3.6, but I still got the same error message.
Here is the update information:

1.What is your version of Python? Is it 32-bit or 64-bit?
Python 64-bit

2.What is your cx_Oracle version?
6.4.1

3.What exact command caused the problem (e.g. what command did you try to install with)? Who were you logged in as?
import cx_Oracle
conn_str = u'postpaid/ppaid4apc@CAMPPR-scan.corp.ads:41521/CAMPPRsv1.WORLD'
conn=cx_Oracle.connect(conn_str)

4.What error(s) you are seeing?
DatabaseError: DPI-1047: 64-bit Oracle Client library cannot be loaded: "The specified module could not be found".

5.What OS (and version) is Python executing on?
Python 3.6

6.What is your version of the Oracle client (e.g. Instant Client)? How was it installed? Where is it installed?
18.3 64-bit
From Oracle website
http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/index.html

7.What is your Oracle Database version?
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

8.What is the PATH environment variable (on Windows) or LD_LIBRARY_PATH (on Linux) set to? On macOS, what is in ~/lib?
C:\Oracle\instantclient\instantclient_18_3

9.What Oracle environment variables did you set? How exactly did you set them?
PATH2

10.Do you have a small, single Python script that immediately runs to show us the problem?
no

[anthony-tuininga]

Please check the cx_Oracle installation documentation and confirm that you are doing everything there. In particular, did you install the relevant Visual Studio redistributable?

[hjsdssz]

Yes. I did follow each step and install Visual Studio redistributable.

[cjbj]

@hjsdssz you'll need to provide more details about what is set and what you are running. We can't guess

[hjsdssz]

@cjbj hey the details has been provided here, baiscally the issue is my Oracle and Python are both 64-bit, but somehome I cannot connect to Oracle by using Python by showing 'DatabaseError: DPI-1047: 64-bit Oracle Client library cannot be loaded: "The specified module could not be found".'
What else information do you need?
Let me know, thanks!

1.What is your version of Python? Is it 32-bit or 64-bit?
Python 64-bit

2.What is your cx_Oracle version?
6.4.1

3.What exact command caused the problem (e.g. what command did you try to install with)? Who were you logged in as?
import cx_Oracle
conn_str = u'postpaid/ppaid4apc@CAMPPR-scan.corp.ads:41521/CAMPPRsv1.WORLD'
conn=cx_Oracle.connect(conn_str)

4.What error(s) you are seeing?
DatabaseError: DPI-1047: 64-bit Oracle Client library cannot be loaded: "The specified module could not be found".

5.What OS (and version) is Python executing on?
Python 3.6

6.What is your version of the Oracle client (e.g. Instant Client)? How was it installed? Where is it installed?
18.3 64-bit
From Oracle website
http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/index.html

7.What is your Oracle Database version?
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

8.What is the PATH environment variable (on Windows) or LD_LIBRARY_PATH (on Linux) set to? On macOS, what is in ~/lib?
C:\Oracle\instantclient\instantclient_18_3

9.What Oracle environment variables did you set? How exactly did you set them?
PATH2

10.Do you have a small, single Python script that immediately runs to show us the problem?
no

[cjbj]

Show a screenshot where you do these in the same terminal window:

• echo %PATH% or $Env.Path
• run python and execute import platform;platform.architecture()

Also show the VC Redistributable(s) you have installed.

[hjsdssz]

[hjsdssz]

[anthony-tuininga]

Looks like your Oracle client installation is missing from your PATH environment variable. That would definitely result in the error you are seeing. Can you adjust that?

[hjsdssz]

@anthony-tuininga I did set PATH environment variable as follows

[anthony-tuininga]

You need to set PATH, not PATH2! Setting PATH2 will not have any effect, unfortunately. Try adjusting PATH (include the value you have in your PATH2 environment variable, but ensure there is a semicolon between it and the existing value).