Problem
SQL>CONN eb/@eb
ERROR:
ORA-12516: TNS:listener could not find
available handler with matching protocol stack
Solution
$ sqlplus "/as
sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on
Wed Feb 25 12:38:31 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-00020: maximum number of processes (150) exceeded
kill all the PIDs which are connected through client
$ for i in `ps -ef |grep LOCAL=NO |awk '{print $2}'`; do `kill
-9 $i`; done
$ sqlplus "/as
sysdba"
alter system set processes=1000 scope=spfile;
SHUTDOWN & RESTART