1. Installation Guide
  2. Installing and Patching Oracle Applications and Oracle Database
  3. Create an Oracle Warehouse Builder Repository

Create an Oracle Warehouse Builder Repository

Oracle Warehouse Builder 11.2.0.4 is required for Oracle LSH's execution system, which is also used by Oracle DMW. It is included in Oracle Database 11.2.0.4.

Follow instructions in Oracle Warehouse Builder Installation and Administration Guide 11g Release 2 (11.2) (Part E17130-03), which is included on the media pack, Chapter 4, Section 3, "Creating the First Workspace in the Repository on Linux."

Note:

During the creation of the Workspace Repository, the value of both the Owner's Username and Workspace name should be CDR_RTREPOS. This is required for a successful Oracle LSH 2.5 installation.

For a RAC installation, refer to instructions in "Installing Warehouse Builder in Oracle RAC Environments" in Chapter 2 of the Oracle Warehouse Builder Installation and Administration Guide 11g Release 2 (11.2) (Part E17130-03).

Verify that OWB is correctly installed following instructions in My Oracle Support article 455999.1, How to Verify if OWB is Installed Correctly on RAC and Exadata.

Parent topic: Installing and Patching Oracle Applications and Oracle Database