Skip Headers
Oracle® Retail Data Model Installation Guide
10g Release 2 (10.2)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

2 Hardware and Software Requirements

This chapter describes the hardware and software requirements of Oracle Retail Data Model:

Before you install Oracle Retail Data Model, you must verify that all hardware and software requirements are met.

Supported Platforms

Oracle Retail Data Model is supported on the following platforms:

For more information about Oracle Linux, see Oracle Linux Notes.

Oracle Linux Notes

For information about the Oracle Linux, go to To download Linux, click Oracle Linux in the Downloads list; the link takes you to the Oracle Linux download site, Oracle Linux is a free download.

Follow the standard installation for Linux. For a simple installation, install all components (RPMs) when installing Linux. During the installation, select as the installation type "install everything". This installation type installs all the Linux components required by the Oracle Database. For helpful information about installing Oracle Linux, see

Hardware Requirements

The Oracle Database installation guide for your platform includes procedures for checking that your installation meets the hardware and operating system requirements described.

The minimum hardware requirement for Oracle Retail Data Model is:

Software Requirements

The minimum software requirements for Oracle Retail Data Model are as follows:

Oracle Database Requirements

Oracle Retail Data Model requires one of these releases of Oracle Database:

  • Oracle Database 10g Release 2 Enterprise Edition or

  • Oracle Database 11g Release 1 Enterprise Edition or higher.

Oracle Retail Data Model may require the following options to the database:

  • Oracle Partitioning (recommended)

  • Oracle Online Analytical Processing (OLAP)

  • Oracle Data Mining (required for model building)

There are two kinds of Oracle Retail Data Model installation:

  1. For the Relational with OLAP and Data Mining installation, OLAP and Data Mining are required; Partitioning is optional.

  2. Sample Schemas and Reports installation does not require any database options, but does require Oracle BI EE installation.

After you download and install the Database, upgrade to the latest patch. For example, Oracle OLAP requires patchset (patchset number 5337014). Patches are available from My Oracle Support (

Check the file sqlnet.ora in ORACLE_HOME/network/admin. If you cannot find EZCONNECT in the NAMES.DIRECTORY_PATH, add it so that the line reads:


When you install the database ensure that the database character set is UFT8 to support multi-language installations. Oracle Retail Data Model permits the installation of support for English and one other language. See "Setting up Language Support" for more information.

Oracle Retail Data Model supports the partition of transaction-related fact tables according to your data volume estimation. You can specify the start year, end year and then the transaction related fact tables are partitioned by the date as one partition for each month.

In order to support the partition of transaction-related fact tables, when you install the database server use DBCA to change the Maximum Datafiles option using the following formula:

Maximum Datafiles = Default Value + ((End year) - (Start year) + 1) * 12

If you are using Oracle Database Vault in your Database installation, perform the steps in Database Vault Option before you install Oracle Retail Data Model.

Setting up Language Support

Brazilian Portuguese, French, German, Italian, Japanese, Korean, Latin American Spanish, Simplified Chinese, and Traditional Chinese are supported in addition to English.

Select Product Languages in the installation type selection page of the OUI Installer, and select the language to support in addition to English.

Data Mining Option

Before you install Oracle Retail Data Model, check that the Oracle Data Mining option is installed in your Oracle Database. To check, log in as SYS and enter the following query:


If this query returns TRUE, Oracle Data Mining is installed.


For Oracle Data Mining 10.2, you must install the Data Mining Option, not the Oracle Data Mining Scoring Engine. The Scoring Engine does not allow you to build models. For more information, see the Oracle Data Mining Administrator's Guide.

Database Vault Option

The Oracle Retail Data Model installer requires additional steps on a Vault-enabled database. For an Oracle Database with the Vault option on, follow these steps to install Oracle Retail Data Model:

  1. Activate the SYSDBA.

  2. Grant the SYSDBA and DV_ACCTMGR roles to system by performing the following steps:

    1. Login DB as DV_OWNER.

    2. Execute the following SQL command.

      GRANT DV_ACCTMGR to system;
    3. Login DB as SYSDBA.

    4. Execute the following SQL command.

      GRANT SYSDBA to system;
  3. Disable two triggers by performing the following steps:

    1. Login DB as DV_OWNER.

    2. Execute the following SQL commands.

  4. Follow the Oracle Retail Data Model installation instructions in this document. When the installation is complete, follow the remaining steps in these instructions.

  5. Revoke the SYSDBA and DV_ACCTMGR roles from system.

  6. Enable the triggers by performing the following steps:

    1. Login DB as DV_OWNER.

    2. Execute the following SQL commands.

  7. Disable the SYSDBA.

Oracle Business Intelligence Suite Enterprise Edition

Oracle Business Intelligence Suite Enterprise Edition (BI EE) or higher can be downloaded from Oracle Technology Network at:

Installation instructions are included in the documentation.