BizTalk 2013R2 Wcf-lob Oracle Adapter Installation Configuration/issues & Workarounds

BizTalk 2013r2 wcf-lob Oracle Adapter Installation Configuration / problem & Workaround

Installing Oracle Adapter

Installing the Oracle Client

The BizTalk 2013R2 installation package comes with a WCF LOB Adapter pack for Oracle that requires the Oracle client component ODP. NET or ODAC components. There is a problem, the version is not compatible, because the Oracle adapter default need to install 11.1.0.7 this version

The Oracle Database adapter uses the Oracle Data Provider for. NET (odp.net) 11.1.0.7-Communicate with the Oracle Datab Ase. You can use the Oracle database adapter to communicate with the Oracle database in the following ways:

Http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

Configuration is required after installation is complete

Tnsnames.ora file

There's no more talking about TNS's configuration.

Under normal circumstances, the installation and configuration will be complete.

Problems encountered and how to resolve them

For example, you have installed another version of Oracle client such as 12C, or other version

Then there will be the following

The reason for this is that Oracle adapter references the Oracle.DataAccess.dll class library, and if you install multiple versions, multiple versions of the DLL will appear in the C:\Windows\assembly directory.

The solution is to erase the superfluous

You can also modify the. NET configuration file

C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config

<system.data><dbproviderfactories><add name= "Oracle data Provider for. NET" Invariant= " Oracle.DataAccess.Client "description=" Oracle Data Provider for. NET "Type=" Oracle.DataAccess.Client.OracleClientFactory, Oracle.dataaccess, version=2.111.7.20, Culture=neutral, publickeytoken=89b483f429c47342 "/><add name=" Odbc Data Provider "invariant=" System.Data.Odbc "description=". Net Framework Data Provider for Odbc "type=" System.Data.Odbc.OdbcFactory, System.Data, version=2.0.0.0, culture=neutral , publickeytoken=b77a5c561934e089 "/><add name=" OLE DB Data Provider "invariant=" System.Data.OleDb "description= ". Net Framework Data Provider for OLE DB" Type= "System.Data.OleDb.OleDbFactory, System.Data, version=2.0.0.0, culture= Neutral, publickeytoken=b77a5c561934e089 "/><add name=" OracleClient Data Provider "invariant=" System.Data.OracleClient "description=". Net Framework Data Provider for Oracle "type=" System.Data.OracleClient.OracleClientFactory, System.Data.OracleClIent, version=2.0.0.0, Culture=neutral, publickeytoken=b77a5c561934e089 "/><add name=" SqlClient Data Provider " Invariant= "System.Data.SqlClient" description= ". Net Framework Data Provider for SQL Server" Type= " System.Data.SqlClient.SqlClientFactory, System.Data, version=2.0.0.0, Culture=neutral, publickeytoken= b77a5c561934e089 "/><add name=" Data Provider for SAP "invariant=" Microsoft.Data.SAPClient "description=". NET Framework Data Provider for MySAP business Suite "type=" Microsoft.Data.SAPClient.SAPClientFactory, Microsoft.Data.SAPClient, version=3.5.0.0, Culture=neutral, publickeytoken=31bf3856ad364e35 "/></ Dbproviderfactories></system.data>

　　

Change to the corresponding version number

You also need to modify the BizTalk configuration file

C:\Program Files (x86) \microsoft BizTalk Server r2\ BTSNTSvc.exe.config

If you have multiple versions of the Oracle client installed, you need to add a oracle_home directory to the environment variable to tell the program which version to use to connect to the database server at runtime

Configuration complete these should be ready for use

BizTalk 2013R2 Wcf-lob Oracle Adapter Installation Configuration/issues & Workarounds