Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using ODP.Net with Biztalk Adapter oracleDBBinding fails

791627Aug 16 2010
Hello,

I try to connect to Oracle Database 10G from a Biztalk Adapter oracleDBBinding.

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

I try with the second Biztalk Adapter OracleEBSBinding with same connection information and I connect to the database without errors.

I activate the trace 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)
....

Can you help me to understand why the first adapter oracleDbBinding can't work ?

I use the follwoing version of ODP.Net Oracle.DataAccess.dll => 2.112.1.0

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2010
Added on Aug 16 2010
0 comments
1,069 views