In this lesson, you will learn how to create a user for logging
into the design client, and use the setup files to configure the Oracle Warehouse
Builder 10g (OWB 10g) environment.
This lesson will take approximately 20 minutes to complete.
Viewing Screenshots
Move your mouse over this icon to show
all screenshots. You can also move your mouse over each individual icon to see
only the screenshot associated with it.
Overview
In this first lesson you will learn how to install OWB
and download and execute the setup files to configure the Warehouse Builder
environment. You will also use the OWB Repository Assistant to create a user
for logging into the Oracle Warehouse Builder Design Repository database where
your warehouse design metadata is stored.
In order for this lesson to work successfully, you will need
to have performed the following:
1.
Completed the Install Oracle10g Database
module (Enterprise Edition). It is suggested that you create a database
named obeowb for this course. Otherwise, you will need
to substitute the Oracle Service Name of your database wherever you see
obeowb mentioned in this course.
Install Warehouse Builder into a separate
Oracle home (ORACLE_HOME) directory from Oracle Database or any other
Oracle product.
In Warehouse Builder 10g Release 1 (10.1), there is
no longer a distinction between the Server Side and Design Time installations.
Warehouse Builder 10g Release 1 (10.1) has only one type of installation
on the database server, which you must install on a computer hosting an
instance of Oracle Database.
2.
If you have not already installed Oracle Workflow
Server as part of the Oracle database, do so now. By default, Oracle Workflow
is not selected as a component to be installed. Oracle Workflow Server
has to be installed in the same Oracle home as the database.
Oracle Workflow 2.6.3 for Oracle Database 10g is now available for download
on OTN. You also get Oracle Workflow 2.6.3 with Oracle Application Server
10g.
3.
Once the software has been installed, a wizard
pops up to create the workflow engine in the server. Do not cancel the
wizard, but ensure that the database is up and running. The Workflow Server
will be installed in a workflow server schema <OWF_MGR> (use the
default username of OWF_MGR).
Before logging in to the design client, you must create
a design client user with which to log in. In
this topic you learn how to create a new design client user and install the
Warehouse Builder Design Repository.
The OWB Repository Assistant wizard's Welcome screen appears. Click Next.
2.
In the OWB Repository Assistant Server
and SYSDBAInformation window, enter the User
Name as sys, Password as system or <name
of your sys password>, Host Name as localhost, Port
Number 1521, and Oracle Service Name as obeowb
or <your database service name>. Click Next.
3.
In the OWB Repository Assistant Create
or Drop window, select Create a New Warehouse Builder
Repository. Click Next.
4.
In the OWB Repository Assistant New
or Existing User window, select Create and install into
a new user schema. Click Next.
5.
In the OWB Repository Assistant User
Name and Password (New) window, enter the User Name as design_client,
Password as design_client, and Re-enter Password as design_client.
Click Next. A database configuration warning appears. Ignore the
warning and click OK.
6.
In the OWB Repository Assistant Tablespace
window, accept the defaults and click Next.
7.
In the OWB Repository Assistant Define
Languages window, accept American English in the "Choose
MLS Base Language" drop-down list and click Next.
8.
In the Summary window, click
Finish. Installation may take several minutes. An Installation
Successful window appears. Click OK. The OWB Repository Assistant
closes.
In order to partially prepopulate your design repository
for this course, there are a few steps you need to take.
1.
Download the owb_files.zip file by
right-clicking here
and selecting Save Target As... from the pop-up menu. Direct the
download to any directory on your computer's hard drive.
2.
Open the owb_files.zip file, select
all files and unzip them, if possible, to your computer's C:\
drive, so that your file locations will match the screenshots in the following
lessons.
Note: If you extract the files using Winzip, be sure to checkmark
the option "Use folder names".
If you unzip this way to the C:\ drive, the resulting file locations
will be:
C:\OWB-OBE\dmp\na_source.dmp
C:\OWB-OBE\DQ\customers_system3.txt
C:\OWB-OBE\DQ\customers_system4.txt
C:\OWB-OBE\mdl\OWB10g_DEMO.mdl
C:\OWB-OBE\scripts\set_email_properties.tcl
C:\OWB-OBE\sourcefiles\Channels.txt
C:\OWB-OBE\sourcefiles\customers.txt
C:\OWB-OBE\sourcefiles\customers_system1.txt
C:\OWB-OBE\sourcefiles\customers_system2.txt
C:\OWB-OBE\sourcefiles\EmployeeInitialLoad.txt
C:\OWB-OBE\sourcefiles\Promotions.txt
C:\OWB-OBE\sourcefiles\WeeklySales.txt
C:\OWB-OBE\sql\create_grants.sql
Make note of the C:\ or other directory location where you place
these files.
3.
You will now create a database user NA_SOURCE
and import the na_source.dmp file as this user.
Log in to SQL*Plus as the user SYSTEM, with host string including
obeowb or <your database service name>.
Create a user NA_SOURCE identified by password NA_SOURCE.
create user na_source identified
by na_source default tablespace users account unlock;
Grant the roles CONNECT and RESOURCE to this user.
grant connect, resource to
na_source;
4.
Open a Command Prompt window. Change directories
to where you unzipped the na_source.dmp file from owb_files.zip
in Step 2. (It was recommended that you unzip to C:\OWB-OBE\dmp.)
Run the database import utility to import the na_source.dmp file
to the na_source user. Accept all default settings, including 'Import
grants:yes'. Set 'Import entire export file' to 'yes'. When the import
finishes, you should see that two tables were imported.
Note: If your Oracle database home is not in your Windows path
statement as a system environment variable, you may need to invoke the
import utility from \<your Oracle database home>\bin\imp.exe.
5.
You will create a runtime environment in Lesson
7- Deploying Targets to deploy your data warehouse objects. The runtime
system will need access to objects in the default HR and OE schemas that
are installed as part of the Oracle sample database. If the HR and OE
schemas are remote from your Warehouse Builder client, you
will be using direct database links. If the HR and OE schemas are remote,
ignore the remaining steps.
However, it is more likely that HR and OE schemas are local
on the same computer hosting Warehouse Builder. If that is the case, you
need to grant access to the objects (tables and views) in both the HR
and OE schemas.
By default, the HR and OE schemas in the sample database are locked.
If you have not already unlocked them, log in to SQL*Plus as the user
SYSTEM.
Unlock the HR schema using the command alter
user HR account unlock and set the password to HR using the
command alter user HR identified
by HR.
In the same way, unlock the user OE using the command
alter user OE account unlock
and set the password to OE using the command alter
user OE identified by OE.
6.
Log in to SQL*Plus as the user HR and
run the create_grants.sql script that you unzipped in Step 2.
If you unzipped the contents of owb_files.zip to the directory
C:\OWB-OBE\sql, then use the command:
@c:\owb-obe\sql\create_grants;
7.
Log back in to SQL*Plus as the user OE
and run the same create_grants.sql script.
Keep this SQL*Plus session open for the next step.
8.
Logged in to SQL*Plus as the user OE,
run the following command:
grant select on categories_tab
to public;
Summary
In this module you should have learned how to:
Create the OWB Design Client User and Install
the Design Repository
Execute the Setup Files for the Warehouse
Builder Lessons
Move your mouse over this icon to hide all screenshots
Bookmark
