Hi Experts,
I am on Oracle 11.2.0.3 on Linux. In my production database, I am getting this alert, in the alert log:
Error 604
trapped in 2PC on transaction 50.73.546578. Cleaning up.
--the above two lines are from alert log.
--query from a data dictionary view
SQL> select count(*) from DBA_2PC_PENDING;
COUNT(*)
----------
1
When I query the production database I see that there is one row in the DBA_2PC_PENDING view. But I dont' know how to identify which are the databases that are involved in this distributed transaction. That is my first issue - how to identify which are the two databases that are involved in the distributed transaction?
Can someone please help on it?
Thanks,
OrauserN
;
;