Beta Draft: 2016-09-11

3 Installing Oracle Data Miner

This chapter explains how to install SQL Developer and the Oracle Data Miner repository.

• Oracle Data Miner Installation Overview
  Oracle Data Miner installation refers to installation of the Oracle Data Miner repository in an Oracle Database. The repository serves as application manager and workflow storage manager for Oracle Data Miner.
• About Oracle Data Miner Sample Data
  Oracle Data Miner contains sample data that includes tables and views.
• Downloading SQL Developer
  Oracle SQL Developer is available for download free of charge from the Oracle Technology Network.
• Installing the Repository Using a Script
  You can install the Oracle Data Miner repository by running the installodmr script.
• Loading the Sample Data Using a Script
  After you install the repository using a script, you can run a second script to load the sample data that is used in Oracle Data Miner tutorials.
• Installing the Repository Using SQL Developer GUI
  You can install the Oracle Data Miner repository using the SQL Developer graphical user interface.
• Installing JSON Parser and Data Guide
  JSON query processing is available in Oracle Database 12.1.0.2 and later.

Oracle Data Miner Installation Overview

Oracle Data Miner installation refers to installation of the Oracle Data Miner repository in an Oracle Database. The repository serves as application manager and workflow storage manager for Oracle Data Miner.

To install Oracle Data Miner:

1. Install Oracle Database. If you already have a database, verify that it meets the requirements specified in Table 2-1.

2. Download SQL Developer.

3. Check Oracle Data Miner Release Notes

4. Install the Oracle Data Miner repository. You can use SQL Developer or you can run scripts to perform the installation.

   See Also:

   "About Data Miner Repository Installation" in Oracle Data Miner User's Guide

About Oracle Data Miner Sample Data

Oracle Data Miner contains sample data that includes tables and views.

The sample tables and views are:

• MINING_DATA_BUILD_V, MINING_DATA_TEST_V, MINING_DATA_APPLU_V: These are views based on tables in the SH schema. This data is used in Oracle Data Mining sample programs, as described in Oracle Data Mining Application Developer’s Guide and Oracle Data Mining Administrator’s Guide.

• MINING_DATA_TEXT_BUILD_V, MINING_DATA_TEXT_TEST_V, MINING_DATA_TEXT_APPLU_V: These are views based on tables in the SH schema. The views include an additional COMMENTS column that is used in text mining examples in OBEs and in Data Mining sample programs.

• ODMR_CARS_DATA: This is sample data about US automobiles, for experimenting with the Graph node.

• INSUR_CUST_LVT_SAMPLE: This is sample data used by the Oracle By Example (OBE) tutorials for Data Mining.

• ODMR_SALES_JSON_DATA: This is sample sales data for experimenting with the JSON query node in Oracle Database 12.1.0.2 and later.

• ODMR_MINING_DATA_TEXT, ODMR_SALES_DATA: This is sample data that can be used as a partial replacement, if SH schema is not easily available. It is loaded when Oracle Data Miner demo data is installed, without SH dependencies.

• WIKISAMPLE: This is sample data to demonstrate the Explicit Feature Extraction node.

Downloading SQL Developer

Oracle SQL Developer is available for download free of charge from the Oracle Technology Network.

To install SQL Developer, simply download and unzip it on your system. SQL Developer does not include an installation program.

To download SQL Developer:

1. Go to the Downloads tab of the Oracle SQL Developer home page:

   http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

2. Select the documentation links to view the release notes, a list of new features, and the SQL Developer Documentation Library.

   Note:

   The documents in the Documentation Library are available for online viewing or for download in PDF, Mobi (for Kindle), or ePub (for iBook) format. You can bookmark the Documentation Library page for ease of access:

   Documentation

3. Select the installation instructions for your platform and follow the instructions to download and start SQL Developer.

   Note:

   SQL Developer requires the Java Development Kit (JDK) version 1.7 or later. If the JDK is not included in the SQL Developer software download bundle and you do not have it installed on your system, then you must download and install it separately.

   The SQL Developer installation instructions include a link to the JDK download page.

4. The first time you start SQL Developer, you must supply the path to the JDK.

Installing the Repository Using a Script

You can install the Oracle Data Miner repository by running the installodmr script.

