一:环境信息

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

最后修改:2022 年 02 月 20 日
如果觉得我的文章对你有用,请随意赞赏