Ora-27300 OS system dependent operation:fork failed with status: 11 [ID 392006.1]

 今天处理一个oracle双机切换的问题的，最后定为出原因如下：操作系统无法分配进程给我oracle，原因就是已经达到用户的最大进程数

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 and later
Generic UNIX
Generic Linux
***Checked for relevance on 17-AUG-2012***

Symptoms

The following message reported in alert log:

Mon Sep 18 18:10:34 2006
Errors in file /u01/oracle/admin/orcl/bdump/orcl1_psp0_954436.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
Mon Sep 18 18:10:35 2006
Process P073 died, see its trace file

Cause

The error messages indicating that oracle has problem in forking more process, the maximum number of PROCESSES allowed per user could be too low.

This is configured by the following kernel settings:

  AIX: maxuproc

  HP and Solaris: maxuprc

  Solaris 10: project.max-lwps

  Linux: nproc (/etc/security/limits.conf)

Solution

The setting can be changed using platform specific commands. For example, on AIX:

1. login as root.
2. use smitty utility
    Select 'System Environments'
    Select 'Change / Show Characteristics of Operating System'
    Maximum number of PROCESSES allowed per user'   ---> change to an appropriate value
    OR
    use command line:
    chdev -l sys0 -a maxuproc <n>, where n is an appropraite value

From the AIX installation guide, the recommended value for parameter 'maxuproc' is 16384.

11gR1: http://download.oracle.com/docs/cd/B28359_01/install.111/b28258/preaix.htm#CEGJICGC
11gR2: http://download.oracle.com/docs/cd/E11882_01/install.112/e17162/pre_install.htm#CIHGFEBD

 

The following note suggests the recommended value for different platforms:

Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) (Doc ID 169706.1)

---