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 10g Release 2

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 host name, port number, and service name for the Oracle Self-Service E-Billing OLAP database, and click Next.
4. Select Manage a Warehouse Builder repository owner, and click Next.
5. Select Create a new Warehouse Builder repository owner, and click Next.
6. Enter repository owner user name rep_admin and a password, and click Next.
7. Re-enter the password, and click OK.
8. Enter the following tablespace information:
   • 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
9. Select the language required for the repository. The default is American English. Click Next.
10. Click Next to skip selecting a user.
11. The Repository Assistant Summary displays all the information related to repository. Click Finish.
12. On the Repository Users screen, click OLAP on the Available pane, then click the right arrow key to move it to the Selected pane. Click Next.
13. On the Request Password Information screen enter the password for OLAP. Click OK. The Summary Page appears. Verify the information on this screen.
14. Click Finish. A progress bar shows the installation status.
15. When complete, an Installation Successful message appears. Click OK.

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 host name, port number, and service name for the Oracle E-Billing OLAP database, and 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. (Windows Only) If you are creating the first workspace for the repository, 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, typically OWBSYS, 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. If necessary, select the language required for the repository. The default is American English. Click Next.
14. Click Next to skip selecting a user.
15. The Repository Assistant Summary displays all the information related to repository. Click Finish.
16. The progress bar shows the installation status. When it finishes, click OK on the Installation Successful dialog.
17. Click Finish.