none
Oracle wcf adapter RRS feed

  • Question

  • Hi,  when I try changing a property for the Oracle wcf adapter receive location, when I apply the change it throws an error - Error saving properties. Invalid binding. The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.The provider is not compatible with the version of Oracle client.

    My enviornment is windows server 2008 R2(64-bit). I have the following installed - BizTalk adapter pack 2.0, wcf lob adapter sdk, oracle client. oracle client version is 11.2.0.1.0. Could someone please help me with this.

     

    • Moved by Ben Cline1Moderator Sunday, September 5, 2010 12:44 PM relates to adapters (From:BizTalk Server General)
    Friday, September 3, 2010 3:50 PM

Answers

  • To summarize for everyone,

    On a 32 bit installation, you need:

    1 WCF LOB Adapter SDK 32 bit
    2 Adapter Pack 32 bit
    3 Oracle Client including ODP.NET 11.1.0.7 32 bit

    On 64 bit installation, you need:

    1 WCF LOB Adapter SDK 64 bit
    2 Adapter Pack 32 bit
    3 Adapter Pack 64 bit
    4 Oracle Client inluding ODP.NET 11.1.0.7 32 bit
    5 Oracle Client including ODP.NET 11.1.0.7 64 bit

    If you are not able to get it working even with this data, I suggest you contact support so that they can guide you.

    Friday, September 17, 2010 9:48 AM

All replies

  • Hi Sbharati,

    Ensure that you are running the 64 bit Oracle Client for version 11.2.0.1.0.

    Thanks,

    William

    Friday, September 3, 2010 4:14 PM
  • Hi,

    I suggest to follow instructions in the installation guide and download appropiate Oracle client.

    HTHRegards,

    Steef-Jan Wiggers - MVP & MCTS BizTalk Server
    blog: http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly


    BizTalk
    Friday, September 3, 2010 4:46 PM
    Moderator
  • Thanks William and Steef. Now I have a new issue. The receive location, when enables, throws the following error and shuts down-

     Reason: "System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

    File name: 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342'

     

    I can see two Oracle.DataAccess dll with versions - 2.111.7.20 and 2.112.1.0 in my machine. Please let me know if you know the issue. Thanks



    Friday, September 3, 2010 5:55 PM
  • Hi,

    You could try doing the following by adding this to the file 'Microsoft.Adapters.OracleDB.Config' in the folder 'C:\Program Files\Microsoft BizTalk Adapter Pack(x64)\bin':

            <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
                <dependentAssembly>
                    <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" culture="neutral" />
                        <bindingRedirect oldVersion="2.111.7.00" newVersion="2.111.7.20"/>
                </dependentAssembly>
            </assemblyBinding>

    HTH

    Regards,

    Steef-Jan Wiggers - MVP & MCTS BizTalk Server
    blog: http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly


    BizTalk
    Friday, September 3, 2010 6:30 PM
    Moderator
  • Thanks Steef. Will try the same and provide an update.
    Friday, September 3, 2010 6:43 PM
  • The above change did not help and the error persists.
    Friday, September 3, 2010 6:49 PM
  • Hi,

    It seems that you miss the appropiate Oracle.DataAccess assembly or cannot be reached. You can read my blogpost BizTalk Adapter Pack 2.0: OracleBinding around this or this thread on forums (if you haven't seen them yet).  You can also read my article in latest hotrod 8.  Another option is to review this thread or this thread on BizTalk Adapter Pack forum.

    HTH

    Regards,

    Steef-Jan Wiggers - MVP & MCTS BizTalk Server
    blog: http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly

     


    BizTalk
    Friday, September 3, 2010 7:01 PM
    Moderator
  • Thanks Steef. Will review the links as provided.
    Friday, September 3, 2010 7:31 PM
  • Have you installed both 32 and 64bit versions of the adapter pack?

     

    Some of the client ui's still read the 32bit config, thus when using the Oracle adapter, both configurations need to be in place for the 32bic and 64bit versions.

     

    HTH


    MCT, MCSD.NET, BizTalk TS
    Friday, September 3, 2010 9:39 PM
  • Hi Dwight

     

    Yes I have both the versions installed. Any other suggestion ?

    Saturday, September 4, 2010 4:15 AM
  • Is the order of installation for the various Oracle components as required by the adapter important. The issue still remains unresolved
    Friday, September 10, 2010 2:58 PM
  • order of installtion is not important. Ensure that you have both 32 and 64 bit Oracle clients installed, and that both 32 bit and 64 bit Oracle.DataAccess.dll is present in the machine GAC.
    Monday, September 13, 2010 10:49 AM
  • Thanks Manas. Can you tell me how to determine the the version of the Orcle client installed. I do hve orcle client installed which I think is 64-bit, not sure
    Tuesday, September 14, 2010 12:21 AM
  • an easy way to check is to go to the system GAC, and check the processor architecture of Oracle.DataAccess.

    For the adapter to function correctly, you'll need both 32 and 64 bit Oracle clients.

    Tuesday, September 14, 2010 4:54 AM
  • Thanks Manas.I have the following versions - Oracle.DataAccess - 2.111.7.20 (x86) Oracle.DataAccess - 2.112.1.0 (AMD64) The error in the eventlog says - System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Thanks !
    Tuesday, September 14, 2010 5:30 PM
  • sbaharati,

    Did you get it installed?

    Thanks

    Ann

    Thursday, September 16, 2010 6:23 PM
  • Hi Ann, my issue is still unresolved.Not sure what installation you are asking about
    Thursday, September 16, 2010 6:36 PM
  • Sbharati,

    I saw couple of posts says that Adapter pack 2.0 does not support Oracle 11gR2. Just want to make sure whether it is true. I was talking about the Oracle Installation. It seems your environment is Oracle 11gR2. As far as I know Oracle client 11g R2 32 bit is not available. My environment is same with BizTalk sever 2010. I am really confused with Oracle installation.

    Thanks

    Ann

    Thursday, September 16, 2010 9:16 PM
  • To summarize for everyone,

    On a 32 bit installation, you need:

    1 WCF LOB Adapter SDK 32 bit
    2 Adapter Pack 32 bit
    3 Oracle Client including ODP.NET 11.1.0.7 32 bit

    On 64 bit installation, you need:

    1 WCF LOB Adapter SDK 64 bit
    2 Adapter Pack 32 bit
    3 Adapter Pack 64 bit
    4 Oracle Client inluding ODP.NET 11.1.0.7 32 bit
    5 Oracle Client including ODP.NET 11.1.0.7 64 bit

    If you are not able to get it working even with this data, I suggest you contact support so that they can guide you.

    Friday, September 17, 2010 9:48 AM
  • Manas, could you give me the link to download the Oracle client please. 
    Friday, September 17, 2010 12:23 PM
  •  

    Try this. Install Oracle 11g ODAC 11.1.0.7.20

    http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html

    I installed the above one, when I faced the same error and it solved the issue.

    Good luck

    Ann

    Friday, September 17, 2010 8:38 PM
  • Thanks everyone. The issue is finally resolved. It took some troubleshooting to determine this one. Thanks all for help !
    Saturday, September 18, 2010 11:04 PM