2014-07-02 11:07:00
Topic starter
Notifications
Clear all
Developer Network Q&A
2
Posts
2
Users
0
Reactions
897
Views
0
How do I resolve this error:
ORA-12516: TNS:listener could not find available handler with matching protocol stack
1 Answer
0
2014-07-02 11:07:00
Topic starter
This can happen if Oracle is not configured with enough processes to handle all the concurrent requests coming from the server. To increase your process count, first login as a "system" user and execute:
show parameter process;
Pay attention to the line with name "processes". You should increase this value. For example, by default in Oracle XE it is 100, which is pretty low. To increase it to 400, you can execute:
alter system set processes=400 scope=spfile;
Then restart the Oracle service. If you reconnect after restart, and rerun show parameter process;, you should see a higher count now.
