Skip to main content
Question

Error connecting to Oracle database via FME Server

  • May 17, 2018
  • 3 replies
  • 90 views
B
Forum|alt.badge.img

I get an Oracle connection error using FME Server 2017.1.2 - Build 17722 - win64 to import data to an Oracle Spatial 11g or 12c database. The server OS = Windows Server 2008 R2

The following Oracle Server settings are present:

tnsnames.ora is set via an environment system variable to a certain drive mapping:

TNS_ADMIN %O_DRIVE%\\Oracle

O_DRIVE \\\\srv_name\\environment\\app

ORA_HOME not set

Locally tnsnames is NOT set via:

<<Installation_Drive>>\\app\\Administrator\\product\\<<versiono of Oracle>>\\client_1\\network\\admin\\tnsnames.ora

When I copy tnsnames.ora locally FME SRV connects without problem (which we don’t want), if ORACLE_HOME is set or not doesn’t matter.

When tnsnames.ora is set via TNS_ADMIN variable and NOT locally FME SRV oracle connection fails.

FME Workbench doesn’t have this problem, it connects to TNS_ADMIN without problems.

Is there a solution?

    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.

    3 replies

    J
    Forum|alt.badge.img+2

    Hi @benschmarkbvba

    We have a troubleshooting guide here which may help.

    Does the account running the fme server engine in with down services have permissions to your database?

    If that doesn't help, it'd be useful to see which errors you're getting

    B
    Forum|alt.badge.img

    Hey,

    I've checked the guide already, without success.

    Account permissions should be ok, i'm admin.

    oracleissuefmesrv.zip

    i've uploaded 2 log files:

    job_17485 > no TNS issue (tnsnames.ora is set locally)

    job_17488 > TNS issue (tnsnames.ora is NOT set locally)

    Regards,

    Raf

    B
    Forum|alt.badge.img

    Hi @benschmarkbvba

    We have a troubleshooting guide here which may help.

    Does the account running the fme server engine in with down services have permissions to your database?

    If that doesn't help, it'd be useful to see which errors you're getting

    Jennifer,

     

     

    Were the logs helpfull? Or do you need more feedback?

     

     

    Regards

     

     

    Raf

     

    Community Stats

    32,296
    Posts
    122,517
    Replies
    39,980
    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.