TNS-12518: TNS:listener could not hand off client connection

[minquan2001]

我的服务器突然出现用户偶然连接不上的问题，
我的alert.log
Errors in file /export/home/oracle/admin/wcb/bdump/wcb_psp0_68658.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
我的listener.log里:
TNS-12518: TNS:listener could not hand off client connection
TNS-12549: TNSperating system resource quota exceeded
TNS-12560: TNSrotocol adapter error
TNS-00519: Operating system resource quota exceeded
IBM/AIX RISC System/6000 Error: 11: Resource temporarily unavailable

ＯＳ：IBM/AIX ５.３　ＯＲＡＣＬＥ：１０.２.０.３
ＡＩＸ：MEM:4G
maxuproc ＝1024

DB1:/#vmstat 1 2

System configuration: lcpu=8 mem=15744MB

kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
0 0 1370290 2080074 0 0 0 0 0 0 60 2857 378 0 0 99 0
0 0 1370333 2080031 0 0 0 0 0 0 233 4286 546 1 1 97 1

ＯＲＡＣＬＥ：process =1000
session =1105
PGA=1000MB
SGA=1500MB
出现问题时V$PROCESS里面只有１００多个，
目前数据库还没有上线，

不知道什么问题？

[byfree]

CauseThe 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.


SolutionTo 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

[ruihuahan]

增加 swap/paging 大小试试。

[minquan2001]

maxuproc已经是1024了,我想应该足够了

[byfree]

metalink这样建议的，你可以试试