Database Reference
In-Depth Information
The default limit of
processes
is not sufficient for creating the SOA Suite schema.
Set the
processes
to
600
for all the SIDs, as given in the following lines of com-
mand:
SQL> alter system reset sessions scope=spfile
sid='*';
SQL> alter system set processes=600
scope=spfile;
Make the changes effective immediately with the following command:
SQL> shutdown immediate
Using system Start menu's
Start Database
menu options start the Oracle Database
service.
Validate the system settings with the following steps:
1. Connect to the database using a Windows shell command prompt and
run
sqlplus system/{password}@XE as sysdba
.
SQL> show parameter session
SQL> show parameter processes
