Hi All,
Application Team has reported that they are getting the below error while running distributed transaction from their end.
Unable to enlist in a Distributed Transaction
FYI: (they are not getting any ORA error)
Below are the sessions as I checked from the database side:
SQL> select SID,status,program,machine,event from v$session where machine!='JBLDCVSDORA02';
SID STATUS PROGRAM MACHINE EVENT
---------- -------- ------------------------------------------------ ---------------------------------------------------------------- ----------------------------------------------------------------
29 INACTIVE w3wp.exe SADARA\JBLDCVSDMER02 SQL*Net message from client
80 INACTIVE w3wp.exe SADARA\JBLDCVSDMER02 SQL*Net message from client
93 INACTIVE w3wp.exe SADARA\JBLDCVSDMER02 SQL*Net message from client
155 INACTIVE w3wp.exe SADARA\JBLDCVSDMER02 SQL*Net message from client
225 INACTIVE w3wp.exe SADARA\JBLDCVSDMER02 SQL*Net message from client
The session will be in the same status and waiting on the same event for exact 10 mins and then will error out with that transaction error.
When checked with the application user, he says that this program will update a no. of records in a table and then commit.
But after exact 10 mins it's erroring out.
I want to know
1. Is there any parameter at the database side which defines this limit
2. What can be the cause of this error.
Thanks,
Sandeep