Installing Oracle SOA Suite atop XE Database


Although not officially supported, installing Oracle SOA Suite a top of the lightweight XE database is often convenient for development, demo or training purpose.  It avoids going through the complete installation of her big brother : the complete Oracle Database 11g system.

XE is less than 220 Mb download and Installing it on  a Linux system is as simple as

rpm -ivh oracle-xe.rpm

However, there is some caveats, i.e. some system parameters to tweak before installing SOA Suite’s database schemas using Repository Creation Utility (RCU).

In the same spirit as my previous blog entry : here are the magical incantations for the database gods, to be executed before RCU.

First connect to the database :

sqlplus sys/yourpassword@XE as sysdba

(be sure to have /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin in your PATH)

SQL> show parameter processes //processes should be 40 – must be 200
SQL> alter system set processes = 200 scope=spfile;
SQL> show parameter session;
SQL> alter system reset sessions scope=spfile sid='*';
SQL> shutdown immediate;
SQL> exit;

then restart XE with :

sudo /etc/init.d/oracle-xe start

Finally, as stated on SOA Suite download page :

“If you want to use XE you can set the RCU_JDBC_TRIM_BLOCKS environment variable to TRUE *prior* to running RCU. As a reminder as to support level, when running RCU against XE you will receive a warning stating that the database version is not supported by Oracle.”

You must issue

export RCU_JDBC_TRIM_BLOCKS=true

before starting RCU. Failing to do so will cause WebLogic to issue a bunch of database related exceptions at startup time.

That’s it !  You can now proceed with RCU to install SOA Suite’s database schemas.

Enjoy !

, , ,

  1. #1 by Chris Selwyn on 20/01/2011 - 18:18

    Lightweight?? 220Mb???

    My how things have changed!

    Chris

  2. #2 by sst on 20/01/2011 - 22:52

    everything is relative …. 11G is > 2gb 🙂

  3. #3 by Carol Thom on 08/02/2011 - 01:34

    Thanks so much for posting this. I’ve been trying to run RCU against my XE database, and was getting nowhere until I stumbled across this.

  4. #4 by Tim on 15/07/2011 - 02:06

    What is the command

    If you want to use Oracle XE as your database on a windows box, to set the RCU_JDBC_TRIM_BLOCKS environment variable to TRUE *prior* to running RCU?

  5. #5 by sst on 15/07/2011 - 08:34

    it depends on your OS
    on most linux distro : export RCU_JDBC_TRIM_BLOCKS=TRUE
    on Windows : set RCU_JDBC_TRIM_BLOCKS=TRUE (I think – double check the set syntax for Windows on Google)

(will not be published)