Hi All
Currently we are facing some weird issue
We have a FME workspace which is running fine in FME Form (2024.2.3 - 64 bit), we have published to FME Flow (2024.2.3) and when we ran the workspace from FME Flow, it started throwing below Ora error (changed ServerName & UserName values to XXX to hide)-
“ Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`ORACLE8I', serverName=`XXX', userName=`XXX', password=`***', dbname=`') “
I have cross verified the below from my side on FME Flow (Windows Server) and I’m not sure what I’m missing, please suggest how can I overcome this issue in FME Flow.
- We are not connecting to Oracle using local naming (tnsnames.ora file) instead using LDAP
- TNSPING ServiceName - resulted correct response
- Ensured both Oracle Client 32 bit and Oracle Client 64 bit paths are part of ‘Path’ environment variable under system variables
FME Flow windows services (Application, Core, Database, Engines) are running with a service account, does service account needs any access at DB level or any folder where Oracle client is installed to understand that Oracle Identifier is already present ?