BizTalk 2020 WCF-OracleDB adapter Error

%3CLINGO-SUB%20id%3D%22lingo-sub-2588307%22%20slang%3D%22en-US%22%3EBizTalk%202020%20WCF-OracleDB%20adapter%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2588307%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20WCF-Oracle%20DB%20send%20port%20and%20I%20get%20this%20error.%20I%20have%20Installed%20both%26nbsp%3BODP.NETUnmanaged19.10Xcopy32bit%20and%26nbsp%3BODP.NETUnmanaged19.10Xcopyx64%20and%20used%20the%20command%20OraProvCfg.exe%20%2Faction%3Agac%20%2Fproviderpath%3A%22Oracle.DataAccess.dll%22%20to%20Gac%20the%20Dlls.%20Also%20I%20have%20changed%20the%20machine%20config%20on%20both%20Framework%20and%20Framework64%20to%20point%20to%20this%20version.%3C%2FP%3E%3CP%3E%3CRUNTIME%3E%3CBR%20%2F%3E%3CASSEMBLYBINDING%20xmlns%3D%22%26quot%3Burn%3A%22%3E%3CBR%20%2F%3E%3CDEPENDENTASSEMBLY%3E%3CBR%20%2F%3E%3CASSEMBLYIDENTITY%20name%3D%22%26quot%3BOracle.DataAccess%26quot%3B%22%20publickeytoken%3D%22%26quot%3B89b483f429c47342%26quot%3B%22%3E%3C%2FASSEMBLYIDENTITY%3E%3CBR%20%2F%3E%3CBINDINGREDIRECT%20oldversion%3D%22%26quot%3B4.122.18.3%26quot%3B%22%20newversion%3D%22%26quot%3B4.122.19.1%26quot%3B%22%3E%3C%2FBINDINGREDIRECT%3E%3CBR%20%2F%3E%3C%2FDEPENDENTASSEMBLY%3E%3CBR%20%2F%3E%3C%2FASSEMBLYBINDING%3E%3CBR%20%2F%3E%3C%2FRUNTIME%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20running%20out%20of%20ideas%20here.%20Any%20body%20encountered%20the%20same%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WCFOracleDB%20error.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298485i32686F88CB7ECE67%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22WCFOracleDB%20error.png%22%20alt%3D%22WCFOracleDB%20error.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CSYSTEM.DATA%3E%3CBR%20%2F%3E%20%3CDBPROVIDERFACTORIES%3E%3CBR%20%2F%3E%20%3CADD%20name%3D%22%26quot%3BOracle%22%20data%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20provider%3D%22%22%20for%3D%22%22%20.net%3D%22%22%3E%3C%2FADD%3E%3CBR%20%2F%3E%20%3C!--%3Cadd%20name%3D%26quot%3BOracle%20Data%20Provider%20for%20.NET%26quot%3B%20invariant%3D%26quot%3BOracle.DataAccess.Client%26quot%3B%20description%3D%26quot%3BOracle%20Data%20Provider%20for%20.NET%26quot%3B%20type%3D%26quot%3BOracle.DataAccess.Client.OracleClientFactory%2C%20Oracle.DataAccess%2C%20Version%3D4.122.18.3%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3D89b483f429c47342%26quot%3B%20%2F%3E--%3E%3CBR%20%2F%3E%20%3C%2FDBPROVIDERFACTORIES%3E%3CBR%20%2F%3E%20%3C%2FSYSTEM.DATA%3E%3CBR%20%2F%3E------%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20also%20make%20sure%20to%20update%20to%20the%20latest%20BizTalk%202020%20CU%20(CU2%20currently)%20as%20there%20were%20some%20updates%20related%20to%20Oracle%20adapter%20after%20initial%20RTM%20release.%20%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20this%20helps.%3CLINGO-SUB%20id%3D%22lingo-sub-2754238%22%20slang%3D%22en-US%22%3ERe%3A%20BizTalk%202020%20WCF-OracleDB%20adapter%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2754238%22%20slang%3D%22en-US%22%3EIf%20you%20changed%20BTSNTSvc.exe.config%20%2F%20BTSNTSvc64.exe.config%20files%2C%20you%20may%20also%20need%20to%20change%20MMC.exe.config%20(BizTalk%20admin%20console)%20for%20BizTalk%20admin%20console.%20You%20may%20also%20need%20to%20change%20the%20Oracle.DataAccess.Client%20to%20point%20to%20newer%20version%20(see%20below).%20%3CBR%20%2F%3E%3CBR%20%2F%3E-----%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fbiztalk%2Fadapters-and-accelerators%2Fpost-installation-steps-for-biztalk-adapter-pack-2016%23use-a-newer-oracledataaccessdll-version%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fbiztalk%2Fadapters-and-accelerators%2Fpost-installation-steps-for-biztalk-adapter-pack-2016%23use-a-newer-oracledataaccessdll-version%3C%2FA%3E%3CBR%20%2F%3E-----%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CDEPENDENTASSEMBLY%3E%3CBR%20%2F%3E%20%3CPUBLISHERPOLICY%20apply%3D%22%26quot%3Bno%26quot%3B%22%3E%3C%2FPUBLISHERPOLICY%3E%3CBR%20%2F%3E%20%3CASSEMBLYIDENTITY%20name%3D%22%26quot%3BOracle.DataAccess%26quot%3B%22%20publickeytoken%3D%22%26quot%3B89b483f429c47342%26quot%3B%22%20culture%3D%22%26quot%3Bneutral%26quot%3B%22%3E%3C%2FASSEMBLYIDENTITY%3E%3CBR%20%2F%3E%20%3CBINDINGREDIRECT%20oldversion%3D%22%26quot%3B0.0.0.0-65535.65535.65535.65535%26quot%3B%22%20newversion%3D%22%26quot%3B4.122.19.1%26quot%3B%22%3E%3C%2FBINDINGREDIRECT%3E%3CBR%20%2F%3E%20%3C!--%3CbindingRedirect%20oldVersion%3D%26quot%3B0.0.0.0-65535.65535.65535.65535%26quot%3B%20newVersion%3D%26quot%3B4.122.18.3%26quot%3B%20%2F%3E%20--%3E%3CBR%20%2F%3E%20%3C%2FDEPENDENTASSEMBLY%3E%3CBR%20%2F%3E%20%3C%2FLINGO-BODY%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CSYSTEM.DATA%3E%3CBR%20%2F%3E%20%3CDBPROVIDERFACTORIES%3E%3CBR%20%2F%3E%20%3CADD%20name%3D%22%26quot%3BOracle%22%20data%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20provider%3D%22%22%20for%3D%22%22%20.net%3D%22%22%3E%3C%2FADD%3E%3CBR%20%2F%3E%20%3C!--%3Cadd%20name%3D%26quot%3BOracle%20Data%20Provider%20for%20.NET%26quot%3B%20invariant%3D%26quot%3BOracle.DataAccess.Client%26quot%3B%20description%3D%26quot%3BOracle%20Data%20Provider%20for%20.NET%26quot%3B%20type%3D%26quot%3BOracle.DataAccess.Client.OracleClientFactory%2C%20Oracle.DataAccess%2C%20Version%3D4.122.18.3%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3D89b483f429c47342%26quot%3B%20%2F%3E--%3E%3CBR%20%2F%3E%20%3C%2FDBPROVIDERFACTORIES%3E%3CBR%20%2F%3E%20%3C%2FSYSTEM.DATA%3E%3CBR%20%2F%3E------%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20also%20make%20sure%20to%20update%20to%20the%20latest%20BizTalk%202020%20CU%20(CU2%20currently)%20as%20there%20were%20some%20updates%20related%20to%20Oracle%20adapter%20after%20initial%20RTM%20release.%20%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20this%20helps.
Regular Visitor

