ORA-27300 For AIX6.1

系统进程数超出 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博客 ” ，链接：http://blog.itpub.net/789833/viewspace-1036113/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/789833/viewspace-1036113/