none
WCF-OracleDBBinding fails with stange message RRS feed

  • Question

  • Hello,

    I try to connect to Oracle database and i Have a strange error message :

    Connecting to the LOB system has failed.
    ORA-28045: échec de l'authentification SSL entre la base de données et OID.

    I use Biztalk 2010 Béta on windows 7 64 bits.

    I have installed ODP.Net (32 bits and 64 bits) from official release 11G client (Not the Béta) and our server is in the 10G release.

    I can connect to Oracle with the WCF-OracleEBSBinding without errors and directly from code with ODP.Net

    Can you help me to understand the problem ? (I asked to our DBA but they only looked my computer configuration and don't look the server traces or It seems that this message is sent by the oracle server)

    Thanks,


    Yannick
    Wednesday, July 28, 2010 10:45 AM

Answers

  • Hi,

    This issue has been solved. I don't know how but I think that DBAs have changed configuration parameters on their Oracle Engine.

    Thank you for your support !


    Yannick
    • Marked as answer by YGO Wednesday, January 19, 2011 9:50 AM
    Wednesday, January 19, 2011 9:50 AM

All replies

  • It sounds like the account used to access the Oracle DB might be an LDAP account stored in the Oracle Internet Directory. This other thread suggests LDAP authentication was not supported in BizTalk 2009: http://social.msdn.microsoft.com/Forums/en-US/biztalkr2adapters/thread/2d603c88-d42f-4d29-80f6-6581f89474a3. I am guessing it may be supported in BizTalk 2010, but it could still be buggy.

    Here is a link with the error text in English: http://www.oradev.com/ORA-28045.jsp. The text says it is an authentication issue. I am guessing maybe the BizTalk host account is unable to connect to OID. Is your test of the OracleEBSBinding using the same host account of where you are trying the OracleDBBinding? If not, try using the same account.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Thursday, July 29, 2010 5:52 AM
    Moderator
  • With OracleEBSBinding, I use the same User/Password and the same DatasourceName.

    If i well understand, Oracle Adpaters used ODP.Net to connect to databses so OracleEBSBinding and OracleDBBinding could use the same channel to connect to Oracle Database. As DBA are not concerned by this issue and don't read traces on Oracle databse server, could it possible to activate trace on Oracle Adapters and ODP.Net to see if they use the same way to connect to the database.

     

    Thanks,


    Yannick
    Friday, July 30, 2010 9:40 AM
  • I know the OracleDBBinding does rely on ODP.NET in some way but am not sure if this is in the login logic.

    Do you know if the OracleDBBinding works with BizTalk 2009? BizTalk 2010 is currently in beta and is not as stable. I am not sure what changes may have occurred to the OracleDBBinding for 2010 but I would anticipate at least a few changes.

    I would try setting up an environment with BizTalk 2009 because this version of the product is much more stable at this point. This may give you some better diagnostic information as well you could use in determining the problem you have with the 2010 version.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    • Marked as answer by Andrew_ZhuModerator Wednesday, August 4, 2010 8:54 AM
    • Unmarked as answer by YGO Monday, August 16, 2010 3:58 PM
    Friday, July 30, 2010 1:23 PM
    Moderator
  • Hello,

    After holidays, I come back with the real world....

    Thanks for your help. I Have installed the Adapter with Biztalk 2009 and I have the same issue.

    I have activated trace from ODP.Net and i have the following trace :

    With oracleDBBinding :
    TIME:2010/08/16-12:10:28:866 TID: b4c (ENTRY) OracleConnection::OracleConnection(2)
    TIME:2010/08/16-12:10:28:881 TID: b4c (EXIT) OracleConnection::OracleConnection(2)
    TIME:2010/08/16-12:10:28:897 TID: b4c (ENTRY) OracleConnection::Open()
    TIME:2010/08/16-12:10:28:897 TID: b4c (ENTRY) OpsConAllocValCtx()
    TIME:2010/08/16-12:10:28:897 TID: b4c (EXIT) OpsConAllocValCtx(): RetCode=0 Line=394
    TIME:2010/08/16-12:10:28:913 TID: b4c (ENTRY) OpsConOpen()
    TIME:2010/08/16-12:10:28:913 TID: b4c (HA) OpsConOpen(): OciEvents=0 Line=1759
    TIME:2010/08/16-12:10:28:991 TID: b4c (ENTRY) OpsConAddRef(): (fb10458)=263259224
    TIME:2010/08/16-12:10:28:991 TID: b4c (EXIT) OpsConAddRef(): RefCount=1 RetCode=0 Line=3223 (fb10458)=263259224
    TIME:2010/08/16-12:10:28:991 TID: b4c (ENTRY) OpsConClose(): (fb10458)=263259224
    TIME:2010/08/16-12:10:28:991 TID: b4c (ENTRY) OpsConRelRef(): (fb10458)=263259224
    TIME:2010/08/16-12:10:28:991 TID: b4c (EXIT) OpsConRelRef(): RefCount=0 RetCode=0 Line=3399 (0)=0
    TIME:2010/08/16-12:10:28:991 TID: b4c (EXIT) OpsConClose(): RetCode=0 Line=1279 (fb10458)=263259224
    TIME:2010/08/16-12:10:28:991 TID: b4c (ENTRY) OpsConDispose(): (0)=0
    TIME:2010/08/16-12:10:28:991 TID: b4c (EXIT) OpsConDispose(): RetCode=0 Line=1357
    TIME:2010/08/16-12:10:28:991 TID: b4c (ENTRY) OpsErrGetOraMesg()
    TIME:2010/08/16-12:10:28:991 TID: b4c (EXIT) OpsErrGetOraMesg(): RetCode=0 Line=310

    With OracleEBSBinding :
    TIME:2010/08/16-12:12:35:420 TID: b4c (ENTRY) OracleConnection::OracleConnection(2)
    TIME:2010/08/16-12:12:35:420 TID: b4c (EXIT) OracleConnection::OracleConnection(2)
    TIME:2010/08/16-12:12:35:420 TID: b4c (ENTRY) OracleConnection::Open()
    TIME:2010/08/16-12:12:35:420 TID: b4c (ENTRY) OpsConAllocValCtx()
    TIME:2010/08/16-12:12:35:420 TID: b4c (EXIT) OpsConAllocValCtx(): RetCode=0 Line=394
    TIME:2010/08/16-12:12:35:420 TID: b4c (ENTRY) OpsConOpen()
    TIME:2010/08/16-12:12:35:420 TID: b4c (HA) OpsConOpen(): OciEvents=0 Line=1759
    TIME:2010/08/16-12:12:35:467 TID: b4c (ENTRY) OpsConAddRef(): (484fcc0)=75824320
    TIME:2010/08/16-12:12:35:467 TID: b4c (EXIT) OpsConAddRef(): RefCount=1 RetCode=0 Line=3223 (484fcc0)=75824320
    TIME:2010/08/16-12:12:35:467 TID: b4c (ENTRY) OpsErrAllocCtx(): (484fcc0)=75824320
    TIME:2010/08/16-12:12:35:467 TID: b4c (EXIT) OpsErrAllocCtx(): RetCode=0 Line=197 (484fcc0)=75824320
    TIME:2010/08/16-12:12:35:467 TID: b4c (EXIT) OpsConOpen(): RetCode=0 Line=2280 (484fcc0)=75824320
    TIME:2010/08/16-12:12:35:467 TID: b4c (ENTRY) OpsGetOptimumUsableMemoryInfo()
    TIME:2010/08/16-12:12:35:467 TID: b4c (EXIT) OpsGetOptimumUsableMemoryInfo(): returnValue=0 Line=1033
    TIME:2010/08/16-12:12:35:467 TID: b4c (ENTRY) OracleTuningAgent::Register()
    TIME:2010/08/16-12:12:35:467 TID: b4c (EXIT) OracleTuningAgent::Register()
    TIME:2010/08/16-12:12:35:545 TID: b4c (ENTRY) OpsConAllocValCtx()
    TIME:2010/08/16-12:12:35:545 TID: b4c (EXIT) OpsConAllocValCtx(): RetCode=0 Line=394
    TIME:2010/08/16-12:12:35:545 TID: b4c (POOL) New connection pool created for: "User Id=XXX;DECR POOL SIZE=1;STATEMENT CACHE SIZE=10;METADATA POOLING=True;POOLING=True;DATA SOURCE=XXX;MIN POOL SIZE=1;ENLIST=true;CONNECTION TIMEOUT=300;INCR POOL SIZE=5;VALIDATE CONNECTION=True;MAX POOL SIZE=100;CONNECTION LIFETIME=0;STATEMENT CACHE PURGE=False" (id: 1178642071)
    ....

    I also activated trace in the devenv.exe.config and I have the following trace with OracleDBBinding :

    <E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
    
    <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system">
    
    <EventID>0</EventID>
    
    <Type>3</Type>
    
    <SubType Name="Information">0</SubType>
    
    <Level>8</Level>
    
    <TimeCreated SystemTime="2010-08-16T10:44:09.8194070Z" />
    
    <Source Name="Microsoft.Adapters.OracleDB" />
    
    <Correlation ActivityID="{00000000-0000-0000-0000-000000000000}" />
    
    <Execution ProcessName="devenv" ProcessID="5996" ThreadID="9" />
    
    <Channel />
    
    <Computer>XXX</Computer>
    
    </System>
    
    <ApplicationData>
    
    <TraceData>
    
    <DataItem>
    
    <TraceRecord Severity="Information" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
    
    <TraceIdentifier>http://Microsoft.LobServices.OracleDB/2007/03Connections/</TraceIdentifier>
    
    <Description>Created OracleDBConnection instance with ID:5996::1::0</Description>
    
    <AppDomain>DefaultDomain</AppDomain>
    
    </TraceRecord>
    
    </DataItem>
    
    </TraceData>
    
    <System.Diagnostics xmlns="http://schemas.microsoft.com/2004/08/System.Diagnostics">
    
    <LogicalOperationStack></LogicalOperationStack>
    
    <Timestamp>48583200528000</Timestamp>
    
    </System.Diagnostics>
    
    </ApplicationData>
    
    </E2ETraceEvent>
    
    
    
    <E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
    
    <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system">
    
    <EventID>524293</EventID>
    
    <Type>3</Type>
    
    <SubType Name="Warning">0</SubType>
    
    <Level>4</Level>
    
    <TimeCreated SystemTime="2010-08-16T10:44:09.9287568Z" />
    
    <Source Name="System.ServiceModel" />
    
    <Correlation ActivityID="{00000000-0000-0000-0000-000000000000}" />
    
    <Execution ProcessName="devenv" ProcessID="5996" ThreadID="9" />
    
    <Channel />
    
    <Computer>XXX</Computer>
    
    </System>
    
    <ApplicationData>
    
    <TraceData>
    
    <DataItem>
    
    <TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Warning">
    
    <TraceIdentifier>http://msdn.microsoft.com/fr-CH/library/System.ServiceModel.CommunicationObjectOpenFailed.aspx</TraceIdentifier>
    
    <Description>Failed to open Microsoft.ServiceModel.Channels.Common.Channels.AdapterRequestChannel</Description>
    
    <AppDomain>DefaultDomain</AppDomain>
    
    <Source>Microsoft.ServiceModel.Channels.Common.Channels.AdapterRequestChannel/44624228</Source>
    
    </TraceRecord>
    
    </DataItem>
    
    </TraceData>
    
    <System.Diagnostics xmlns="http://schemas.microsoft.com/2004/08/System.Diagnostics">
    
    <LogicalOperationStack></LogicalOperationStack>
    
    <Timestamp>48583545933735</Timestamp>
    
    </System.Diagnostics>
    
    </ApplicationData>
    
    </E2ETraceEvent>
    
    

    Yannick
    • Marked as answer by YGO Wednesday, January 19, 2011 9:48 AM
    • Unmarked as answer by YGO Wednesday, January 19, 2011 9:48 AM
    Monday, August 16, 2010 10:53 AM
  • Hi,

    This issue has been solved. I don't know how but I think that DBAs have changed configuration parameters on their Oracle Engine.

    Thank you for your support !


    Yannick
    • Marked as answer by YGO Wednesday, January 19, 2011 9:50 AM
    Wednesday, January 19, 2011 9:50 AM