Skip Headers

Oracle Business Intelligence
Installing the Oracle Common Schema
Release 10.1.2

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Copyright © 2006, Oracle. All rights reserved.

Overview | Common Schema | BI Beans

# Installing the Common Schema

These instructions guide you through the installation of a sample data set (known as the "common schema"). This common schema includes both relational and multidimensional (OLAP) data structures. The data in this schema is the basis for the samples and tutorials delivered with Oracle Business Intelligence Discoverer (OracleBI Discoverer), Oracle Business Intelligence Beans (OracleBI Beans), and the Oracle Business Intelligence Spreadsheet Add-in (OracleBI Spreadsheet Add-In).

## Contents

- What the install program does
- Installing the schema
  - Installing the schema - relational
  - Installing the schema - OLAP
  - Installing the schema - complete
- Uninstalling the schema

## What the install program does

This installation program lets you install the common schema for relational as well as OLAP data. The installation program performs the following tasks:

For relational data:

1. Determines your Oracle database version.
2. If connected to a 9i database, it will drop the existing 9i common schema 'SH' and import a new updated version which supports the tutorials. If connected to a 10g database, it will modify certain tables in the existing 'SH' common schema to include additional data to support the tutorials.

For OLAP data:

1. Determines your Oracle database version.
2. Creates a user that owns the analytic workspace. The user ID and password are the same: CS_OLAP. Note that if the CS_OLAP account exists, the account and all associated metadata will be first dropped and then recreated.
3. Creates a directory object, named EIFDIR, in the database. This directory object references the location of the EIF file that will be imported into the analytic workspace.
4. Creates two analytic workspaces:

- SHAW: Contains the data for the analytic workspace.
- UTILS: Contains programs used by the BI Beans application (e.g., forecasting programs).

5. Enables the analytic workspace for use by applications that leverage the Oracle OLAP API. OracleBI Beans is an example of such a technology.
6. Creates two new folders: Electronics - KPIs and Electronics - Trend Calculations.
7. Moves the measures and dimensions that were enabled in step 4 into these folders. Note that the measures that are located in the Electronics - Trend Calculations folder are a superset of those in the Electronics KPIs folder. When you use the QueryBuilder in the client tools (i.e., OracleBI Discoverer, OracleBI Beans, or OracleBI Spreadsheet Add-in), you look in these folders for the measures that are stored in SHAW.

Downloading the latest samples version

Before you install the common schema, you need to download the extract the latest version of the samples to the machine where you will install the samples.

1. Create a new directory (referred to as `<SAMPLE_HOME>`) on the computer where Oracle Business Intelligence is installed.
2. Download the latest version of the samples from the Oracle Technology Network (OTN) to `<SAMPLE_HOME>` and unzip the file.
   Note: On Windows NT/2000/XP, do not unzip the script files into a directory using long names or names that contain spaces.

## Installing the schema

### Installation Options

You can install the relational and OLAP common schema data separately, if you so want.

### Pre-installation checklist

The following are required:

- This installation process has been tested only on a US-English language database.
- The installation process uses connect / as sysdba to manage the main installation tasks. Your login ID must be included in the ORA_DBA group before you can install the schema. If your login id does not have the appropriate privileges, you will get an ORA-01031: insufficient privileges error.
- The installation requires Oracle10g Database, Release 10.1.0.3 or higher. Additionally, you must also install the appropriate patches, as described in the Oracle Business Intelligence Installation Guide. This installation will NOT work with an earlier version.
- Also note,that you must not use this sample set if you plan on using these samples against OLAP data and are using the Oracle Database version 10.2 or higher. A separate set of samples has been made available for the Oracle Database version 10.2
- In addition to the above database versions, the OLAP sample data installation requires that you must also have the database OLAP option installed.
- You must have 450MB of free disk space on the machine where you are installing the schema.
- The scripts must run on the same machine as the database.
- All CS_OLAP sessions must be terminated before running the install script.
- The SYS user must be assigned the OLAP_DBA role (if installing OLAP sample data).
- The OLAPSYS user must be unlocked (if installing OLAP sample data).
- The SH common schema must have been installed and the SH user account must be unlocked and active (not expired).
- SQL*Plus and the database 'imp' utility must be in your path.
- If you had installed the beta version of the software, you should remove your Discoverer catalog first before attempting the installation. You can remove the catalog by connecting to the database using SQL*Plus as 'system' user and running the following command:
  - drop user d4osys cascade;
- When installing on Unix, verify that all .sh files (shell scripts) in the common_schema and sub-folders (disco and olap) have execute privileges prior to starting the installation.
  - chmod 755 *.sh ;

