Experts Corner Article Here is some useful information that is missing from the FIM Documentation. 1) Your FIM server should be installed with Windows 2008 64 Bit - non R2 version 2) You MUST download the Oracle Client 10.2.0.4 which is the only version of the Oracle Client supported on Windows 2008 64 Bit, the 10.2.0.1 will not install on 2008 64 Bit. The exact Oracle download link is: http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10204_winx64_vista_win2k8.html 3) If you are running R2 then you can modify the oraparam INI file under "client\install\oraparam.ini" from the zip downloaded above. If you open the INI in wordpad (not notepad) under the [Certified Versions] section to say: Windows=5.0,5.1,5.2,6.0,6.1 Adding the 6.1 onto the end will mean that the initial steps of the installer won't fail because you're running R2. Then just do a "Administrator" install, or if you want to save space selet a Custom install and include "Oracle Windows Interfaces" which will include the Oracle OLE DB which is required as per the documentation. With the Administrator install you will also get Net Manager. 4) You should set the ORACLE_HOME variable to your oracle home (such as "C:\oracle\product\10.2.0\client_1" if you do a default install) then things go a bit more smoothly. 5) Under Start -> Oracle -> Configuration and Migration Tools -> select Net Manager. This will allow you to setup your connection (this may also be done by your friendly Oracle DBA). If you open Local -> Service Naming select Edit -> Create and give your net service the instance name that your Oracle DBA has given you. Normally it will be TCP/IP (without ssl). Put in the IP address/DNS name and Port for the Oracle Instance. Then put in either the Service Name or SID, again the DBA should have given you this information. Click finish to close. Now save the configuration File -> Save Network Configuration. 6) In the Command Prompt try: tnsping instancename Then you will know if your connectivity into the Oracle Instance is working or not. 7) Add the FIM Sync Service account to have full rights over the C:\Oracle directory to ensure it has rights to read the oracle config 8) Restart the FIM Sync Service to make sure it picks up on the new permissions. Then you can configure the Oracle FIM MA and put in the Instance name that you just did a tnsping to for the destination address, table name. Normally you also won't use integrated login, so put in the username and password you were given by your Oracle DBA. Then wait a few mins (well that's how long it took with me) for the FIM MA to connect to the Oracle instance and pull up the full table information. And you're good to go! Go to the Experts Corner

Thanks for sharing this with the community, Peter. I have added your post to the Experts Corner. Cheers, MarkusMarkus Vilcinskas, Knowledge Engineer, Microsoft Corporation

Peter, if you have the cylces, you could write a Wiki article on configuring the Oracle MA. If you have pictures such as screenshots you need to include, you could mail them to fimexperts@live.com. Cheers, MarkusMarkus Vilcinskas, Knowledge Engineer, Microsoft Corporation

Peter , if you have the cylces, you could write a Wiki article on configuring the Oracle MA. If you have pictures such as screenshots you need to include, you could mail them to fimexperts@live.com . Cheers, Markus Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation Will do. I have a doc I have written up, so will cleanse it of customer specific information and forward it through with attached JPGs.

Peter , if you have the cylces, you could write a Wiki article on configuring the Oracle MA. If you have pictures such as screenshots you need to include, you could mail them to fimexperts@live.com . Cheers, Markus Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation Will do. I have a doc I have written up, so will cleanse it of customer specific information and forward it through with attached JPGs. All done, e-mail sent.

Peter, Very nice writeup, but I'm a bit confused. You say that FIM server should be installed on W2008 X64, and then in step 3 you mention R2 and some modification to the ini file. Does that means that in fact it also works on Windows 2008 R2, allthough with some (unsupported?) modifications. Second question, I'm kinda unfamiliar with oracle versions. According to the FIM FAQ only Oracle 10g is supported. What oracle version were you connecting to? 10g? Would 11g work? Kind regards, Thomashttp://setspn.blogspot.com

Hi, I've installed my FIM server with Windows 2008 64 Bit enterprise - R2 version, tried installing oracle client 10.2.0.4 after modifying oraparam INI file, installation started, but ends prematurely saying that, prerequiste failure error " this version of windows does not support". Then i've installed oracle 11g client which is compatible to windows 2008 enterprise R2. It's working fine and now am able to connect to oracle db server, tested through tnsping connectivityis perfect. Is that mandatory to install oracle client 10.2.0.4 for FIM2010 ? Rahmath

Ali, To get the 10.2.0.4 client software installed you also need to adjust the refhost.xml file (client\stage\prereq\client). Add the following lines: <OPERATING_SYSTEM> <VERSION VALUE="6.1"/> </OPERATING_SYSTEM> After this step you can start the installation. You should start the installation as a Local Administrator. I've tried the installation with a Domain Administrator and this didn't work. I don't know if it is mandatory to work with the 10.2.0.4 oracle client. Kr, Stefan

Thanks a lot for this thread! Microsoft CRM Freelancer My blog (english) ()