ORA-01591: lock held by in-doubt distributed transaction

QL> select * from T_SSIS_TEST; select * from T_SSIS_TEST * ERROR at line 1: ORA-01591: lock held by in-doubt distributed transaction 9.25.27026

SQL> set linesize 9999 SQL> select * from dba_2pc_neighbors;

LOCAL_TRAN_ID          IN_ DATABASE     DBUSER_OWNER        I DBID        SESS# BRANCH ———————- — ——– —————————— – —————- 9.25.27026             in              SYS                    N                            1 0000 9.25.27026             out SQLSERVER   SYS                    C 01010101                   1 4

SQL> COMMIT FORCE ‘9.25.27026’;

Commit complete.

SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY (9.25.27026′; ERROR: ORA-01756: quoted string not properly terminated

SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY ('9.25.27026');
PL/SQL procedure successfully completed.
SQL> select * from T_SSIS_TEST;
       TID      TNAME                
---------- ------------          
1                Sami                           
2                Ahmed                          
 3                 Gul                       
 4                Ghani                       
 4 rows selected.
SQL
Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Database Locks. Bookmark the permalink.

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