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?