Setting Up Oracle Data Miner 11g Release 2

Purpose

This tutorial covers the process of setting up Oracle Data Miner 11g Release 2 for use within Oracle SQL Developer 3.0.

Time to Complete

Approximately 15 mins.

Overview

The Oracle Data Miner graphical user interface (GUI) is included as a free extension of Oracle SQL Developer, version 3.0. In order to use the Oracle Data Miner GUI to perform data mining, you must complete the following three setup tasks:

  1. Create a database user account for data mining
  2. Create a database connection within SQL Developer for the data miner user
  3. Install the Oracle Data Miner Repository

Notes:

Prerequisites

Before starting this tutorial, you should:

1.

Have access to or have Installed Oracle Database 11g Enterprise Edition, Release 2 (11.2.0.1) with Data Mining Option.

 

2.

Have access to or have installed Oracle SQL Developer, version 3.0, or later.

Note: SQL Developer does not have an installer. To install SQL Developer, just unzip the free SQL Developer download to any directory on your PC.

 

3 .

Have access to the following database information for the SYS user:

  • Password
  • Database port number
  • Database SID (Service ID) value

Note: You will need this information in order to install the Oracle Data Miner Repository.

 

Setting Up Oracle Data Miner 11g Release 2

In the following topics, you perform the steps required to set up Oracle Data Miner 11g Release 2 for use within SQL Developer 3.0.

Important: As stated above, you need the SYS user credentials in order to install the Oracle Data Miner Repository . In addiiton, you will use the SYS user to create a database user account for data mining purposes.

Create a Data Miner User Account

SQL Developer is a client to the Oracle Database software. Before you can perform actions such as creating a user, you must connect to the database from SQL Developer.

To connect to the database, you will define an administrative (SYS) connection in SQL Developer, and then use that connection to create the data miner user.

Perform the following steps.

1.

To open SQL Developer, double-click sqldeveloper.exe in the directory where you unzipped SQL Developer.

For example, double-click C:\SQLDev\sqldeveloper.exe, as shown below:

Show Screenshot for Step

Notes:

  • If you are prompted to import settings from an earlier version, click Yes if you have been using an earlier version of SQL Developer and want to preserve those settings.
  • If you wish, create a shortcut to C:\SQLDev\sqldeveloper.exe and move it to your desktop.

 

2.

In the the SQL Developer Connections tab, right-click Connections and select New Connection from the pop-up menu.

Show Screenshot for Step

Result: The New / Select Database Connection dialog box appears.

Notes:

  • Your SQL Developer interface may also display the Reports tab next to the Connections tab.
  • In this lesson, we have already closed the SQL Developer Reports tab.


3.

In the New / Select Database Connection dialog box:

A. Enter the following parameters:

  • Connection Name: admin
  • Username: sys
  • Password: The Administrative password for your database
  • Connection Type: Basic
  • Role: SYSDBA
  • Hostname: The host name of your database server (localhost if the database is installed on your PC)
  • Port: Enter the apropriate port number (1521 is the default)
  • SID: The name of SID for your database (orcl the default)

Show Screenshot for Step

B. Click Test to test the connection.

Note: If the connection is successful, Status (just above the Help button) changes to "Success!"

C. Click Connect to save the connection and to also establish a connection to the database.

 

4 .

Next, create an account for data mining.

A. In the SQL Developer Connections tab, drill on the admin connection.

B. Then, right-click the Other Users node and select Create User from the pop-up menu, like this:

Show Screenshot for Step

C. In the Create/Edit User window, select the User tab and specify a username, password, default tablespace, and temporary tablespace for the user account. In the example below, the parameters include:

  • User Name: dmuser
  • Password: Create a password of your choice
  • Default Tablespace: USERS
  • Temporary Tablespace: TEMP

Note: Your available tablespaces may differ if you are using an existing database that does not have the standard default tablespaces.

Show Screenshot for Step

D. Still in the Create/Edit User window, select the Roles tab and click the check box in the Granted Column for CONNECT.

Show Screenshot for Step

E. Still in the Create/Edit User window, select the Quotas tab and click the check box to set Tablespace to Unlimited (for the default tablespace).

Show Screenshot for Step

F. Click Apply to create the account.

Note: The Results tab displays the following:

Show Screenshot for Step

E. Click Close to dismiss the Create/Edit User window.

 

