ksvcreate:Process(m001)creationfailed问题处理

ksvcreate: Process(m001) creation failed 问题处理 问题描述： ---------------------------------------------------------------------------------- 系统windwos 2003 64bit oracle 10.2.0.2 alert_xx.log Thread 1 advanced to log sequence 2628 Curr

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：事件查看器