Oracle data mining is a part of Oracle database enterprise edition.Installation of Oracle data mining involves the following steps:
1) Installing the Oracle database
2) Installing Oracle database companion
3) Create a data mining demo user
4) running the sample programs
Installing the Oracle database:
1) Login as a user with appropriate privileges
2) Install database with sample schemas.Sample schemas are needed for data mining sample programs.
3) Run setup.exe which invokes Oracle universal installer.Click option to create a starter database.DBCA is used to create a starter database.
4) Unlock the accounts SYS,SYSTEM,SH.Change the password for the accounts.
5) Exit the wizard.
Installing Oracle Database Companion :
The Oracle Data Mining sample programs are installed with Oracle Database Companion.
The Database Companion installation process copies the Oracle Data Mining sample programs, along with examples and demonstrations of other database features, to the rdbmsdemo subdirectory of the Oracle home directory.Use Oracle Universal Installer to install it.Run setup.exe program.
Create a Data Mining Demo User:
1)Login as SYS User
2) Create data mining demo user as:
SQL> CREATE USER dmuser IDENTIFIED BY password
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS;
3)Run dmshgrants.sql to grant access to the SH schema. Several tables in SH are used by the Data Mining sample programs. Specify the Data Mining user name as the parameter.
@ %ORACLE_HOME%rdbmsdemodmshgrants dmuser
4) Connect to the database as the Data Mining user.
Enter password: password
5) Run dmsh.sql to populate the schema of the Data Mining user with tables, views, and other objects needed by the sample programs.
Run the Sample Programs:
To locate the sample programs on computer, navigate to the rdbmsdemo subdirectory under Oracle home.
To display the Data Mining PL/SQL sample programs, search for the files that start with dm and end with .sql. (The list will include dmsh.sql and dmshgrants.sql, which are used to configure the Data Mining demo user ID.) In the same directory, search for the files that start with dm and end with .java to display the Java samples.