Using XE as Dehydration for SOA Suite

If you are using XE as your dehydration store for oracle soa suite, often you see a connection issue happening from BPELConsole or ESBConsole or OWSM that server "Cannot fetch a datasource connection". One of the possible reasons after making sure your connection information is correct is to increase the number of sessions/processes for XE.

The default number of sessions / process in XE is 20 each which is not sufficient for SOA Suite, you have to increase that to a minimum of 50.

Here are the instructions on how to do it !

Increase Database Sessions / Processes

Make sure you shutdown your soa suite.
Goto Start->Oracle Database 10g Express Edition ->Run SQL Command Line
At the SQL Prompt enter the following commands.
SQL> connect / as sysdba
SQL> show parameters processes
SQL> alter system set processes=100 scope=spfile;
SQL> alter system set sessions=100 scope=spfile;
SQL> shutdown immediate
SQL> startup
SQL> show parameters processes