Configure OWB 11gR1 on 11gR1 RDBMS on Windows 2008 Server Standard Edition - Basic Install

From Oramosswiki

Overview

This article shows the steps involved in configuring an 11gR1 OWB Repository for use on an 11gR1 database running on a Windows 2008 Server Standard Edition Virtual machine.

Assumptions

You have a working OS, with basic installation options, i.e. nothing fancy!
An 11gR1 database is accessible - the article assumes access to a database [TEST] on the same server [DENVER]
The TEST database is up and running and accessible via standard SQL connections
You have the login details of a DBA, e.g. SYSTEM
You have the password for the OWBSYS user

Optional Steps

I created a tablespace for the OWB Data - this isn't strictly necessary as you can just use USERS, but I like to keep things reasonably organised. To create the tablespace I issued the following:

create tablespace OWBDATA 
datafile 'C:\APP\ORACLE\ORADATA\TEST\OWBDATA01.DBF' 
size 1G
autoextend on
extent management local autoallocate
/

The images throughout the document assume the use of OWBDATA tablespace for the installation - feel free to use whatever tablespace you see fit.

Installation

Start the Repository Assistant from the Start Menu \ Oracle Home \ Warehouse Build \ Adminstration:

A welcome screen appears - you can choose to have this not display in future if you wish by ticking the checkbox.

Click next and move on to the first step of the wizard where you enter the connection details for the target database [TEST]. I specify a Host, Port & Service but you can use a SQL*Net connection if you prefer. Click "Next" to continue.

Choose "Manage Warehouse Builder workspaces" and click next to contnue.

Choose "Create a new Warehouse Builder workspace" and click "Next" to continue.

Choose "Create a workspace with a new user as workspace owner" and click "Next" to continue.

Enter the password of the SYSTEM user, or the username and password of any other DBA and click "Next" to continue.

Specify the details for a Workspace owner Username, password and the name of the Workspace and click next to continue.

Enter the password for the OWBSYS user and click "Next" to continue.

Set the tablespaces to be OWBDATA for everything bar the Temporary Tablespace which should be set to TEMP. Click "Next" to continue.

Set the Base Language as appropriate. The default language of ENGLISH is fine for me. Click "Next" to continue.

This screen allows you to choose the users who will be registered as Workspace users. We'll assume that you need to create a new one called JEFF. Click "Create New User".

Enter the details to create user JEFF. The DBA details you input earlier appear as the DBA credentials. Click "OK".

Click "Next" to continue.

A summary of the installation details appears. Click "Finish" to continue and start the installation process.

The installation proceeds...it may take some time.

When the installation completes click "OK" and the assistant ends.

Choose "Design Centre" from the Start Menu. Enter the login details for the Workspace user - JEFF is the one we created. Click "OK" to continue.

That's it, we're now logged into the Design Centre.

Search

Navigation