在listener.log中发现如下的错误信息
TNS-12540: TNS:internal limit restriction exceeded
这是由于同时并发的connect太多导致 listener 异常终止
可修改如下的参数
$TNS_ADMIN/listener.ora里面的参数
max_all_connections_listener=40000
/u01/app/grid/diag/tnslsnr/atpd-exa-ntlo24/listener/trace/listener.log
16-DEC-2020 08:02:02 * (CONNECT_DATA=(SERVER=SHARED)(SERVICE_NAME=guannewpdb10009_high.atp.oraclecloud.com)(CID=(PROGRAM=sqlplus)(HOST=scaqad02adm02.us.oracle.com)(USER=oracle))(CONNECTION_ID=tpFJ4CHZXzvgU+IUHwqr1A==)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.26.37)(PORT=16229)) * establish * guannewpdb10009_high.atp.oraclecloud.com * 0
16-DEC-2020 08:02:02 * 1159
TNS-01159: Internal connection limit has been reached; listener has shut down
TNS-12540: TNS:internal limit restriction exceeded
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.26.41)(PORT=1521)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.26.37)(PORT=1521)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=10.1.26.41)(PORT=2484)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
2020-12-16T08:02:34.524951+00:00
如何确认这个参数是否生效呢
/u01/app/grid/diag/crs/atpd-exa-ntlo24/crs/trace/crsd_oraagent_grid.trc
2020-12-16 08:19:23.115 :CLSDYNAM:513074944: [ora.LISTENER.lsnr]{4:46892:21568} [start] ConfigFile::parse mmap name:max_all_connections_listener nameWithCase:max_all_connections_listener value:40000 comment: