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 (4)
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 | September 7, 2007 8:11 AM
Posted on September 7, 2007 08:11
Thanks for the help.
Posted by Chris Coyle | September 7, 2007 8:11 AM
Posted on September 7, 2007 08:11
Thanks a lot, this note has solved a problem.
Posted by Ivan Noboa | September 21, 2007 4:14 PM
Posted on September 21, 2007 16:14
Glad you found it useful.
Posted by Antony Reynolds | September 22, 2007 5:20 AM
Posted on September 22, 2007 05:20