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
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
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
ORA600 [13011] is raised due to indexes corruption. To verify the corruption run the following statements:
then re-run
Note: The last statement should not report any errors.
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
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;
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.
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- FIELDS TERMINATED BY WHITESPACE & FIELDS TERMINATED BY x'09'
- FIELDS TERMINATED BY WHITESPACE & FIELDS TERMINATED BY x'09' 區別
- idea 報錯maven [ERROR] Maven execution terminated abnormally (exit code 1)IdeaMavenErrorORM
- MRP0- Background Media Recovery terminated with error 1111Error
- The OracleService$$$ service terminated unexpectedly.Oracle
- JVM terminated. Exit code=1JVM
- MRP0: Background Media Recovery terminated with error 328,ORA-00328Error
- The SQL Server (MSSQLSERVER) service terminated with service-specific error 1814 (0x716).SQLServerError
- sublime text編譯時提示錯誤[Decode error - output not utf-8] compilation terminated編譯Error
- ora-01092 oracle instance terminatedOracle
- System Monitor Process (SMON) (120)
- eclipse出現jvm terminated exit code=1問題[轉]EclipseJVM
- sqli-labs————Less-47(procedure alalyse\lines terminated by利用)SQL
- Rman-10038: Database Session For Channel D1 Terminated UnexpectedlyDatabaseSession
- ASM例項出現ORA-04031導致Instance terminated by ASMBASM
- 升級遇到 ORA-01092: ORACLE instance terminated. Disconnection forcedOracle
- 解決Pycharm配置R語言環境報錯RWrapper terminated, exitcode: 127PyCharmR語言APP
- 使用建庫語句建庫時遇到ORA-01092: ORACLE instance terminated錯誤Oracle
- Fatal error in launcher: Unable to create process using '"'Error
- Sub-process /usr/bin/dpkg returned an error codeError
- [PM2][ERROR] Process XXX not foundError
- ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 106DatabaseDB2SQL
- android studio Error:Unable to start the daemon process【轉】AndroidError
- innobackupex:Error:xtrabackup child process has died at /usr/bin/innobackupexError
- O/S-Error: (OS 33) The process cannot access the fileError
- WSL:Sub-process /usr/bin/dpkg returned an error code (1)Error
- SMON程式詳解
- SMON 程式的作用
- Git bash Error: Could not fork child process: There are no available terminals (-1)GitErrorAI
- kkjcre1p: unable to spawn jobq slave process, error 1089Error
- SMON: Parallel transaction recovery triedParallel
- Oracle SMON程式的作用Oracle
- ORA-31687: error creating worker process with worker id 1Error
- Job for mysqld.service failed because the control process exited with error code...MySqlAIError
- SMON故障造成的parallel rollbackParallel
- SMON功能(三):清理obj$基表OBJ
- Oracle SMON系統監視程式Oracle
- LGWR DBWR SMON 等程式說明