Dbabc.Net

Alert日志报错:ORA-02019: connection description for remote database not found

Sun Feb 20 05:32:15 2011
Errors in file /u01/dbabc.net/admin/dbabc/bdump/dbabc_reco_12071.trc:
ORA-02019: connection description for remote database not found
Sun Feb 20 05:35:57 2011
Thread 1 advanced to log sequence 56791 (LGWR switch)

more /u01/dbabc.net/admin/dbabc/bdump/dbabc_reco_12071.trc
发现

ERROR, tran=16.53.38796, session#=1, ose=0:
ORA-02019: connection description for remote database not found，

出现的频率没有规律，有时候一天出现2两次，有时候半个月到1一个月出现一次。

…………省略部分……
*** 2010-12-08 23:29:08.464
ERROR, tran=16.53.38796, session#=1, ose=0:
ORA-02019: connection description for remote database not found
*** 2011-01-04 12:23:32.289
ERROR, tran=16.53.38796, session#=1, ose=0:
ORA-02019: connection description for remote database not found
Sun Feb 20 05:32:15 2011
ERROR, tran=16.53.38796, session#=1, ose=0:
ORA-02019: connection description for remote database not found

经查原来是是DB升级的时候创建了一个dblink，现在已经删除了，但是有未完成的事物，囧，
这个dblink只是用来比较升级前后的数据对象是否相同。
不记得操作过什么事物～～

数据库环境：

Oracle 10.2.0.4 for Red Hat Enterprise Linux AS release 4

操作：

SYS@orcl>l
1  SELECT LOCAL_TRAN_ID,state, tran_comment, advice
2    FROM dba_2pc_pending
3*
SYS@orcl>/

LOCAL_TRAN_ID        STATE            TRAN_COMMENT         A
——————– —————- ——————– -
16.53.38796          collecting

SYS@orcl>EXECUTE sys.dbms_transaction.purge_lost_db_entry(’16.53.38796′);

PL/SQL procedure successfully completed.

SYS@orcl>commit;

Commit complete.

附：详细参考 metalink doc 1012842.102