Summary of the content on the page No. 1
®
Oracle Retail Data Warehouse
Database Installation Guide
Release 13.0
April 2008
Summary of the content on the page No. 2
Oracle® Retail Data Warehouse Database Installation Guide, Release 13.0 Copyright © 2008, Oracle. All rights reserved. Primary Author: Paul Kehler The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the P
Summary of the content on the page No. 3
Value-Added Reseller (VAR) Language (i) the software component known as ACUMATE developed and licensed by Lucent Technologies Inc. of Murray Hill, New Jersey, to Oracle and imbedded in the Oracle Retail Predictive Application Server – Enterprise Engine, Oracle Retail Category Management, Oracle Retail Item Planning, Oracle Retail Merchandise Financial Planning, Oracle Retail Advanced Inventory Planning and Oracle Retail Demand Forecasting applications. (ii) the MicroStrategy Components d
Summary of the content on the page No. 4
Summary of the content on the page No. 5
Contents Preface ............................................................................................................................. vii Audience ............................................................................................................................... vii Related Documents.............................................................................................................. vii Customer Support..........................................................
Summary of the content on the page No. 6
Summary of the content on the page No. 7
Preface Oracle Retail Installation Guides contain the requirements and procedures that are necessary for the retailer to install Oracle Retail products. Audience This Installation Guide is written for the following audiences: Database administrators (DBA) System analysts and designers Integrators and implementation staff Related Documents You can find more information about this product in these resources: Oracle Retail Data Warehouse Middle Tier Installation Guide Oracle Reta
Summary of the content on the page No. 8
Conventions Navigate: This is a navigate statement. It tells you how to get to the start of the procedure and ends with a screen shot of the starting point and the statement “the Window Name window opens.” Note: This is a note. It is used to call out information that is important, but not necessarily part of the procedure. This is a code sample It is used to display examples of code A hyperlink appears like this. viii
Summary of the content on the page No. 9
1 Preinstallation Tasks This release of RDW incorporates optional interfaces with these Oracle Retail products which can be sources for the data warehouse: Oracle Retail Merchandising System (RMS), Oracle Retail Invoice Matching (ReIM), Oracle Retail Merchandise Financial Planning (MFP), and Oracle Retail Price Management (RPM). Additionally, the data warehouse can also operate as a standalone product and be fed from other legacy systems. If Oracle Retail applications are used as the
Summary of the content on the page No. 10
Preinstallation Tasks Implementation Capacity Planning There is significant complexity involved in the deployment of Oracle Retail applications, and capacity planning is site specific. Oracle Retail strongly suggests that before installation or implementation you engage your integrator (such as the Oracle Retail Consulting team) and hardware vendor to request a disk sizing and capacity planning effort. Sizing estimates are based on a number of factors, including the following: Workload
Summary of the content on the page No. 11
Check Database Server Software Requirements Overall database size for the RDW. A capacity plan should be done for the database server and DASD requirements in general to assess how large the environment will need to be. Note: These data warehouse server requirements should only be used as guidelines because they reflect the hardware used to run a small environment (approximately 200 gigabytes of data). Actual requirements can be somewhat smaller, or typically much larger, depending on
Summary of the content on the page No. 12
Preinstallation Tasks Other Software Requirements for the Data Warehouse Please refer to the RDW 13.0 Middle Tier Installation Guide for the full installation instructions of the Oracle Business Intelligence Enterprise Edition components. Requirement Version Oracle Business Intelligence 10.1.3.3 Enterprise Edition Oracle Retail Extract Transform 13.0 and Load (RETL) Oracle Retail Merchandising 13.0 System (RMS)/Oracle Retail Trade Management (RTM)/Oracle Retail Sales Audit (ReSA) O
Summary of the content on the page No. 13
Alter Directory Ownership and Privileges 2. Create RDW database directory structure: Log in to the database server as UNIX user rdwdba. This user owns the database directory structure. Extract the files from the downloaded zip file. FTP (in binary mode) the tar file, rdw13_db.zip, to on the UNIX server where the rdw13 database will be created. The directory is a working directory that should be designated at this time. As the rdwdba user, ex
Summary of the content on the page No. 14
Preinstallation Tasks Copy Profiles for RDW User 1. Login to UNIX as the rdw13dev user and change directories to /rdw13.0/sample_profiles. 2. Copy the profile to the home directory of rdw13dev. Edit the .profile to correspond with the server file system, RETL installation and UNIX environment. Note: The sample profiles by default are set up for a development environment. Change the indicated variables as necessary for other environments. Any variables that may requi
Summary of the content on the page No. 15
2 Installation Tasks It is assumed that Oracle 10g release 2, with appropriate patches, has already been installed. If not, refer to “Check Database Server Software Requirements” in Chapter 1, “Preinstallation Tasks” before proceeding. Note: Become familiar with the RDW application in a development environment before setting up a production system. The following instructions are recommended for development and test environments only. When implementing RDW for a production envir
Summary of the content on the page No. 16
Installation Tasks Create the RDW Database and Tablespaces Create the Database as Follows 1. Login to the RDW database server as the rdwdba user. 2. Create the Oracle recommended OFA directory structure for the database (datafile directories, adump, bdump, cdump, arch, create, exp, pfile, udump, utl_file_dir). 3. Place an entry in the oratab file for the database and execute oraenv to set the ORACLE_SID and ORACLE_HOME environment variables. 4. Copy INSTALL_DIR/rdw13/create_db/init.o
Summary of the content on the page No. 17
Load RDW Database Load RDW Database Create RDW Schema Owners 1. As the rdwdba user, change directories to INSTALL_DIR/rdw13/utility. 2. Review the crusers.sql file for the names and passwords of the rdw users that will be created. Note these as they are used later in the installation. 3. Login to SQL*Plus as SYSDBA and execute the following script: SQL>@crusers..sql 4. To secure the passwords in the create users script, change the privileges on the script by entering: chmod 700 cru
Summary of the content on the page No. 18
Installation Tasks SP2-0734: unknown command beginning "no rows se..." - rest of line ignored. Note: These scripts are also used for maintenance. If you need to drop or add a table in the database, run these scripts again to give the appropriate privileges to your users. If a table has been dropped and recreated for maintenance, you also need to verify that all objects in the database are VALID. For a test or a production environment, you need to modify the rdw_users.sql script to alte
Summary of the content on the page No. 19
Data Population Populate Datamart Default Data 1. As the rdw13dev user, change directories to /rdw13.0/install. This directory contains the code for all default data installation scripts. 2. At the UNIX prompt, enter: default_load.ksh Note: Read the comments on every install script called within default_load.ksh, specifically load_maint_dim_key_dm.sql because the initial date for curr_load_dt might be different for every client. This script executes the followi
Summary of the content on the page No. 20
Installation Tasks 8. On the UNIX server, cChange directories to /rdw13.0/log. 9. Review the log file that was created or modified. 10. On the UNIX server, change directories to /rdw13.0/error. 11. Review the error files that were created for time_static_load. Note: Refer to the RDW Operations Guide for more information on the log files and error files. 12. Import the localization_dm.dmp file to the localization_dm table following the steps below
