ORA-0600 [ktstgrowseg-retry] Encountered During Impdp (Doc ID 2498409.1)
In this Document
Symptoms
Changes
Cause
Solution
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.
Symptoms
After adding a new tempfile to the Temp tablespace during the import process, the same was aborted because of error ORA-0600 [ktstgrowseg-retry]
Impdp logfile:
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-00600: internal error code, arguments: [ktstgrowseg-retry], [], [], [], [], [], [], [], [], [], [], []
Alert.log:
2019-01-21 16:33:18.823000 -02:00
Dumping diagnostic data in directory=[cdmp_20190121163318], requested by (instance=1, osid=83423 (DW00)), summary=[incident=49081].
statement in resumable session 'SYS.SYS_IMPORT_SCHEMA_01.1' was aborted
Errors in file /u01/app/oracle/diag/rdbms/<db_name>/<instname>/trace/<sid>_dw00_83423.trc (incident=49082):
ORA-00600: internal error code, arguments: [ktstgrowseg-retry], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /<diagnostic_dest>/diag/rdbms/<db_name>/<instname>/incident/incdir_49082/<sid>_dw00_83423_i49082.trc
Changes
Added a tempfile to the temporary tablespace.
Cause
There are no patches presently for this error but the workaround is used to correct the error. There is one open unpublished bug being worked by development for a future release to address this issue, unpublished Bug 27726513 : ETL:HITS ORA-600 [KTSTGROWSEG-RETRY], SIGNAL_FUNC: KTSTGROWSEG.
Solution
There is no data loss/corruption and the failure is transient and will work on retry.