I had found a number of articles and forum posts that had bits and pieces of information about what to do, none of which was complete. So, I decided to add this blog post as a short how-to.
Since FIM 2010 runs on Server 2008 R2, you need the 64-bit client tools for ORACLE. I found that the 64-bit 11.2.0 client setup package works best (for ORACLE 11g) and can be found here. Install the Full Client.
Now, there are a couple of steps you need to do (or make sure they where done by the installer) for the configuration to work:
- Set (or create) the ORACLE_HOME environment variable. Should have a value of the installation path up to the client_X folder.
- Add to the PATH environment variable the value leading up to the path where you have placed your TNSNAMES file.
- Give access to the Synchronization Service account to the ORACLE client installation folder (make sure they are inherited up to the folder where your TNSNAMES file is stored).
After the installation completed, I fired up the Synchronization Service Manager, created an ORACLE MA, and tried to connect to the database to read a View I had created. Everything worked as a charm!