ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600: : [2662], [2], [1444548108], [32772], [103887673], [876099122]

ORA-00600: : [2662], [2], [1444548108], [32772], [103887673], [876099122]

原创 Linux操作系统 作者:tolywang 时间:2011-08-24 14:30:31 0 删除 编辑
ORACLE 11.2.0.2.0 ,   RAC ,  3Nodes ,      LINUX  5.4   64BIT  


同事为了缩小temp表空间的一个文件 temp02.dbf ,   在线使用命令将 temp02.dbf  设置为 offline,   然后使用
drop 命令想要删除此文件,  但是报错退出 ,  因无法删除,  所以又下命令将temp02.dbf  文件 online , 这时候
发现开始报出类似下面的 2662 的错误,  而且很频繁,   又将temp02.dbf 文件设置为offline .   但是错误并没有
消失 。   部分报错信息如下 (只有节点2 上报下面的错) :     


Tue Aug 23 18:00:19 2011
DDE: Problem Key 'ORA 600 [2662]' was completely flood controlled (0x4)
Further messages for this problem key will be suppressed for up to 10 minutes
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/trace/wsjdell2_ora_3251.trc:
ORA-00600: 鍏ч儴閷??浠g⒓, 寮曟暩: [2662], [2], [1444548108], [32772], [103887673], [876099122], [], [], [], [], [], []
ORA-00600: 鍏ч儴閷??浠g⒓, 寮曟暩: [2662], [2], [1444548107], [32772], [103887673], [876099122], [], [], [], [], [], []
ORA-00600: 鍏ч儴閷??浠g⒓, 寮曟暩: [2662], [2], [1444548106], [32772], [103887673], [876099122], [], [], [], [], [], []
Errors in file /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/trace/wsjdell2_ora_3251.trc:
ORA-00600: 鍏ч儴閷??浠g⒓, 寮曟暩: [2662], [2], [1444548108], [32772], [103887673], [876099122], [], [], [], [], [], []
ORA-00600: 鍏ч儴閷??浠g⒓, 寮曟暩: [2662], [2], [1444548107], [32772], [103887673], [876099122], [], [], [], [], [], []
ORA-00600: 鍏ч儴閷??浠g⒓, 寮曟暩: [2662], [2], [1444548106], [32772], [103887673], [876099122], [], [], [], [], [], []
Tue Aug 23 18:00:24 2011
Dumping diagnostic data in directory=[cdmp_20110823180024], requested by (instance=2, sid=3251), summary=[abnormal process termination].
Tue Aug 23 18:00:25 2011
Errors in file /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/trace/wsjdell2_ora_3251.trc  (incident=82140):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [2], [1444548108], [32772], [103887673], [876099122], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [2], [1444548107], [32772], [103887673], [876099122], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [2], [1444548106], [32772], [103887673], [876099122], [], [], [], [], [], []
Incident details in: /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/incident/incdir_82140/wsjdell2_ora_3251_i82140.trc
Errors in file /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/incident/incdir_82140/wsjdell2_ora_3251_i82140.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [2], [1444548108], [32772], [103887673], [876099122], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [2], [1444548107], [32772], [103887673], [876099122], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [2], [1444548106], [32772], [103887673], [876099122], [], [], [], [], [], []
Dumping diagnostic data in directory=[cdmp_20110823180026], requested by (instance=2, sid=3251), summary=[abnormal process termination].
Tue Aug 23 18:00:46 2011
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.


其他节点上报错信息如下:

Tue Aug 23 13:43:44 2011
Archived Log entry 30084 added for thread 1 sequence 10561 ID 0x4fa453a7 dest 1:
Tue Aug 23 13:49:37 2011
ALTER DATABASE TEMPFILE '+INDX/wsjdell/tempfile/temp02.dbf' DROP
ORA-25152 signalled during: ALTER DATABASE TEMPFILE '+INDX/wsjdell/tempfile/temp02.dbf' DROP ...
Tue Aug 23 13:52:15 2011
ALTER DATABASE TEMPFILE '+INDX/wsjdell/tempfile/temp02.dbf' DROP
ORA-25152 signalled during: ALTER DATABASE TEMPFILE '+INDX/wsjdell/tempfile/temp02.dbf' DROP ...
Tue Aug 23 13:58:43 2011
Dumping diagnostic data in directory=[cdmp_20110823135843], requested by (instance=2, sid=10748), summary=[incident=72665].
Dumping diagnostic data in directory=[cdmp_20110823135845], requested by (instance=2, sid=10748), summary=[incident=72666].
Dumping diagnostic data in directory=[cdmp_20110823135847], requested by (instance=2, sid=10748), summary=[incident=72667].
Dumping diagnostic data in directory=[cdmp_20110823135849], requested by (instance=2, sid=10278), summary=[incident=72889].
Dumping diagnostic data in directory=[cdmp_20110823135850], requested by (instance=2, sid=10278), summary=[incident=72890].














原来碰到过这种问题, 查询metalink 也有解决方法, 但是这次碰到的相似, 但是参数大小恰好相反 。     

很早以前碰到的问题 :  
ORA-00600: internal error code, arguments: [2662], [0], [450796715], [0], [451228542], [4194306], [], []   
SMON: terminating instance due to error 600
Instance terminated by SMON, pid = 6046

450796715  比   451228542  要小 。  所以可以用下面的方式处理。  

根据文章 http://space.itpub.net/35489/viewspace-702568        在mount状态下运行
alter   session  set    events‘10015 trace name adjust_scn  level 1‘;   




这次是前面的   1444548108  大于   103887673   



重新启动节点2 后,    恢复正常 .

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

下一篇: incarnation
请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13476396