求助：ORA-00600 错误

显示全部楼层 · 2009-8-24 09:30:46

本帖最后由 244159303 于 2013-6-21 11:07 编辑
ORA-00600: internal error code, arguments: [25027], [11], [216493070], [], [], [], [], []
ORACLE Instance fohow (pid = 8) - Error 600 encountered while recovering transaction (6, 1) on object 62554.
Fri Jun 21 10:33:33 2013
Errors in file /u01/admin/fohow/bdump/fohow_smon_21253.trc:
ORA-00600: internal error code, arguments: [25027], [11], [216493070], [], [], [], [], []
Fri Jun 21 10:38:34 2013
Errors in file /u01/admin/fohow/bdump/fohow_p002_21684.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Fri Jun 21 10:38:34 2013
Errors in file /u01/admin/fohow/bdump/fohow_p001_21682.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Fri Jun 21 10:38:34 2013
Errors in file /u01/admin/fohow/bdump/fohow_p007_21694.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Fri Jun 21 10:38:38 2013
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Fri Jun 21 10:38:38 2013
Errors in file /u01/admin/fohow/bdump/fohow_smon_21253.trc:
ORA-00600: internal error code, arguments: [25027], [11], [216493070], [], [], [], [], []
ORACLE Instance fohow (pid = 8) - Error 600 encountered while recovering transaction (6, 1) on object 62554.
Fri Jun 21 10:38:39 2013
Errors in file /u01/admin/fohow/bdump/fohow_smon_21253.trc:
ORA-00600: internal error code, arguments: [25027], [11], [216493070], [], [], [], [], []
trc如下：

fohow_smon_21253.rar(496.53 KB, 下载次数: 1)2013-6-21 11:01 上传点击文件名下载附件

fohow_p007_21694.trc.txt(4.85 MB, 下载次数: 2)2013-6-21 11:01 上传点击文件名下载附件

千问 · 2009-8-24 09:30:46

应该重点关注这三个文件的内容：
/u01/admin/fohow/bdump/fohow_p001_1916.trc
/u01/admin/fohow/bdump/fohow_p001_1916.trc
/u01/admin/fohow/bdump/fohow_p001_1916.trc

千问 · 2009-8-24 09:30:46

应该重点关注这两个文件的内容：
/u01/admin/fohow/bdump/fohow_p001_1916.trc
/u01/admin/fohow/bdump/fohow_smon_1604.trc

千问 · 2009-8-24 09:30:46

Err_code: ORA-00060: Deadlock detected. More info in file /opt/oraweb/diag/rdbms/yktdwebdg2/yktdweb/trace/yktdweb_ora_7798.trc.
Err_lines: (120405)
Err_code: ORA-00060: Deadlock detected. More info in file /opt/oraweb/diag/rdbms/yktdwebdg2/yktdweb/trace/yktdweb_ora_7804.trc.
Err_lines: (120395)
Err_code: ORA-00060: Deadlock detected. More info in file /opt/oraweb/diag/rdbms/yktdwebdg2/yktdweb/trace/yktdweb_ora_7812.trc.
Err_lines: (120389)
Err_code: ORA-00060: Deadlock detected. More info in file /opt/oraweb/diag/rdbms/yktdwebdg2/yktdweb/trace/yktdweb_ora_7818.trc.
Err_lines: (120414)
Err_code: ORA-00060: Deadlock detected. More info in file /opt/oraweb/diag/rdbms/yktdwebdg2/yktdweb/trace/yktdweb_ora_7830.trc.
Err_lines: (120384)
Err_code: ORA-00060: Deadlock detected. More info in file /opt/oraweb/diag/rdbms/yktdwebdg2/yktdweb/trace/yktdweb_ora_7838.trc.
Err_lines: (120420)
Err_code: ORA-00060: Deadlock detected. More info in file /opt/oraweb/diag/rdbms/yktdwebdg2/yktdweb/trace/yktdweb_ora_7848.trc.
Err_lines: (120422)
Err_code: ORA-00060: Deadlock detected. More info in file /opt/oraweb/diag/rdbms/yktdwebdg2/yktdweb/trace/yktdweb_ora_7868.trc.
Err_lines: (120403,120393,120382)
Err_code: ORA-00060: Deadlock detected. More info in file /opt/oraweb/diag/rdbms/yktdwebdg2/yktdweb/trace/yktdweb_ora_7876.trc.
Err_lines: (120437)
Err_code: ORA-00060: Deadlock detected. More info in file /opt/oraweb/diag/rdbms/yktdwebdg2/yktdweb/trace/yktdweb_ora_7902.trc.
Err_lines: (120431)
-- 我一般都监控了

千问 · 2009-8-24 09:30:46

本帖最后由 244159303 于 2013-6-21 09:08 编辑
都是一样的错误 trc提示的内容都一样，trc更新上去了。麻烦大侠们看看

千问 · 2009-8-24 09:30:46

查metalink

千问 · 2009-8-24 09:30:46

没有metalink帐号

千问 · 2009-8-24 09:30:46

这是死锁，你查查TRC文件，看看是哪2个会话

千问 · 2009-8-24 09:30:46

百步亭花园发表于 2013-6-21 10:10
这是死锁，你查查TRC文件，看看是哪2个会话
没有查到死锁情况

千问 · 2009-8-24 09:30:46

本帖最后由 www_xylove 于 2013-6-22 09:37 编辑
遇到00600错误，最好的解决方法是上metalink。
如果没有metalink账号，说明公司对数据库也不重视，那么，也可以不解决，只有不宕机就可以了。