当会话达到最大值以后,后台日志会报如下错误信息:
[ERROR] database P0000005340 main_thread Reached the max session limit.
客户端连接错误信息如下:
解决办法:修改数据库最大连接数限制
# su - dmdba
[dmdba@dmserver ~]$ disql
disql V7.6.0.151-Build(2019.04.12-105437)ENT
username:SYSDBA
password:
Server[LOCALHOST:5236]:mode is normal, state is open
login used time: 10.355(ms)
SQL> ALTER SYSTEM SET 'MAX_SESSIONS' =1000 spfile;
之后重启数据库,检查参数是否生效:
SQL> select SF_GET_PARA_VALUE(2,'MAX_SESSIONS');
LINEID SF_GET_PARA_VALUE(2,'MAX_SESSIONS')
---------- -----------------------------------
1 1000
used time: 1.258(ms). Execute id is 17750.