Before you install the repository, verify disk space availability. You must have 4 MB disk space for initial storage allocation. For additional storage, you must have an average of 1 MB disk space to handle 10 workflows of 20 nodes each.

Note:

For Oracle Database 11.2.0.4 or later, the default tablespace for the repository must have auto specified for segment space management.

To install the Oracle Data Miner repository:

1. Log in to the database as SYS.

2. Run the installodmr script.

   installodmr.sql default_tablespace temp_tablespace
   

   For example, if you have set the default search path as described in Setting the Path to Oracle Data Miner Scripts, then the following statement installs the repository with default tablespace USERS and temporary tablespace TEMP:

   @installodmr USERS TEMP

When the database is remote and the repository is using XML DB object-relational storage, the installation script takes approximately ten minutes to run. When the database is remote and the repository is using binary storage (Oracle Database 11.2.0.4 and later), the installation completes in approximately three minutes.

Note:

After installing the repository, you must enable Oracle Data Miner access for at least one database user.

See Also:

• Storage Configuration for Oracle Data Miner for information about object-relational and binary storage for Oracle Data Miner.

• Granting or Dropping Access Rights to Oracle Data Miner Repository for more information related to enabling or disabling access to the repository.

• About Oracle Data Miner Administration Scripts before running the installation script.

Loading the Sample Data Using a Script

After you install the repository using a script, you can run a second script to load the sample data that is used in Oracle Data Miner tutorials.

If you install the repository by using the SQL Developer GUI, then you can install the sample data by checking a check box.

The instDemoData script prepares demo data for an Oracle Data Miner user. The script grants access to the data described. If the SH schema is not present in the database, then the script prepares only the demo data that does not depend on SH.

To install the Oracle Data Miner sample data for a user:

1. Log in to the database as SYS.

2. Verify that the SH schema is present in the database.

3. Run the instDemoData script:

   instDemoData.sql user
   

   For example, if you have set the default search path, then the following statement installs the sample data for the user dmuser1:

   @instDemoData dmuser1
   

To drop the sample data for a user:

1. Log in to the database as SYS.

2. Run the dropDemoData script:

   dropDemoData.sql user
   

   For example, if you have set the default search path, then the following statement drops the sample data for the user dmuser1:

   @dropDemoData dmuser1
   

Installing the Repository Using SQL Developer GUI

You can install the Oracle Data Miner repository using the SQL Developer graphical user interface.

Before you install the repository, verify disk space availability. You must have 4 MB disk space for initial storage allocation. For additional storage, you must have an average of 1 MB disk space to handle 10 workflows of 20 nodes each.

To install the Oracle Data Miner repository from SQL Developer GUI:

1. In the Connections tab of SQL Developer, select an administrative connection to the target database, or create a new one.

2. Create an Oracle Data Miner user:

   1. Drill on the administrative connection.

   2. Right click Other Users and choose Create User.

   3. Grant the CONNECT role to the user, and for Default Tablespace, specify Unlimited Quota.

3. In the Connections tab, create a connection for the Oracle Data Miner user.

4. From the View menu, select Data Miner, and then Data Miner Connections.

5. The Data Miner Connections tab appears beneath the SQL Developer Connections tab.

6. Click the plus sign on the Data Miner tab to display the Select Connection dialog box. Choose the Data Miner user from the drop-down list.

7. The new connection appears on the Data Miner tab.

8. When you attempt to drill on the new connection, this dialog box is displayed:

   Figure 3-1 Repository not Installed

   
   Description of "Figure 3-1 Repository not Installed"

9. Click Yes to install the repository.

10. After you provide the SYS password, information about the repository is displayed. For example:

    Figure 3-2 Repository Installation Settings

    
    Description of "Figure 3-2 Repository Installation Settings"

11. Click OK.

12. The Repository Installation Settings dialog box appears.

    Select the Install Demo Data check box to install the sample data in the schema of the user connection. If the SH schema is present in the database, then all sample data is installed. If SH is not installed, then only ODMR_CARS_DATA, INSUR_CUST_LVT_SAMPLE, ODMR_SALES_JSON_DATA ODMR_MINING_DATA_TEXT, ODMR_SALES_DATA, and WIKISAMPLE (Database 12.1 only) are installed.

    Figure 3-3 Install Data Miner Repository

    
    Description of "Figure 3-3 Install Data Miner Repository"

    Note:

    The repository installation automatically grants the database privileges required by Oracle Data Miner.

    The privileges required by Oracle Data Miner are different from the privileges required for using the Oracle Data Mining APIs directly. For details, see "Controlling Access to Mining Models and Data" in Oracle Data Mining Application Developer’s Guide.

