TNS-12518,TNS-12536,TNS-00506,Linux Error: 11: Resource temporarily unavailable

weixin_34363171

于 2014-01-15 10:18:00 发布

阅读量429

点赞数

文章标签：数据库

本文介绍了一种Linux环境中由于进程限制设置过低导致的应用错误，特别是针对Oracle环境中的grid用户。通过调整/etc/security/limits.conf文件中grid用户的nproc值从2047增加到131072，成功解决了TNS系列错误及资源暂时不可用的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

TNS-12518: TNS:listener could not hand off client connection
TNS-12536: TNS:operation would block
TNS-12560: TNS:protocol adapter error
TNS-00506: Operation would block
Linux Error: 11: Resource temporarily unavailable

It turns out the Linux Error: 11: Resource temporarily unavailable was caused due my nproc limit being set to low.
Within the /etc/security/limits.conf file I had my oracle user set at 131072 nproc value
(oracle's best practice from their oracle-validated rpm), however my grid user nproc value was set at 2047!
I changed the nproc value of my grid user to 131072 and now the issue no longer occurs.
nproc is the max number of processes that can be run by a user.