2 Creating Database Schemas

This chapter details the steps required to install Repository Creation Utility (RCU) and use it to create database schemas to use with Oracle WebLogic Communication Services. Topics include:

2.1 Install RCU

RCU should already be installed on your computer. You use it to create schemas for OWLCS. You can reuse an existing database schema, or you can create a new one. If you are going to reuse an existing database schema, you can go on to the following chapter Chapter 3, "Installing Oracle WebLogic Communication Services Base Platform".

2.2 Create Database Schemas using RCU

Follow these steps to create new schemas:

Note:

RCU is available only on Linux and Windows platforms. Use Linux RCU to install for UNIX supported databases and Windows RCU for supported Windows databases

Note:

You can skip this step if database schema has already been created. You can reuse the schema you've already created; ensure that you use the same schema prefix when entering database information while configuring data sources in subsequent steps. If you are skipping this step, ensure that you have created all component schemas needed by OWLCS, namely: Presence, User Messaging, Subscriber Data Service, Location Service and OWSM MDS Schema.
  1. Navigate to the directory into which RCU is installed. For example:

    UNIX: $rcuHome/bin/rcu

    Windows: <rcuHome>\BIN

    where $rcuHome is the directory in which RCU is installed.

  2. Start the application:

    UNIX: ./rcu

    Windows: rcu.bat

    The Repository Creation Utility Welcome screen appears.

  3. Click Next. The Create Repository screen appears.

    Figure 2-1 Create Repository screen

    Create Repository screen.
    Description of "Figure 2-1 Create Repository screen"

  4. Select Create, then click Next. The Database Connection Details screen appears. For simplicity, many users use their sys name here. Enter database details in the fields provided (Database Type, Host Name, Port, Service Name, Username, Password, Role).

    Figure 2-2 Database Connection Details screen

    Database Connection screen.
    Description of "Figure 2-2 Database Connection Details screen"

  5. Click Next.The Installer checks prerequisites.

    Note:

    In general, users will be using database servers that are configured to use UTF-8 encoding. If you are not using a database server configured to use UTF-8 encoding, then a warning message appears informing you that your database is not using UTF-8 format by default. Click Ignore and continue with the installation.

    When the prerequisite checks are complete, click OK. Click Next. The Components screen appears. Select OWLCS (all necessary [5] schemas will be selected, including UMS).

    Figure 2-3 Components screen

    Components screen
    Description of "Figure 2-3 Components screen"

  6. Click the Create a new prefix option and choose a schema prefix (such as OWLCS).

  7. Check the checkbox in front of WebLogic Communication Services. OWLCS and accompanying components are automatically selected for you (Metadata Services, Presence, SIP Infrastructure Subscriber Data Services SIP Infrastructure Location Service, and User Messaging Service). Ensure that those five components are selected before proceeding. If any of those five components are not selected, select them manually. Then, click OK when completed.

  8. Click Next. The Schema Password screen appears.

    Figure 2-4 Schema Passwords screen

    Schema Passwords screen.
    Description of "Figure 2-4 Schema Passwords screen"

  9. Select Use same passwords for all schemas.

  10. Enter your password in the field provided and confirm it.

  11. Click Next. The Map Tablespaces screen appears. You click Manage Tablespaces when you want to modify existing tablespaces.

    Figure 2-5 Map Tablespaces screen

    RCU Tablespaces screen
    Description of "Figure 2-5 Map Tablespaces screen"

  12. For this installation, click Next. A Repository Creation notification will appear. Click OK. Tablespaces are created, and the progress will be displayed in a pop-up notification. When the operation is completed, click OK. The Summary screen appears.

    Figure 2-6 Summary screen

    Summary screen
    Description of "Figure 2-6 Summary screen"

  13. Click Create. The schema is created. A Completion Summary screen appears.

    Figure 2-7 Completion Summary screen

    Completion Summary screen.
    Description of "Figure 2-7 Completion Summary screen"

  14. Click Close.