SMON Signals ORA-00600 [ktspfupdst-1] and Instance Terminates (Doc ID 1353076.1)

Last updated on JANUARY 30, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
** Checked for relevance 13-Feb-2013 **

Symptoms

After changing the database from NOARCHIVELOG to ARCHIVELOG Mode , the following error is reported by SMON :

ERROR
-----------------------
ORA-00600: internal error code, arguments: [ktspfupdst-1], [], [], [], [], [], [], [], [], [], [], []

Alert Log File Shows :


ORA-00600: internal error code, arguments: [ktspfupdst-1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /bbdd_prod/diag/rdbms/prod/prod/incident/incdir_14418/prod_smon_6431_i14418.trc
PMON (ospid: 6365): terminating the instance due to error 474
System state dump requested by (instance=1, osid=6365 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /bbdd_prod/diag/rdbms/prod/prod/trace/prod_diag_6383.trc
Instance terminated by PMON, pid = 6365


The SMON incident trace file shows the following as Current SQL Statement :

insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)


Analyze on the table and cluster, gives the following error:


SQL> analyze table SMON_SCN_TIME validate structure cascade ;
analyze table SMON_SCN_TIME validate structure cascade
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file


SQL> analyze cluster SMON_SCN_TO_TIME_AUX validate structure cascade ;
analyze cluster SMON_SCN_TO_TIME_AUX validate structure cascade
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file

Changes

Changing the database from NOARCHIVELOG to ARCHIVELOG mode .

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