13. When the installation is complete, click Close.

Installing JSON Parser and Data Guide

JSON query processing is available in Oracle Database 12.1.0.2 and later.

Note:

If you have installed or migrated the repository using scripts, then separate postinstallation step to enable JSON support in Oracle Data Miner is not required.

• About the Scripts for Installing JSON Support
  To install JSON parser and the schema generator for Oracle Data Miner, two scripts are available.
• Requirements for Running the Scripts to Install JSON Parser
  The scripts loadjsonschemagen.sql and loadjsonschemagenWithSN.sql install the JSON parser and schema generator for Oracle Data Miner.
• Installing JSON Parser in a Remote Database
  You can install JSON support in a remote database by running the loadjsonschemagen or loadjsonschemagenWithSN scripts.
• Installing JSON Parser Locally on the Database Host
  You can install JSON parser locally on a database host by using the scripts loadjsonschemagen.sql, validateODMRSYS.sql, org.glassfish.javax.json.jar, and JSONSchemaGenerator.jar.

About the Scripts for Installing JSON Support

To install JSON parser and the schema generator for Oracle Data Miner, two scripts are available.

The only difference between the two scripts in their arguments: one takes the Oracle SID, the other takes the Oracle Service Name. You can choose the script that best suits your database installation. If you are using a pluggable database, the Oracle Service Name is required.

• loadjsonschemagen.sql uses the Oracle SID.

  loadjsonschemagen.sql sys_user sys_password host port SID jar_path
  

• loadjsonschemagenWithSN.sql uses the Oracle Service Name.

  loadjsonschemagenWithSN.sql  sys_user sys_password host port service_name jar_path
  

For both scripts, specify the SYS user and password, the database host name and port number and the path to the jar files:

org.glassfish.javax.json.jar

JSONSchemagenerator.jar

Requirements for Running the Scripts to Install JSON Parser

The scripts loadjsonschemagen.sql and loadjsonschemagenWithSN.sql install the JSON parser and schema generator for Oracle Data Miner.

To run the scripts, ensure the following requirements:

• The jar_path argument must be a directory that is accessible to the current database system.

• The Oracle database command-line utilities loadjava and dropjava must be available on the system where the script is run.

Installing JSON Parser in a Remote Database

You can install JSON support in a remote database by running the loadjsonschemagen or loadjsonschemagenWithSN scripts.

1. Log in to the computer where SQL Developer is installed.
2. Navigate to the scripts directory:
   cd SQL_Developer_Home\sqldeveloper\dataminer\scripts
3. Start SQL*Plus as SYS:

   SQLPLUS sys / as sysdba

4. Run either the SID or Service Name version of the script:
   @loadjsonschemagen sys_user sys_password host port SID jar_path

   or

   @loadjsonschemagenWithSN sys_user sys_password host port service_name jar_path

   where the value of jar_path is:

   c:\SQL_Developer_home\sqldeveloper\extensions\oracle.dmt.dataminer\lib

Installing JSON Parser Locally on the Database Host

You can install JSON parser locally on a database host by using the scripts loadjsonschemagen.sql, validateODMRSYS.sql, org.glassfish.javax.json.jar, and JSONSchemaGenerator.jar.

To install JSON parser locally on a database host:

1. Copy the scripts loadjsonschemagen.sql and validate ODMRSYS.sql from:

   \SQL_Developer_home\sqldeveloper\dataminer\scripts

   to the database host computer staging directory. For example, /scratch.

2. Copy org.glassfish.javax.json.jar and JSONSchemaGenerator.jar from:

   \SQL_Developer_home\sqldeveloper\extensions\oracle.dmt.dataminer\lib

   to the database host computer staging directory. For example, /scratch.

3. Go to the host computer staging directory. For example, /scratch and start SQL*Plus as SYS:

   SQLPLUS sys / as sysdba

4. Run either the SID or Service Name version of the script.

See Also:

"About the Scripts for Installing JSON Support" for more information about how to run the scripts for installing the JSON parser.