ORA-12518, TNS:listener could not hand off client connection
linux 7 安装oracle 11g，prcess和session设置10000+ 还是提示ora-12518错误提示，通过统计$process发现一直维持在2048；操作系统ulimit.conf限制远远超过2048限制；
oracle数据库还有其它地方限制嘛？或者linux系统有其它限制？
In Linux 6 or earlier version, you may need to check ‘max user processes’ etc. with ‘ulimit -a’ command.
But from Linux 7, there are something more need to be check:
DefaultTasksMax was default value(512).
systemd limited maximum number of tasks that may be created in the unit.
This setting also effect maxpid value on OS.
We observed some ’ fork rejected by pids controller’ error in OS log.
2017-08-16T02:36:55.560027+08:00 server-0 kernel: [ 165.619978] cgroup: fork rejected by pids controller in /system.slice/ohasd.service
which indicates some fork issue due to pid limits.
Listener cannot fork more process when the limits is reached, hence TNS-12518 was raised.
解决方法：
Edit /etc/systemd/system.conf
Set DefaultTasksMax to ‘infinity’
评论
有用 0
当前数据库会话有多少？
select count(*) from v$session; --取得数据库目前的会话数。
如果上述会话确实接近1w,那就需要再把session和processc参数设置大点(结合当前资源环境)。如果远小于1w,那么可能是监听配置有问题，建议删除监听，再重建监听。
评论 有用 1 评论 有用 0
