1. Application Installation Guide
  2. Create Domains, Repositories, Data Sources
  3. Creating Schemas using Repository Creation Utility

2.1 Creating Schemas using Repository Creation Utility

The following section details the steps to create schemas using repository creation utility.
  1. Open command prompt on Unix and browse to <WL_HOME>/oracle_common/bin and run ./rcu.
    The following window is displayed.

    Figure 2-1 Repository Creation Utility 1


    Description of Figure 2-1 follows
    Description of "Figure 2-1 Repository Creation Utility 1"

  2. Click Next.
    The following window is displayed.

    Figure 2-2 Repository Creation Utility 2


    Description of Figure 2-2 follows
    Description of "Figure 2-2 Repository Creation Utility 2"

  3. Select Create Repository and select System Load and Product Load. Click Next.
    The following screen is displayed.

    Figure 2-3 Repository Creation Utility 3


    Description of Figure 2-3 follows
    Description of "Figure 2-3 Repository Creation Utility 3"

  4. Provide database details where you want to create schemas, as shown in the above screen.

    Note:

    You will require a user with SYSDBA role to create schemas.
  5. Click Next.
    The following window is displayed.

    Figure 2-4 Repository Creation Utility 4


    Description of Figure 2-4 follows
    Description of "Figure 2-4 Repository Creation Utility 4"

  6. Click OK in the confirmation dialog.
  7. Click Next the following window is displayed.

    Figure 2-5 Repository Creation Utility 5


    Description of Figure 2-5 follows
    Description of "Figure 2-5 Repository Creation Utility 5"

  8. Select Create new Prefix option and specify the value.
    For example, OLL.
  9. Select the options Metadata Services and Oracle Platform Security Services as shown in the above screen. Click Next.
    The following window is displayed.

    Figure 2-6 Repository Creation Utility 6


    Description of Figure 2-6 follows
    Description of "Figure 2-6 Repository Creation Utility 6"

  10. Click Next.
    The following window is displayed.

    Figure 2-7 Repository Creation Utility 7


    Description of Figure 2-7 follows
    Description of "Figure 2-7 Repository Creation Utility 7"

  11. You can select one of the following:
    • Select Use same password for all schemas and specify the password.
    • Select Specify different passwords for all schemas and specify Schema Passwords for each schema.
  12. Click Next.
    The following window is displayed.

    Figure 2-8 Repository Creation Utility 8


    Description of Figure 2-8 follows
    Description of "Figure 2-8 Repository Creation Utility 8"

  13. Click Next.
    The following window is displayed.

    Figure 2-9 Repository Creation Utility 9


    Description of Figure 2-9 follows
    Description of "Figure 2-9 Repository Creation Utility 9"

  14. Click OK in the confirmation dialog.
    The following window is displayed.

    Figure 2-10 Repository Creation Utility 10


    Description of Figure 2-10 follows
    Description of "Figure 2-10 Repository Creation Utility 10"

  15. Click OK in the confirmation dialog.
    The following window is displayed.

    Figure 2-11 Repository Creation Utility 11


    Description of Figure 2-11 follows
    Description of "Figure 2-11 Repository Creation Utility 11"

  16. Click Create.
    The following windows are displayed.

    Figure 2-12 Repository Creation Utility 12


    Description of Figure 2-12 follows
    Description of "Figure 2-12 Repository Creation Utility 12"

    Figure 2-13 Repository Creation Utility 13


    Description of Figure 2-13 follows
    Description of "Figure 2-13 Repository Creation Utility 13"

  17. Click Close to close the window.

Parent topic: Create Domains, Repositories, Data Sources