Tutorial 2 : How to Install Oracle SOA Suite 11g (11.1.1.3) Part II - Installing Oracle XE Database

In this tutorial, I am going to cover installation for the Oracle database  required for SOA Suite 11g. For developement purpose we are going to use Oracle Express edition of Database i.e. Oracle XE database. This tutorial and screen shots taken all are for Windows operation system but process is more or less similar in other operation systems as well.

This tutorial has to be followed properly and Oracle XE database has to be installed and configured perfectly. For successfull installation of SOA Suite 11g, this Oracle XE database has to be up and running before proceeding further for other tutorials.

If you have not download yet, Get the latest copy from Oracle website at http://www.oracle.com/technetwork/database/express-edition/downloads/index.html and save it to c:\SOAInstallables (This is the same director which we have created in first tutorial of How to Install Oracle SOA Suite 11g.

When you download the Oracle XE database make sure you download the Universal Installer


Note : When you are running Repository creation utility for creating schema in database before installing SOA Suite 11g, you will see warning that the database you are using is too old. you can safely ignore this warning as it applies for production environment.

As you are installing the Oracle XE as database server for SOA Suite 11g installation, It is important to know that what is the version when we say we are using Oracle XE Database. Database version for Oracle XE is 10.2.0.1 and SOA Suite 11g Installation requires actually 10.2.0.4 or higher or 11.1.0.7 or higher. And that is the reason we are getting the warning while running the Repository Creation Utility before installing SOA Suite 11g. Oracle XE is very good choice for small footprint database in SOA Suite 11g development environment.


Ok, Now you are ready to start with the installation of Oracle XE database for seting up SOA Suite 11g development environment.

Step 1 : Go to c:\SOAInstallables directory and click on OracleXEUniv.exe and It will start the Installation wizard as below. Click Next to proceed

Step 2: As shown in below screen shot select "I accept" and click Next

Step 3 : Specify the location where you want to install Oracle 10g Express Edition server and click next.

Step 4 : specify the password for the SYS and SYSTEM
user account for this database

Step 5 : Reviw the setting and click on Install

Step 6 :  Wizard will start installing and copying files

Step 7 : Click on Finish

Step 8 : Go to this URL http://127.0.0.1:8080/apex/ and login using SYS and password you have specified for the SYS and SYSTEM user accounts while creating database.  You will be able to see four icons

• Administration
• Object browser
• SQL
• Utilities

You won't need Oracle client here, all can be done from this User Interface.

• Oracle Essentials: Oracle Database 11g
• Oracle 11g For Dummies
• Expert Oracle Practices: Oracle Database Administration from the Oak Table 
• Oracle Database 11g DBA Handbook (Osborne ORACLE Press Series) 
• Oracle Database 11g The Complete Reference (Osborne ORACLE Press Series) 
• Beginning Oracle Database 11g Administration: From Novice to Professional 
• Oracle Database 10g Performance Tuning Tips & Techniques (Osborne ORACLE Press Series) 
• Expert Oracle Database Architecture: Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions, Second Edition 
• Oracle Database 10g: A Beginner's Guide (Osborne ORACLE Press Series) 
• Oracle Database 11g PL/SQL Programming (Osborne ORACLE Press Series) 
• Expert Oracle Database 11g Administration (Expert's Voice in Oracle)