Tuesday 16 July 2013

ORA-27300: OS system dependent operation:fork failed with status: 2


When operating system is encountering with some unknown error like insufficient space in temp Area or swap Area or insufficient system resources then Oracle throws following errors.

Error:
ORA-27300: OS system dependent operation:fork failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: skgpspawn5

Solution:
On System: maxproc 128 to 16384             

ora11g@abc_test#  lsattr -E -l sys0 | grep -i maxuproc
maxuproc        16384              Maximum number of PROCESSES allowed per user      True


On DB: process 150 to 300

SQL> show parameter proce
processes   integer     300