Using Database XE with SOA Suite

Making DB XE work with SOA Suite


Many people have happily installed SOA Suite on top of an Oracle XE Database.  However when they come to use it they run into problems with number of sessions being exceeded.  For those of you a bit unclear on how to reconfigure XE to allow more sessions I offer the following advice.



  • Log on to the database as system administrator (In SQL Plus "connect / as sysdba" will do the job)
  • Set the number of processes to be 150 (In SQL Plus "alter system set processes=150 scope=spfile")
  • Unset the number of sessions to remove the 20 session limit (In SQL Plus "alter system reset sessions scope=spfile sid='*'")
  • Shutdown the database (In SQL Plus "shutdown immediate")
  • Startup the database (In SQL Plus "startup")
  • Check the changes have taken effect (in SQL Plus "show parameter sessions" and "show parameter processes") sessions has now been reset to a calculated value.

You should now have enough sessions available for the SOA Suite to use.

Comments:

Thanks. This helped me a lot. It took a lot of time and digging to find out what my problem was, but this fixed it quickly. There are so many logs in SOA Suite, and so many places to go to on the web to fix and reconfigure the SOA Suite, that it can be tough to manage.

Posted by Chris Coyle on September 07, 2007 at 02:11 AM MDT #

Thanks for the help.

Posted by Chris Coyle on September 07, 2007 at 02:11 AM MDT #

Thanks a lot, this note has solved a problem.

Posted by Ivan Noboa on September 21, 2007 at 10:14 AM MDT #

Glad you found it useful.

Posted by Antony Reynolds on September 21, 2007 at 11:20 PM MDT #

Post a Comment:
Comments are closed for this entry.
About

Musings on Fusion Middleware and SOA Picture of Antony Antony works with customers across the US and Canada in implementing SOA and other Fusion Middleware solutions. Antony is the co-author of the SOA Suite 11g Developers Cookbook, the SOA Suite 11g Developers Guide and the SOA Suite Developers Guide.

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