3 Database Objects Installation

Database Objects Installed

The installation described in this chapter creates all of the database objects of Oracle Retail Data Model and also data mining models.

For detailed information about all created objects in the BIA_RTL and BIA_RTL_MINING schemas, see the Oracle Retail Data Model Reference.

Database Objects Installation Steps

Follow these steps to install the database objects:

1. Log in using the user id that you plan to use to run the installation. You should use the same user id to install Oracle Retail Data Model as used to install the Oracle Database and BI EE.

2. Before you start the installation, check that the Oracle Data Mining option is installed. To check, log in as SYS and enter the following query:

   SQL> SELECT * FROM V$OPTION WHERE PARAMETER ='Data Mining';
   

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

   Note:

   For Oracle 10g Release 2, you must have the Data Mining Option installed, 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.

3. Set the ORACLE_HOME environment variable to the location of the Database on which to install ORDM.

   For example, suppose that Oracle Home is in the directory /loc/app/oracle/product/10.1.0/

   In a Bourne, Bash, or Korn shell, use these commands to set ORACLE_HOME:

   $ ORACLE_HOME=/loc/app/oracle/product/10.1.0/
   $ export ORACLE_HOME
   

   In a C shell, use this command to set ORACLE_HOME

   % setenv ORACLE_HOME /loc/app/oracle/product/10.1.0/
   

4. Start the installer from the directory that contains the ORDM installation files:

   cd directory-containing-Oracle-Retail-Data_Motel_installation-files
   ./runInstaller
   

5. The Welcome page is displayed. Click Next.

6. In the Specify Source Location page, click Next.

7. Select the Retail Data Model installation type.

   Oracle Retail Data Model supports English and 9 other languages. To add support for one language in addition to English, click Product Languages and select the language.

   Click Next.

8. In the Specify Home Details page, verify that the Name and Path correspond to the Database in which you want to install ORDM.

   Click Next.

9. Provide the following information:

   • Host Name: Name of the system where the Oracle Database is installed

   • Oracle Service Name

   • Oracle SID

   • Listener Port Number

   • Password for the system user

   Click Next.

10. Specify the data file location. This location is the path where all the data files on which Oracle Retail Data Model tablespaces reside.You can click Browse to navigate to any valid local data file path. Click Next.

11. Specify the calendar data range by providing a start date and the number of years. This information is used to populate the calendar data.

    The start date must be in the format YYYY-MM-DD; for example, 2007-01-01 stands for January 1, 2007. The number of years must be a whole number.

    Click Next.

12. Oracle Retail Data Model will partition the transaction-related fact tables for you. Specify the start year and the end year. The default partition creates one partition for each month in the range. The start year must be earlier that the end year.

    Click Next.

13. You can load data to the base that is at transaction level and at aggregate level, with data summarized at the day or week level.

    Select Yes or No. Click Next.

14. The installer summarizes the information that you specified. Check that this information is correct. If necessary, click Back to return to previous screens and make corrections. When you are satisfied with the information, click Install.

15. The database objects are installed. If there are any problems, messages are displayed. After the installation finishes, the end of installation screen appears. Click Exit to end the installer.

16. At the end of the installation, the BIA_RTL and BIA_RTL_MINING accounts are locked. Log in the database with a DBA id and password and unlock the accounts as follows:

    SQL> alter user bia_rtl account unlock;
    
    User altered.
    
    SQL> alter user bia_rtl_mining account unlock;
    
    User altered.
    

17. For Oracle 11g Release 1 Database, BIA_RTL_MINING does not have the privileges required by Oracle Data Mining 11.1. To assign the proper grants to BIA_RTL_MINING, follow these steps:

    1. Log in to the database using an ID that has been granted the system privilege with the ADMIN OPTION or that has been granted the GRANT ANY PRIVILEGE system privilege.

    2. Execute the following commands:

       SQL> grant CREATE ANY MINING MODEL to bia_rtl_mining;
       SQL> grant ALTER ANY MINING MODEL to bia_rtl_mining;
       SQL> grant DROP ANY MINING MODEL to bia_rtl_mining;
       SQL> grant SELECT ANY MINING MODEL to bia_rtl_mining; 
       

    Note:

    This step is not required for Oracle Database 10g.

18. To ensure that all objects are valid, log in to the database with a DBA id and password and recompile all objects in BIA_RTL and BIA_RTL_MINING as follows:

    SQL> exec utl_recomp.recomp_serial('BIA_RTL');
    PL/SQL procedure successfully completed.
    SQL>  exec utl_recomp.recomp_serial('BIA_RTL_MINING');
    PL/SQL procedure successfully completed. 
    

Oracle Retail Data Model Home Directory Structure

The installation image contains the following directories under ORACLE_HOME/ORDM:

• PDM: Physical schema dump, interface schema, creation script, lookup value population, and physical schema related documents

  • PDM/Relational: Schema installation and relational scripts

  • PDM/Relational/Intra_ETL: Intra-ETL database packages

  • PDM/Interface: Interface schema definition

  • PDM/OLAP: OLAP-related documentation and exports

  • PDM/Mining: Data Mining model installation

  • PDM/Utilities: Scripts used in DDL script generation, out of stock, and so on

• Report: Files and documentation required for Oracle Retail Data Model installation