看到这个错误,想到可能是session满了,试了一下果然是
[oracle@oraclerac1 ~]$ sqlplus "/ as sysdba" SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 2 19:04:13 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-00020: maximum number of processes (150) exceeded
解决办法很简单,修改processes参数,如下:
SQL> alter system set processes=1000 scope=spfile; System altered.
需要重启数据库
