ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ora-00600[4400]错误的解决

ora-00600[4400]错误的解决

原创 Linux操作系统 作者:cc59 时间:2008-02-06 03:16:33 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: oracle中的临时表
请登录后发表评论 登录
全部评论

注册时间:2007-12-21

  • 博文量
    132
  • 访问量
    286086