Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02049: timeout: distributed transaction waiting for lock (Oracle 10g)
ORA-02049: timeout: distributed transaction waiting for lock [message #445613] Tue, 02 March 2010 23:13 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi ,

I am getting ORA-02049: timeout: distributed transaction waiting for lock , how to resolve this type error
Re: ORA-02049: timeout: distributed transaction waiting for lock [message #445614 is a reply to message #445613] Tue, 02 March 2010 23:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
02048, 00000, "attempt to begin distributed transaction without logging on"
// *Cause: client program must issue a distributed transaction login.
// *Action: contact support.


I can't debug code I can not see.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: ORA-02049: timeout: distributed transaction waiting for lock [message #445616 is a reply to message #445613] Tue, 02 March 2010 23:18 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member


ORA-02049: timeout: distributed transaction waiting for lock 
Re: ORA-02049: timeout: distributed transaction waiting for lock [message #445617 is a reply to message #445616] Tue, 02 March 2010 23:20 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I need to learn how to use CUT & PASTE!

02049, 00000, "timeout: distributed transaction waiting for lock"
// *Cause: exceeded INIT.ORA distributed_lock_timeout seconds waiting for lock.
// *Action: treat as a deadlock
Previous Topic: cursor prblem?
Next Topic: Need Assistance On PL/SQL Coding
Goto Forum:
  


Current Time: Sun Feb 16 00:43:48 CST 2025