none
Sevral Oracle Clients on the BizTalk server issue RRS feed

  • Question

  • unfortunately we have several clients installed on the BizTalk production environment. The funny part is that BizTalk uses a the 11g client insatlled under the folder c:\app and the TNSPING uses the 10g client installed under c:\oracle in the registry the orahome is the c:\oracle folder.


    Is there a special definition, string or registry unit defining the oracle version to be used by BizTalk.


    We are running BizTalk 2006 R2.

    Wednesday, December 8, 2010 8:25 AM

Answers

  • Hi Tord,

    Which adapter are you using? WCF Oracle (the one that comes with the adapter pack) or Oracle LOB?

    Adapter pack (at least 2.0) only supports Oracle Client 11 (http://msdn.microsoft.com/en-us/library/dd788528(v=BTS.10).aspx).

    I had your same problem using adapter 2.0 (i needed client 10 to communicate with an older oracle server but WCF adapter doesn't support it).

    So i had to make WCF Oracle ports insist on client 11 and Oracle LOB ports using 10 .
    I don't know if there's a smarter way but what i did was to create 2 service accounts for biztalk (in fact which client to use is simply driven by PATH environment variable):

    The account called BTSUSER_LEGACY has PATH environment variable pointing to oracle client path 10 (c:\oracle\...)
    The standard account (BTSUSER?) has PATH environment variable pointing to oracle client path 11 (c:\apps\...)

    Once you have the two accounts you create one host instance for user and assing ports requiring Oracle Client 10 on the instance running with BTSUSER_LEGACY account and ports requiring Oracle Client 11 running on the instance running with BTSUSER.

    Hope this helps,
    Angelo
    Wednesday, December 8, 2010 10:57 AM

All replies

  • Hi Tord,

    Which version of Oracle.DataAccess.dll does your BizTalk Componennt uses, I beleive you would be using a .net class component to perform the data access?

    Regards

    Naushad


    http://alamnaushad.wordpress.com/
    Wednesday, December 8, 2010 10:07 AM
    Moderator
  • I currently have two installed:

     

    Oracle.DataAccess.dll - 2.102.3.2 (AMD 64)

    Oracle.DataAccess.dll - 2.111.7.20 (x86)

     

    the server is x64

    Wednesday, December 8, 2010 10:18 AM
  • Hi Tord,

     

    Whcih one is used while building your component?

     

    Regards

    Naushad


    http://alamnaushad.wordpress.com/
    Wednesday, December 8, 2010 10:40 AM
    Moderator
  • Hi Tord,

    Which adapter are you using? WCF Oracle (the one that comes with the adapter pack) or Oracle LOB?

    Adapter pack (at least 2.0) only supports Oracle Client 11 (http://msdn.microsoft.com/en-us/library/dd788528(v=BTS.10).aspx).

    I had your same problem using adapter 2.0 (i needed client 10 to communicate with an older oracle server but WCF adapter doesn't support it).

    So i had to make WCF Oracle ports insist on client 11 and Oracle LOB ports using 10 .
    I don't know if there's a smarter way but what i did was to create 2 service accounts for biztalk (in fact which client to use is simply driven by PATH environment variable):

    The account called BTSUSER_LEGACY has PATH environment variable pointing to oracle client path 10 (c:\oracle\...)
    The standard account (BTSUSER?) has PATH environment variable pointing to oracle client path 11 (c:\apps\...)

    Once you have the two accounts you create one host instance for user and assing ports requiring Oracle Client 10 on the instance running with BTSUSER_LEGACY account and ports requiring Oracle Client 11 running on the instance running with BTSUSER.

    Hope this helps,
    Angelo
    Wednesday, December 8, 2010 10:57 AM