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:
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?
Sormita, you have to add oracle.dataAccess.dll file only.
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!!!
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?
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.
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?
Have you rebooted the machine after giving permission?
you've an incredible weblog here! would you prefer to make some invite posts on my weblog? online casino games
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!!
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.
Thanks for sharing good blog with us
biztalk certification training
biztalk training
Rohit sharma height in feet Problem Cricket
kayseriescortu.com - alacam.org - xescortun.com
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
This is an awesome post. Really very informative and creative content. For more details visit here.
kütahya eskort
çankırı eskort
afyon eskort
burdur eskort
çorum eskort
bilecik eskort
amasya eskort
yalova eskort
çorlu eskort
şile eskort
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
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
Smm Panel
smm panel
iş ilanları
İnstagram takipçi satın al
hirdavatciburada.com
beyazesyateknikservisi.com.tr
servis
tiktok jeton hilesi
very beneficial information shared in this text, perfect written! . ทางเข้าเล่น joker
Good content. You write beautiful things.
sportsbet
taksi
hacklink
vbet
vbet
sportsbet
hacklink
korsan taksi
mrbahis
başakşehir
bayrampaşa
beşiktaş
beykoz
beylikdüzü
X7A
https://saglamproxy.com
metin2 proxy
proxy satın al
knight online proxy
mobil proxy satın al
8UC
adapazarı
adıyaman
afyon
alsancak
antakya
35DC
Thanks for shareing comments
Thanks for sharing all this information here on this page.
I truly enjoy looking through on this web site , it holds superb content .
Post a Comment