Installing Oracle Data Miner

The scripts described in this document are available to manage the Oracle Data Miner Repository. These scripts are also integrated with Oracle SQL Developer 3.0 to allow users to manage the repository through SQL Developer as well.

It is not necessary to install SQL Developer to run the installation scripts for Oracle Data Miner.

Download the scripts directly from the Oracle Data Miner page at Oracle Technology Network.

Download the file and unzip it.

Using SQL*Plus, log in as SYS, and run the appropriate script.

Installing the Oracle Data Miner Repository

installodmr.sql installs the Oracle Data Miner Repository; use it as follows:

set serveroutput on
@installodmr.sql default tablespace TEMP tablespace

Example: @installodmr.sql USER TEMP

The initial space requirement for the Data Miner Repository is 200MB; however, the tablespace will grow as metadata is added.

The script will take approximately 10 minutes to run for remote database installation and 2 minutes for local database installation.

See Loading and Dropping Sample Tables to load sample data.

Granting a User the Rights to Access the Repository

usergrants.sql user account grants the specified user account the rights required by Oracle Data Miner to use the Oracle Data Miner Repository. For example,

@usergrants.sql MININGACCT

dropusergrants.sql user account revokes all of these grants. For example,

@dropusergrants.sql MININGACCT

See Loading and Dropping Sample Tables to load sample data.

Dropping the Oracle Data Miner Repository

dropRepositoryAndUserObjects.sql drops the Repository and the user objects. For example,

@dropRepositoryAndUserObjects.sql

During the process of dropping the repository:

• The Database will not allow any new connections to be established during this process.
• Any connections granted rights to the Oracle Data Miner Repository will be disconnected.
• If a script failure occurs, you may have to manually place the database back into unrestricted mode.
  
• Enter the following command : alter system disable restricted session;
  

These steps are taken to ensure there are no conflicts in dropping the repository.

All workflows and internal tables will be dropped. Models created by Oracle Data Miner will not be dropped. Tables created by the Create Table node will not be dropped.

See Loading and Dropping Sample Tables to drop sample data.

Migrating the Oracle Data Miner Repository

migrateodmr.sql migrates the Data Miner Repository from an earlier version to the current version. All workflows created by users are preserved; only the repository software is updated. In future migrations, there may be a need to perform a migration of the workflows as well.  For example,

@migrateodmr.sql

During the process of migrating the repository:

• The Database will not allow any new connections to be established.
• Any connections granted rights to the Oracle Data Miner Repository will be disconnected.
• If a script failure occurs, you may have to manually place the database back into unrestricted mode.
  
• Enter the following command : alter system disable restricted session;
  

Loading and Dropping Sample Tables

These scripts load and remove the sample data used in the Cue Cards and in the Oracle by Example (OBE) for Oracle Data Miner:

• instDemoData.sql user account prepares demo data for user. The script grants user access to SH schema, creates mining_data_* views in user account based on SH schema, and . load insurance data into table in user account.

  Example: @instDemoData.sql MYUSER

• dropDemoData.sql user account drops the demo data prepared by instDemoData.sql.

  Example: @dropDemoData.sql MYUSER