营销型网站建设报价,灌南县规划局网站理想家园规划建设,中山网站的优化,铁西网络建设项目经理反馈#xff0c;现场已做了单个用户的最大连接数2000的限制#xff0c;但数据库还是报无法连接#xff0c;故障用户的连接数已3800多了。
查看日志报错如下
2023-07-20T13:07:57.79465308:00 Process m000 submission failed with error 20 Process m000 submiss…项目经理反馈现场已做了单个用户的最大连接数2000的限制但数据库还是报无法连接故障用户的连接数已3800多了。
查看日志报错如下
2023-07-20T13:07:57.79465308:00 Process m000 submission failed with error 20 Process m000 submission failed with error 20 Process m000 submission failed with error 20 Process m000 submission failed with error 20 2023-07-20T13:08:16.88244108:00 ORA-00020: maximum number of processes (5000) exceeded ORA-20 errors will not be written to the alert log for the next minute. Please look at trace files to see all the ORA-20 errors. 2023-07-20T13:08:57.84626108:00 Process m001 submission failed with error 20 Process m002 submission failed with error 20 2023-07-20T13:09:15.71254608:00 Process J000 submission failed with error 20 2023-07-20T13:09:15.71278008:00 kkjcre1p: unable to spawn jobq slave process 2023-07-20T13:09:15.71295008:00 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_3577.trc:
2023-07-20T13:12:20.92040108:00 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_3577.trc: 2023-07-20T13:12:22.93046308:00 ORA-00020: maximum number of processes (5000) exceeded ORA-20 errors will not be written to the alert log for the next minute. Please look at trace files to see all the ORA-20 errors. 2023-07-20T13:12:58.04956208:00 Process m000 submission failed with error 20 Process m001 submission failed with error 20 Process m000 submission failed with error 20 Process m000 submission failed with error 20 2023-07-20T13:13:25.51045908:00 ORA-00020: maximum number of processes (5000) exceeded ORA-20 errors will not be written to the alert log for the next minute. Please look at trace files to see all the ORA-20 errors.
故障用户的当前连接数已3880了 查看默认的PROFILESESSIONS_PER_USER也确实做了2000限制 处理办法
1、SQL alter system set resource_limit TRUE; --对资源类的参数限制必须启用该参数 SQL alter profile DEFAULT limit sessions_per_user 2000; ---事先已执行过可不执行
2、kill用户USR_LTWX的非活动session
3、持续观察该用户最大连接数没超过2000
4、让现场经理通知用户产品排查故障原因