Question

Error connecting to Oracle database via FME Server


Badge

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

Badge +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

Badge

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

Badge

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