Create a SQL Developer Connection for the Data Miner User

In this topic, you create a SQL Developer connection for the data miner user.

You can create this connection either by using the SQL Developer Connections tab or the Data Miner tab. In either case, the same New / Edit Database Connection dialog box appears. All saved SQL Developer connections appears in both tabs.

Follow these steps to create a connection for the data miner user:

1 .

In the SQL Developer Connections tab, right-click the Connections node and select New Connection from the pop-menu.

Show Screenshot for Step

 

2 .

In the New / Select Database Connection dialog box, specify the following parameters:

  • Connection Name: dmuser
  • Username: dmuser
  • Password: Enter the password that you created for the data miner user
  • Connection Type: Basic
  • Role: default
  • Host Name: Enter the appropriate host name for your database server
  • Port: Enter the apropriate port number (1521 is the default)
  • SID: Enter the approriate value (orcl the default)

Note: If you wish to avoid prompts for passwords, you can select the Save Password option.

Show Screenshot for Step

 

3 .

Still in the New / Select Database Connection dialog box:

A. Click Test to test the Connection.

Result: The Status prompt should display "Success!"

B. Click Connect.

Result: The SQL Developer Connections tab now displays both connections, like this:

Show Screenshot for Step

Note: When you activate a connection from the SQL Developer Connections tab, a SQL Developer Worksheet window automatically opens for that user.


4 .

Close both the dmuser and admin Worksheet windows, like this:

Show Screenshot for Step

Next, you will install the Data Miner Repository.

 

Install the Data Miner Repository

At this stage, you have created a database account for the data miner user (dmuser), and have created a SQL Developer connection for that user. Next, you install the Data Miner Repository in the database using an automated process.

To accomplish this, you simply display the Oracle Data Miner tab ( which looks similar to the SQL Developer Connections tab), and then connect to the data miner user from the Data Miner tab.

Notes:

Follow these steps:

1.

From the SQL Developer menu, select View > Data Miner > Data Miner Navigator, as shown here:

Show Screenshot for Step

Result: The Data Miner tab appears below the SQL Developer Connections tab.

Show Screenshot for Step

 

2.

Dismiss the SQL Developer Connections tab by clicking the Close (X) icon, like this:

Show Screenshot for Step

Result: The Data Miner tab now appears directly below the SQL Developer main menu.

Show Screenshot for Step

 

3 .

To begin the installation process of the Data Miner Repository:

A. Double-click on dmuser (and not the admin user).

Result: A message tells you that the Data Miner Repository is not installed in the database, and asks you if you want to install the Repository.

Show Screenshot for Step

B. Click Yes to launch the installation process.


4 .

In the Connection Information dialog box:

A. Enter the Administrative password for the database.

Show Screenshot for Step

Note: You must be logged in as SYS to install the repository.

B. Click OK to continue.

 

5 .

In the Repository Installation Settings dialog box:

A. Select the Default Tablespace and the Temporary Tablespace for the repository account named ODMRSYS.

Show Screenshot for Step

Notes:

  • The initial space requirement for the Data Miner Repository is 200MB; however, the tablespace grows as metadata is added.
  • In our example, we select the default values, which are USERS for Default Tablespace and TEMP for Temporary Tablespace.

B. Click OK to display the Install Data Miner Repository dialog box.

 

6 .

In the Install Data Miner Repository dialog box:

  • The Install Demo Data option is preselected (the demo data is used by subsequent Oracle Data Miner OBE tutorials).

Show Screenshot for Step

A. Click Start to begin the repository installation.

Notes:

  • The Installation takes approximately 10 minutes for remote database installations and 2 minutes for local database installations.
  • The scroll bar provides a visual indication of the installation process progress, as shown below.

Show Screenshot for Step

B. When the installation completes, click Close to dismiss the dialog box.


You are now ready to perform data mining with the dmuser account. You can begin with the tutorial Using Oracle Data Miner 11g Release 2.

Summary

In this lesson, you learned how to set up the Oracle Data Miner graphical user interface for use within SQL Developer, version 3.0.

Resources

To learn more about Oracle Data Mining:

Curriculum Developer: Brian Pottle

Technical Contributors: Charlie Berger, Mark Kelly, Margaret Taft, Kathy Talyor

Hardware and Software Engineered to Work Together About Oracle |Oracle and Sun | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Your Privacy Rights