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.
Oracle Retail Data Model is supported on the following platforms:
Linux x86
Oracle Linux 4
Oracle Linux 5
Red Hat Enterprise Linux AS/ES 4.0
Red Hat Enterprise Linux AS/ES 5.0
Linux x86-64
Oracle Linux 4
Oracle Linux 5
Red Hat Enterprise Linux AS/ES 4.0
Red Hat Enterprise Linux AS/ES 5.0
Solaris SPARC (64-bit)
Solaris 10
AIX 5L Based Systems (64-bit)
AIX 5L version 5.3
AIX 6L version 6.1
HP-UX Itanium
HP-UX 11i v2 (11.23)
HP-UX 11i v3 (11.31)
For more information about Oracle Linux, see Oracle Linux Notes.
For information about the Oracle Linux, go to http://www.oracle.com/us/technologies/linux/index.html
. To download Linux, click Oracle Linux in the Downloads list; the link takes you to the Oracle Linux download site, http://edelivery.oracle.com/linux
. 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 http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html
.
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:
The minimum software requirements for Oracle Retail Data Model are as follows:
Operating System: For details of supported platforms, see Supported Platforms.
Oracle Database 10g Release 2 Enterprise Edition or Oracle Database 11g Release 1 Enterprise Edition. See Oracle Database Requirements
Oracle Business Intelligence Suite Enterprise Edition (BI EE) 10.1.3.3.3 or higher for dashboards and reports.
Oracle Online Analytical Processing (OLAP) and Oracle Analytic Workspace Manager (AWM); OLAP and AWM requirements depend on the release of Oracle Database that you use. See OLAP Installation and Configurationfor details.
Oracle Warehouse Builder (OWB) version compatible with database version you are using. OWB is optional.
Oracle Retail Data Model requires one of these releases of Oracle Database:
Oracle Database 10g Release 2 Enterprise Edition 10.2.0.3 or 10.2.0.4.
Oracle Database 11g Release 1 Enterprise Edition 11.1.0.6 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:
For the Relational with OLAP and Data Mining installation, OLAP and Data Mining are required; Partitioning is optional.
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 10.2.0.3 (patchset number 5337014). Patches are available from My Oracle Support (http://metalink.oracle.com
).
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:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
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.
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.
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:
SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER ='Data Mining';
If this query returns TRUE
, Oracle Data Mining is installed.
Note:
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.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:
Activate the SYSDBA.
Grant the SYSDBA and DV_ACCTMGR roles to system
by performing the following steps:
Login DB as DV_OWNER
.
Execute the following SQL command.
GRANT DV_ACCTMGR to system;
Login DB as SYSDBA.
Execute the following SQL command.
GRANT SYSDBA to system;
Disable two triggers by performing the following steps:
Login DB as DV_OWNER
.
Execute the following SQL commands.
ALTER TRIGGER DVSYS.DV_BEFORE_DDL_TRG DISABLE; ALTER TRIGGER DVSYS.DV_AFTER_DDL_TRG DISABLE;
Follow the Oracle Retail Data Model installation instructions in this document. When the installation is complete, follow the remaining steps in these instructions.
Revoke the SYSDBA and DV_ACCTMGR roles from system
.
Enable the triggers by performing the following steps:
Login DB as DV_OWNER
.
Execute the following SQL commands.
ALTER TRIGGER DVSYS.DV_BEFORE_DDL_TRG ENABLE; ALTER TRIGGER DVSYS.DV_AFTER_DDL_TRG ENABLE;
Disable the SYSDBA.
Oracle Business Intelligence Suite Enterprise Edition (BI EE) 10.1.3.3 or higher can be downloaded from Oracle Technology Network at:
http://www.oracle.com/technology/software/products/ias/htdocs/101320bi.html
Installation instructions are included in the documentation.