SMON Signals ORA-00600 [ktspfupdst-1] and Instance Terminates
(Doc ID 1353076.1)
Last updated on AUGUST 04, 2018
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation 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
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
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
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 |
Changes |
Cause |
Solution |
References |