Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.2 and later [Release: 10.2 and later ]
IBM AIX on POWER Systems (64-bit)
IBM AIX Based Systems (64-bit)
IBM RS 6000 AIX 5L
Symptoms
On 10.2.0.2 in Production:
the following error occurs in the alert.log
ERROR
Errors in file /u01/oracle/admin/MFACTOR/bdump/mfactor1_psp0_954436.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot connect to the database.
Verified the issue in the log file as noted below:
LOG FILE
Filename = alert_MFACTOR1.log
See the following error:
Process startup failed, error stack:
Mon Sep 18 18:10:34 2006
Errors in file /u01/oracle/admin/MFACTOR/bdump/mfactor1_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 issue is caused by the following setup: maximum number of processes allowed per user.
The error messages indicating that oracle has problem in forking more process.
Checked the "maxuproc", it is only set to 128.
Solution
To implement the solution, please execute the following steps:
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
3. use command line:
chdev -l sys0 -a maxuproc <n>, where n is an appropraite value作者: yddll 时间: 2011-04-15 18:12
不会这个都没改吧