1 Installing Oracle Database for Data Mining

Hardware Requirements

Verify that your computer meets the following requirements:

• Processor: 200 MHz minimum

• Available hard disk space:

  System drive: 100 MB

  Oracle home drive: 1.5 GB

  Temp disk space: 100 MB

• RAM: 256 MB minimum, 512 MB recommended

• Virtual memory: double the amount of RAM

• Video adapter: 256 color

Software Requirements

The following operating systems are among those supported for Oracle Database:

• Windows XP Professional

• Windows 2000 with service pack 1 or higher

Preliminary Steps

If any Oracle products are already installed on your computer, you must disable them before installing Oracle Database. Take these steps:

• Delete the ORACLE_HOME environment variable:

  1. From the Control Panel, choose System.

  2. On the Advanced tab of the System Properties page, choose Environment Variables.

  3. In the System Variables, select ORACLE_HOME, then click Delete.

• Stop all Oracle services.

  1. From the Control Panel, choose Administrative Tools, then Services.

  2. On the Services page, scroll down the list of names and locate those that begin with Oracle. Select those services and choose Stop.

If you are installing from a network drive, use Windows File Manager to map that drive to your computer.

Installing Oracle Database

To install Oracle Database on a Windows platform, take these steps:

1. From Database (db) Disk 1 (of 1), run SETUP.EXE.

   Oracle Universal Installer opens and displays the Welcome page.

2. Select Advanced Installation. Click Next to advance to each page.

   
   Description of the illustration db_installa.gif
   
   

3. On the Select Installation Type page, select Enterprise Edition.

   
   Description of the illustration db_install1.gif
   
   

4. On the Specify Home Details page, create a new Oracle home directory.

   
   Description of the illustration db_install2.gif
   
   

5. On the Product-Specific Prerequisite Checks page, verify that all checks succeeded. If any checks failed, then you must correct the problem before proceeding.

6. On the Select Configuration Option page, select Create a database.

7. On the Select Database Configuration page, select General Purpose.

8. Complete the Specify Database Configuration Options page as follows:

   • Type in a global database name and SID.

     The SID is a name that you choose. If you are installing on a personal computer for your own use, then the SID and the global database name are the same; the global database name does not include the domain.

   • Choose a database character set from the drop-down list. The Western European character set is a good choice for databases for the European Union and the Americas. UTF8 is a good choice for global databases.

   • Select Create database with sample schemas.

   
   Description of the illustration db_install6.gif
   
   

9. Choose the options you want. The following steps identify the simplest choices.

   1. On the Select Database Management Option page, select Use Database Control for Database Management.

   2. On the Select Database File Storage Option page, select File System.

   3. On the Specify Backup and Recovery Options page, select Do not enable automated backups.

   4. On the Specify Database Schema Passwords page, select Use the same password for all the accounts. Then enter a password of your choice in the Enter Password and Confirm Password fields.

10. On the Summary page, review your previous choices, then click Install.

11. On the Database Configuration Assistant page, click Password Management.

    Tip: Print a screen shot of this page or write down the information it contains for future reference.

    
    Description of the illustration db_install12.gif
    
    

12. On the Password Management page, unlock the DMSYS, SCOTT, and SH accounts and enter new passwords for them.

    
    Description of the illustration db_install13.gif
    
    

13. On the End of Installation page, confirm that the installation was successful.

    Tip: Print a screen capture of this page or write down the information it contains for future reference.

    
    Description of the illustration db_install14.gif
    
    

Installing the Data Mining Sample Programs

To install the Data Mining Sample Program Files on a Windows platform, take these steps:

1. From Companion Disk 1 (of 1), run SETUP.EXE.

   Oracle Universal Installer opens and displays the Welcome page. Click Next to advance to each page.

2. On the Select a Product to Install page, select Oracle Database 10g Products 10.2.0.0.0.

   
   Description of the illustration cp_install1.gif
   
   

3. On the Specify Home Details page, select the Oracle home in which you installed Oracle Database 10g Release 2 in the previous procedure. Do not rely on the default setting to be correct.

4. On the Product-Specific Prerequisite Checks page, verify that all checks succeeded. If any checks failed, then you must correct the problem before proceeding.

5. On the Summary page, review your previous choices, then click Install.

