none
Oracle 11g Client And BizTalk Adapter Pack 2.0 RRS feed

  • Question

  • Hi,

    I am using Biz Talk Server 2006 R2 on Windows Server 2003 (64 bit). I have installed Biz Talk Adapter Pack 2.0 and Oracle Client 11g. 

    When I try to connect to Oracle database and add a schema in my project, I get following error.

    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.

    I see that Oracle.DataAccess.dll with above PublicKeytoken present in GAC.

    Please advice. Thanks in advance.

    Ashish
    Monday, June 22, 2009 10:43 PM

Answers

  • It worked guys,

    My environment is Windows Server 2003 (64 bit), VS 2005.

    I am able to connect to Oracle database using 11g client(Beta), Biz Talk adapter 2.0 adapter. I installed following components to get it worked.

    1. Biz Talk adapter Pack 32 bit and 64 bit.
    2. Biz Talk WCF LOB adapter SDK 64 bit.
    3. ODAC 1110710 beta. (Downloaded from OTN)

    I hope it helps.

    Regards
    Ashish
    • Marked as answer by Ashish_Kar Tuesday, June 30, 2009 5:25 PM
    Tuesday, June 30, 2009 5:25 PM

All replies

  • Hey,

    I am assuming that you insalled 64-bit 11g client. Visual studio is 32-bit process and you need to have the 32-bit 11g client intsalled.

    Please refer to the section "Scenarios for Installing the BizTalk Adapter Pack on 32-bit and 64-bit Platforms" in the install guide:
    http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ff0b19a6-72c1-43b3-9d38-b874303590ce 

    Pls let us know if you have any further questions.

    Thanks,
    Murali
    This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
    Tuesday, June 23, 2009 3:51 AM
  • Hi,

    other question: Which version of ODAC do you use?

    The only version of the ODAC faultless works with Oracle 11g is the from Oracle Metalink.

    Regards
    Oliver

    Tuesday, June 23, 2009 11:26 AM
  • Hi Oliver,

    You need to use Oracle Data Provider for .NET (ODP.NET) 11.1.0.7 to use the adapter.

    I didn't understand the second part of your question.

    Thanks,
    Murali
    This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
    Tuesday, June 23, 2009 2:34 PM
  • Hi Murali,

    there is no official 64-bit edition of ODP.NET 11.1.0.7. There is an unofficial 64-bit version as part of the Oracle Support (Oracle Metalink).

    I think the error is caused from an incorrect version.

    Regards
    Oliver

    Tuesday, June 23, 2009 2:53 PM
  • Thanks for the reply.

    I am using ODAC version 11.1.0.6.20.
    I think I will have to get the version Oliver is talking about form Metalink.

    Another point I am getting stuck at is following.

    I have installed Oracle Client 11.1.0.6 with Patch Set 11.1.0.7.

    When I try to install ODAC and select existing Oracle Home as that of the oracle client, I get following error
    OUI-10044. The selected Oracle home location already contains an Oracle home or APPL_TOP created while running a different OS.

    If I create new Oracle Home for ODAC, it get installed. But as far as I know, we should have only one Oracle home on a computer to get it working right ?
    (I am new to Oracle).

    Oliver, can you please let me know unofficial the 64-bit edition of ODP.NET 11.1.0.7?

    Regards
    Ashish

    Tuesday, June 23, 2009 5:15 PM
  • You need to apply patch number 8219268 in order to get 64-bit version of ODP.NET 11.1.0.7 Windows.


    Thanks,
    Murali


    This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
    Tuesday, June 23, 2009 5:31 PM
  • Murali,

    I did apply the above patch but I am still getting the same error.

    Connecting to the LOB system has failed.
    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..

    Do you have any document describing the whole process of using Biz Talk Adapter Pack 2.0 with Oracle client 11g (VS 2005 and Windows Server 2003 (64 Bit))?

    Regards
    Ashish
    Wednesday, June 24, 2009 8:11 PM
  • You're using 64 bit ODP.NET only? To use the design time, you need to install both 32 and 64 bit BAP + ODP.NET as is already mentioned at http://msdn.microsoft.com/en-us/library/dd787836.aspx towards the end.
    Thursday, June 25, 2009 6:31 PM
  • Manas,

    Thanks for the reply.
    I did install both 32 and 64 bit Biz Talk adapter packs and I do see the Oracle Adapter in design time from VS 2005. The error occurs when I try to connect to Oracle database by clicking 'Connect' button on the UI.

    Regards
    Ashish
    Friday, June 26, 2009 3:03 PM
  • Can you pls confirm that you've installed 32-bit and 64-bit 11.1.0.7 ODP.NET versions?


    This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
    Friday, June 26, 2009 3:11 PM
  • Can you check what version of Oracle.DataAccess.dll is present in the GAC?
    Friday, June 26, 2009 3:11 PM
  • My guess is that the Oracle assembly is somehow not gac'd or you have wrong version of ODP.NET on your system.
    Saturday, June 27, 2009 10:31 AM
  • It worked guys,

    My environment is Windows Server 2003 (64 bit), VS 2005.

    I am able to connect to Oracle database using 11g client(Beta), Biz Talk adapter 2.0 adapter. I installed following components to get it worked.

    1. Biz Talk adapter Pack 32 bit and 64 bit.
    2. Biz Talk WCF LOB adapter SDK 64 bit.
    3. ODAC 1110710 beta. (Downloaded from OTN)

    I hope it helps.

    Regards
    Ashish
    • Marked as answer by Ashish_Kar Tuesday, June 30, 2009 5:25 PM
    Tuesday, June 30, 2009 5:25 PM
  • Hi All,

    I have WCF-LOB Oracle adapter installed E:
    I have Oracle 11. Installed on E:

    I can generate schemas but when deploy started to Test it says

    "TNS alias is longer than 39 characters, or (b) ambient transaction is present and a non-TNS based URI was used. To resolve this, use a TNS alias to connect to Oracle and make sure it is not more than 39 characters."

    I did the following checks:

    1. Checked the Sqlnet.ora filen TnsNames.ora files both exist under E:\Oracle\Product\11.1.0\Client_1\network\admin
    2. Sqlnet.Ora --->SQLNET.AUTHENTICATION_SERVICES = (NTS)
    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

    3.TNSNAMES.ora
    ABCDE1 =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = ABC11111)(PORT = 1522))
        )
        (CONNECT_DATA =
          (SID = ABCDE1)
        )
      )
    4. From Command Promt(C:\)I checked using SQLPLUS  xyz/abc@ABCDE1 (gave dummy userid)
       It gives me ERROR: ORA-01017 invalid username/password; login denied.
    5. Checked with right Credentials :
       It gives me ERROR : ORA-12560: TNS: Protocol Adapter error.

    6. From Start--All Programs-Oracle Client 11-Application Development --SQLPLUS
        Cheked with both bad and good credentials
        This it gave me ORA-12560- TNS:Protocol Adapter Error both times.
    7.  I Tried to chek with System DSN in the TNS drodownlist i dont see ABCDE1.
     8. The Schema generation form WCF Consume adaptor works when I keep URIProperties: ServiceType : DEDICATED
    8. If i change Service Type : Shared it gives me ORA-12520 : TNS:listener could not find available handler for requested type of server.

    Can you please guide me What I am missing. What Additional things do i consider to make it to work.
    I am my delivery dates .

    Thanks,

    Saturday, July 25, 2009 7:31 PM
  • Adding this to the file 'Microsoft.Adapters.OracleDB.Config' in the folder 'C:\Program Files\Microsoft BizTalk Adapter Pack(x64)\bin' worked for me:

            <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>

    Jesper

    Thursday, June 10, 2010 8:36 AM
  • This works for me as well, I have installed Oracle ODAC1110720 (2.111.7.20) I modified they config file and it works fine, thanks Jesper for that great help.

     

    Tuesday, August 24, 2010 9:47 AM
  • There are 3 type sof downloads for ODAC1110720. WHich one should I be using? My inclination is to use the first one, but would like to hear from the experts if it makes any difference.

    • Oracle 11g ODAC 11.1.0.7.20 with Oracle Developer Tools for Visual Studio
    • Oracle 11g ODAC 11.1.0.7.20 with Xcopy Deployment
    • Oracle 11g ODAC 11.1.0.7.20

    I have similar platform as others;

    • Windows Server 2008 R2(64 bit)

    I have already installed

    • WCF LOB Adapter Pack SP2
    • Adapter Pack 2.0- 32 bit and 64 bit

     

    Thanks for all the information.

     

     

    • Proposed as answer by Private123 Tuesday, March 1, 2011 2:31 PM
    Wednesday, August 25, 2010 3:13 PM
  • Hi,

    There is no difference with ODAC 11.1.0.7.20 itself, but with extra components that delivered with it i.e. tools for VS (dependency is that you have VS installed!) I can imaging in DTAP strategy, on will use Oracle 11g ODAC 11.1.0.7.20 with Oracle Developer Tools for Visual Studio on Development environment and Oracle 11g ODAC 11.1.0.7.20 with/without Xcopy Deployment on other. I have used Oracle 11g ODAC 11.1.0.7.20 in a recent integration project with Oracle.

    Regards,

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


    BizTalk
    • Proposed as answer by curious_mind Thursday, August 26, 2010 1:46 PM
    Wednesday, August 25, 2010 4:19 PM
    Moderator
  • Thank you. I just wanted to hear that from the experts. Since I have Visual Studio installed, I will go with first one.

    Thanks again.

    Thursday, August 26, 2010 1:47 PM