ITPub博客

首页 > 数据库 > Oracle > ORA-27300 For AIX6.1

ORA-27300 For AIX6.1

原创 Oracle 作者:ningzi82 时间:2010-08-04 15:16:34 0 删除 编辑

系统进程数超出 maxuproc的最大值,导致DB Client无法连接

Wed Aug 4 14:00:15 2010
Process startup failed, error stack:
Wed Aug 4 14:00:15 2010
Errors in file /ora103/admin/STCSAPP/bdump/stcsapp_psp0_2314532.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn3
Wed Aug 4 14:00:16 2010
Process J001 died, see its trace file
Wed Aug 4 14:00:16 2010
kkjcre1p: unable to spawn jobq slave process
Wed Aug 4 14:00:16 2010
Errors in file /ora103/admin/STCSAPP/bdump/stcsapp_cjq0_1433952.trc:

Solution:

# ps -ef|grep oracle{SID}|wc -l --查看进程数

# lsattr -Elsys0|grep maxuproc
maxuproc 1024 Maximum number of PROCESSES allowed per user True

# smitty chgsys 由1024改为8192
*
o Maximum number of PROCESSES allowed per user [1024]

参考网址:http://blog.sina.com.cn/s/blog_592060b50100e1hu.html

[@more@]

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

请登录后发表评论 登录
全部评论

注册时间:2008-12-16

  • 博文量
    130
  • 访问量
    358884