Friday, April 19, 2013

Installing 64-bit Oracle Data Access Components (ODAC) for BizTalk 2010

I didn't find any good reference on this so though of documenting the steps that worked for me

Step 1: Go to 64-bit Oracle Data Access Components (ODAC) Downloads page and download 64-bit ODAC 11.2 Release 5 ( Xcopy for Windows x64

Step 2: Unzip the file downloaded in Step 1 it to a folder location.

Step 3: Create a folder to install Oracle Client. I created C:\Oracle\ODAC_11_2_Release_5_64_Bit 

Step 4: Run the command prompt as Administrator and browse to location where the zip file was extracted in Step 2. 

Step 5: Install Oracle Instant Client and Oracle Data Provider for .NET 2 by executing the following command on Command prompt: 

install.bat odp.net2 C:\oracle\ODAC_11_2_Release_5_64_Bit OraClient11g_home1 true

Step 6: Install Oracle Data Provider for .NET 4 by executing the following command on Command prompt:

install.bat odp.net4 C:\oracle\ODAC_11_2_Release_5_64_Bit OraClient11g_home1 false

Note: Use the same name OraClient11g_home1 for Oracle home in all commands.

Step 7: Install Oracle Service for MTS by executing the following command on Command prompt:

install.bat oramts C:\oracle\ODAC_11_2_Release_5_64_Bit OraClient11g_home1 false

Step 8: Add the install directory (C:\oracle\ODAC_11_2_Release_5_64_Bit) and install directory's bin subdirectory (C:\oracle\ODAC_11_2_Release_5_64_Bit\bin) to the system environment variable PATH.

Step 9: Create the system environment variable ORACLE_HOME and set it’s value to C:\oracle\ODAC_11_2_Release_5_64_Bit

Step 10: Copy over/Create the tnsnames.ora to/at default location %ORACLE_HOME%/network/admin

Step 11: This step is optional if you need to change the language, territory or character set for the oracle client then in this case you need to change the value of registry key NLS_LANG available at path:


Note: If you have specified different name for oracle home instead of OraClient11g_home1 in above commands then you need to look for KEY_<OracleHome>

That's all you are done with installation. In my case I was using only 64-bit host for WCF-Oracle but if you want 32-bit host then you need to install 32-bit oracle client by follow the above steps but do create different folder.

Rohit Sharma


ramesh gollapally said...

Thanks for sharing fabulous information.It' s my pleasure to read it.I have also bookmarked you for checking out new posts.
Digital Marketing Training in Hyderabad

sormita said...

Hi Rohit, I have a problem i need your help with:
I have developed a project in WPF MVVM framework. The database part is Entity Framework and the database is Oracle 11g. When I run the .exe application in the machine where I developed it, it runs perfect but when I run it in another machine it becomes 'Not Responding'. I have tried to include the following dlls:
But the "Add Reference" in Visual Studio is not allowing me to add the above references. What all dlls I need to include in the solution so that it runs perfect on user's machine?

Anonymous said...

Sormita, you have to add oracle.dataAccess.dll file only.

Sri Vasavi P said...

Thanks a lot for the information. As you rightly said, yours is the only link I found with such detailed steps. The install batch file was not running when I click it, and your steps worked like magic!!!

binds said...

Hi Rohit, I installed the 64 bit and then realised we needed the 32 bit one. Do we install the 32 bit ODAC into OraClient11g_home1 as well?

Rohit C.M. Sharma said...

Binds yes you can follow the same steps with same name for oracle home for 32-bit. The registry entries for 64-bit and 32-bit installation get created at different location the value of key ORACLE_HOME will point to the respective folder locations for 32-bit and 64-bit.

binds said...

Hi Rohit, I followed teh above steps but I am getting the error:
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

I have tried giving permissions to 'Authenticated Users' to the Oracle Home folder, but still in vain.

Any suggestions please?

Rohit C.M. Sharma said...

Have you rebooted the machine after giving permission?

eddy shaw said...

you've an incredible weblog here! would you prefer to make some invite posts on my weblog? online casino games

Unknown said...

Installed 64-bit ODAC 11.2 Release 6 ( Xcopy for Windows x64 using these instructions and worked a treat. (Had to install 11.2 to get connection to a 9i database for MS Power BI Desktop). Many thanks for posting this - still useful after all those years!!

Post a Comment