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
  • 276 views
G

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

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, 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

    tomf
    Supporter
    Forum|alt.badge.img+20
    • tomfSupporter
    • Supporter
    • 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.

    Community Stats

    32,154
    Posts
    122,047
    Replies
    39,812
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.