My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.