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
Wednesday, March 19, 2008
Using XE as Dehydration for SOA Suite
Labels:
Database,
JDeveloper,
XE
Subscribe to:
Posts (Atom)