7 Creating the Database Schemas

Before you configure the Oracle SOA Suite domain, use the Repository Creation Utility (RCU) to install the required schemas on a certified database.

• Starting the Repository Creation Utility (RCU)
  After you have installed Oracle SOA Suite, start the Repository Creation Utility (RCU) from the ORACLE_HOME/oracle_common/bin directory to create the SOA Suite schemas for the domain.
• Navigating the RCU Screens to Create the Schemas
  Use the RCU screens to create the database schemas.

Starting the Repository Creation Utility (RCU)

After you have installed Oracle SOA Suite, start the Repository Creation Utility (RCU) from the ORACLE_HOME/oracle_common/bin directory to create the SOA Suite schemas for the domain.

To start RCU on Linux operating systems:

cd ORACLE_HOME/oracle_common/bin
./rcu

Navigating the RCU Screens to Create the Schemas

Use the RCU screens to create the database schemas.

• Introducing RCU
  The Welcome screen is the first screen that appears when you start the RCU.
• Selecting a Method of Schema Creation
  Use the Create Repository screen to select a method to create and load component schemas into the database.
• Providing Database Connection Details
  On the Database Connection Details screen, provide the database connection details for the RCU to connect to your database.
• Specifying a Custom Prefix and Selecting Schemas
  On the Select Components screen, specify a prefix to use for the SOA Infrastructure schema and dependent schemas.
• Specifying Schema Passwords
  On the Schema Passwords screen, specify how you want to set the schema passwords on your database, then enter and confirm your passwords.
• Specifying Custom Variables
  On the Custom Variables screen, specify the custom variables for the SOA Infrastructure schema.
• Verifying Tablespace Information
  The Map Tablespaces screen shows the default and temporary tablespaces for the schemas you are about to create.
• Completing Schema Creation
  On the Summary screen, verify your information, then click Create to begin schema creation.

Introducing RCU

The Welcome screen is the first screen that appears when you start the RCU.

Click Next.

Selecting a Method of Schema Creation

Use the Create Repository screen to select a method to create and load component schemas into the database.

On the Create Repository screen:

• If you have the necessary permission and privileges to perform DBA activities on your database, select System Load and Product Load. This procedure assumes that you have SYSDBA privileges.

• If you do not have the necessary permission or privileges to perform DBA activities in the database, you must select Prepare Scripts for System Load on this screen. This option generates a SQL script that you can give to your database administrator. See Understanding System Load and Product Load in Creating Schemas with the Repository Creation Utility.

• If the DBA has already run the SQL script for System Load, select Perform Product Load.

Providing Database Connection Details

On the Database Connection Details screen, provide the database connection details for the RCU to connect to your database.

For example:

• Database Type: Oracle Database
• Name: examplehost.exampledomain.com
• Port: 1521
• Service Name: Orcl.exampledomain.com
• User Name: sys
• Password: ******
• Role: SYSDBA

Click Next to proceed, then click OK in the dialog window to confirm that connection to the database was successful.

Specifying a Custom Prefix and Selecting Schemas

On the Select Components screen, specify a prefix to use for the SOA Infrastructure schema and dependent schemas.

1. Select Create new prefix, and then enter FMWEX for your prefix. This is the same prefix you used when you created and added the schema credentials to the wallet (see Creating a Wallet).

   Note that FMWEX is the schema prefix used for this tutorial. If you used a different prefix, make sure to replace FMWEX with the value of your actual prefix.

   Note:

   Make a note of the prefix you enter here; you will need this later on during the domain creation process.

   The custom prefix logically groups these schemas together for use in this domain only. For more information about custom prefixes, see About Custom Prefixes in Creating Schemas with the Repository Creation Utility.

2. Select the SOA Suite schema. This will automatically select SOA Infrastructure, along with the following schemas as dependencies:

   • User Messaging Service

   • Metadata Services

   • WebLogic Services

   • Oracle Platform Security Services

   • Audit Services

   • Audit Services Append

   • Audit Services Viewer

   A schema called Common Infrastructure Services is also automatically created; this schema is grayed out (you can’t select it or deselect it).See About the Service Table Schema in Creating Schemas with the Repository Creation Utility.

   For more information about how to organize your schemas in a multi-domain environment, see Planning Your Schema Creation in Creating Schemas with the Repository Creation Utility.

3. Click Next to proceed, then click OK to confirm that prerequisite checking for schema creation was successful.

Specifying Schema Passwords

On the Schema Passwords screen, specify how you want to set the schema passwords on your database, then enter and confirm your passwords.

On this screen, enter the same schema passwords that you created and added to the wallet (see Creating a Wallet).

Tip:

You must make a note of the passwords you set on this screen; you will need them later on during the domain creation process.

Specifying Custom Variables

On the Custom Variables screen, specify the custom variables for the SOA Infrastructure schema.

For the Oracle SOA Suite sample topology, accept both default values for Database Profile (Small) and Healthcare Integration (No).

For more information, see About the Custom Variables Required for the SOA Suite Schemas in Installing and Configuring Oracle SOA Suite and Business Process Management.

Tip:

For more information about the options on this screen, see Custom Variables in Creating Schemas with the Repository Creation Utility.

Verifying Tablespace Information

The Map Tablespaces screen shows the default and temporary tablespaces for the schemas you are about to create.

For this tutorial, review the information on this screen. If you don’t want to make any changes on this screen, click Next to accept the default values.

Click OK on the Confirmation dialog box to begin tablespace creation. When the tablespaces are created, click OK to dismiss the progress window and continue to the Summary screen.

Completing Schema Creation

On the Summary screen, verify your information, then click Create to begin schema creation.

When you reach the Completion Summary screen, click Close to dismiss RCU.