Using Oracle XE with SOA Suite 11g
By Jeff Davies-Oracle on Oct 01, 2010
In the course of my duties, I have to install Oracle SOA Suite 11g several times a month, usually on a laptop or development machine. My preferred development environment is Ubuntu 10.04.
Sometimes when I install Oracle-XE (Universal version 10.2.0.1.0, available at http://www.oracle.com/technetwork/database/express-edition/downloads/index.html) the database and the web server won't automatically start. If this happens to you simply run the following command to configure Oracle XE:
sudo /etc/init.d/oracle-xe configure
That command will prompt you to select the port on which the HTTP server will listen (defaults to 8080), whether or not to start the database on machine startup and what port the Oracle database should listend to (default is 1521). You will also be prompted to define the default password for the database.
Test to ensure that everything is running by pointing your web browser to:
Substitute your port number if you did not choose the default of 8080, naturally.
Next you need to modify your environment so that Oracle XE is a part of your PATH. In your home directory, use gedit to open your .bashrc file and add the following entries at the bottom:
export ORACLE_HOME="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server" export JAVA_HOME="/home/jeff/Oracle/Middleware/jdk160-18" export PATH="$ORACLE_HOME/bin:$JAVA_HOME/bin:$PATH"
Obviously you'll need to substitute your home directory in the paths I've given above. I'm also assuming that you have already installed WebLogic Server 10.3 into your home directory. I like to explicitly set my JAVA_HOME so that I can change it easily if needed (usually for testing purposes).
Now you can open a terminal window and enter the following command to start SQLPLUS:
sqlplus sys/password@XE as sysdba
In SQLPlus, enter these commands:
alter system set processes=500 scope=spfile; alter system set open_cursors=500 scope=spfile; shutdown
Exit SQLSplus and restart your system. Oracle XE is ready to work with SOA Suite 11g, specifically with the RCU (Repository Creation Utility). That's all. It can seem a bit cryptic at first, vut if you follow these steps you should have no problems installing and configuring the Oracle XE database for SOA Suite 11g.