Sunday, 16 August 2020

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

 ERROR:

ORA-02354: error in exporting/importing data

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

SOLUTIONS:

SQL> SELECT LOCAL_TRAN_ID, STATE FROM DBA_2PC_PENDING;

LOCAL_TRAN_ID          STATE

---------------------- ----------------

167.3.155988           prepared

SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('167.3.155988');

BEGIN DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('167.3.155988'); END;

*

ERROR at line 1:

ORA-06510: PL/SQL: unhandled user-defined exception

ORA-06512: at "SYS.DBMS_TRANSACTION", line 105

ORA-06512: at line 1

SQL> SELECT local_tran_id FROM dba_2pc_pending;

LOCAL_TRAN_ID

----------------------

167.3.155988

SQL> rollback force '167.3.155988';

Rollback complete.

SQL> commit;

Commit complete.

SQL> begin dbms_transaction.purge_lost_db_entry('167.3.155988');

  2  end;

  3  /

PL/SQL procedure successfully completed.

SQL> SELECT * FROM dba_2pc_pending;

no rows selected

SQL> commit;

Commit complete.

SQL> SELECT * FROM dba_2pc_pending;

no rows selected

Re-Initiate your process.


No comments:

Post a Comment

OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...