Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Re: cx_Oracle DLL load failed

916253Feb 9 2012 — edited Mar 2 2012
I am having a problem with cx_Oracle module for Python:
I have multiple Oracle Clients installed. I am only interested in accessing the 10g with Python.
I'm running Python 2.7.2 (python-2.7.2.msi)
I've installed cx_Oracle for Python 2.7 and Oracle 10g (cx_Oracle-5.1.1-10g.win32-py2.7.msi)

I thought placing the 10g path at the front of the PATH would fix my problem.

My last check is to verify the %PATH% environment setting is changed via Control Panel > System > Advanced system settings... curses my company has me locked out!!!
import cx_Oracle
Traceback (most recent call last):
File "<pyshell#1>", line 1, in <module>
import cx_Oracle
ImportError: DLL load failed: The specified procedure could not be found.
Path:

echo %PATH%
c:\Oracle\10g\FullClient\bin;C:\Program Files\Oracle\jre\1.1.7\bin\;C:\Oracle\8.0\jdk\bin\;C:\Oracle\8i\bin\;C:\Oracle\8.0\BIN\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\Windows Imaging\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\10.0\DLLShared\;C:\Program Files\ActivIdentity\SecureLogin\;C:\Oracle\10g\FullClient\bin\;C:\Program Files\Axalto\Access Client\v5\;C:\Program Files\1E\SMSNomad


I recall that to get Python talking to Oracle on my personal laptop I needed to install Oracle Instant Client.

I’m not sure if that is required.

Any ideas would be much appreciated,
-Greg

Edited by: 913250 on Feb 9, 2012 8:12 AM

Comments

thatJeffSmith-Oracle
Answer

Sorry, this forum space isn't for EM Express or 12c-specific questions, it's for the Oracle SQL Developer IDE/GUI

Marked as Answer by 2662756 · Sep 27 2020
2662756

Thanks!, let me go to the correct forum

unknown-7404

Repost in the Multitenant forum and see my reply dated Apr 22, 2014 3:54 PM in this thread:

https://community.oracle.com/thread/3550674

Oracle 12c uses a NEW, and different, multitenant architecture. That requires that certain, basic operations (e.g. creating users, connecting) are done DIFFERENTLY.

If you want to avoid the RTFM responses that might be coming your way read jump the gun on them by reading chapters 17 and 18 in the Database Concepts doc. Those chapters, and my reply in that thread, will answer your question.

http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm

1 person found this helpful
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 30 2012
Added on Feb 9 2012
#python
1 comment
3,756 views