Oracle Data Miner的安装

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.

Topics

This tutorial covers the following topics:

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.

Prerequisites

Before you perform this tutorial, you should:

1.	Perform the 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 .

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

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:

1.

Open a command prompt window and execute the following commands to unlock the DMSYS account and assign a password. cd \DATA MINING Demos\admin sqlplus sys/ as sysdba ALTER USER dmsys IDENTIFIED BY dmsys ACCOUNT UNLOCK; is the path where you unzipped the demo files in step 2 of the prerequisites. is the password assigned to sys during database installation. Note: The SH user also needs to be unlocked.

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 '\oradata\orcl\dmuser1.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 20M; 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 dmuser1 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;

 

Installing Oracle Data Miner

To install Oracle Data Miner, perform the following steps:

1.	Download Oracle Data Miner from and unzip into any directory except under your directory .
2.	Double-click \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: 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.

 

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