Error ORA-12516 with Oracle XE with lots of connections

Oracle XE 10g has no hard limit on the number of processes but by default it is limited to 20 or 40 processes. You can change it :

  • Start sqlplus and connect to your database using system user
  • Execute the following code :
alter system set processes=300 scope=spfile;
alter system set sessions=300 scope=spfile;
  • Restart cleanly your database

Sources :

Published 15th May 2012 // #oracle

comments powered by Disqus