We are facing intermittent issue of "ORA-03106: fatal two-task communication protocol error" while performing the below operation.
Basically we are using oracle advance queue in the application, the below code is used to de-queue the entry.
Please note that issue intermittent and cannot be produced at will.using (var sourceQueue = new OracleQueue(SourceQueueName, oracleConnection))
{
var dequeueOptions = new OracleQueueDequeueOptions
{
DequeueMode = OracleQueueDequeueMode.Remove,
Visibility = OracleQueueVisibility.OnCommit,
/* Utilizing WaitTimeout parameter for OracleQueueDequeueOptions.
If WaitTimeout = -1 (by default), the Dequeue() method waits for a message to come, and does not return until the message arrives.
If WaitTimeout = 0, the Dequeue() method checks for a message and returns immediately. If there is no message, an exception is thrown.
If WaitTimeout > 0, it designates a number of seconds to wait for a message. If no message is received during this timeout, an exception is thrown.
*/
WaitTimeout = WaitTimeoutOptionForQueue
};
Below are the environment details :
Windows 2012 Standard R2
Oracle Client 12.1.0
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Devart.Data.dll 5.0.1408.0
Devart.Data.Oracle.dll 8.5.616.0
Devart dotConnect for Oracle Profession 8.5.616.0
.Net Framework 4.0
We have raised this with our DBA team, they have checked this at oracle server end for this error in the logs, but nothing could be found.
Please help us in identifying the issue & resolution.
Thanks,
Sanjay