Configure OWB 11gR1 on 10gR2 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 a 10gR2 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!
A 10gR2 database is accessible - the article assumes access to a database [TEST] on the same server [MILAN]
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 downloaded the standalone installation fileset for 11gR1 OWB. e.g. from [Oracle Technet].

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

First install the standalone 11gR1 OWB software. Double click on setup.exe to start the Oracle Installer. The Welcome page appears. Click "Next" to continue.

Specify the Oracle Home Name and directory and click "Next" to continue.

A summary appears. Click "Install" to continue.

The installation proceeds - it may take some time, depending on your resources. When the files are all installed, the following screen appears. Click "Exit".

Now, before you can configure an OWB repository with the Repository Assistant, you need to create the OWBSYS account, which does not exist on a 10gR2 database by default. To do this start a command prompt and navigate to the %OWBHOME%\owb\UnifiedRepos directory. Log in to SQL*Plus using SYS as SYSDBA and run the "cat_owb.sql" script. Enter the tablespace for OWBSYS - I've used USERS in this instance.

When the script finishes installing the OWBSYS user, it gives a warning that we should run "reset_owbcc_home.sql" in certain circumstances - circumstances which fall under, i.e. installation against 10gR2 RDBMS.

So, run the "reset_owbcc_home.sql" script and supply the full path of the OWBHOME.

The rest of the process to configure a repository, is the same as installing against an 11gR1 RDBMS - instructions for which are here.

Search

Navigation