Steps to alter the maximum number of simultaenous user logins in Oracle XE.

I found it rather strange that to increase the maximum number of connections; you need to increase the processes and not through the web GUI. The steps to alter the maximum number of processes in Oracle XE is similar to Oracle full edition.

Login to the SQL Command Line as sysdba.

SQL> show parameter processes
NAME TYPE VALUE
------------------------------------------------------------------------
processes integer *40*


Then increase the processes.

SQL > alter system set processes=100 scope=spfile.

Restart the database server; Check the processes parameter for confirmation.

This shall increase the number of connections.