Build info:
FME Flow 2024.2.3
Build 24825 - linux-x64
running in Ubuntu 24.04.1 LTS AWS Kubernetes
I have trouble installing oracle client correctly. We are using FME Flow in AWS Kubernetes with helm. I used this dockerfile to install oracle client to the engine pod (this worked in fmeserver 2021):
FROM safesoftware/fmeflow-engine:2024.2.3
USER root
RUN apt-get update && apt-get install -y \
unzip \
libaio1t64 \
sqlite3 \
software-properties-common && \
apt-get clean && \
rm -rf /var/lib/apt/lists/*
RUN mkdir -p /opt/oracle/instantclient_19_26
COPY instantclient-basic-linux.x64-19.26.0.0.0dbru.zip /opt/oracle/
WORKDIR /opt/oracle
RUN unzip instantclient-basic-linux.x64-19.26.0.0.0dbru.zip
ENV LD_LIBRARY_PATH=/opt/oracle/instantclient_19_26:$LD_LIBRARY_PATH
RUN rm instantclient-basic-linux.x64-19.26.0.0.0dbru.zip
COPY mod_spatialite.so /usr/local/lib/
RUN echo "LD_LIBRARY_PATH=/opt/oracle/instantclient_19_26:\$LD_LIBRARY_PATH" >> /etc/environment
WORKDIR /
USER fmeflow
i used kubectl exec to check that engine-pod have the correct folder and files for /opt/oracle/instantclient_19_26. Printenv shows:
LD_LIBRARY_PATH=/opt/oracle/instantclient_19_26
and /etc/environment shows:
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin"
LD_LIBRARY_PATH=/opt/oracle/instantclient_19_26:$LD_LIBRARY_PATH
However, when running workspace in FME Flow that has oracle connection (with easy connect string) I get:
“Oracle client libraries (e.g. oci.dll) could not be loaded. Ensure that the 64-bit client is installed and properly configured, and the PATH environment variable includes the file path to your Oracle client. Refer to https://community.safe.com/s/article/how-to-setup-an-oracle-instant-client-for-use-with for more information”
Im confused about oci.dll because isn’t that suppose to be for windows oracle client? Also for linux installations LD_LIBRARY_PATH should be used instead of PATH? I have also tried with oracle client versions 12,19 and 23. The same workspace works fine in windows EC2 machine with oracle client 19. Also to my understading versions 19 and higher have symbolic links already. At least ls -l in opt/oracle/instantclient_19_26 looks like this (ignore the different version of oracle client that i installed at the time, but the links look the same for 19):

I’ve also tried to delete all pods to restart them and instead of helm upgrade completely uninstalled and installed with helm again. Anything I missed or is there spefic version of oracle client that i should use?