Skip to main content
Question

I cannot get a proper connection to an Oracle database on FME Server. I suspect it may be a TNS_names problem, but I am not sure. The link in the error is not very specific about fixing this problem on Server. I have a proper published Database Conne

  • December 17, 2020
  • 1 reply
  • 245 views

error mesage -

2020-12-17 13:13:41 | 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://knowledge.safe.com/articles/FAQ/How-to-setup-an-Oracle-Instant-Client-for-use-with-FME for more information

1 reply

tomf
Contributor
Forum|alt.badge.img+14
  • Contributor
  • January 15, 2021

@gitopher​ this error is suggesting that FME can't find an Oracle client to connect to your oracle db. Please ensure you have installed 64-bit Oracle client on the FME Server host (unless you are using 32-bit engines as well, then you will likely need both). The windows environment variable PATH also need to be updated to include the path to the oracle client (preferrable at the start of the PATH value).

 

If you are using tns_names.ora for connection details you will also need to set the Window environment variable TNS_ADMIN to be the path to the tns_names.ora file (excluding the filename).

 

The article cited in the the error message gives more information.


Reply


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