ORA-27300: OS system dependent operation:fork failed with status: 11
I have a 10g R2 database on Sun Solaris 5.10 with 4 cpu 4Gb mem. I am getting the following error. Any help is appreciated:
Wed Dec 6 01:50:25 2006
Errors in file /d02/oracle/proddb/10.2.0/admin/PROD_rdcuxsrv191/bdump/prod_psp0_521.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 Dec 6 01:50:26 2006
Process J000 died, see its trace file
Wed Dec 6 01:50:27 2006
kkjcre1p: unable to spawn jobq slave process
Wed Dec 6 01:50:27 2006
Errors in file /d02/oracle/proddb/10.2.0/admin/PROD_rdcuxsrv191/bdump/prod_cjq0_541.trc:
Wed Dec 6 01:58:47 2006
Process startup failed, error stack:
Below is the output from /etc/system:
* USI100fd_start (do not remove)
set hme:hme_adv_100T4_cap = 0
set hme:hme_adv_100fdx_cap = 1
set hme:hme_adv_100hdx_cap = 0
set hme:hme_adv_10fdx_cap = 0
set hme:hme_adv_10hdx_cap = 0
set hme:hme_adv_autoneg_cap = 0
* USI100fd_end (do not remove)
* Attempt to prevent and log stack-smashing attacks
set noexec_user_stack = 1
set noexec_user_stack_log = 1
* Begin MDD root info (do not edit)
rootdev:/pseudo/md@0:0,1,blk
* End MDD root info (do not edit)
* For 2-disk systems, it is recommended to uncomment
* the line below to disable the boot quorom rule
* set md:mirrored_root_flag=1
* improve resync speed at the expense of application i/o
set md_mirror:md_resync_bufsz=2048
set sys:coredumpsize=0
set c2audit:audit_load = 1
set nfssrv:nfs_portmon=1
set shmsys:shminfo_shmmax=3294967296
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=1024
set shmsys:shminfo_shmseg=128
##set semsys:seminfo_semmap=64
set semsys:seminfo_semmni=15680
set semsys:seminfo_semmns=31360
##set semsys:seminfo_semmnu=1600
##set semsys:seminfo_semmsl=256
set semsys:seminfo_semopm=110
set semsys:seminfo_semume=900
set semsys:seminfo_semvmx=32767
set semsys:seminfo_semaem=16384
set rlim_fd_max=65536
set rlim_fd_cur=65536
set default_stksize=65536
set lwp_default_stksize=65536
set rpcmod:svc_default_stksize=65536
set maxuprc=2048
set semsys:seminfo_semmsl=2048
set semsys:seminfo_semmap=1000
set semsys:seminfo_semmnu=3200
Below is the trace file contents
Dump file /d02/oracle/proddb/10.2.0/admin/PROD_rdcuxsrv191/bdump/prod_psp0_521.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /d02/oracle/proddb/10.2.0
System name: SunOS
Node name: rdcuxsrv191
Release: 5.10
Version: Generic_118833-17
Machine: sun4u
Instance name: PROD
Redo thread mounted by this instance: 1
Oracle process number: 3
Unix process pid: 521, image: oracle@rdcuxsrv191 (PSP0)
*** SERVICE NAME:(SYS$BACKGROUND) 2006-12-06 01:50:24.418
*** SESSION ID:(1199.1) 2006-12-06 01:50:24.418
*** 2006-12-06 01:50:24.418
Process startup failed, error stack:
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
*** 2006-12-06 01:58:47.818
Process startup failed, error stack:
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
*** 2006-12-06 01:59:25.943
Process startup failed, error stack:
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
Processes parameter is set at 1000 at db level
