Home > problem-cause-solution > Distributed transaction error ORA-02049: time-out: distributed transaction waiting for lock

Distributed transaction error ORA-02049: time-out: distributed transaction waiting for lock


Problem

While working with dblinks, I got the below error:

ORA-02049: time-out: distributed transaction waiting for lock

 

Cause

More than one session is accessing the remote object.

 

Solution

I had issued commit, rollback for one of the session and the issue is resolved.

But, the key thing here is that; I could only reproduce the error while issueing below statement:

insert /*+ APPEND PARALLEL(4)*/ into admin.test2 
select /*+ DRIVING_SITE(T) PARALLEL(4) */ * from admin1.test2@MYDB2.WORLD T where 1=1
;

While trying it without APPEND hint it does not occur.

Honestly speaking, I did not know the real cause, because sometimes I could not reproduce the error.

The transactions  are not listed in:

select * from dba_2pc_pending; 

select * from dba_2pc_neighbors;

 

 

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!

nimaidba

Welcome to the world of Oracle with me....

Tech

News and reviews from the world of gadgets, gear, apps and the web

WordPress.com

WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.

%d bloggers like this: