A Integration Repository Creation Assistant

This appendix describes how to use the Integration Repository Creation Assistant. It contains these sections:

• About the Integration Repository Creation Assistant

• System Requirements

• Running the Integration Repository Creation Assistant

A.1 About the Integration Repository Creation Assistant

Integration Repository Creation Assistant (IRCA) is a command-line utility used to create and load the Oracle BPEL Process Manager orabpel schema into an Oracle Database. It is necessary to run IRCA if you plan to install Oracle BPEL Process Manager on an Oracle Application Server 10.1.3.1.0 middle tier.

A.2 System Requirements

Requirements for using the Integration Repository Creation Assistant include:

• An Oracle Database

  See Also:

  Table 1-3 for the list of supported database versions

• JDK 1.4 or 1.5

• 120 MB disk space for tablespaces

If you will be running Oracle BPEL Process Manager in a multilingual environment, it is recommended that you use the Unicode (AL32UTF8) database character set encoding. Using a character set encoding other than Unicode may result in possible loss or misinterpretation of data.

A.3 Running the Integration Repository Creation Assistant

You must run the Integration Repository Creation Assistant on the machine where your Oracle Database is installed, or from a remote Oracle client with sqlplus installed.

Follow these steps to run the IRCA utility:

1. Set ORACLE_HOME in your environment so that you can use sqlplus to connect to the local or remote Oracle Database.

2. Make sure you can connect to your Oracle Database as the sys database user with a command structured as follows:

   $ORACLE_HOME/bin/sqlplus "sys/sysPassword@serviceName as sysdba"

3. If your ORACLE_HOME does not contain a JDK with a valid version as listed in "System Requirements" , set JAVA_HOME to the correct JDK version.

4. If there are Oracle BPEL Process Manager users in the target database, ensure that these users are logged out. IRCA will prompt you before overwriting existing data.

5. Obtain the irca.sh/irca.bat file located in the soa_schemas\irca folder of the distribution. A README.txt file in this folder provides additional useful information and examples of running the utility.

6. Execute the irca.sh (UNIX/Linux)/irca.bat(Windows) command to load the schema into the target database. IRCA provides two execution modes: silent and interactive.

   In the silent mode, you provide all the execution parameters in a single string, using the syntax:

   irca[.sh] orabpel "db_host db_port db_service_name" sys_password [-overwrite] ORABPEL orabpel_password

   In the interactive mode, you invoke the command by specifying only the schema to be loaded:

   irca[.sh] orabpel

   The utility prompts you for the database details and the passwords.