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 (11.2.0.3.20) 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:

HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraClient11g_home1

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.

Cheers
Rohit Sharma

27 comments:

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:
-oci.dll
-ociw32.dll
-orannzsbb11.dll
-oraocci11.dll
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.

Unknown 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?

eddyshaw9272711 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 (11.2.0.4.0) 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!!

hari said...

I did the same process. But, I am getting below error
Connecting to the LOB system has failed.
Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified..

Please help me to fix the issue.

Akhila said...

Thanks for sharing good blog with us
biztalk certification training
biztalk training

ThoughtFul said...

Rohit sharma height in feet Problem Cricket

ERTUĞRUL DOĞAN said...

kayseriescortu.com - alacam.org - xescortun.com

Mike Johnson said...

I think it is easier to make a video about this install process and publish such video on youtube. There are many sites like this one https://soclikes.com where you can get many likes for your video

Brandi Love Bio said...

This is an awesome post. Really very informative and creative content. For more details visit here.

Ahmet Gedik said...

kütahya eskort
çankırı eskort
afyon eskort
burdur eskort
çorum eskort
bilecik eskort
amasya eskort
yalova eskort
çorlu eskort
şile eskort

Jale K said...

alanya eskort

afyon eskort

amasya eskort

bayburt eskort

yozgat eskort

ataköy eskort

düzce masöz

manisa masöz

izmit masöz

görükle masöz

Anonymous said...

perde modelleri
mobil onay
mobil ödeme bozdurma
nft nasıl alınır
ankara evden eve nakliyat
trafik sigortası
dedektör
web sitesi kurma
AŞK KİTAPLARI

Anonymous said...

Smm Panel
smm panel
iş ilanları
İnstagram takipçi satın al
hirdavatciburada.com
beyazesyateknikservisi.com.tr
servis
tiktok jeton hilesi

ligaz77king said...

very beneficial information shared in this text, perfect written! . ทางเข้าเล่น joker

mrbahis said...

Good content. You write beautiful things.
sportsbet
taksi
hacklink
vbet
vbet
sportsbet
hacklink
korsan taksi
mrbahis

derin said...

başakşehir
bayrampaşa
beşiktaş
beykoz
beylikdüzü
X7A

nehir said...

https://saglamproxy.com
metin2 proxy
proxy satın al
knight online proxy
mobil proxy satın al
8UC

hamza said...

adapazarı
adıyaman
afyon
alsancak
antakya
35DC

celebrity escorts said...

Thanks for shareing comments

Malviya Nagar Escorts said...

Thanks for sharing all this information here on this page.

Model Delhi Escort said...

I truly enjoy looking through on this web site , it holds superb content .

Post a Comment