none
BizTalk Server Adapter Pack 2013R2 Oracle client issues RRS feed

  • Question

  • Hi 

    I'm struggling to configure correctly Oracle adapter from BizTalk Server Adapter Pack 2013R2 and Oracle client 12c (version 12.1.0)
    It works correctly if i use 32 bit host instance, If i change host instance to run in 64 bit mode I'm getting the following error:

    The Messaging Engine failed to add a receive location to the adapter "WCF-Custom". Reason: "System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. ---> Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client

    Any thoughts what I'm missing 

    My environment  

    Windows server 2012R2 64bit on vmware
    BizTalk Server 2013R2
    Oracle client 12c (32bit and 64bit) installed both 12.1.0 version
    Oracle.DataAccess 2.121.1.0 x86 and Oracle.DataAccess 2.121.1.0 AMD64 present in GAC + Policies
    Microsoft BizTalk Adapter Pack 32bit and 64bit installed
    WCF LOB Adapter SDK 64bit installed


    • Edited by psliwinski Tuesday, November 18, 2014 12:06 PM
    Tuesday, November 18, 2014 11:45 AM

Answers

  • I reinstalled Oracle client 64 bit version selecting exactly the same installation location as initial installation and that resolved the problem.

    I guess there must be some dependency in installation order

    • Marked as answer by psliwinski Wednesday, November 19, 2014 2:51 PM
    Wednesday, November 19, 2014 2:51 PM

All replies

  • The error is Ok  and true , You need install  64bit Oracle client too. You can have 32bit oracle client together with 64bit oracle client.

    You can download 64 bit Oracle client from below link

    Oracle Client for 64 Bit  Operating System

    Thanks

    Abhishek

    Tuesday, November 18, 2014 2:39 PM
  • Thanks for answer, I have done that as a first step. I have installed 64 bit oracle client and than 32 bit client. Than i have installed Adapter pack and I have noticed this issue when i start Receive Location on 64 bit host
    Tuesday, November 18, 2014 3:11 PM
  • Can you verify the whether you have successfully installed the Oracle Client .i do suspect there is an issue with your Configuration . i would also suggest to look into machine.config file to see binding properties are populated correctly

    Tuesday, November 18, 2014 3:23 PM
  • I didn't have any error regarding binding during installation, moreover I have checked machine.config files for both 64 and 32 bit framework and they look ok
    • Edited by psliwinski Tuesday, November 18, 2014 3:41 PM
    Tuesday, November 18, 2014 3:41 PM
  • I didn't have any error regarding binding during installation, moreover I have checked machine.config files for both 64 and 32 bit framework and they look ok

    Can you run the process Monitor and share the details .You can find Process Monitor in below link

    Process Monitor

    Tuesday, November 18, 2014 3:58 PM
  • I reinstalled Oracle client 64 bit version selecting exactly the same installation location as initial installation and that resolved the problem.

    I guess there must be some dependency in installation order

    • Marked as answer by psliwinski Wednesday, November 19, 2014 2:51 PM
    Wednesday, November 19, 2014 2:51 PM