Process m000 died, see its trace file

今天好好回顾了下这段时间所做的事情，突然发现自己越来越懒了。自己在生产生活中遇到了很多问题，有的已经解决掉找到了原因，有的解决了还没有找到原因，不管怎么样想把自己的遇到的一些问题都写下来，就当是自己的一个笔记吧，先说下今天遇到的一个问题，中午吃完饭回来开发的同事就打电话过来说XXX怎么数据库我们这连不上了，这个数据库是单节点的linux的数据库，直接查看oracle日志，错误信息如下

Mon Nov 16 14:00:56 2009
Process m001 died, see its trace file
Mon Nov 16 14:00:56 2009
ksvcreate: Process(m001) creation failed
Mon Nov 16 14:35:43 2009
Thread 1 advanced to log sequence 28085
  Current log# 2 seq# 28085 mem# 0: /data/oracle/oradata/ora10g/redo02.log
Mon Nov 16 15:00:57 2009
Process m000 died, see its trace file
Mon Nov 16 15:00:57 2009
ksvcreate: Process(m000) creation failed
Mon Nov 16 15:01:58 2009
Process m000 died, see its trace file
Mon Nov 16 15:01:58 2009
ksvcreate: Process(m000) creation failed
Mon Nov 16 15:02:59 2009
Process m000 died, see its trace file
Mon Nov 16 15:02:59 2009
ksvcreate: Process(m000) creation failed
Mon Nov 16 15:04:00 2009
Process m000 died, see its trace file
Mon Nov 16 15:04:00 2009
ksvcreate: Process(m000) creation failed
Mon Nov 16 15:05:01 2009
Process m000 died, see its trace file
Mon Nov 16 15:05:01 2009
ksvcreate: Process(m000) creation failed
Mon Nov 16 15:06:02 2009
Process m000 died, see its trace file
Mon Nov 16 15:06:02 2009
ksvcreate: Process(m000) creation failed
Mon Nov 16 15:07:03 2009
Process m000 died, see its trace file
Mon Nov 16 15:07:03 2009
ksvcreate: Process(m000) creation failed
Mon Nov 16 15:08:04 2009
Process m000 died, see its trace file
Mon Nov 16 15:08:04 2009
ksvcreate: Process(m000) creation failed
Mon Nov 16 15:08:49 2009
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Mon Nov 16 15:08:49 2009
Starting ORACLE instance (normal)
Mon Nov 16 15:09:05 2009
Process m000 died, see its trace file
Mon Nov 16 15:09:05 2009
ksvcreate: Process(m000) creation failed
Mon Nov 16 15:09:44 2009
由于需要急切的让开发用上数据库，我直接startup force强制的把数据启了起来！后来查看原因是processes参数设置的太小，修改到1000以后没有出现这个问题。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16719800/viewspace-619882/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16719800/viewspace-619882/