Error DPI-1047 connect Oracle Database

[jrlittlefoot64]

I have superset installed with docker compose and TAG 4.0.2. cx_Oracle is in requirements-local.txt but got this Error:

FEHLER: (builtins.NoneType) None
[SQL: (cx_Oracle.DatabaseError) DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory". See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help
(Background on this error at: https://sqlalche.me/e/14/4xp6)]
(Background on this error at: https://sqlalche.me/e/14/dbapi)

need help!

[dosubot[bot]]

Hey @jrlittlefoot64! I'm here to help you with that Oracle Database issue. Let's get this sorted out! 😊

I found some similar discussions and a closed issue that might help you resolve the DPI-1047 error with cx_Oracle in your Docker setup.

1. A closed issue titled "cx_Oracle installation malfunctioning in docker vm" suggests a solution by extending the Docker image to include the Oracle Instant Client. Here's a summary of the solution:

   • Extend the Superset Docker image by creating a Dockerfile that installs the Oracle Instant Client and configures the environment.
   • Install cx_Oracle within the Docker container.

   Here's an example Dockerfile from the issue:

   FROM apache/superset
   
   USER root
   
   # Install Oracle Instant Client
   RUN apt-get update \
       && apt-get install -y --no-install-recommends \
            unzip libaio1 \
       && apt-get autoremove -yqq --purge \
       && apt-get clean \
       && rm -rf /var/lib/apt/lists/* \
       && mkdir -pv /opt/oracle \
       && chown -R "superset:root" /opt/oracle \
       && cd /opt/oracle \
       && curl -Lf "https://download.oracle.com/otn_software/linux/instantclient/185000/instantclient-basic-linux.x64-18.5.0.0.0dbru.zip?xd_co_f=<oracle-random-key>" \
            --output oracle-instantclient-18-5.zip \
       && unzip ./oracle-instantclient-18-5.zip \
       && rm -f ./oracle-instantclient-18-5.zip \
       && echo "/opt/oracle/instantclient_18_5" > /etc/ld.so.conf.d/oracle-instantclient.conf \
       && ldconfig
   
   USER superset 
   
   RUN pip install --no-cache-dir -t /app/superset/pythonpath cx-Oracle==8.1.0

2. You might also want to check out these discussions for additional context:

   • 连接oracle数据库报错，cx_Oracle已经打包到docker镜像了 ^[1]
   • Oracle InstantClient in Docker ^[2]

These resources should help you configure your Docker environment to properly include the Oracle Client libraries and resolve the DPI-1047 error.

To continue talking to Dosu, mention @dosu.