以前碰到过类似的ORA-27300系列错误，问题都是和系统上错误有关，这次的问题也不例外。
详细错误信息如下：
Tue May 17 22:01:04 2011 Process startup failed, error stack: Tue May 17 22:01:04 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_psp0_866.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 Tue May 17 22:01:05 2011 Process J001 died, see its trace file Tue May 17 22:01:05 2011 kkjcre1p: unable TO spawn jobq slave process Tue May 17 22:01:05 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_cjq0_894.trc: Tue May 17 22:01:42 2011 Process startup failed, error stack: Tue May 17 22:01:42 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_psp0_866.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 Tue May 17 22:01:43 2011 Process m000 died, see its trace file Tue May 17 22:01:43 2011 ksvcreate: Process(m000) creation failed Tue May 17 22:02:49 2011 Process startup failed, error stack: Tue May 17 22:02:49 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_psp0_866.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: skgpspawn5 |
从错误信息上也可以清楚的看出，错误出现在OS层面，查询MOS发现是由于当前的Solaris系统设置的进程相关参数过低造成的。
根据Oracle的推荐，可以修改系统/etc/system文件，添加下面的内容：
# vi /etc/system SET maxuprc=60000 SET pidmax=70000 SET max_nprocs=65000 SET maxusers=4096 # reboot |
要想是修改的参数生效需要重启数据库服务器。