6. On the End of Installation page, confirm that the installation was successful.

Creating Data Mining Tablespaces on Real Application Clusters

When Oracle Database is installed on RAC, the Data Mining tables should be stored in a tablespace with a raw device partition. You can define this tablespace during installation of Oracle Database by choosing Raw Devices on the Specify Database File Storage Option page. Pre-installation steps are required for this storage option. Refer to the Installation Guide for your platform for more information.

Installing the Data Mining Scoring Engine

You only need to install the Data Mining Scoring Engine on computers where you will apply models that were built on another computer system. The Scoring Engine is an Enterprise Edition option that can be installed only during a custom installation. You can include the Data Mining Scoring Engine in a new installation, or you can add it to an existing installation at a later time.

To add the Data Mining Scoring Engine to an existing installation of Oracle Database, take these steps:

1. Open Oracle Universal Installer as described in "Installation of Oracle Database 10g".

2. On the Select Installation Type page, select Custom.

3. On the Specify Home Details page, select the Oracle home in which you previously installed Oracle Database 10g Release 2. Do not rely on the default setting to be correct.

4. On the Available Product Components page, select Data Mining Scoring Engine.
   Description of the illustration db_cust2.gif
   
   

Post-Upgrade Steps for Data Mining

The data mining objects in these schemas require additional upgrade steps after upgrading the database:

• DMSYS Repository Schema. The odmu101s.sql script removes redundant release 10.1 objects.

• User Schemas. The odmu101a.sql script re-creates the views of the Sales History sample schema for users who wish to run the sample Data Mining programs described in Chapter 4.

To upgrade the DMSYS repository, follow these steps:

1. Open SQL*Plus and connect to the database as the SYS user or another privileged account.

2. Verify that the compatibility mode is set to 10.2.x.x (such as 10.2.0.0).

   SELECT name, value, description FROM v$parameter
            WHERE name='compatible';
   
   

   If the compatibility model is incorrect, then edit the init.ora file for the database.

3. Run the odmu101s.sql script.

   Issue this command on Windows platforms:

   %ORACLE_HOME%\rdbms\admin\odmu101s.sql
   
   

   Or this command on Linux platforms:

   $ORACLE_HOME/rdbms/admin/odmu101s.sql
   
   

To upgrade the sample Sales History views in the schemas of Data Mining users, take these steps for each schema:

1. Backup the schema using the expdp command in Oracle Data Pump.

2. Open SQL*Plus and connect to the database as the SYS user or another privileged account.

3. Run the odmu101a.sql script, passing it two parameters: user_name and password.

   Issue this command on Windows platforms:

   %ORACLE_HOME%\rdbms\admin\odmu101a.sql user_name password
   
   

   Or this command on Linux platforms:

   $ORACLE_HOME/rdbms/admin/odmu101a.sql user_name password
   

Upgrading PL/SQL Models

All data mining PL/SQL models residing in user schemas in a release 10.1 database can be upgraded as part of the database upgrade. The upgrade of models is seamlessly integrated into the database upgrade process.

You can also export models from a release 10.1 database and import them into a release 10.2 database. The import process upgrades the models to release 10.2. Use the expdp and impdp command utilities in Oracle Data Pump. The Data Mining option or the Data Mining Scoring Engine option must be installed in the target database.

The Database Upgrade Assistant invokes procedures in the Data Mining DMP_SYS public package for upgrading and downgrading PL/SQL models between release 10.1 and 10.2.

The UPGRADE_MODELS procedure upgrades the Data Mining models from release 10.1 to 10.2, and has this syntax:

UPGRADE_MODELS (
     to_version     IN     VARCHAR2);

The DOWNGRADE_MODELS procedure downgrades models from release 10.2 to 10.1, and has this syntax:

DOWNGRADE_MODELS (
     from_version   IN     VARCHAR2);

These procedures are integrated with the Data Mining upgrade and downgrade processes and run as SYS. You do not need to run them manually.

Downgrading Oracle Data Mining

You can downgrade a database from release 10.2 to release 10.1 if the compatibility setting is set to 10.1.x.x. Otherwise, the database will include incompatibilities that will prevent it from being downgraded. The Data Mining option and user-owned PL/SQL models will be downgraded as part of database downgrade.