ora 2049 error distributed_lock_timeout [message #639156] |
Thu, 02 July 2015 06:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/fc0c4f1effffe68370d04746da979732?s=64&d=mm&r=g) |
mvrkr44
Messages: 132 Registered: December 2012
|
Senior Member |
|
|
Hi All,
i am getting 0ra 2049 error in the below scenario...
DB:oracle 11g
version:11.2.0.4 RAC 2 node
os:OEL6
from application i am inserting values into primary table & child table at same time...While saving from .Net application i am getting error after some time
ora 2049 distibuted transaction lock...
i tried in all ways..but i didn't succeed.Could you please help me..
i tried to increase the parameter distributed_lock_timeout ,but no use after increasing also.
Regards,
Rajesh
|
|
|
|
|
|
Re: ora 2049 error distributed_lock_timeout [message #639164 is a reply to message #639163] |
Thu, 02 July 2015 08:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68662 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
It depends on the actual code and how it is executed.
The key point is "treat as a deadlock": you didn't say but I bet you use XA and one part of the transactions is on one node and the other one in other node.
Remove "load balancing" if you cannot analyze and change the code, it is then more likely it will work.
[Updated on: Thu, 02 July 2015 08:52] Report message to a moderator
|
|
|
|
|
|
|
Re: ora 2049 error distributed_lock_timeout [message #639307 is a reply to message #639305] |
Mon, 06 July 2015 01:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8937 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
This "solution" means that you are not using distributed transactions any more. Well, OK. But you also no longer have any of the fault tolerance capabilities for which you bought RAC. Oracle supports distributed transactions (which is an amazing piece of technology) you simply have to enable them.
|
|
|
|
|
|