Installation Guide for Oracle Self-Service E-Billing > Installing the ETL Module for Oracle Self-Service E-Billing > Process of Installing the Oracle Warehouse Builder Repository >

Creating the Oracle Warehouse Builder Repository Owner

You must create an Oracle Warehouse Builder repository owner, using the Oracle Warehouse Builder Repository Assistant. For additional information about the Repository Assistant, see the Oracle Warehouse Builder documentation on Oracle Technology Network.

Follow the appropriate procedure for your version of the Oracle Warehouse Builder.

This task is a step in Process of Installing the Oracle Warehouse Builder Repository.

To create the Oracle Warehouse Builder repository owner, using Oracle Warehouse Builder 11g

1. Start the Oracle Warehouse Builder Repository Assistant.
   • UNIX. Log in as the Oracle user, change the directory to OWB_HOME/bin/unix, and run the ./reposinst.sh script.

     NOTE:  The Oracle Solaris and Linux Repository Assistant requires a correctly configured X Window environment in order to run.

   • Windows. Log in as an administrator. On the Start Menu, click the link to the Repository Assistant (Administration).
2. On the Welcome screen, click Next.
3. Enter the following information.
   • Single Node Environment. Enter the host name, port number, and Oracle service name for the Oracle Self-Service E-Billing database. Click Next.
   • RAC Environment. Enter the host name and port number. Enter the Oracle Service Name, or a unique Oracle service name, such as ebill1. Select the SQL*NET Connection option. Enter the Net Service Name as the net service name of the cluster database, such as ebill. Click Next.
4. Select Manage Warehouse Builder workspaces, and click Next.
5. Select Create a new Warehouse Builder workspace, and click Next.
6. Select Create a workspace with a new user as workspace owner, and click Next.
7. Enter the SYSTEM password as manager, and click Next.
8. If you are creating the first workspace for the repository, then click Next to accept the default values on the Enable Optional Features page.
9. Enter the Workspace owner's user name rep_admin, the Workspaces Owner password, the Workspace Owner Password Confirmation, and Workspace Name rep_admin. Click Next.
10. Enter the OWBSYS password, and click next.
11. Enter the following tablespace information, and click Next:
    • Tablespace for Data: EDX_REPORT_CDR_DATA
    • Tablespace for Indexes: EDX_REPORT_CDR_IDX
    • Tablespace for Temporary Data: TEMP (Default)
    • Tablespace for Snapshots: EDX_REPORT_CDR_DATA
12. Click Next.
13. Select the language required for the repository, if necessary. The default is American English. Click Next.
14. Click Next to skip selecting a user.

    The Repository Assistant Summary displays all the information related to repository.

15. Click Finish.

    The progress bar shows the installation status.

16. When the progress bar is complete, click OK on the Installation Successful dialog box.
17. Click Finish.