Installing 64-bit Oracle Data Access Components (ODAC)

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_

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

Fonte:  Rohit Sharma

http://rohitt-sharma.blogspot.com.br/2013/04/installing-64-bit-oracle-data-access.html



*****************************************

Setting up an Oracle ODBC Driver and Data Source

06/15/12

by TheCobraGuy

Setting up an Oracle ODBC Driver and Data Source requires more steps than the Microsoft SQL Server database setup. This article explains the steps including tnsnames.ora configuration.
Connecting to an Oracle database via and ODBC driver requires the following steps:

1. Install the ODAC (Oracle Data Access Components) or Oracle Client on the Workstation or Application Server.
2. Setup the SQLNET and TNSNAMES files in the Client or ODAC home’s Admin directory.
3. Use the ODBC Data Source configuration tools to create the ODBC Data Source.

The following blog shows the process involved for each of these steps to get you a working connection to an Oracle database.
Prerequisites: Java JRE or SDK 6 Update 27 or later. These are required by the Oracle Universal Installer to run the ODAC installation program.

Step 1 – Install the ODAC or Oracle Client

In this example we will be installing the ODAC client to complete an ODBC setup on a Windows 7 (64-bit) operating system.  You can install the full administrative option of the Oracle Client to obtain the ODBC driver.
Download the ODAC112030_x64.zip file from Oracle’s web site:
http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
Unzip the file to a location of your choosing.
Locate the Setup.exe file under the root directory of the extracted zip file’s directories.

 

Double-click to run the setup program.
In the ‘Oracle Universal Installer’, click the Next button.

 

In the ‘Select a Product to Install’ dialog, go with the default ‘Oracle Data Access Components for Oracle Client 11.2.0.3.0’ option.

In the ‘Install Location’ dialog, enter a path to install the ODAC home directory to in the ‘Oracle Base:’ field.

In the ‘Available Product Components’ dialog, go with the default options.

In the ‘Summary’ dialog, verify that the components you have selected for install include the ‘Oracle ODBC Driver for Instant Client 11.2.0.3.0’.

Click ‘Install’.
When the installation is complete, click ‘Exit’.

This concludes the steps for installing the ODBC drivers.

Step 2 – Setup the SQLNET and TNSNAMES files

Locate the SQLNET.ora and TNSNAMES.ora in the ‘samples’ directory of the newly installed Oracle client home directory. This is typically:
C:\app\johndoe\product\11.2.0\client_1\Network\Admin\Sample
Where ‘johndoe’ is the windows user name.

Copy these two files into the ‘Admin’ directory above.
Open the ‘TNSNAMES.ora’ file in Notepad and enter your Oracle database details in the file.

Save your changes.
Note: the ‘SQLNET.ora’ generally doesn’t need to be changed.

Step 3 – Create the ODBC Data Source

In the Windows Start menu, click on the Data Sources (ODBC) icon that was created by the ODAC client install.

In the ‘User DSN’ tab of the ‘ODBC Data Source Administrator’ dialog, click Add.

In the ‘Create New Data Source’ dialog, select the ‘Oracle in OraClient 11g_home1’ driver.

Click ‘Finish’.
In the ‘Oracle ODBC Driver Configuration’ dialog, enter the details of your data source.

Note: you should be able to select the TNS Service Name from the drop down list. This name will be that which you named in the TNSNAMES.ora file’s Alias = section.
Click ‘Test Connection’ to ensure your settings are all correct.
When prompted, enter the database login credentials.

Click ‘OK’.

 

Click OK to complete the process.

Fonte: Tensix Consulting
http://www.tensixconsulting.com/2012/06/setting-up-an-oracle-odbc-driver-and-data-source/