问题之Process m000 died, see its trace file&ksvcreate: Process(m000) creation failed

环境：

ORACLE10.2.0.4

LINUX 5.4

ERROR:

Thu Jun 30 13:41:45 2011
Process m000 died, see its trace file
Thu Jun 30 13:41:45 2011
ksvcreate: Process(m000) creation failed
Thu Jun 30 13:42:22 2011

[@more@]

今天DEV环境的数据库前台反应不能进行连接，通过查看ALTER文件发现后台报了许多：

Thu Jun 30 13:41:45 2011
Process m000 died, see its trace file
Thu Jun 30 13:41:45 2011
ksvcreate: Process(m000) creation failed
Thu Jun 30 13:42:22 2011

metalink给出的解释是资源不足导致的问题，于是查看：

select * from v$resource_limit;

1 processes 150 150 150 150

可以发现processes已经爆满，于是kill掉几个就OK了，最后修改processes参数问题解决！

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

转载于:http://blog.itpub.net/10130206/viewspace-1051806/