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 |