Hello BizTalk Buddies,
It has been a while that since I have written an article.
Recently, I have had a requirement to upgrade BizTalk from
2010 to 2016. My client is using Oracle Database Adapter extensively in BizTalk Server.
There are good Articles that explain the installation
and configuration or ODAC for BizTalk 2016 but I feel that they are not detail
enough so it's my attempt to clear the gaps in understanding.
Before you can download the ODAC (Oracle Data Access
Components), create an Oracle online account from the below URL.
Once you have created an Oracle account, log in to oracle
online and you can navigate to the below URL to download the 32 bit Version of
the ODAC.
Accept the License Agreement as shown below.
On the same page navigate down till you spot the 12.1.0.1.0 version of ODAC as shown below.
Logon to the BizTalk Server using either an Administrator's account or the service account that the host instances run on.
Open the command line as an administrator, and navigate to
the folder location where you have extracted the downloaded zip file.
In my case, I have downloaded and extracted the file to the
below location.
D:\Software\ODAC121010Xcopy_32bit
In the command prompt run the following command if you would
like to install to C:\ Drive on the server. Otherwise, change the drive
accordingly and run the below command.
D:\Software\Oracle Client\ODAC121010Xcopy_32bit>install.bat all C:\Oracle myhome
Note:- Some checks after the above installation is completed.
1). Double-check that, the Oracle home path is set up properly in System Environment variables.
2). If you are using TNS name aliases, then double-check your file exists in the respective location. In my case, it is in C:\Oracle\network\admin\tnsnames.ora.
No comments:
Post a Comment