Skip to main content
  • EN

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?

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

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

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


Community Stats

30,108
Posts
114,294
Replies
37,743
Members
Terms & ConditionsCookie 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.