Skip to main content
Question

Error connecting to Oracle database via FME Server

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?

    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
    jlutherthomas wrote:

    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

     

    Reply


    Helpful Members This Week

    Community Stats

    31,375
    Posts
    119,003
    Replies
    39,005
    Members

    Latest FME

    Terms & ConditionsCookie settings

    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
    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.