ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-27300 和skgpspawn3错误

ORA-27300 和skgpspawn3错误

原创 Linux操作系统 作者:yangtingkun 时间:2011-11-08 23:10:16 0 删除 编辑

以前碰到过类似的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

要想是修改的参数生效需要重启数据库服务器。

 

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

下一篇: ORA-600(2037)错误
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1964
  • 访问量
    11076237