Wednesday, July 8, 2009

Error in Running Repository Creation Utility (RCU) While Using Oracle XE database

While following the Quick Installation Guide for Oracle SOA Suite11g Release 1, I encountered the following error in running the Repository Creation Utility while using Oracle XE database.

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:\installers\Development\Active\rcuHome\rcu\log\logdir.2009-07-08_16-16\rcu.log for details. at oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.executePrereqTask(PrereqEvaluator.java:600) at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:68) at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:303) at java.lang.Thread.run(Thread.java:619) 2009-07-08 16:34:49.848 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:\installers\Development\Active\rcuHome\rcu\log\logdir.2009-07-08_16-16\rcu.log for details. RCU-6107:DB Init Param Prerequisite failure for: processes Required Value = 200, Current Value = 40, Comparison Operator: ">=" at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:76) at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:303) at java.lang.Thread.run(Thread.java:619)

Solution:
Run SQL Command Line
Connect as SYSDBA using user "system"
SQL> connect system/password
SQL> show parameters processes
SQL> alter system set processes=200 scope=spfile;

And dont forget to restart your database...(thanks Attila for reminding me).
For more info, see the following site: Oracle XE Tuning Tags: JDeveloper 11g R1 WebLogic SOA Suite Repository Creation Utility

1 comment:

  1. Hi, thanks for the information! A minor issue: this is not enough, you must also restart the DB after this. I learned it at http://forums.oracle.com/forums/thread.jspa?threadID=669548#2588112 .
    The link "Oracle XE Tuning" is now broken, but of course one may find resources elsewhere.

    ReplyDelete