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掉，重启实例就好了
问题处理：
在原版的基础上做了一下修正评论没有提交正文的问题特价商品的调用连接问题去掉了一个后门补了SQL注入补了一个过滤漏洞浮动价不能删除的问题不能够搜索问题收藏时放入购物车时出错点放入购物车弹出2个窗口修正主题添加问题商家注册页导航连接问题销售排行不能显示更多问题热点商品不能显示更多问题增加了服务器探测 增加了空间使用查看 增加了在线文件编辑增加了后台管理里两处全选功能更新说明：后台的部分功能已经改过前台
----------------------------------------------------------
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：事件查看器