### Pre-installation tasks

1. Change to the `<SAMPLE_HOME>/samples/common_schema` directory.
2. Set your ORACLE_HOME environment variable to the your Oracle database home. This is the database where you will be installing the common schema. You can use the echo command to verify that the environment variables have been set correctly.

- For example on Windows platforms:
  `set ORACLE_HOME=c:\oracleDB`
  echo %ORACLE_HOME%
- And on Unix platforms:
  `ORACLE_HOME=/oracleDB; export ORACLE_HOME`
  echo $ORACLE_HOME

3. Set the ORACLE_SID environment variable to the SID for the target database instance. For example on Windows platforms:
   - For example on Windows platforms:
     `set ORACLE_SID=orcl`
     echo %ORACLE_SID%
   - And on Unix platforms:
     `` `ORACLE_SID=orcl; export ORACLE_SID`
     echo $ORACLE_SID

### Installation steps - relational

If you only want to install the relational samples, perform these steps, only after downloading the samples as described above.

1. Navigate to the <SAMPLE_HOME>/common_schema folder.
2. Run install_rel.bat (on Unix you need to run install_rel.sh).

For example:
c:\samples\common_schema> install_rel
Note: The install file to be run is under the samples\common_schema folder. Do not run any file in the 'disco' or 'olap' sub-folders.
This script does not take any parameters.

### Installation steps - OLAP

If you only want to install the OLAP samples, perform these steps only after downloading the samples as described above.

1. Install the relational samples first, as described above in the 'Installation Steps - Relational' section.
2. Navigate to the <SAMPLE_HOME>/common_schema folder.
3. Run install_olap.bat (on Unix you need to run install_olap.sh) using the following two parameters:

- Location where you want to store your Oracle database data files. These are the files associated with CS_OLAP tablespace that the install script creates.
- Location of the installation script.
- Note that you should not append a 'slash' character at the end of either of the two paths of the two parameters.

For example:
c:\samples\common_schema> install_olap c:\orahome1\oradata\myservice c:\samples\common_schema
Note: The install file to be run is under the samples\common_schema folder. Do not run any file in the 'disco' or 'olap' sub-folders.

### Installation steps - complete

If you want to install both the relational and OLAP schemas, you should run the complete installation script. This script runs the relational installation followed by the OLAP installation. Perform these steps only after downloading the samples as described above.

1. Run install_all.bat (on Unix install_all.sh) using the following two parameters:

- Location where you want to store your Oracle database data files. These are the files associated with CS_OLAP tablespace that the install script creates.
- Location of the installation script.
- Note that you should not append a 'slash' character at the end of either of the two paths of the two parameters.

For example:
c:\samples\common_schema> install_all c:\orahome1\oradata\myservice c:\samples\common_schema
Note: The install file to be run is under the samples\common_schema folder. Do not run any file in the 'disco' or 'olap' sub-folders.

#### Errors during installation

It is normal to have errors displayed during the installation process. This is because the script drops common schema objects that may already be existing. If these do not exist there will be error messages displayed.

- The installation process creates a log file named install.log.
- If the directory object eif_dir does not exist, you will get a message ' ORA-04043: object EIFDIR does not exist'. This is ok and not an error in the installation.
- When removing metadata from the OLAP catalog for user SH, if the dimensions do not exist you may get error messages like 'ORA-30333: dimension does not exist '. This is ok and not an error in the installation.
- When running the script against an Oracle 10g database, you may get ORA-00942 table of view does not exist errors. These are benign error messages that you can ignore.

#### Uninstalling the schema

Note: The uninstall script must run on the same machine as the database.

### Uninstall steps

1. Go to the <SAMPLE_HOME>/common_schema/olap directory.
2. Run uninstall.bat using the same parameters as the install script: (run uninstall.sh on Unix)

- Location where you want to store your Oracle database data files. These are the files associated with CS_OLAP tablespace that the install script creates.
- Location of the installation script.
- Note that you should not append a 'slash' character at the end of either of the two paths of the two parameters.

For example: `
` `uninstall c:\orahome1\oradata\myservice c:\samples\common_schema`

The uninstall script removes the following:

- The CWM2 metadata for CS_OLAP
- The CS_OLAP user account
- The tablespaces associated with the CS_OLAP user account. (The cs_olap tablespace and the cs_olaptemp temporary tablespaces are also dropped)

The script creates a log file named drop.log.

Copyright © 2006 Oracle Corporation
All Rights Reserved