What to do if there are ORA-00600 internal errors in oracle?

This article is about what to do with ORA-00600 internal error in oracle. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

ORA-00600: Internal Error Code, Parameters: [kcbnew_3]

I. Environmental information

DB：Oracle 11.2.0.3.0

OS：Windows Server 2008

II: Problem phenomena

Portal Front Desk Error:

Warning logs:

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: Internal error code, arguments: [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.

trace log orcl_ora_6324.trc:

DDE: Problem Key 'ORA 600 [kcbnew_3]' was flood controlled (0x6) (incident: 63384)

ORA-00600: Internal error code, arguments: [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: 'kdswh21: 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

......

III: Solutions

Empty database cache (use caution in formal environments)

alter system flush buffer_cache;

ORA-600 [kcbnew_3] (Doc ID 204512.1)

Go to bottom

Modified time: 2017-10-26 Type: REFERENCE

Note: For additional ORA-600 related information please read

PURPOSE:

it means and possible actions. The information here is only applicable

You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:

indicates that an alert exists for that issue.

·'+' Note:1944526.1