Rails rake tests randomly generate ORA-12520 errors.
Jan.05, 2009 in
Rails
If you find your application randomly throwing “ORA-12520: TNS:listener could not find available handler for requested type of server” errors, then try to increase the number of available processes that you have allocated to your Oracle instance.
Logon to
Oracle using sys as sysdba and execute the following:
ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;
After changing the PROCESSES parameter restart your Oracle service. I recently encountered this on a rails project I’m currently working on with an Oracle XE installation running in a Windows XP VM. It seems like the default process level was set to 40 so running the rake tests consistently, but sporadically produced these errors at random intervals.
