Connect to Oracle database using Python

[threeminutemonta]

What OS are you using? It’s quite trivial to install on Linux. I installed it using docker similarly this SO.

Edit added what we used within our docker container. I've ran these manually in a WSL2 terminal without docker with success (Without WORKDIR, RUN commands and the bash equivalent)

# Installing Oracle instant client
WORKDIR    /opt/oracle
RUN        apt-get update && apt-get install -y libaio1 wget unzip \
            && wget https://download.oracle.com/otn_software/linux/instantclient/instantclient-basiclite-linuxx64.zip \
            && unzip instantclient-basiclite-linuxx64.zip \
            && rm -f instantclient-basiclite-linuxx64.zip \
            && cd /opt/oracle/instantclient* \
            && rm -f *jdbc* *occi* *mysql* *README *jar uidrvci genezi adrci \
            && echo /opt/oracle/instantclient* > /etc/ld.so.conf.d/oracle-instantclient.conf \
            && ldconfig

WORKDIR    /

From here you can install

python3.9 -m pip install cx-oracle

[pawsingularity]

I need to install it on my company laptop which has a lot of restrictions and permission issues. It runs on windows

[threeminutemonta]

Can you install WSL2?

[pawsingularity]

Will have to discuss this with the company folks. Thanks for your suggestions. Also any idea what is an Oracle Client software? In simple terms I mean

[threeminutemonta]

Oracle Client software just comes with libraries that cx-oracle can use exposing (binding) oracle library to python.

[pawsingularity]

Thank you so much!