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 >

Registering Users in Oracle Warehouse Builder 11g

You must register the OLAP, OLTP, and OWF_MGR users when creating the repository, using Oracle Warehouse Builder 11g.

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

To register users in Oracle Warehouse Builder 11g

1. Start the Oracle Warehouse Builder Design Center.
   • UNIX. Log in as the Oracle user, change the directory to ORACLE_HOME/owb/bin/unix, and run the ./owbclient.sh script.
   • Windows. Log in as an administrator. On the Start Menu, click the link to the Design Center. If you want to connect to a UNIX-hosted Oracle Warehouse Builder repository, then you can use the Windows native client if Oracle Warehouse Builder is installed.
2. Log in to the Design Center.
   • Single Node Environment.Log in to the Design Center as the repository owner. Select the host name, port number, and SID for the Oracle Self-Service E-Billing database.
   • RAC Environment. Use SQL*Net Connection to log in to the Design Center, using the RAC Net Service Name, such as ebill, as the Net Service Name.
3. Select the EBILLING_ETL project. Expand the security tree in the Global Explorer (Global Navigator On Oracle Database 11g Release 2). Right-click the User element, and click New to start the Oracle Warehouse Builder User Wizard.
4. In the list of Available DB Users, double click OWF_MGR, and OLAP and OLTP schema names to add them to the list of selected users. Click OK.
5. (Oracle Database 11g Release 2 only) For both OWF_MGR, and OLAP and OLTP users, uncheck the To Create a Location option, and click Next.
6. Click Next to create a user (on Oracle Database 11g Release 2, click Finish).

   Selected users appear in the Global Explorer (Global Navigator On Oracle Database 11g Release 2) under the user list.

   NOTE:  Always reregister the OLAP or OLTP schema whenever the corresponding the schema refresh or reimage is done. If the OLAP or OLTP schema is not registered, then the following error message appears:

   ETL_SOURCE_SCANNER:GET_DIRECTORIES_MAPPING

   Error ORA-20000: You are not a registered user on workspace: REP_ADMIN, and you cannot access the public views of the workspace.

   ORA-06512: at "OWBSYS.START_ENABLE_OWB_ROLES", line 23

   ORA-06512: at line 1