os:redhat linux
oracle:9207
alert.log如下:
Tue Mar 11 19:21:44 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_13176.trc:
ORA-00600: internal error code, arguments: [6002], [0], [112], [9], [0], [], [], []
Tue Mar 11 19:21:46 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_13176.trc:
ORA-00600: internal error code, arguments: [2662], [0], [3322146038], [6773], [2522038368], [16], [], []
ORA-00600: internal error code, arguments: [6002], [0], [112], [9], [0], [], [], []
Tue Mar 11 19:21:52 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_13176.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [0], [3322146038], [6773], [2522038368], [16], [], []
ORA-00600: internal error code, arguments: [6002], [0], [112], [9], [0], [], [], []
Tue Mar 11 19:41:17 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_18614.trc:
ORA-00600: internal error code, arguments: [4519], [6], [184592835], [1], [], [], [], []
Tue Mar 11 19:41:26 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_18653.trc:
ORA-00600: internal error code, arguments: [4519], [6], [184592835], [1], [], [], [], []
Tue Mar 11 19:41:55 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_18653.trc:
ORA-00600: internal error code, arguments: [4519], [6], [184592835], [1], [], [], [], []
Tue Mar 11 19:44:46 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_18667.trc:
ORA-00600: internal error code, arguments: [4519], [6], [184592835], [1], [], [], [], []
Tue Mar 11 19:45:44 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_18667.trc:
ORA-00600: internal error code, arguments: [4519], [6], [184592835], [1], [], [], [], []
多谢.相关内容如下:
/oracle/admin/q1wip01/udump/q1wip01_ora_18653.trc
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
ORACLE_HOME = /oracle/product/9.2
System name: Linux
Node name: Q1WIP001
Release: 2.6.9-42.ELsmp
Version: #1 SMP Wed Jul 12 23:32:02 EDT 2006
Machine: x86_64
Instance name: q1wip01
Redo thread mounted by this instance: 1
Oracle process number: 161
Unix process pid: 18653, image: oracle@Q1WIP001 (TNS V1-V3)
*** SESSION ID232.20510) 2008-03-11 19:41:26.005
Dump of buffer cache at level 10
BH (0x0x96fab800) file#: 44 rdba: 0x0b00a9c3 (44/43459) class 1 ba: 0x0x96530000
set: 11 dbwrid: 0 obj: 35493 objn: 32669
hash: [ad9f2518,ad9f2518] lru: [8afda068,87ff7d68]
LRU flags: hot_buffer
ckptq: [NULL] fileq: [NULL]
st: XCURRENT md: NULL rsop: 0x(nil) tch: 0
LRBA: [0x0.0.0] HSCN: [0xffff.ffffffff] HSUB: [255] RRBA: [0x0.0.0]
buffer tsn: 6 rdba: 0x00333152 (0/3354962)
scn: 0x0000.c5e1b72e seq: 0x01 flg: 0x06 tail: 0xb72e0601
frmt: 0x00 chkval: 0x7402 type: 0x01=KTU UNDO HEADER
Hex dump of corrupt header 4 = CORRUPT
Dump of memory from 0x0000000096530000 to 0x0000000096530014
096530000 00000001 00333152 C5E1B72E 06010000 [....R13.........]
096530010 00007402 [.t..]
Hex dump of corrupt block
Dump of memory from 0x0000000096530014 to 0x0000000096531FFC
096530010 00000002 BFFFA090 0000007F [............]
096530020 00000000 00320002 00000001 00343152 [......2.....R14.]
096530030 00000000 00000000 00000002 00000000 [................]
096530040 00000006 00000000 00000000 00807A66 [............fz..]
096530050 00000001 00353152 C5E1B72E 00000000 [....R15.........]
096530060 00000002 02800000 96534C10 00000000 [.........LS.....]
096530070 00000000 00000000 00000001 00505352 [............RSP.]
096530080 00000006 4EC01F60 1F361F02 1F0C1F21 [....`..N..6.!...]
096530090 960743F8 0000002A 00000000 1E641E79 [.C..*.......y.d.]
35493应该是个index
32272应该是个table
如果现在alert.log一直报ORA-00600: internal error code, arguments: [4519]的话,可以考虑先重启数据库,看是否还频繁报ORA-600,如果有,再根据trace来确定是哪个object可能有问题,到时候可以考虑重建等。 |