Oracle 10g (10.2.0.4), Solaris 10
Problem:
alert.log:
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
ORA-27303: additional information: skgpspawn5
Mon Mar 8 14:07:46 2010
Process J007 died, see its trace file
Mon Mar 8 14:07:46 2010
kkjcre1p: unable to spawn jobq slave process
Solution:
It happened to be lack of swap. For Solaris use:
swap -s
swap -l
Useful info:
For other status number of ORA-27300 check Metalink note ID 579365.1