Using Oracle XE with SOA Suite 11g

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:

http://localhost:8080/apex

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.

Comments:

Would you mind commenting on the resources needed on the system to handle SOA Suite? How much disk space, RAM, CPU Speed, etc.. Also do you have experience with AIA and do the requirements increase if you add AIA to the picture?

Posted by Daniel Longmore on October 01, 2010 at 02:21 AM PDT #

I have downloaded the latest version of xe database Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production I get this warning with RCU: RCU-6002:The specified database does not meet the minimum requirement to load metadata repository. RCU-6080:Global prerequisite check failed - Check requirement for specified database The database you are connecting is not a supported version. Enter Database with version equal to or higher than 10.2.0.4.0 in 10g or version equal to or higher than 11.1.0.7.0 in 11g. Refer to the certification matrixfor supported DB versions

Posted by Yaadgiri on October 24, 2010 at 03:54 AM PDT #

Hi Yaadgiri, That is a known issue. Just continue and it wiill install fine. I use Oracle XE myself on my development machine. You do need the Universal edition though, to use the extended character set. SOA Suite 11g cannot be installed with XE standard edition. But the Universal edition is free also.

Posted by jeff.x.davies on October 25, 2010 at 12:59 AM PDT #

I am trying to install OID for WebLogic on Linux using Oracle Express but keep running into the error message:

JVM is not installed on the Database

How do I resolve this? I have not been able to find any reference on getting JVM installed to Oracle XE.

Is the Universal vs Standard Oracle XE issue that you commented on above?

Posted by guest on June 11, 2012 at 12:34 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

A site for SOA thought and discussion.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today