Terminated With Error ORA-474: SMON Process Terminated With Error-1361872.1

rongshiyuan發表於2013-01-22

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

Solution

Rebuild corrupted indexes:

SQL> conn as sysdba
SQL> ALTER INDEX SMON_SCN_TIME_TIM_IDX REBUILD ONLINE;
SQL> ALTER INDEX SMON_SCN_TIME_SCN_IDX REBUILD ONLINE;

then re-run

SQL> ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE;

Table analyzed.

Note: The last statement should not report any errors.

References

NOTE:978502.1 - How to Resolve ORA-08102 Reported on Table SMON_SCN_TIME

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-753025/,如需轉載,請註明出處,否則將追究法律責任。

相關文章