昨日做数据库升级, 升级完毕后, 在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
********************************************************
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/