Resolution of error in running Repository Creation Utility using Oracle XE database, Error: RCU-6107:DB Init Param Prerequisite failure for: processes Current Value is 40. It should be greater than or equal to 200.

While Installing Repository Creation Utility (RCU 11.1.1.3.0) and when RCU was checking prerequisites, I had Operation failed for SOA Infrastructure and had the following screen

The details of exception is bellow

Infrastructure 2010-11-07 13:39:52.071 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator::executePrereqTask: Prereq taskId = SOAINFRA

2010-11-07 13:39:52.071 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator::executePrereqTask: Starting component prereq check
2010-11-07 13:39:52.086 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.PrereqTask::execute: Prereq Evaluation Failed
oracle.sysman.assistants.rcu.backend.validation.PrereqException: RCU-6083:Failed - Check prerequisites requirement for selected component:SOAINFRA
Please refer to RCU log at C:\Users\united\Desktop\ofm_rcu_win32_11.1.1.3.3_disk1_1of1\rcuHome\rcu\log\logdir.2010-11-07_13-37\rcu.log for details.
at oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.executePrereqTask(PrereqEvaluator.java:642)
at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:68)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
at java.lang.Thread.run(Thread.java:619)
2010-11-07 13:39:52.086 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6083:Failed - Check prerequisites requirement for selected component:SOAINFRA
Please refer to RCU log at C:\Users\united\Desktop\ofm_rcu_win32_11.1.1.3.3_disk1_1of1\rcuHome\rcu\log\logdir.2010-11-07_13-37\rcu.log for details
RCU-6107:DB Init Param Prerequisite failure for: processes
Current Value is 40. It should be greater than or equal to 200.
at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:76)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
at java.lang.Thread.run(Thread.java:619)


Reason of this error message
The current value of processes is set to 40 but for repository creation it should be 200 or above.
Resolution: to resolve this issue, number of processes need to be increased in database parameters.

Open your SQLPLUS.exe

Provide username as “Sys as sysdba” and password for sys

When you get connected, write "show parameters"

You will be shown the list of parameters find the processes parameter to make sure it is 40, now you need to update the processes

wirte the following command

SQL> alter system set processes=200 scope=spfile;

Shutdown your database using following command

SQL> shutdown immediate;

and start your database using

SQL>startup

Write show parameter command again to verify the changes in processes parameter

Hope so your Repository creation utility won't give you pain and run smoothly...

Cheeeeeeeers.. !