Instance Terminated With Error ORA-00474: SMON Process Terminated With Error (Doc ID 1361872.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 28-May-2013***


Symptoms

The instance is terminated with error:

ORA-00474: SMON process terminated with error
PMON (ospid: 11806): terminating the instance due to error 474


The alert log contains the following messages:

Mon Sep 19 15:45:44 2011
Errors in file /u02/oracle/oramgr/db/tech_st/11.1.0/admin/mgr_oradev/diag/rdbms/mgr/mgr/trace/mgr_smon_11826.trc (incident=115403):
ORA-00600: internal error code, arguments: [13011], [351384], [146850571], [7], [146850571], [4], [], [], [], [], [], []
Incident details in: /u02/oracle/oramgr/db/tech_st/11.1.0/admin/mgr_oradev/diag/rdbms/mgr/mgr/incident/incdir_115403/mgr_smon_11826_i115403.trc
Mon Sep 19 15:45:46 2011
Errors in file /u02/oracle/oramgr/db/tech_st/11.1.0/admin/mgr_oradev/diag/rdbms/mgr/mgr/trace/mgr_pmon_11806.trc:
ORA-00474: SMON process terminated with error
PMON (ospid: 11806): terminating the instance due to error 474
Instance terminated by PMON, pid = 11806


The call stack is

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
    <- ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE
       <- 1936 <- dbkePostKGE_kgsf <- 128 <- kgeade <- kgeriv_int
          <- kgeriv <- kgesiv <- ksesic5 <- $cold_delexe <- opiexe
             <- opiall0 <- opikpr <- opiodr <- rpidrus <- skgmstack
                <- rpidru <- rpiswu2 <- kprball <- $cold_ktf_scn_time <- ktmmon
                   <- ktmSmonMain <- ksbrdp <- opirip <- opidrv <- sou2o
                      <- opimai_real <- main <- main_opd_entry


The failing statement is

delete from smon_scn_time where scn = (select min(scn) from smon_scn_time)

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