Databases Reference
In-Depth Information
4.
In the
Select Components
screen, select
SOA and BPM Infrastructure
,
and click on
Next
.
5.
Complete the rest of the steps to set up passwords, and map table spaces.
Setting up database parameters
The
processes
parameter on an Oracle database instance represents the
maximal number of open sessions (active database connections) allowed at the
database side. As Oracle SOA Suite and Oracle BAM use their dedicated data
sources to connect to the backend database, it is important to set the
pro-
cesses
parameter to an appropriate value, so that SOA/BAM can always obtain
database connections if needed.
To set this parameter, perform the following steps:
1.
Connect to the database server as the
sys
user or a user with the
DBA
role.
2.
Run the following Oracle database command to determine the number of
processes for the database instance:
SQL> SHOW PARAMETER processes;
3.
Determine the appropriate value for the
processes
parameter. The recom-
mended setting of the
processes
parameter is dependent on the Fusion
Middleware components used in your system. For example, if you are using
BAM, this parameter should be set to
100
or above. If you are using both
SOA and BAM, it is recommended to set this parameter to
400
or above.
4.
To change the value of this parameter, run the following Oracle command,
and then restart the database:
SQL> ALTER SYSTEM SET processes=400 SCOPE=SPFILE
