Thursday, November 11, 2010

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.. !

1 comment: