GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Can not create capture, ORA-02049: timeout: distributed transaction waiting for lock

edited Mar 28, 2013 1:31AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
Dear All,

I want to create downstream database.
When I try to create capture at stream database, it show message as below:

 SQL> exec  DBMS_CAPTURE_ADM.CREATE_CAPTURE(queue_name => 'DOWNSTREAM_CAPTURE_Q',capture_name => 'DOWNSTREAM_CAPTURE_Q',rule_set_name => NULL, start_scn  => NULL, source_database  => 'ELTITX', use_database_link  => true, first_scn => NULL,logfile_assignment => 'implicit');
BEGIN DBMS_CAPTURE_ADM.CREATE_CAPTURE(queue_name => 'DOWNSTREAM_CAPTURE_Q',capture_name => 'DOWNSTREAM_CAPTURE_Q',rule_set_name => NULL, start_scn  => NULL, source_database  => 'ELTITX', use_database_link  => true, first_scn => NULL,logfile_assignment => 'implicit'); END;

*
ERROR at line 1:
ORA-02049: timeout: distributed transaction waiting for lock

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center