I am trying to create a WCF-Oracle DB send port and I get this error. I have Installed both ODP.NETUnmanaged19.10Xcopy32bit and ODP.NETUnmanaged19.10Xcopyx64 and used the command OraProvCfg.exe /action:gac /providerpath:"Oracle.DataAccess.dll" to Gac the Dlls. Also I have changed the machine config on both Framework and Framework64 to point to this version.

<runtime>
<assemblyBinding xmlns="urn: schemas-microsoft-com: asm.v1">
<dependentAssembly>
<assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" />
<bindingRedirect oldVersion="4.122.18.3" newVersion="4.122.19.1" />
</dependentAssembly>
</assemblyBinding>
</runtime>

 

I am running out of ideas here. Any body encountered the same issue?

 

WCFOracleDB error.png

 

1 Reply
If you changed BTSNTSvc.exe.config / BTSNTSvc64.exe.config files, you may also need to change MMC.exe.config (BizTalk admin console) for BizTalk admin console. You may also need to change the Oracle.DataAccess.Client to point to newer version (see below).

-----
https://docs.microsoft.com/en-us/biztalk/adapters-and-accelerators/post-installation-steps-for-bizta...
-----

<dependentAssembly>
<publisherPolicy apply="no" />
<assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="4.122.19.1" />
<!--<bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="4.122.18.3" /> -->
</dependentAssembly>
</assemblyBinding>
</runtime>

<system.data>
<DbProviderFactories>
<add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342" />
<!--<add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342" />-->
</DbProviderFactories>
</system.data>
------

I would also make sure to update to the latest BizTalk 2020 CU (CU2 currently) as there were some updates related to Oracle adapter after initial RTM release.

I hope this helps.