ORA-00600 [kcbgcur_9] - Instance crashes by SMON (Doc ID 371198.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
Information in this document applies to any platform.

Symptoms

SMON crashes the instance on startup with ORA-600 [kcbgcur_9]

You shall get into this issue in following scenario.

o A rollback segment is dropped.
o It belongs to locally managed tablespace.
o The rollback segment is marked as temporary for later cleanup.

1. The following query is to check if it is a Locally Managed tablespace.
SELECT EXTENT_MANAGEMENT FROM DBA_TABLESPACES WHERE TABLESPACE_NAME='&RBS';



--- Extent Management of the RBS tablespace is LOCAL
--- RBS = Rollback Segment tablespace

2. The following query will show the segments that are marked as TEMPORARY in the rollback segment tablespace.

SELECT SEGMENT_NAME, SEGMENT_TYPE FROM DBA_SEGMENTS WHERE SEGMENT_TYPE='TEMPORARY'
AND
TABLESPACE_NAME='&RBS';



--- Returns TEMPORARY object / objects..

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms