Query to check in doubt transactions...
=====================================
SQL> SELECT LOCAL_TRAN_ID, GLOBAL_TRAN_ID,to_char(FAIL_TIME,'dd-mon-yyyy HH24:MI:SS'), STATE, MIXED FROM DBA_2PC_PENDING;
LOCAL_TRAN_ID GLOBAL_TRAN_ID TO_CHAR(FAIL_TIME,'DD-MON-YYY STATE MIX
---------------------- ---------------------------------------- ----------------------------- ---------------- ---
88.33.88299 abc.a930e3e9.36.36.71299 24-jan-2017 07:56:31 collecting no
44.77.88441 abc.a930e3e9.33.40.68441 24-jan-2017 09:27:49 collecting no
99.99.99919 abc.a930e3e9.27.44.59919 24-jan-2017 15:39:21 collecting no
SQL> SELECT LOCAL_TRAN_ID, IN_OUT,INTERFACE, DATABASE FROM DBA_2PC_NEIGHBORS;
LOCAL_TRAN_ID IN_ I DATABASE
---------------------- --- - ------------------------------
01.01.11299 in N
33.44.55441 in N
22.44.55919 in N
88.33.88299 out N REM2CRM_HZ_PARTIES_DBLINK
44.77.88441 out N REM2CRM_HZ_PARTIES_DBLINK
99.99.99919 out N REM2CRM_HZ_PARTIES_DBLINK
6 rows selected.
SQL>
To clear the in doubt transactions...
=====================================
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('88.33.88299');
COMMIT;
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('44.77.88441');
COMMIT;
=====================================
SQL> SELECT LOCAL_TRAN_ID, GLOBAL_TRAN_ID,to_char(FAIL_TIME,'dd-mon-yyyy HH24:MI:SS'), STATE, MIXED FROM DBA_2PC_PENDING;
LOCAL_TRAN_ID GLOBAL_TRAN_ID TO_CHAR(FAIL_TIME,'DD-MON-YYY STATE MIX
---------------------- ---------------------------------------- ----------------------------- ---------------- ---
88.33.88299 abc.a930e3e9.36.36.71299 24-jan-2017 07:56:31 collecting no
44.77.88441 abc.a930e3e9.33.40.68441 24-jan-2017 09:27:49 collecting no
99.99.99919 abc.a930e3e9.27.44.59919 24-jan-2017 15:39:21 collecting no
SQL> SELECT LOCAL_TRAN_ID, IN_OUT,INTERFACE, DATABASE FROM DBA_2PC_NEIGHBORS;
LOCAL_TRAN_ID IN_ I DATABASE
---------------------- --- - ------------------------------
01.01.11299 in N
33.44.55441 in N
22.44.55919 in N
88.33.88299 out N REM2CRM_HZ_PARTIES_DBLINK
44.77.88441 out N REM2CRM_HZ_PARTIES_DBLINK
99.99.99919 out N REM2CRM_HZ_PARTIES_DBLINK
6 rows selected.
SQL>
To clear the in doubt transactions...
=====================================
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('88.33.88299');
COMMIT;
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('44.77.88441');
COMMIT;
Amazing post.Thanks for your details and explanations..I want more information from your side.Thank you
ReplyDeleteGuest posting sites
Education
Great Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
Whether small or large, business transactions can be extremely complex and require a great deal of work behind the scenes. As the size and/or complexity of a transaction increases, the need for innovative structuring options also increases.소액결제현금화
ReplyDeleteThe first thing that many do when losing money online during a transaction is to blame the bank or financial agency. However, the technology driving the online transactions is more often to blame.소액결제현금화
ReplyDeleteThank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. 소액결제 현금화
ReplyDelete