My Oracle Support Banner

Ora-600 [kghstack_free1], [list of datafile #'s] When Adding Multiple Tempfiles to Empty Temp Tablespace (Doc ID 473614.1)

Last updated on OCTOBER 18, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Adding multiple tempfiles to an empty temp tablespace generates the following error:

ORA-00600: internal error code, arguments: [kghstack_free1], [list of datafile #'s], [], [], [],
[], [], []

Example that produces the error:

ALTER TABLESPACE PSTEMP ADD TEMPFILE
'<FILSYSTEM_PATH>/xxx01.dbf' SIZE 1000M REUSE,
'<FILSYSTEM_PATH>/xxx02.dbf' SIZE 1000M REUSE,
'<FILSYSTEM_PATH>/xxx03.dbf' SIZE 1000M REUSE

The call stack contains the following:

kghstack_free <- ksmfrs <- atsdrv <- opiexe <- opiosq0 <- kpooprx <- kpoal8

 

The tracefile shows a corrupt memory header, which will look similar to this:

"Corrupted stack chunk header at location <memory_address>"

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.