Oracle SOA Suite: Reinstall repository (dehydration store)

During the installation of the SOA Suite, it depends on the installation, if it creates automatically the repository. The following schemas are created, by a default install.

• orabpel
• oraesb
• orawsm

With the advanced install it expects that these three schemas are already there. But it can also be that for some reason you want to re-install the schemas. To (re)install the schemas or just one of these schemas, Oracle provides a script on the installation disk to peform this. This can be found at:

$SOASUITE_INSTALL_DISK/install/soa_schemas/irca

The following files can be used; there is a Windows and Unix flavour:

• irca.bat
• irca.sh

Make sure the database en the listener is started. Stop SOA components on the Oracle Application Server, if they are still running.

Start the script, in the example I assume you are running on Linux (as I do :-) ). First the script will ask the location of the database, then it will ask if you want to overwrite the schema.

sh irca.sh

Integration Repository Creation Assistant (IRCA) 10.1.3.1.0
(c) Copyright 2006 Oracle Corporation. All rights reserved.

Enter database "host port serviceName" [localhost 1521 orcl]:
Enter sys password:
Running IRCA for all product(s):
connection="localhost 1521 orcl", , orabpelUser=ORABPEL, esbUser=ORAESB, orawsmUser=ORAWSM

Validating database ...
Validating database character set ...

Running prerequisite checks for ORABPEL ...
WARNING: This script will overwrite the existing ORABPEL schema.
Do you wish to continue? (y/n) y
Enter password for ORABPEL:
Loading ORABPEL schema (this may take a few minutes) ...

Running prerequisite checks for ORAESB ...
WARNING: This script will overwrite the existing ORAESB schema.
Do you wish to continue? (y/n) y
Enter password for ORAESB:
Loading ORAESB schema (this may take a few minutes) ...

Running prerequisite checks for ORAWSM ...
WARNING: This script will overwrite the existing ORAWSM schema.
Do you wish to continue? (y/n) y
Enter password for ORAWSM:
Enter password for ORAWSM: Loading ORAWSM schema (this may take a few minutes) ...

INFO: ORABPEL schema contains 225 valid objects.
INFO: ORAESB schema contains 180 valid objects.
INFO: ORAWSM schema contains 90 valid objects.

IRCA completed.
Please check for any ERROR message above and also check the log file
/tmp/irca2007-05-15_12-22-05PM.log for any error or other information.

If you are using Oracle Managed Files, you must make some changes in the files. This is written in the following article.

Sometimes you ESB repository does not behaves as expected. In the $ORACLE_HOME/integration/esb/bin directory a script called 'reset.bat|sh' is available. This script will cleanup the ESB repository. Look in the config file, esbsetenv.bat|sh for the connection to the database.