Home » RDBMS Server » Server Administration » -2049ORA-02049: timeout: distributed transaction waiting for lock
-2049ORA-02049: timeout: distributed transaction waiting for lock [message #238394] Thu, 17 May 2007 15:53 Go to next message
vish3210
Messages: 4
Registered: August 2006
Location: Portland
Junior Member
Hi there

we got ORA-02049: timeout: distributed transaction waiting for lock during commit process. As my understanding, the error comes from a DML statement that requires locks on a database can be blocked if another transaction own locks on the requested data. Does any one have any comments? Thanks for any input.

Thank you,
--vimal

Report message to a moderator

Re: -2049ORA-02049: timeout: distributed transaction waiting for lock [message #238428 is a reply to message #238394] Fri, 18 May 2007 00:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
 
ora-02049: timeout: distributed transaction waiting for lock
 *Cause: exceeded INIT.ORA distributed_lock_timeout seconds waiting for lock.
 *Action: treat as a deadlock

Regards
Michel

Report message to a moderator

Re: -2049ORA-02049: timeout: distributed transaction waiting for lock [message #238632 is a reply to message #238428] Fri, 18 May 2007 15:46 Go to previous messageGo to next message
vish3210
Messages: 4
Registered: August 2006
Location: Portland
Junior Member
Mitchel,

I wonder is there way to resolve this. distributed_lock_timeout by increasing the time on this OR any other best suitable method. Please advice.

Thank you,
--Vimal

Report message to a moderator

Re: -2049ORA-02049: timeout: distributed transaction waiting for lock [message #238634 is a reply to message #238632] Fri, 18 May 2007 15:50 Go to previous message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The advice is in the "action" part: treat this as a deadlock.

Regards
Michel

Report message to a moderator

Previous Topic: Unable to invoke Net Configuration Assistant
Next Topic: faq
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:44:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.