FAN In ODP.NET With Connection Pooling Not Working During Dataguard Role Transitions

(Doc ID 1454341.1)

Last updated on NOVEMBER 08, 2013

Applies to:

Oracle Data Provider for .NET - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Microsoft Windows x64 (64-bit)
***Checked for relevance on 08-Nov-2013***

Symptoms

Using 4.112.2.0 ODP.NET with 11.2.0.2.0 Client on Windows 64-bit, an application crashes when a Dataguard switchover is performed against an 11.2.0.2 Database on Windows 2008 R2.

The following errors were received in the ODP.NET application:

ORA-03113: end-of-file on communication channel

 

Unhandled Exception: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

at Oracle.DataAccess.Client.OpsCon.RegisterCallbacks(IntPtr& opsConCtx, IntPtr& opsErrCtx, OpoConValCtx* pOpoConValCtx, OpoConRefCtx& pOpoConRefCtx)
at Oracle.DataAccess.Client.ConnectionDispenser.RegisterCallbacks(OpoConCtx opoConCtx)
at Oracle.DataAccess.Client.ConnectionPool.PopulatePool(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms