span8
span4
span8
span4
Configuring your Mac OS to allow FME Desktop to locate the Oracle client libraries
The following was tested in FME Desktop (2015.1.3, 2016.x, 2017.x, 2018.x, 2019.x) for Mac OS on Mojave, El Capitan, Sierra, High Sierra.Yosemite OS is expected to work but has not been tested.
Prerequisites:
1) Oracle Client 10g for Mac or greater downloaded and extracted to a known location
2) FME 2015+ for Mac OS.
3) Mac OS Yosemite or newer.
Configuration Steps
mkdir -p ~/lib ;ln -fhs /path/to/OracleClient/*.dylib* ~/lib/
ln -s /path/to/OracleClient/libclntsh.dylib.~/lib/libclntsh.dylib
Optional Parameters to help your Oracle Experience on Mac OS
export TNS_ADMIN=$ORACLE_HOME/admin
export SQLPATH=$ORACLE_HOME
TNS_ADMIN- variable points to your tnsnames.ora file.This is optional and if you plan to use direct connect.i.e.//servername:1521/sid you don't need to add this Environment Variable.SQLPATH- is for Oracle's SQLPlus command if you have downloaded this as part of the OracleInstant client.This is optional and if you don't plan to use the SQLPlus command line then this can be ignored.
Trouble Shooting Steps:
See the articleWhy are my Oracle Formats Greyed Out in the Formats Gallery?for troubleshooting steps.
Report issues
Please report any problems you encounter with FME and the Mac OS toSafe Software Supportteam.Please include a ~/dydl.log which can be obtained from the instructions below:
1.Launch Workbench from the command line using the following command (you may need to replace the version in the command line)
DYLD_PRINT_TO_FILE=~/dydl.log DYLD_PRINT_ENV=1 DYLD_PRINT_LIBRARIES=1 DYLD_PRINT_APIS=1 /Library/FME/2018.1/Apps/FME\ Workbench.app/Contents/MacOS/FME\ Workbench
2.Try to add an Oracle reader/writer (which should not be possible if formats are greyed out).
3.Shut down Workbench.
4.Send us the resulting~/dydl.log
ln -s /path/to/OracleClient/libclntsh.dylib.11.1 ~/lib/libclntsh.dylibThanks @aaronkoning
ln -s /path/to/OracleClient/libclntsh.dylib.12.1 ~/lib/libclntsh.dylib
fmeocilink.so was found but could not be loaded
Geodatabase Direct Connect returning error - "TNS: could not resolve the connect identifier"
Connecting to an Oracle database with an older client (9.x)
Issues connecting to SDE Geodatabase (Oracle)
How to setup an Oracle Instant Client for use with FME
Why are my Oracle formats greyed out in the formats gallery
Workbench Crashes (Windows 7 with Intel or AMD Graphics Card)
Oracle Writer - Additional Table Creation Parameters usage
Connect to an Oracle Service Name (not Oracle SID)
How Do I Know What FME Edition, License, Build, or Version I am Running?
© 2020 Safe Software Inc |Legal