Installing Oracle Data Miner

Purpose

This tutorial shows you how to enable the Data Mining option in the Oracle Database 10g Release 2, populate a data mining schema with sample tables, and install Oracle Data Miner.

Time to Complete

Approximately 30 minutes

Topics

This tutorial covers the following topics:

	Overview
	Prerequisites
	Enabling the DMSYS Account
	Load Mining Data into Your Database
	Installing Oracle Data Miner
	Summary

Viewing Screenshots

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: Because this action loads all screenshots simultaneously, response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over each individual icon in the following steps to load and view only the screenshot associated with that step.

Overview

Oracle Data Miner is a graphical user interface for Oracle Data Mining. It provides wizards that can easily be used to perform all data mining operations. Oracle Data Miner helps data analysts find valuable hidden information and makes data mining easier by doing the following:

	Automating data mining and model scoring process.
	Giving hints for the flow of steps in the operations.

Back to Topic List

Prerequisites

Before you perform this tutorial, you should:

1.	Perform the Installing Oracle Database 10g on Windows tutorial or have access to an Oracle Enterprise Edition 10g Release 2 Database with the Data Mining option enabled.
2.	Download and unzip the Data Mining Sample Data from OTN.

Note: It is recommended that you perform the Basic Installation. If you are required to perform a Custom Installation, note that the Oracle Data Mining option is automatically installed with any installation. DO NOT install the Oracle Data Mining Scoring Engine option as that action will disable the Oracle Data Mining option. Also, if you unlock and assign a password to the user DMSYS in step 11 of the database installation instructions, it is not necessary to enter the commands shown in the section below : Enabling the DMSYS account.

Back to Topic List

Enabling the DMSYS Account

After installing Oracle Database 10g on Windows, you need to enable the Oracle Data Mining administrative function and unlock schema required for the data mining examples. Perform the following steps:

Open a command prompt window and execute the following commands to unlock the DMSYS account and assign a password.

cd <demofilelocation>\DATA MINING Demos\admin
sqlplus sys/<sys_password> as sysdba
ALTER USER dmsys IDENTIFIED BY dmsys ACCOUNT UNLOCK;

<demofilelocation> is the path where you unzipped the demo files in step 2 of the prerequisites.

<sys_password> is the password assigned to sys during database installation.

Note: The SH user also needs to be unlocked.

Back to Topic List

Creating and Configuring a Data Mining Account

Each database user who executes ODM operations must have:

	Default and temporary tablespaces specified
	Permission to access the mining data

Under normal circumstances in a simple training environment, or single-user system, users can share existing default and temporary tablespaces. But, in a production setting with several users, it is better to create separate tablespaces for each user.

To create and configure a data mining account, perform the following steps:

1.	Now you can create a new tablespace. To create a new tablespace named dmuser1, execute the following command: CREATE TABLESPACE dmuser1 DATAFILE '<oracle_base>\oradata\orcl\dmuser1.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 20M; <oracle_base> is the directory where the oracle_home is defined (i.e. c:\oracle\product\10.2.0).
2.	You can create a data mining user named dmuser1 having password dmuser1. Execute the following command: CREATE USER dmuser1 IDENTIFIED BY dmuser1 DEFAULT TABLESPACE dmuser1 TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON dmuser1;
3.	Next, the user must be granted permissions to carry out data mining tasks. Execute the following command: @dmshgrants <sh_password> dmuser1 <sh_password> is the password assigned to the user SH when the account is unlocked (i.e. SH).
4..	Finally, the schema for the new user can be populated with tables and views constructed from the data in the SH schema. You need to connect as dmuser1. Execute the following commands: connect dmuser1/dmuser1 @dmsh commit;

Back to Topic List

Installing Oracle Data Miner

To install Oracle Data Miner, perform the following steps:

1.	Download Oracle Data Miner from OTN and unzip into any directory except under your <database oracle home> directory .
2.	Double-click <your_path>\bin\odminerw.exe.
3.	You need to create a database connection for the DMUSER1 account you created previously. Enter the following details in the window and click OK. Connection Name: dmuser1_connect User: dmuser1 Password: dmuser1 Host: <the machine where your Oracle Database is installed> Port: 1521 SID: orcl Note: The connection name can be anything you want. The Port and SID (Global Database Name) were assigned during the database installation.
4.	Once your connection has been created, click OK to open Data Miner.
5.	Confirm that the sample tables and views are in your dmuser1 user schema. Expand Data Sources > DMUSER1 > Views and Tables.

Back to Topic List

Summary

In this tutorial, you learned how to:

	Enable the data mining option in the Oracle Database 10g Release 2 database
	Populate a data mining schema with sample tables
	Install Oracle Data Miner

Back to Topic List