首頁 > 資料庫 > mysql教程 > ksvcreate:Process(m001)creationfailed问题处理

ksvcreate:Process(m001)creationfailed问题处理

WBOY
發布: 2016-06-07 15:55:51
原創
1261 人瀏覽過

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:事件查看器
登入後複製
相關標籤:
來源:php.cn
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板