Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Frequently Asked Questions

Frequently Asked Questions

The following are some frequently asked questions (FAQs) related to Microsoft BizTalk Adapter 3.0 for Oracle Database.

The Microsoft BizTalk Adapter 3.0 for Oracle Database can be installed on client systems that have one of the following operating systems installed:

  • Windows XP SP2

  • Windows Server 2003 SP1

  • Windows Server 2003 SP2

  • Windows Server 2003 R2

  • Windows Vista (32-Bit)

The Oracle Database adapter can be used to connect to the following versions of the Oracle database:

  • Oracle 9.2.0.2

  • Oracle 10.1.0.2.0

  • Oracle 10.2.0.1.0

The Oracle Database adapter supports Oracle Client version 10.2.0.3, along with the following ODP.NET versions:

For 32-bit

For a 32-bit Oracle client you need:

  • Oracle client version 10.2.0.3.

  • Oracle Data Provider for .NET 2.0, 10.2.0.2.20. This is available as part of Oracle Data Access Components (ODAC) 10.2.0.2.21.

You must install the client in the following order:

  • Install the Oracle client 10.2.0.3.

  • Install ODAC in the same destination folder as the Oracle client.

For 64-bit

For a 64-bit Oracle client you need:

  • Oracle client version 10.2.0.3. This is available as part of the following patches:

    • 10.2.0.3.0 (patch number 5337014)

    • 10.2.0.3 patch 10 (patch number 6344569 )

  • Oracle Data Provider for .NET 2.0, 10.2.0.3.02. This is available as part of Oracle Data Access Components (ODAC) 10.2.0.3 for Windows x64.

You must install the client in the following order:

  • Install ODAC.

  • Install Oracle client patch 5337014 in the same destination folder as ODAC.

  • Install Oracle client patch 6344569 in the same destination folder as ODAC.

You must also have the following drivers:

  • For 32-bit: Oracle.DataAccess.dll version 2.102.2.20

  • For 64-bit: Oracle.DataAccess.dll version 2.102.3.2

    You must manually add the Oracle.DataAccess.dll to the global assembly cache (GAC). This DLL will be installed on your computer, typically at <installation drive>:\oracle\product\10.2.0\client_1\odp.net\bin\2.x.

The BizTalk Adapter Pack is supported with Microsoft BizTalk Server 2006 R2 RTM (version 3.6.1404.0).

You must always run the BizTalk Adapter Pack setup wizard under a user context with administrative privileges on the computer.

Microsoft BizTalk Adapter Pack enables adapter clients to activate Windows Communication Foundation (WCF) tracing and adapter-specific tracing. For more information about tracing, see Diagnostic Tracing and Message Logging.

The trace files are stored at a location that the adapter clients specify. The adapter clients can specify this location while enabling tracing. For more information about tracing, see Diagnostic Tracing and Message Logging.

You can use the WCF Service Trace Viewer tool to view the traces. For more information about the tool, see http://go.microsoft.com/fwlink/?LinkId=91243.

The BizTalk Adapter Pack provides an "LOB Time (Cumulative)" performance counter to measure the time, in milliseconds, that the LOB client library takes to complete an action initiated by the adapter. For more information about performance counters, see Using Performance Counters.

You can enable or disable the performance counters by setting the binding property EnablePerformanceCounters. To enable performance counters, set the EnablePerformanceCounters binding property to True. To disable performance counters, set EnablePerformanceCounters to False. By default, EnablePerformanceCounters is set to False.

You can check the version of the BizTalk Adapter Pack, evaluation or standard, which is installed on your computer by looking at the product ID in the PID.txt file. This file is available in the <installation drive>:\Program Files\Microsoft BizTalk Adapter Pack\Documents folder on a 32-bit computer and the <installation drive>:\Program Files\Microsoft BizTalk Adapter Pack(x64)\Documents folder on a 64-bit computer.

If the product ID is:

  • 92810-028-0001260-00301, an evaluation version of the BizTalk Adapter Pack is installed.

  • 92809-270-0001264-04309, a standard version of the BizTalk Adapter Pack is installed.

Show:
© 2015 Microsoft