Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › ORA-00474: SMON process terminated with error

8 积分	0 好友	2 主题

发消息

[SQL调优] ORA-00474: SMON process terminated with error

1^#

发表于 2014-8-14 10:34:59 | 查看: 5152| 回复: 10

突然进程自动SMON process terminated

Wed Aug 13 08:00:54 2014
Restarting dead background process CJQ0
CJQ0 started with pid=16, OS id=26527
Wed Aug 13 08:01:40 2014
SMON: Parallel transaction recovery tried
Wed Aug 13 08:01:42 2014
Errors in file /oracle/data/mesb/log/bdump/mesb_pmon_5746.trc:
ORA-00474: SMON process terminated with error
Wed Aug 13 08:01:42 2014
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 5746

mesb_pmon_5746.txt

3.92 MB, 下载次数: 757

8/13号8:00左右挂掉

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2014-8-14 10:59:01

群里最早就说了让看smon 的trace，还是上传的pmon的trace ; 交流有代沟啊

回复只看该作者道具举报

wangmaochun1982

3^#

发表于 2014-8-14 11:48:41

哈哈，SMON LOG，

mesb_smon_5760.rar

956.98 KB, 下载次数: 1144

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2014-8-14 15:16:51

ORA-00474: SMON process terminated with error

/oracle/data/mesb/log/bdump/mesb_smon_5760.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/app
System name: Linux
Node name: ktmes2
Release: 2.6.16.60-0.54.5-smp
Version: #1 SMP Fri Sep 4 01:28:03 UTC 2009
Machine: x86_64
Instance name: mesb
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 5760, image: oracle@ktmes2 (SMON)

*** 2014-08-13 08:01:40.069
*** SERVICE NAME:(SYS$BACKGROUND) 2014-08-13 08:01:39.577
*** SESSION ID:(383.1) 2014-08-13 08:01:39.577
Dead transaction 0x0015.005.00068f65 recovered by 16 server(s)
*** 2014-08-13 08:01:40.083
SMON: Parallel transaction recovery tried

回复只看该作者道具举报

Maclean Liu(刘相兵

5^#

发表于 2014-8-14 15:23:35

ODM FINDGING:

ORA-474: SMON process terminated with error

1- ORA-00474: SMON process terminated with error during parallel transaction recovery

Solution:

Turn off Parallel Recovery by adding following parameter to your init@SID.ora
fast_start_parallel_rollback=FALSE
Bounce the instance.

For more details refer to:

Instance Crashing With Ora-600 [15789] And Ora-474 (Doc ID 1094645.1)

回复只看该作者道具举报

Maclean Liu(刘相兵

6^#

发表于 2014-8-14 15:23:56

尝试设置 fast_start_parallel_rollback=FALSE 并重启实例

回复只看该作者道具举报

wangmaochun1982

7^#

发表于 2014-8-14 16:01:43

Thank you，我设置了，再观察一下看看

回复只看该作者道具举报

wangmaochun1982

8^#

发表于 2014-8-19 08:24:03

Tue Aug 19 08:02:17 2014
Errors in file /oracle/data/mesb/log/bdump/mesb_pmon_9126.trc:
ORA-00474: SMON process terminated with error
Tue Aug 19 08:02:17 2014
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 9126

回复只看该作者道具举报