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 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
- 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, you can use the Windows native client if Oracle Warehouse Builder is installed.
- Log in to the Design Center as the repository owner. 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.
- In the list of Available DB Users, double click OWF_MGR, and OLAP schema names to add them to the list of selected users. Click OK.
- (Oracle Database 11g Release 2 only) For both OWF_MGR, and OLAP users, uncheck the To Create a Location option, and click Next.
- 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 re-register the OLAP schema whenever the OLAP schema refresh or reimage is done. If the OLAP schema is not registered 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
|