phpBB

Development Wiki

Talk:Unit Tests

From phpBB Development Wiki

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