- 论坛徽章:
- 0
|
一个生产中用到的数据库出现如下告警日志:遇到这样的问题怎么解决呢,谢谢!
Archived Log entry 60 added for thread 1 sequence 1475 ID 0x89e1442a dest 1:
Fri Dec 13 17:26:30 2013
Errors in file /opt/oracle/diag/rdbms/hrdb/HRDB/trace/HRDB_ora_13649.trc (incident=15161):
ORA-00600: 内部错误代码, 参数: [kglLockOwnersListDelete], [0x0BE483408], [0x0AFF7FA40], [], [], [], [], [], [], [], [], []ORA-03135: 连接失去联系
Incident details in: /opt/oracle/diag/rdbms/hrdb/HRDB/incident/incdir_15161/HRDB_ora_13649_i15161.trc
Fri Dec 13 17:26:37 2013
opidcl aborting process unknown ospid (13520) as a result of ORA-3113
Fri Dec 13 17:27:13 2013
opidcl aborting process unknown ospid (13649) as a result of ORA-600
Fri Dec 13 17:27:13 2013
Errors in file /opt/oracle/diag/rdbms/hrdb/HRDB/trace/HRDB_pmon_11490.trc (incident=14817):
ORA-00600: internal error code, arguments: [kglLockOwnersListDelete], [0x0BE483408], [0x0A27318D0], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/hrdb/HRDB/incident/incdir_14817/HRDB_pmon_11490_i14817.trc
Fri Dec 13 17:27:14 2013
Trace dumping is performing id=[cdmp_20131213172714]
Fri Dec 13 17:27:14 2013
Sweep [inc][15161]: completed
Sweep [inc][14817]: completed
Sweep [inc2][15161]: completed
Sweep [inc2][14817]: completed
Fri Dec 13 17:27:37 2013
Errors in file /opt/oracle/diag/rdbms/hrdb/HRDB/trace/HRDB_pmon_11490.trc:
ORA-00600: internal error code, arguments: [kglLockOwnersListDelete], [0x0BE483408], [0x0A27318D0], [], [], [], [], [], [], [], [], []
PMON (ospid: 11490): terminating the instance due to error 472
Instance terminated by PMON, pid = 11490
opt/oracle/diag/rdbms/hrdb/HRDB/trace/HRDB_ora_13649.trc
Redo pool range [0x0 0x7f80c35df690 0x7f80c35e1e90]
Undo pool range [0x0 0x7f80c35dce90 0x7f80c35df690]
chnf control flags 0x100 CHNF hwm uba uba: 0x00000000.0000.00 ----------------------------------------
SO: 0xbbb80f10, type: 51, owner: 0xbbf529f8, flag: -/-/-/0x00 if: 0x3 c: 0x3
proc=0xbfe441f0, name=Block List, file=ktlcts.h LINE:175, pg=0
(List of Blocks) next index = 2
index itli buffer hint rdba savepoint
-----------------------------------------------------------
0 2 0x85fb8638 0x142fbe0 0x6f9a5e
1 2 0x8cf95818 0x142f7cd 0x6f9a61
----------------------------------------
SO: 0xbbb80ad8, type: 51, owner: 0xbbf529f8, flag: -/-/-/0x00 if: 0x3 c: 0x3
proc=0xbfe441f0, name=Block List, file=ktlcts.h LINE:175, pg=0
(List of Blocks) next index = 10
index itli buffer hint rdba savepoint
-----------------------------------------------------------
0 3 0x8efe4c58 0x142d49e 0x6f900f
1 2 0x8ef968b8 0x142d4a0 0x6f9010
2 3 0x8ef6ee98 0x142d4a3 0x6f9012
3 3 0x8ef6e518 0x142fd71 0x6f9013
4 3 0x8efb9478 0x142fd72 0x6f9014
5 2 0x8efb9a68 0x142d4a8 0x6f9016
6 2 0x8efb9938 0x142d4aa 0x6f9018
7 2 0x8ef6e188 0x142fd76 0x6f901a
8 3 0x8ef6e778 0x142d4ad 0x6f901b
9 2 0x8efb90e8 0x142fd77 0x6f901d
----------------------------------------
SO: 0x906c4a10, type: 3, owner: 0xbfe441f0, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0xbfe441f0, name=call, file=ksu.h LINE:11463, pg=0
(call) sess: cur bdc19858, rec 0, usr bdc19858; flg:20 fl2:1; depth:0
svpt(xcb nil) sptn:0x6fb0dd uba: 0x00000000.0000.00)
ksudlc FALSE at location: 6
(k2g table)
error 472 detected in background process
ORA-00600: internal error code, arguments: [kglLockOwnersListDelete], [0x0BE483408], [0x0A27318D0], [], [], [], [], [], [], [], [], []
*** 2013-12-13 17:27:37.802
PMON (ospid: 11490): terminating the instance due to error 472
|
|