How connect to an Oracle database from Python

Learn how to connect to an Oracle database from Python. Includes installation of packages, OS dependencies, connection configuration and troubleshooting.

[ishanipaul]

This step by step tutorial is really helpful while setting the Oracle DB connection. Really appreciate your effort.

[danielgreenblatt]

after 2 freaking days of trying to work this thing out and going through half the internet your video is what helped me!!! THANK YOU!!!

[Gelidely]

Thank you for your instructions, they were very helpful

[mithunchandra]

Very Nice Explanation, Sir.Needs More.

[apolomachine]

YOU ARE THE MAN!!




you save me! finally i can connect to oracle from python thanks to YOU!

[danielkike]

Thanks for the video, very helpfull :D

[reetabhal]

Mesej yang jelas, struktur yang jelas, mudah difahami, terima kasih

[chandu_akula]

ORA-12541: TNS:no listener




I got this error when I am trying to connect python to oracle database in python .... Can you please help me solving this ???

[hunainwali]

numpy library can import in java(OAF)?

[sjk_]

What happens in the background of cx_Oracle? How does it connect to the database?

[luvuday]

I have oracle 12 c database I used your command pip install cx_oracle. after this command my oracle services from the service.msc has vanished. I cannot login to a connection in oracle. I am getting adaptor error. Can you please help?

[dennisverhoeven]

Hi, thank you for this. I am struggling to connect to my Oracle DB on a different Windows system. While I can connect with Oracle MySQL Developer from my computer (and the connection is working), the set-up in the video does not work. I get either an ORA-12514: TNS: listener does not currently know of service requested in connect descriptor' (when I add the host name as path) or a connection timeout error. Any idea what might be a solution? Thanks!

[kata-manasse]

How can I add the name/pw to the tnsnames.ora default service file? Also is there an example of usage?

[shaukhkhan]

please guide me.
my oracle database is remote location please tell me how can i connect through python program
i mean how can i implement ssh path in cx_Oracle() method

[CttageChees]

Thank you very much for the help. =] I'm also very interested in knowing what other languages you know. I have a guess but do not want to say and potentially be offensive or something lol May I know?

[pratik]

this errror shows when i use, pip intsall cx_Oracle
error : Could not build wheels for cx_Oracle, which is required to install pyproject.toml-based projects

[fabienperon]

hi, pip nstall cx_oracle doesn't work. Two errors : ERROR: Could not find a version that satisfies the requirement cx_oracle (from versions: none) / AND / ERROR: No matching distribution found for cx_oracle. Any Idear ? Python version 3.9.2rc1 AND pip version 20.2.3

[M.Alsharafi]

Thank you for Help me .
but how can i fix this problem :
cx_Oracle.DatabaseError: DPI-1072: the Oracle Client library version is unsupported....

[ashokbanala]

Hello, i am encountered with exception cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 32-bit Oracle Client library; wherein i have checked the python (3.7) 32 bit and instant client version(32 bit).
any help would be appreciated.

[anthonyalfaro]

after following the steps, I'm getting this error:
>>> import cx_oracle
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: No module named cx_oracle