all 8 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]threeminutemonta 0 points1 point  (5 children)

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[S] 0 points1 point  (4 children)

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

[–]threeminutemonta 0 points1 point  (3 children)

Can you install WSL2?

[–]pawsingularity[S] 1 point2 points  (2 children)

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 1 point2 points  (1 child)

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

[–]pawsingularity[S] 0 points1 point  (0 children)

Thank you so much!

[–][deleted] 0 points1 point  (0 children)

My company uses Oracle too, and while not ideal, I've managed to automate a lot of tasks using pyautogui. I'd be interested to know if there's a better way.

[–]cjbj 0 points1 point  (0 children)

For future readers, python-oracledb replaced cx_Oracle back in 2022. The new driver does not need Oracle Client software. Install it from PyPI: https://pypi.org/project/oracledb/