ORA-600 [KGHSTACK_FREE1] when adding multiple Tempfiles. (Doc ID 1355834.1)

Last updated on FEBRUARY 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.2 [Release 10.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 22-Nov=2013***

Symptoms

ORA-600 [kghstack_free1] occurs when adding multiple temp files to temporary tablespace after controlfile creation.



SCENARIO
--------
1. Create a controlfile script

   SQL> alter database backup controlfile to trace;

2. Determine the current redo log (this will be required by step #4)
   doing the recovery)

   select a.member from v$logfile a, v$log b
   where a.group#=b.group#
   and b.status='CURRENT';

3. Shutdown database and execute the controlfile script

   shutdown immediate;

   STARTUP NOMOUNT
   CREATE CONTROLFILE REUSE DATABASE "S124SA" RESETLOGS NOARCHIVELOG
   ... lines truncated ...

3. Recover database

   SQL> RECOVER DATABASE USING BACKUP CONTROLFILE;

   When being asked for specifying the logfile for recovering the database,
   specify the path and name of the last current redo log. (see step 2)

4. Open database using resetlogs option

   ALTER DATABASE OPEN RESETLOGS;

5. Verify temp tablespace

   -- The temp tablespace will not have any temp files mounted.
   select * from dba_temp_files;
   ==> no rows selected

  -- Now add at least 2 temp files
  ALTER TABLESPACE TEMP
  ADD TEMPFILE
    '/testcases/7011773.992/TEMP-01.db' size 100M reuse,
    '/testcases/7011773.992/TEMP-02.db' size 100M reuse;



ERROR

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kghstack_free1], [list of
datafile #'s], [], [], [], [], [], []
Current SQL statement for this session:
ALTER TABLESPACE TEMP
ADD TEMPFILE
'/testcases/7011773.992/TEMP-01.db' size 100M reuse,
'/testcases/7011773.992/TEMP-02.db' size 100M reuse



STACK TRACE: (10g)
------------------
kghstack_free ksmfrs atsdrv opiexe opiosq0 kpooprx kpoal8 ...

 

 

Changes

Added multiple temp files to temporary tablespace after controlfile creation.

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