ORA-03106: fatal two-task communication protocol error

[san_eins]

Hi Team,

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.

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


};

Please note that issue intermittent and cannot be produced at will.

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

[Pinturiccio]

Could you try using the latest dotConnect for Oracle 9.6.696? Your version 8.5.616 was released 2 years ago, and lot of changes were made since that time. You can download the trial version of dotConnect for Oracle from our site https://www.devart.com/dotconnect/oracle/download.html

You have also sent us the code sample. Is the issue reproduced when you initialize OracleQueueDequeueOptions or when performing dequeue? Please create and send us a small complete test project, which reproduces the issue. Please also send us the DDL/DML scripts for the objects, used in the project. The scripts should be complete enough to create these object in a clean Oracle database.