Installation Steps for XE Database and Schema Creation using RCU

Hi Friends,

In this blog we will learn the steps to install Oracle SOA Suit 11g. The blog will describe step by step description to install oracle SOA Suit.

1. For installing Oracle SOA Suit first we need to install Oracle XE database. Below are the steps to install Oracle XE Database:

Installation or Oracle XE Database:

1. Click on XE Database Installer. Fist it will check the if the required space for installation is available or not. Also if you want you can change the location destination folder in this step. From my installation I choose the path as D:\oraclexe\

2. In the next step it will prompt for password for SYS and SYSTEM database users. For my installation I choose the password as welcome1. You can select any other convenient password. 

3. Before stating the installation it will show a summary page with current Installation Settings. Click on Install.

 4. In the middle of  installation I got below error . The error comes because of the missed registry entry by installer. We need to add the Registry Entry for resolving below error.

Refer below blog for resolving this error. In the blog detailed steps are mentioned for the above Error Resolution:

http://blog.mclaughlinsoftware.com/2011/09/13/oracle-11g-xe-installer/ 

5. After making necessary changes according to above blog the installation will resume as show below.

Once the installation gets complete click on Finish button.

Checking if XE Database is Up and Running:

1. Start the database from Start-->All Programs-->Oracle Database 11g Express Edition-->Start Database

 2. In command prompt connect to database using SQLPLUS command and run commands as shown below:

If all the commands run successfully Database is up and running.

Creation of necessary schemas using RCU

Double click on rcu.bat file at RCU_Home\bin

1. Click next to welcome page and selct Create. Click on Next.

 2. Provide the connection details for the database installed above. Enter the user with DBA or SYSDBA previlages. I used SYS user for my installaion. Provide the password mentioned during installation of database. For my case I used password as "welcome1".

3.Once you click on next RCU will check for necessary Prerequisites. Click OK after all Prerequisites checks are done.

4. In next step select SOA and BPM Infrastructure Component. It will select all other  necessary components also which are required for installation.

5. In the next screen provide the password for each Schema. You can provide either same password or Schema specific passwords. I have provide same password for all the schemas "welcome1"

6. In the next screen it will Map Tablespaces with the Schemas created in above step. Click on Next.

7. It will create the necessary Tablespaces after you click on Next.

8. In the Summay page it will show all the details of the schemas creation. Click on Create

9. In final screen it will show status of all the Schemas Create. Click on Close to complete Schemase using RCU.