Talk:Unit Tests

Running tests under Oracle XE
The default connection limits are fairly low and will cause the tests to fail with the following error: "ORA-12520: TNS:listener could not find available handler for requested type of server" The number of available database sessions becomes exhausted. The limits can be changed by using SQL*Plus: C:\>sqlplus / as sysdba SQL> alter system set sessions=300 scope=spfile; SQL> alter system set processes=300 scope=spfile; You will then need to stop and restart the database service.

Reference: http://www.eddgrant.com/blog/EdD/entry/increasing_the_number_of_processes