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@]