This tutorial covers the process of setting up Oracle Data Miner 11g Release 2 for use within Oracle SQL Developer 3.0.
Approximately 15 mins.
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:
Notes:
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:
Note: You will need this information in order to install the Oracle Data Miner Repository.
|
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.
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: Notes:
|
---|---|
2. |
In the the SQL Developer Connections tab, right-click Connections and select New Connection from the pop-up menu. Result: The New / Select Database Connection dialog box appears. Notes:
|
3. |
In the New / Select Database Connection dialog box: A. Enter the following parameters:
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: 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:
Note: Your available tablespaces may differ if you are using an existing database that does not have the standard default tablespaces. D. Still in the Create/Edit User window, select the Roles tab and click the check box in the Granted Column for CONNECT. 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). F. Click Apply to create the account. Note: The Results tab displays the following: E. Click Close to dismiss the Create/Edit User window.
|
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:
|
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: Result: The Data Miner tab appears below the SQL Developer Connections tab.
|
---|---|
2. |
Dismiss the SQL Developer Connections tab by clicking the Close (X) icon, like this: Result: The Data Miner tab now appears directly below the SQL Developer main menu.
|
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. B. Click Yes to launch the installation process.
|
4 . |
In the Connection Information dialog box: A. Enter the Administrative password for the database. 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. Notes:
B. Click OK to display the Install Data Miner Repository dialog box.
|
6 . |
In the Install Data Miner Repository dialog box:
A. Click Start to begin the repository installation. Notes:
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.
In this lesson, you learned how to set up the Oracle Data Miner graphical user interface for use within SQL Developer, version 3.0.
To learn more about Oracle Data Mining:
Curriculum Developer: Brian Pottle
Technical Contributors: Charlie Berger, Mark Kelly, Margaret Taft, Kathy Talyor
About Oracle |Oracle and Sun | | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Your Privacy Rights | |