ksvcreate: Process(m001) creation failed 问题处理
问题描述：
----------------------------------------------------------------------------------
系统windwos 2003 64bit
oracle 10.2.0.2
alert_xx.log
Thread 1 advanced to log sequence 2628
Current log# 2 seq# 2628 mem# 0: X:\ORACLE\ORADATA\NWZW\NWZW\REDO02.LOG
Wed Apr 09 17:01:02 2014
Process m001 died, see its trace file
Wed Apr 09 17:01:02 2014
ksvcreate: Process(m001) creation failed
Wed Apr 09 18:00:08 2014
Process m001 died, see its trace file
Wed Apr 09 18:00:08 2014
ksvcreate: Process(m001) creation failed
Wed Apr 09 19:00:14 2014
Process m000 died, see its trace file
Wed Apr 09 19:00:14 2014
ksvcreate: Process(m000) creation failed
Wed Apr 09 19:01:15 2014
Process m000 died, see its trace file
Wed Apr 09 19:01:15 2014
ksvcreate: Process(m000) creation failed
Wed Apr 09 19:02:16 2014
Process m000 died, see its trace file
Wed Apr 09 19:02:16 2014
ksvcreate: Process(m000) creation failed
Wed Apr 09 21:00:31 2014
Process m001 died, see its trace file
Wed Apr 09 21:00:31 2014
ksvcreate: Process(m001) creation failed
Wed Apr 09 21:59:33 2014
Process m000 died, see its trace file
Wed Apr 09 21:59:33 2014
ksvcreate: Process(m000) creation failed
Wed Apr 09 22:00:37 2014
Process m000 died, see its trace file
实例会down掉，重启实例就好了
问题处理：
----------------------------------------------------------
1》。可能Oracle实例资源不足，其中较为常见的是实例instance的process使用达到上限，
可以通过查询v$resource_limit视图来了解实例生命周期内是否发生过process总数暴满的情况:
SQL> select * from v$resource_limit;
如果proces ， session 数达到上限 则设置一个合理值alter system set processes=xx scope=spfile；重启生效
2》。可能os 系统资源不足 在确定数据库参数 session， processes 没有达到上限时 可以额外部署下oswatch来查看历史资源使用情况，此外也可以查看 os 日志 如 aix：errpt 、 linux：dmesg 、 windows：事件查看器