5 Patching Oracle Warehouse Builder

This section includes the following topics:

• Apply OWB Patches

• Create Tablespaces

• Create the OWBSYS Schema

• Point to the 11gR2 Oracle Home

• Create New OWB Workspace for CDR_RTREPOS

• Set Up Your Environment

• (Optional) Install Oracle Warehouse Builder 10.2.0.1

Oracle Life Sciences Data Hub (Oracle LSH)'s internal processing is based on Oracle Warehouse Builder (OWB). The 11gR2 database installation by default includes an installation of OWB 11gR2.

After you install both OWB and Oracle LSH you must integrate them. See Integrate Oracle LSH with the Oracle Warehouse Builder.

Note:

If you are using Oracle Discoverer, you also need an installation of OWB 10.2.0.4; see (Optional) Install Oracle Warehouse Builder 10.2.0.1.

Apply OWB Patches

Apply OWB patches to the OWB installation that was done automatically when you installed the 11gR2 database.

1. Download the following patches from My Oracle Support (see "Finding Patches on My Oracle Support").

   • 9472946

   • 9584600

     Note:

     Set the ORACLE_HOME environment variable to point to the actual Oracle Home, not the OWB Home as currently directed in the patch readme files. In Oracle 11g, the OWB Home and the Oracle Home are the same.

2. Apply the patches using instructions in the readme files.

Create Tablespaces

To maximize performance, Oracle recommends that you create three new 500MB tablespaces in which to install Oracle Warehouse Builder.

To create tablespaces for OWB data files, OWB index files, and OWB snapshot files, do the following:

1. Log in to the server as the owner of the RDBMS ORACLE_HOME.

2. Set the env variables by running the env file, <sid>_<server name>.env, in the RDBMS ORACLE_HOME directory.

3. Enter:

   Sqlplus "/ as sysdba"
   
   CREATE TABLESPACE OWB_DATA datafile '<datafile location>/owb_data01.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
   
   CREATE TABLESPACE OWB_IDX datafile '<datafile location>/owb_idx01.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
   
   CREATE TABLESPACE OWB_SNAP datafile '<datafile location>/owb_snap01.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
   

Create the OWBSYS Schema

Create the OWBSYS schema in the database.

Note:

Running this script also creates the user OWBSYS_AUDIT. Oracle LSH does not use this account and you do not need to unlock it.

1. Log on to the computer where Oracle LSH is installed.

2. Change directories to <OWB_HOME>/owb/UnifiedRepos.

3. Log in to SQL*Plus as a database user with SYSDBA privileges.

4. Run the following script to create the OWBSYS schema:

   @cat_owb.sql
   

   This script creates and locks the user OWBSYS.

5. Enter the following command to unlock the OWBSYS user:

   alter user owbsys account unlock
   

Note:

Oracle recommends changing the default password for this account. You will need the password later.

Point to the 11gR2 Oracle Home

1. Log in to SQL*Plus as the OWBSYS user.

2. Reset the OWB Home to the new 11gR2 OWB Home:

   @reset_owbcc_home;
   

   At the prompt, enter the full path of the 11gR2 Oracle Home. If you are installing in a Windows environment, be sure to match the case of the path exactly, including the drive letter.

Create New OWB Workspace for CDR_RTREPOS

To create a new OWB Workspace for the existing user (CDR_RTREPOS):

1. Change directory to <OWB_HOME>/owb/bin/unix.

2. Run the script reposinst.sh to launch the Repository Assistant.

3. Follow instructions on screen. Enter the database connection information and click Next.

4. In the Choose Operation screen, select Manage Warehouse Builder workspaces and click Next.

5. In the Choose Workspace Operations screen, select Create a new Warehouse Builder Workspace and click Next.

6. In the New or Existing User screen, select Create a workspace with a new user as workspace owner and click Next.

7. In the DBA Information screen, in the User Name field enter system. In the Password field enter the password you created for the system account and click Next.

8. In the Workspace Owner (New) screen:

   • Enter CDR_RTREPOS in the Workspace Owner's User Name field.

   • Enter a password for the CDR_RTREPOS account and confirm the password.

   • Enter CDR_RTREPOS in the Workspace Name field and click Next.

9. In the OWBSYS Information screen, enter the password you created for the OWBSYS account and click Next.

10. In the Select Tablespaces screen, accept the default OWBSYS tablespaces by clicking Next.

11. In the Select Languages screen, accept the default setting American English by clicking Next.

12. Skip the optional Workspace Users by clicking Next.

13. In the Summary screen, click Finish.

Set Up Your Environment

After you install Oracle LSH itself you must set up your environment so that it is possible to integrate Oracle LSH with OWB. This process is covered in Set Up Your Environment.

(Optional) Install Oracle Warehouse Builder 10.2.0.1

If you are using Oracle Discoverer to create data visualizations, you must install the standalone version of Oracle Warehouse Builder 10.2.0.1. This software is included on the Oracle LSH media pack.

Note:

Only the software is required; do not install the 10.2.0.1 repository.

This older version of OWB is required because the newer version is now delivered as part of the database and no longer includes the middle tier components used by Oracle Discoverer.