我的服务器突然出现用户偶然连接不上的问题， 我的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
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
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
