Python Oracle DB Connect without Oracle Client

Question

I am trying to build an application in python which will use Oracle Database installed in corporate server and the application which I am developing can be used in any local machine.

Is it possible to connect to oracle DB in Python without installing the oracle client in the local machine where the python application will be stored and executed?

Like in Java, we can use the jdbc thin driver to acheive the same, how it can be achieved in Python.

Any help is appreciated

Installing oracle client, connect is possible through cx_Oracle module. But in systems where the client is not installed, how can we connect to the DB.

Perhaps pypi.org/project/JayDeBeApi - use Java JDBC driver in Python. You must still install JayDeBeApi module though (instead of Oracle Client), and download the driver file (JAR) from Oralce's site. — krokodilko
– krokodilko, Commented Sep 4, 2019 at 14:40
I tried to install this module but getting below error error: Microsoft Visual C++ 14.0 is required. — Bishnu
– Bishnu, Commented Sep 4, 2019 at 17:04
See this article - python windows compilers. You are using Windows, so you need to install Microsoft C++ compiler which is compatible with your versionof Python. — krokodilko
– krokodilko, Commented Sep 4, 2019 at 19:14
python other functionalities are working perfectly fine. Even cx_Oracle module also working fine. Getting error only while installing the JayDeBeApi module. — Bishnu
– Bishnu, Commented Sep 4, 2019 at 19:33
If all the target machines are Windows, you can put the Oracle Instant Client libraries in the same directory as the cx_Oracle shared library. — Christopher Jones
– Christopher Jones, Commented Sep 6, 2019 at 5:06

Christopher Jones · Accepted Answer · 2025-05-03 02:32:01Z

6

The python-oracledb driver (that superseded cx_Oracle) does not need Oracle Client libraries. It only takes a few megabytes. Installation is simple:

python -m pip install oracledb

It supports the Python DB API so usage is the same as cx_Oracle, e.g.:

import getpass
import oracledb

un = 'cj'
cs = 'localhost/orclpdb1'
pw = getpass.getpass(f'Enter password for {un}@{cs}: ')

with oracledb.connect(user=un, password=pw, dsn=cs) as connection:
        with connection.cursor() as cursor:        
        sql = """select systimestamp from dual"""
        for (r,) in cursor.execute(sql):
            print(r)

See the python-oracledb documentation and samples.

Also see the python-oracledb release announcement.

The cx_Oracle driver is obsolete and should not be used for any projects.

answered May 3 at 2:32

Christopher Jones

11.1k7 gold badges32 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Niels Jespersen · Accepted Answer · 2020-01-03 13:54:18Z

5

You can use JDBC

"""
Connect from Python to Oracle via JDBC
Get JDBC-driver here: https://download.oracle.com/otn/utilities_drivers/jdbc/193/ojdbc8-full.tar.gz
Python 3.7.4
conda install -c conda-forge jaydebeapi==1.1.1 --force-reinstall -y
conda install -c conda-forge JPype1==0.6.3 --force-reinstall -y
"""
import jpype
import jaydebeapi

JHOME = jpype.getDefaultJVMPath()
jpype.startJVM(JHOME, '-Djava.class.path=/ojdbc8-full/ojdbc8.jar')
con = jaydebeapi.connect('oracle.jdbc.driver.OracleDriver',
                         'jdbc:oracle:thin:user/pass@host_ip:1521:SID')
cur = con.cursor()
cur.execute('select dummy from dual')
r = cur.fetchall()
print(r[0][0])
cur.close()
con.close()

answered Jan 3, 2020 at 13:54

Niels Jespersen

4585 silver badges17 bronze badges

1 Comment

Marc Over a year ago

this just substitutes one enormous dependency (java) for another (oci). If the target already has java, ok, but if you're trying to limit dependencies, this is definately a frying pan/fire situation.

Sam · Accepted Answer · 2020-07-30 23:53:28Z

2

It is not correct that java can connect to oracle without any oracle provided software.

It needs a compatible version of ojdbc*.jar to connect. Similarly python's cx_oracle library needs oracle instant-client software from oracle to be installed.

Instant client is free software and has a small footprint.

edited Jul 30, 2020 at 23:53

answered Jul 29, 2020 at 22:55

Sam

4144 silver badges7 bronze badges

Comments

Bik Dhaliwal · Accepted Answer · 2022-02-04 03:54:12Z

0

Installing Oracle client is a huge pain. Could you instead create a Webservice to a system that does have OCI and then connect to it that way? This might end being a better solution rather than direct access.

answered Feb 4, 2022 at 3:54

Bik Dhaliwal

411 silver badge4 bronze badges

2 Comments

Simas Joneliunas Over a year ago

This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review

Yunnosch Over a year ago

I recommend against rhetoric questions in answers. They risk being misunderstood as not an answer at all. You are trying to answer the question at the top of this page, aren't you? Otherwise please delete this post.

Collectives™ on Stack Overflow

Python Oracle DB Connect without Oracle Client

4 Answers 4

Comments

1 Comment

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related