ora-00600[4400]错误的解决

ora-00600[4400]错误的解决

4400错误通常在分布式事务中出现，如到这个错误不会对数据库产生重大的影响，

以下是一个生产库的实际解决的例子。

故障描述：
Errors in file .../udump/ora_15899_$ORACLESID.trc:
ORA-00600: 内部错误代码，自变量: [4400], [48], [], [], [], [], [], []
Tue Feb 5 17:07:18 2008
Errors in file .../bdump/reco_1297_$ORACLESIDl.trc:
ORA-02062: distributed recovery received DBID e23ac21, expected 232acd6
ARC1: media recovery disabled

 

原因及解决方法：
由于db_link断开，两阶段事务不能正常处理，查询dba_2pc_pending
LOCAL_TRAN_ID          GLOBAL_TRAN_ID                 STATE            MIX A TRAN_COMMENT         FAIL_TIME FORCE_TIM RETRY_TIM OS_USER
---------------------- ------------------------------ ---------------- --- - -------------------- --------- --------- --------- ----------------------------------------------------------------
OS_TERMINAL
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
HOST                                                                                                                             DB_USERCOMMIT#
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------------
192.168.1.1              jpb.6c5f8f5f.192.168.1.1     collecting       no                         05-FEB-08           05-FEB-08 Administrator
DGDX-WR
WORKGROUP\DGDX-WR                                                                                                                IBSS7740378455873

192.168.1.2             jpb.6c5f8f5f.192.168.1.2    collecting       no                         05-FEB-08           05-FEB-08 Administrator
DGDX-WR
WORKGROUP\DGDX-WR                                                                                                                IBSS7740389820541
192.168.1.112             jpb.6c5f8f5f.192.168.1.112    collecting       no                         05-FEB-08           05-FEB-08 Administrator
DGDX-WR
WORKGROUP\DGDX-WR                                                                                                                IBSS7740970651708

通过以下方法来清除这些事务：

SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('192.168.1.2');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('192.168.1.1');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('192.168.1.112');
PL/SQL procedure successfully completed.
SQL> commit;

 

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

转载于:http://blog.itpub.net/104152/viewspace-168428/