I am trying to establish a connection from Azure pipelines to oracle using cx_oracle. I’m using a dockerfile:
FROM python:3.9-slim-buster
RUN apt-get update && apt-get install -y git && apt-get install telnet RUN apt-get install -y gcc RUN apt-get -y install wget RUN apt -y install unzip RUN wget https://download.oracle.com/otn_software/linux/instantclient/215000/instantclient-basic-linux.x64-21.5.0.0.0dbru.zip RUN unzip instantclient-basic-linux.x64-21.5.0.0.0dbru.zip RUN apt-get -y install libaio1 RUN sh -c “echo /instantclient_21_5 > /etc/ld.so.conf.d/oracle-instantclient.conf” RUN ldconfig RUN apt -y remove unzip RUN rm instantclient-basic-linux.x64-21.5.0.0.0dbru.zip
CMD [“/bin/sh”]enter image description here
Im doing automated tests using robotframework, i just updated to cx-Oracle 8.3.0. I still get the error “DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “libclntsh.so: cannot open shared object file: No such file or directory”.”