ORA-02019: connection description for remote database not found

最新推荐文章于 2025-07-09 16:31:37 发布

转载最新推荐文章于 2025-07-09 16:31:37 发布 · 2k 阅读

文章标签：

在进行Oracle数据库升级后出现ORA-02019错误，通过查询dba_2pc_pending表并使用dbms_transaction.purge_lost_db_entry过程解决了分布式事务未完成同步的问题。

昨日做数据库升级，升级完毕后，在alert log 里报如下错误：
Node name:      suzdrsas-updrade
Release:        5.10
Version:        Generic_138888-03
Machine:        sun4u
Instance name: mdw
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 5466, image: oracle@suzdrsas-updrade (RECO)

*** SESSION ID:(7.1) 2010-08-04 14:15:57.282
*** 2010-08-04 14:15:57.282
ERROR, tran=3.4.6502005, session#=1, se=0:
ORA-02019: connection description for remote database not found
*** 2010-08-04 14:16:30.301
ERROR, tran=3.4.6502005, session#=1, se=0:

经过一番搜索，发现是由于分布式事务，未完成同步所致。

sql>select local_tran_id from dba_2pc_pending;

SQL> execute sys.dbms_transaction.purge_lost_db_entry('');

Refrence: （metalink doc 1012842.102）

*************************************************************
SQL> select GLOBAL_TRAN_ID,OS_TERMINAL from dba_2pc_pending;

GLOBAL_TRAN_ID
--------------------------------------------------------------------------------
OS_TERMINAL
--------------------------------------------------------------------------------
LSS_WXDPMDWA.WUX.CHIN.SEAGATE.COM.addce4b6.3.4.6502005

SQL>
SQL> show user
USER is "SYS"
SQL> execute sys.dbms_transaction.purge_lost_db_entry('3.4.6502005');

PL/SQL procedure successfully completed.

SQL> select GLOBAL_TRAN_ID,OS_TERMINAL from dba_2pc_pending;

no rows selected

SQL> select GLOBAL_TRAN_ID,OS_TERMINAL from dba_2pc_pending;

no rows selected
********************************************************

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/3637/viewspace-670318/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/3637/viewspace-670318/