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
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: 64428
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
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
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: 64428
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
Previous Topic: Unable to invoke Net Configuration Assistant
Next Topic: faq
Goto Forum:
  


Current Time: Tue Feb 21 01:40:05 CST 2017

Total time taken to generate the page: 0.13346 seconds