If you get the following error on Oracle XE:
ORA-12520: TNS:listener could not find available handler for requested type of server
This is probably because the value for the processes parameter is too low.
For some reason, Oracle set the default value of the processes parameter on Oracle XE to 40. If your application opens many process or several queries are executed at the same time, the ORA-12520 could be displayed.
The solution for this issue is simple. All you need to do is give the processes parameter an higher value.
open sql plus (All Programs -> Oracle Database 10g Express Edition -> Run SQL Command Line) and run the following command:
Alter system set processes=100 scope=spfile;
Restart the DB:
shutdown immediate
Startup
if needed, an higher number can be provided.
HAY THANKS!! THIS WAS VERY HELPFUL… I’m developing a payroll software using oracle xe database that runs a lot of processes during pay-processing. It kept giving me that error! thanks 4 the info
Thank you. it is nice to know that it was useful.
Pingback: Oracle XE and Processes Limit « Life in Brighton
Thank you for putting this up! Still very useful!
Thank you so much
YES…THANKS!!! THIS WAS VERY HELPFUL…
Thank you ! Very helpful!
Very Good Work, Thanks
Thank u !! This saved a hell lot of time
Thank you so much! You saved by bacon!
Really A big Thanks for This Post,, I was like Gone,, but this Post SAVED me..Thanks