+20I'm trying to set ORACLE_HOME for FME Server on Linux, but the FME Engine is not seeing it. I fetch it and print it in a workspace, but it's set to a value I definitely didn't set:
/opt2/oracle8i/app/oracle/product/8.1.6
How can I set ORACLE_HOME for the FME Engine?
Best answer by fmelizard
On Linux, the FME Server processes are run by the user fmeserver. It's possible that you could set that fmeserver user's environment variables in some way. An alternative way that worked for me was to update the startEngines.sh script to include the following:
ORACLE_HOME=/something/that/I/want
export ORACLE_HOMEHere is a screenshot of the change I made and a log file from FME Server showing the value it sees. They are the same :-)
The other value you saw is set by the FME Engine if ORACLE_HOME is not already set.
+20On Linux, the FME Server processes are run by the user fmeserver. It's possible that you could set that fmeserver user's environment variables in some way. An alternative way that worked for me was to update the startEngines.sh script to include the following:
ORACLE_HOME=/something/that/I/want
export ORACLE_HOMEHere is a screenshot of the change I made and a log file from FME Server showing the value it sees. They are the same :-)
The other value you saw is set by the FME Engine if ORACLE_HOME is not already set.