Tuesday, September 22, 2009

ORA-03114: not connected to ORACLE and Biztalk Oracle Adapter

Problem

You receive an error "ORA-03114: not connected to ORACLE" when you are trying to connect to the Oracle database with Biztalk Oracle Adapter. This error can occur even if you was connected to the database just few seconds ago.


Solution

Problem relates to the connection pool.

If the connection pooler detect that the connection with the server has been broken it will remove the broken connection from the connection pool. This doesn't happen all the time and you actually get a bad connection from the pool.

Workaround is to change Send port settings: Change useOracleConnectionPool to false at Bindings tab

2 comments:

  1. what adapter is it ... is this the Oracle (BizTalk Adapter for Enterprise Applications) or the WCF one as I don't see such property there on my adapter. I'm using BizTalk Adapter for Enterprise Application out of LOB Adapter Pack 1

    ReplyDelete
  2. For WCF based Oracle adapter...

    ReplyDelete