文章目录
一、解决ORA-00020:maximum number of processes (150) exceeded 错误
杀死所有oracle进程
su - oracle
ps -ef |grep $ORACLE_SID|grep -v grep|awk '{print $2}' | xargs kill -9
ipcs -m | grep oracle | awk '{print $2}' | xargs ipcrm shm
lsnrctl stop
lsnrctl start
查看当前最大连接数sessions和最大线程数processes
sqlplus / as sysdba
SQL> startup;
SQL> show parameter sessions;
SQL> show parameter processes;
修改最大连接数sessions和最大线程数processes
alter system set sessions=2272 scope=spfile;
alter system set processes=1500 scope=spfile;
shutdown immediate;
startup;
修改成功
二、连接不上实例，lsnrctl status提示The listener supports no services 问题解决方法
解决方法
修改监听文件/deploy/oracle/product/11.2.0.4/network/admin/listener.ora
监听文件，通过lsnrctl status能查看到
增加如下内容：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = orcl)
)
)
lsnrctl stop
lsnrctl start
sqlplus / as sysdba
SQL> startup