A Integration Repository Creation Assistant

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

• About the Integration Repository Creation Assistant

• System Requirements

• Running the Integration Repository Creation Assistant

About the Integration Repository Creation Assistant

Integration Repository Creation Assistant is a command-line utility used to create and load the Oracle Enterprise Service Bus oraesb schema into an Oracle Database. It is necessary to run Integration Repository Creation Assistant if you plan to install Oracle Enterprise Service Bus on an Oracle Application Server 10g (10.1.3.1.0) middle tier..

System Requirements

Requirements for using the Integration Repository Creation Assistant include:

• An Oracle Database

  See Also:

  "Supported Databases" 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 Enterprise Service Bus in a multi-lingual 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.

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.

Take these steps to run the Integration Repository Creation Assistant 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 assysdba"
   
   

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 Enterprise Service Bus users in the target database, ensure that these users are logged out. Integration Repository Creation Assistant will prompt you before overwriting existing data.

5. Unzip the irca.zip distribution into an appropriate directory.

6. Execute the irca.sh command to load the schema into the target database. Integration Repository Creation Assistant provides two execution modes: silent and interactive.

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

   irca[.sh] oraesb "db_host db_port db_service_name" sys_password [-overwrite] ORAESB oraesb_password
   
   

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

   irca[.sh] oraesb
   
   

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