Running irca script for creating dehydration store

If you are going for a advacned installation of SOA Suite you have to point to a database.I would suggest to use database 10.2.0.3+ for the same.

The different components BPEL,ESB,OWSM use the database as a dehydration store.

What do you mean by dehydration store.When ever we create a process it has some associate data like when it is invoked ,when it is deliverd ,staus and lot of things.These values get stored in the dehydration database.

We use the irca.bat in order to create the schema for BPEL ,ESB and ORAWSM.

The same can be found in following location.

Go to following location where you have downloaded the SOA Suite

SOA_install\install\soa_schemas\irca

Ensure that your database and listener is up and running.

Now open a command console

set your ORACLE_HOME and set your PATH

and move up to irca




It basically installs three schema ORABPEL,ORAESB and ORAWSM in database so it will ask for the credentials of database.

Provide the local host name ,port and the SID




Once it will connect to database it will ask for the password for different schemas

It is recommended to use orabpel ,oraesb and orawsm for the ORABPEL,ORAESB and ORAWSM schema respectively.




Once all the password is provide it will show how many valid objets are created or each schema and finally will display message irca completed.



So you have complete the creation of different schemas.

If you are going for a basic installation of SOA Suite then you need not install a database as the basic installation itself create an olite database with the schemas.We will discuss it separately later.

Now the next thing is to check whether you are able to log in to the database using ORABPEL ,ORAESB and ORAWSM as user .

Log in to database using orabpel as user and orabpel as password.



Similarly check for the other schemas whether you are able to log in or not.