一:环境信息
DB : Oracle 11.2.0.3.0
OS : Windows Server 2008
二:问题现象
portal 前台报错:
警告日志:
Wed Nov 15 09:08:45 2017
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_6324.trc (incident=63384):
ORA-00600 : 内部错误代码, 参数: [ kcbnew_3 ], [0], [76058], [4], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
跟踪日志orcl_ora_6324.trc :
DDE: Problem Key 'ORA 600 [kcbnew_3]' was flood controlled (0x6) (incident: 63384)
ORA-00600: 内部错误代码, 参数: [kcbnew_3], [0], [76058], [4], [], [], [], [], [], [], [], []
Dump of buffer cache at level 10 for tsn=6 rdba=29499424
BH (0x000000152FF4F868) file#: 7 rdba: 0x01c22020 (7/139296) class: 1 ba: 0x000000152EA10000
set: 78 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 1646,28
dbwrid: 1 obj: 286891 objn: 286891 tsn: 6 afn: 7 hint: f
hash: [0x000000158F99A338,0x00000039D9FA7BA0] lru: [0x000000152FF4FBB0,0x000000152FF4F820]
ckptq: [NULL] fileq: [NULL] objq: [0x000000152FF4FBD8,0x000000152FF4F848] objaq: [0x000000152FF4FBE8,0x000000152FF4F858]
st: XCURRENT md: NULL fpin: 'kdswh11: kdst_fetch' tch: 1
flags: only_sequential_access
LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
buffer tsn: 6 rdba: 0x01c22020 (7/139296)
scn: 0x0000.0bc4eb5e seq: 0x01 flg: 0x06 tail: 0xeb5e0601
frmt: 0x02 chkval: 0x22e8 type: 0x06=trans data
......
三:解决方案
清空数据库缓存( 正式环境需谨慎使用)
alter system flush buffer_cache;
作者:chenoracle