Using ODP.Net with Biztalk Adapter oracleDBBinding fails
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