- 论坛徽章:
- 0
|
metalink了一吧, 按照如下操作 把每个用户的能够打开的最大 进程数由原来默认的128改成256就ok了
metalink见: note [ID 392006.1]
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 |
|