Installing Oracle Data Miner

Enabling the DMSYS Account
Open a command prompt window and execute the following commands to unlock the DMSYS account and assign a password.
sqlplus sys/ as sysdba
ALTER USER dmsys IDENTIFIED BY dmsys ACCOUNT UNLOCK;

Creating and Configuring a Data Mining Account
1. Now you can create a new tablespace. To create a new tablespace named dmuser1, execute the following command:
CREATE TABLESPACE dmuser1 DATAFILE ' D:\oracle\product\10.2.0\oradata\orcl\dmuser1.dbf'
SIZE 20M REUSE AUTOEXTEND ON NEXT 20M;

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:
GRANT create procedure to DMUSER1;
GRANT create session to DMUSER1;
GRANT create table to DMUSER1;
GRANT create sequence to DMUSER1;
GRANT create view to DMUSER1;
GRANT create job to DMUSER1;
GRANT create type to DMUSER1;
GRANT create synonym to DMUSER1;
GRANT execute on ctxsys.ctx_ddl to DMUSER1;

Installing Oracle Data Miner
To install Oracle Data Miner, perform the following steps:
1. Download Oracle Data Miner from Oracle Web Site and unzip into any directory For example C:\odminer
2. Double-click C:\odminer\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.