狂暴綿羊完勝企鵝教戰手冊

Senario:

oracle alert log shows

Errors in file $ORACLE_ALERT/trace/<SID>_reco_<pid>.trc:
ORA-12154: TNS:could not resolve the connect identifier specified

Solution:

1. check DB_2PC_PENDING

2. status is collecting and transactions are no used anymore after check.

3. clear the record. Must execute by sqlplus.

execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('local_tran_id');

Related artical you can reference

https://oracleblog.org/working-case/how-to-deal-with-distributed-transaction/

Official Oracle online document about remote transaction:

https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_txnman003.htm#ADMIN12249