Terminated With Error ORA-474: SMON Process Terminated With Error-1361872.1相关内容

77 阅读 0 评论 51 点赞

我是靠谱客的博主复杂烧鹅，最近开发中收集的这篇文章主要介绍Terminated With Error ORA-474: SMON Process Terminated With Error-1361872.1相关内容，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

Instance Terminated With Error ORA-00474: SMON Process Terminated With Error [ID 1361872.1]

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later [Release: 11.1 and later ]
Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.2 [Release: 11.1 to 11.2]
Information in this document applies to any platform.

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
The failing statement is

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

Cause

ORA600 [13011] is raised due to indexes corruption. To verify the corruption run the following statements:

SQL> conn / as sysdba
SQL> ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE;

Table analyzed.

-- It should come out clean giving message table analyzed.

SQL> ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE;

-- it should fail with Ora-1499 if at least one index is corrupted