连接oracle数据库报错，cx_Oracle已经打包到docker镜像了

[jinlinyouyou]

superset.exceptions.SupersetErrorsException: [SupersetError(message='(builtins.NoneType) None\n[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\n(Background on this error at: https://sqlalche.me/e/14/4xp6)]\n(Background on this error at: https://sqlalche.me/e/14/dbapi)', error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra={'engine_name': 'Oracle', 'issue_codes': [{'code': 1002, 'message': 'Issue 1002 - 数据库返回意外错误。'}]})]

[dosubot[bot]]

I found a similar closed issue that might help you resolve the error you're encountering:

1. cx_Oracle installation malfunctioning in docker vm (closed on May 24, 2023):
   The suggested solution involves extending the Docker image to include the Oracle Instant Client. Here is the Dockerfile provided in the solution:

   FROM apache/superset
   
   USER root
   
   # Install Oracle Instant Client 18.5 (by LRBS)
   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

   After creating this Dockerfile, build a new image and run the container. This should resolve the issue with the Oracle Client library not being found ^[1].

Additionally, ensure that the Oracle environment variables are set correctly and use cx_Oracle.init_oracle_client() to specify the library directory if needed. For more details, refer to the cx_Oracle installation guide.

To continue talking to Dosu, mention @dosu.