TNS:listener could not find available handler with matching protocol stack

Problem:
-----------
TNS:listener could not find available handler with matching protocol stack


Solution:
-----------
Your current process is max procecess.

You have to kill some session.

After you kill,sessions continue coming.If this case happen,

You can kill LOCAL=NO via awk.

After this issue completed.

bash$>ps -ef | grep LOCAL=NO | awk '{print "kill -9 " $2}' > kill.ksh

bash$>ksh kill.ksh

When you are available,you have to increase max processes parameter

SQL>alter system set processes=3000 scope=spfile;

Then you have to restart the database.Because this parameter is static.

Note:In my case processes parameter is 1500,so I should set bigger than 1500.

Pry and try :)