Oracle RCU for Soa Suite Installation

Oracle Repository Configuration Utility

1.       To configure Oracle SOA Schema by using Oracle Repository Configuration Utility (RCU), perform the following steps:

Download the RCU from the following location

Download it from here for windows x86
http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html

a:

B: Select Create to create the schemas
 

C:Give the details as shown below. Give host name as  “localhost” if the database  is  installed in the same machine.Given  password as welcome1

D:Ignore the warning as shown in figure below and click Ignore

E:

 

F:You can create new prefix. YOU can give various names like SOA, SOA_ORACLE,DEV,TEST etc, here it is given as DEV. AVOID giving names like SOA2,SOA3 in other words avoid giving numbers

Select the SOA and BPM Infrasturcture as shown below

G: The following is created

H: Select use same passwords for al l schemas for simplicity. Give the password as welcome1

I: The following table spaces are created

J:

K:

J:

Troubleshooting

Note1: At any pont if  you get the following error

RCU-6083:Failed - Check prerequisites requirement for selected component:SOAINFRA

RCU-6107:DB Init Param Prerequisite failure for: processes

Current Value is 40. It should be greater than or equal to 200.

You need to do the following

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

Installing XE Database for Oracle SOA Suite 11g

The following needs to  be installed .

Install Oracle Database 10g Release 2 (10.2.0.1) Express Edition (Universal).

Note: Currently 10g express edition is  not  available  on oracle  website  . Instead 11 g express edition is available , you can use the 11g express edition which is available here

http://www.oracle.com/technetwork/products/express-edition/overview/index.html

a.       Download the Oracle Database 10g Expression Edition (Universal) executable for Windows into your c:\software folder

b.      Double-click the OracleXEUniv.exe file and perform the instructions in the following table:

Step	Screen/Window name	Values
1	Welcome	Click Next
2	License Agreement	Select “I accept the terms in the license agreement” option, and click Next
3	Choose Database Destination	Accept the default, or click Browse to change the destination as desired, and click Next
4	Specify Database Passwords	Enter welcome1  in the password and confirm password fields, and click Next
5	Summary	Click Install, and wait for installation to complete.
6	Finish	Click Finish.

 

c.       Start the SQL*Plus command line tool by selecting the following menu:
Start > All Programs > Oracle Database 10g Express Edition > Run SQL Command Line.

In the SQL command window enter the following commands:

SQL> connect sys/password as sysdba
Connected.

SQL> ALTER SYSTEM SET sessions=100 scope=spfile;
SQL> ALTER SYSTEM SET processes=200 scope=spfile;
SQL> shutdown immediate
SQL> startup
SQL> exit

Note: Now you may wonder why the above sql commands have to be performed .

The answer to this is very simple . If you don't run the above commands then while installing RCU/SOA Suite you get an error and you will not be able install the same.  

Hence remember always that the above commands are mandatory for the successful installation of Oracle SOA Suite 

d: now again go to sql command and check the database,

SQL> select * from dual;

It should show 

D

-

X