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

The samples included in this installation shall not work the Oracle Database 9i Release 2. This installation program lets you install the common schema for relational as well as OLAP data.
If you need to install these samples on an earlier supported version of the Oracle Database please use this link instead. The installation program performs the following tasks:
For relational data:
- It will modify certain tables in the existing 'SH' common schema to include
additional data to support the tutorials.
For OLAP data:
- Creates a user that owns the analytic workspace. The user ID and password
are the same: SH_OLAP. Note that if the SH_OLAP account exists, the account and all associated metadata will be first dropped and then recreated.
- Creates two analytic workspaces:
- SH_AW: Contains the data for the analytic
workspace.
- UTILS: Contains programs used by the
BI Beans application (e.g., forecasting programs).
- Enables the analytic workspace for use by applications that leverage the
Oracle OLAP API. OracleBI Beans is an example of such a technology.
- Creates nine new folders: three for Electronics analysis, three for Customer Analytics, and three for Brand Analytics.
- Moves the measures and dimensions that were enabled in the step above into these
folders.
- Note: The SH_OLAP schema is fully specified in the 10.2 standard form and has been built using Oracle Analytic Workspace Manager (AWM). It is thus completely compatible with custom member functionality and single or multi user writeback with the Oracle Spreadsheet Add-In (SSA). It does not support the forecasting applications built with BI Beans (the Executive Insight demo). This is not supported because of limitations with the current release of the AWM with supporting fine-grain control on limiting dimensions necessary for forecasting.
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.
- Create a new directory (referred to as
<SAMPLE_HOME>
) on the computer where Oracle Business Intelligence is installed.
- 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.2.0.1 or higher. 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 of the Oracle Database.
- 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 SH_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.
Pre-installation tasks
- Change to the
<SAMPLE_HOME>/samples/common_schema
directory.
- 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
- 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.
- Navigate to the <SAMPLE_HOME>/common_schema folder.
- 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.
- Install the relational samples first, as described above in the 'Installation Steps - Relational' section.
- Navigate to the <SAMPLE_HOME>/common_schema folder.
- 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 SH_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.
- 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 SH_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
- Go to the <SAMPLE_HOME>/common_schema/olap directory.
- 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 SH_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 SH_OLAP
- The SH_OLAP user account
- The tablespaces associated with the SH_OLAP user account. (The sh_olap tablespace and the sh_olap temp temporary tablespaces are also dropped)
The script creates a log file named drop.log.
Copyright © 2006 Oracle Corporation
All Rights Reserved