Oracle Instant Client for Use with FME Flow

Hi ​@davtorgh,

It seems like you could be encountering the same issue as jnknn in the post I’ve linked below. Could you take a look at their answer and see if installing libaio1 does the trick?

If not, please let me know here or submit a support ticket.

Also, I’ll look into “oci.dll” in the error message - it’s possible it’s been removed/replaced in later versions of FME.

Hi ​@zoe.forbes,

I’ve already read that post and doesn’t apply in my case, because it refers to an installation on Ubuntu via kubernetes and I have an on premise installation on Debian. By the way, for me the symlink /usr/lib/x86_64-linux-gnu/libaio.so.1 is already in place and points to libaio.so.1.0.1 (in the same directory).

Please, let me know ho to proceed.

Thanks!

Hi ​@davtorgh,

Apologies for sending information which doesn't apply. Please try the following in order:

1. Temporarily set LD_LIBRARY_PATH to

'/opt/fmeflow/Server/lib/fmeutil/fmecore:/opt/fmeflow/Server/fme/fmecore:/opt/oracle/instantclient_XX_X’

and restart Flow. If this doesn’t work, revert LD_LIBRARY_PATH.

2. Next, set ORACLE_HOME to the location of Instant Client (‘/opt/oracle/instantclient_XX_X’) and restart Flow. If this doesn’t work, revert it.

3. One other thing which has resolved this error in the past is uninstalling all Instant Client versions (if you have multiple right now), and reinstalling the one you are using.

If the issue still isn’t resolved, I recommend filing a support ticket which will allow us to take a closer look. If you do file a ticket, please send screenshots or logs showing the error message and the values of LD_LIBRARY_PATH and ORACLE_HOME.

Hopefully we can get this resolved soon!

Hi ​@zoe.forbes,

I think the paths suggested for LD_LIBRARY_PATH don’t work in my case, because both directory 

/opt/fmeflow/Server/lib/fmeutil

/opt/fmeflow/Server/fme

don’t contain directory ‘fmecore’.

By the way, I use systemd and, accordingly with the instructions, I tried, in turn, to set ‘LD_LIBRARY_PATH=/opt/oracle/instantclient_23_8’ in the systemd script to run core and engines, but neither had worked.

There is only one Instant Client and it isn’t installed, but merely extracted from the zipfile downloaded from Instant Client site.

I’ll wait for your further considerations before sending the support ticket.

Thanks!

Hi ​@davtorgh,

Thanks for the additional info. I think filing a ticket is the best course of action - this will allow someone with more expertise in FME and Oracle to look into this. Please include a link to this Community Post in your ticket so they have as much information as possible.

Sorry I couldn’t be more helpful!

Hi ​@davtorgh,

Glad you were able to get it resolved, and thanks for coming back here with your solution. I’ll look into updating the article.

Thanks,
Zoe