Oracle常见问题：ORA-00020: maximum number of processes (1500) exceeded

问题描述

ORA-00020: maximum number of processes (1500) exceeded

处理方式

删除相关进程

kill -9 `ps -ef | grep "oracle" | grep "LOCAL=NO" | awk '{print $2}'`

提高进程上限

# 登录
sqlplus / as sysdba

# 查看processes配置
show parameter processes;

# 修改配置
alter system set processes=2500 scope=spfile;

# 关闭数据库
shutdown immediate

# 启动
startup

# 再次查看确认配置
show parameter processes;

参考资料

https://www.cnblogs.com/sharpest/p/10159949.html