Olaf Heimburger's Blog

I'm about to finalize the work on a Development Environment based on the latest Developer Previews of the SOA Suite and JDeveloper (10.1.3.1) and Oracle XE on RedHat AS 4.3.

Gotcha 1: ORAWSM tables missing.

The installation went very smooth... until the SOA Suite installer was about to execute the "Oracle Web Services Manager Configuration Assistant". This one completely failed. The reason was that the tables and sequences for the ORAWSM user weren't installed before the assistant was started. After creating a simple script by hand and running it within SQLDeveloper I could retry the failing assistant. Now it could finish this step and also the remaining ones.

Update: Tried the install again on a different host. This time I checked the distribution and found the $DISK1/install/soa_schemas directory. This contains the Integration Repository Configuration Assistent (irca) which installs the complete repository.

Once I've finished the installation, I installed a custom made sample
application with some EJBs, a Web GUI and a BPEL process. Easy, but I
couldn't test it properly.

Gotcha 2: BPEL No default domain installed

First problem was the missing domain in the BPEL dehydration store. This
was solved by checking the URLs in the BPEL console configuration (use localhost on DHCP machines) and also by reinstalling the store by executing the domain_oracle.ddl and server_oracle.ddl from $SOA_HOME/bpel/system/database/scripts.

Gotcha 3: No proper TNS connections

By default Oracle XE comes with a "small" database configuration (/usr/lib/oracle/xe/app/product/10.2.0/server/dbs/init.ora). The reason for this particular problem is the number of processes supported by XE. By changing not only the processes value but all other settings to the proposed "medium" values I could get around this issue.

Caveat

These are just the some Gotchas I came across while implementing the development environment. These might not happen during your installation nor while using it. But if it does you have some hints.