TNS-12518: TNS:listener could not hand off client connection For ORACLE 10G （AIX6.1)
现象：
Client 连接报错：ORA-12537: TNS :连接关闭
alert log:
Errors in file /ora103/admin/STCSAPP/bdump/stcsapp_psp0_192826.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
TNS LOG如下：
15-SEP-2010 16:25:45 *
(CONNECT_DATA=(SERVICE_NAME=STCSAPP)(CID=(PROGRAM=C:EzLink.exe)(HOST=TE-20094228)(USER=stcs_mes)))
* (ADDRES
S=(PROTOCOL=tcp)(HOST=192.168.138.57)(PORT=1241)) * establish *
STCSAPP * 12518
TNS-12518: TNS:listener could
not hand off client connection
TNS-12549: TNS:operating system
resource quota exceeded
TNS-12560: TNS:protocol
adapter error
TNS-00519: Operating system
resource quota exceeded
IBM/AIX RISC System/6000
Error: 11: Resource temporarily unavailable
Solutions:
1）查看maxuproc参数当前值
lsattr -El sys0|grep maxuproc
maxuproc 1024 Maximum number of PROCESSES allowed per user True
2）使用命令chdev将maxuproc参数调大到1024
# chdev -l sys0 -a maxuproc=1280
参考网址：http://space.itpub.net/519536/viewspace-625634
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/789833/viewspace-1038441/ ，如需转载，请注明出处，否则将追究法律责任。
