Skip to main content
Solved

Oracle client libraries (e.g. oci.dll) could not be loaded in kubernetes installation of FME Flow

  • February 25, 2025
  • 1 reply
  • 52 views

jnknnn
Contributor
Forum|alt.badge.img+5

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?

Best answer by jnknnn

I was able to solve this with

ln -s /usr/lib/x86_64-linux-gnu/libaio.so.1t64 /usr/lib/x86_64-linux-gnu/libaio.so.1

as guided in here:

https://forums.oracle.com/ords/apexds/post/instant-client-on-ubuntu-24-04-noble-numbat-7244

There is a link in here https://support.safe.com/hc/en-us/articles/25407741842573-How-to-Setup-an-Oracle-Instant-Client-for-Use-with-FME for the Oracle forums. However, the instructions said if you “get "Oracle client libraries could not be loaded..." error, install libaio1” and I got  “Oracle client libraries (e.g. oci.dll) could not be loaded” instead.

View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

jnknnn
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • Best Answer
  • February 27, 2025

I was able to solve this with

ln -s /usr/lib/x86_64-linux-gnu/libaio.so.1t64 /usr/lib/x86_64-linux-gnu/libaio.so.1

as guided in here:

https://forums.oracle.com/ords/apexds/post/instant-client-on-ubuntu-24-04-noble-numbat-7244

There is a link in here https://support.safe.com/hc/en-us/articles/25407741842573-How-to-Setup-an-Oracle-Instant-Client-for-Use-with-FME for the Oracle forums. However, the instructions said if you “get "Oracle client libraries could not be loaded..." error, install libaio1” and I got  “Oracle client libraries (e.g. oci.dll) could not be loaded” instead.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings