2 Installing Oracle Data Mining

This chapter is intended for anyone who wishes to install Oracle Data Mining and its client interfaces on a personal computer or laptop running Microsoft Windows.

Note:

For production installations of Oracle Database with Oracle Data Mining, refer to the installation instructions for your platform.

See the "Installing and Upgrading" page of the Oracle Database Online Documentation Library:

http://www.oracle.com/pls/db112/homepage

This chapter contains the following sections:

Install Oracle Database

Oracle Data Mining is an option to Oracle Database Enterprise Edition. To perform data mining activities, you must be able to log on to an Oracle database, and your user ID must have the database privileges described in Chapter 4.

The instructions in this section explain how to perform a basic installation of Oracle Database Enterprise Edition on Microsoft Windows. Instructions for creating a starter database are included.

Important:

These instructions are not intended as a replacement for Oracle Database installation documentation. If you have questions, if you encounter problems during the installation, or if you already have Oracle components installed on your PC, refer to:

For a high level introduction to Oracle Database installation and configuration, see:

Additional documentation is available on the "Installing and Upgrading" page of the Oracle Database 11g Online Documentation Library:

http://www.oracle.com/pls/db112/homepage

  1. Before you begin the installation, ensure that your computer meets the system requirements described in Oracle Database Installation Guide for Microsoft Windows.

    Note:

    If your computer uses Dynamic Host Configuration Protocol (DHCP), you may need to install a loopback adapter to assign a local IP address to your computer.

    See Oracle Database Installation Guide for Microsoft Windows for instructions.

  2. Log on to your computer as a member of the Administrator's group. If you are unsure if your user ID is in the Administrator's group, check User Accounts in Windows Control Panel.

  3. Stop any Oracle services that may be running on your computer.

    In Windows Control Panel, choose Administrative Tools, then Services. Find the service names that start with "Oracle". Choose Stop for each one.

    Note:

    To stop an Oracle database, first stop the database service (OracleServiceservice_name), then stop the database listener (OracleOraDb11g_homeTNSListener).
  4. To start the installation, run SETUP.EXE from the Database installation directory.

    Oracle Universal Installer opens and displays the Configure Security Options page. Type your My Oracle Support email address. Click Next.

    Description of orainst1of11.gif follows
    Description of the illustration orainst1of11.gif

  5. In the Download Software Updates box, type your My Oracle Support credentials if you want to automatically download software updates. Click Next.

    Description of orainst2of11.gif follows
    Description of the illustration orainst2of11.gif

  6. On the Select Installation Option page, choose Create and configure a database.

    Description of orainst3of10.gif follows
    Description of the illustration orainst3of10.gif

    Note:

    If you choose Install database software only instead of Create and configure a database, you may choose which database options you want to include in the installation. If you do not choose the Data Mining option during installation, you can enable it later. See "Enable or Disable the Data Mining Option" for instructions.
  7. On the System Class page, choose Desktop Class then Next.

    Description of orainst4of9.gif follows
    Description of the illustration orainst4of9.gif

  8. On the Typical Install Configuration page, specify the following information about the installation:

    • Oracle Base — Specify a base directory for Oracle products on this computer. If this directory does not exist, the Installer will create it.

      Oracle base is the root of the Oracle directory tree. It may contain multiple Oracle home directories. By convention, Oracle base is referred to as ORACLE_BASE.

    • Software LocationThe Installer provides a Software Location under ORACLE_BASE. This will be the home directory for this installation of Oracle Database. If this directory does not exist, the Installer will create it. If the directory does exist, make sure that it is empty.

    • Database File Location — The Installer provides a Database File Location under ORACLE_BASE. This directory will hold the data files for the starter database. If this directory does not exist, the Installer will create it. If the directory does exist, make sure that it is empty.

    • Database Edition — Choose Enterprise Edition.

    • Global Database Name — Specify a unique name for the starter database.

      The Global Database name is the fully–qualified name of the database: for example, dbname.us.oracle.com. Specify a unique name for dbname that is not more than eight characters.

    • Administrative Password — Specify a password for the database system accounts SYS and SYSTEM. The password should have at least eight characters and include both alphabetic and numeric characters.

      You will have the opportunity to change the passwords at a later time.

    • Confirm Password — Re–enter the administrative password.

    Description of orainst5of9.gif follows
    Description of the illustration orainst5of9.gif

    Note:

    To obtain information about any of the items on this page, drag the cursor from right to left over the item. A tooltip that describes the item will appear.

    After you have provided the information, click Next.

  9. The Installer analyzes your computer to determine if you have the resources needed for the installation. If the prerequisite checks are successful, click Next. If not, click Fix and Check Again.

    Description of orainst6of9.gif follows
    Description of the illustration orainst6of9.gif

  10. On the Summary page, click Install.

    Description of orainst7of9.gif follows
    Description of the illustration orainst7of9.gif

  11. The Install Product page displays the progress of the installation.

    Description of orainst8of9.gif follows
    Description of the illustration orainst8of9.gif

  12. Once the software has been copied to your computer, the Database Configuration Assistant creates and starts the starter database.

    Description of orainst_configassist.gif follows
    Description of the illustration orainst_configassist.gif

  13. The Database Configuration Assistant displays summary information about the starter database.

    At the bottom of the page is a note about passwords for the starter database. Choose Password Management if you wish to reset the administrative passwords or unlock any other accounts that are available in the database. By default the SYS and SYSTEM accounts are unlocked.

    Note:

    If you wish to use Oracle sample data or the Oracle Data Mining sample programs, unlock the SH account.

    See Chapter 7 for information about the sample programs.

    Description of orainst_pswdunlock.gif follows
    Description of the illustration orainst_pswdunlock.gif

    Click OK to return to the Database Configuration Assistant page. Click OK to return to Oracle Universal Installer.

  14. On the Finish page, click Close.

  15. Now the database is running and ready to accept connections.

  16. If you stopped any Oracle services before running Oracle Universal Installer, you can restart them at this time.

    In Windows Control Panel, choose Administrative Tools, then Services. Find the service names that start with "Oracle". Choose Start for each one.

    Note:

    To restart an Oracle database, first restart the listener (OracleOraDb11g_homeTNSListener), then restart the database service (OracleServiceservice_name).

Verify the Data Mining Installation

If you wish to verify that Oracle Data Mining is present and functioning properly in the database, you can execute a few simple commands at the SQL command line. A set of commands is provided for this purpose in Appendix A.

You can perform this verification without installing or downloading any additional software.

Enable or Disable the Data Mining Option

The Data Mining option is enabled by default during installation of Oracle Database. However, you can choose to disable Data Mining and other database options when you install the database software. (See step 6 of Install Oracle Database.)

If you wish to enable or disable a database option for an Oracle home, you can use the command-line utility chopt.

chopt [ enable | disable ] db_option_name

Set db_option_name. to dm for the Data Mining option.

To enable the Data Mining option: 

  1. Shut down the database.

    srvctl stop database -d db_name
    
  2. Stop the database service, OracleServiceSID, using the Services program in Control Panel.

  3. Execute these commands.

    cd ORACLE_HOME/bin
    chopt enable dm
    
  4. Start the database service, Oracle ServiceSID, using the Services program in Control Panel.

  5. Start up the database.

    srvctl start database -d db_name
    

To disable the Data Mining option: 

  1. Shut down the database.

    srvctl stop database -d db_name
    
  2. Stop the database service, OracleServiceSID, using the Services program in Control Panel.

  3. Execute these commands.

    cd ORACLE_HOME/bin
    chopt disable dm
    
  4. Start the database service, Oracle ServiceSID, using the Services program in Control Panel.

  5. Start up the database.

    srvctl start database -d db_name
    

See Also:

Oracle Database Installation Guide for Microsoft Windows for more information about chopt

Optionally Install Oracle Database Examples

The Data Mining sample programs are installed with Oracle Database Examples. The installation process copies the Data Mining sample programs, along with examples and demonstrations of other database features, to the \RDBMS\demo subdirectory of Oracle home.

Note:

You only need to install Oracle Database Examples if you wish to use the sample programs. If you do not wish to install the sample programs, you can skip this section.

See Also:

Oracle Database Examples Installation Guide for complete installation instructions

Chapter 7 for information about the Oracle Data Mining sample programs

To install Database Examples, perform these steps:

  1. Ensure that your computer meets the system requirements described in Oracle Database Examples Installation Guide.

  2. Stop any Oracle services that may be running on your computer.

    In Windows Control Panel, choose Administrative Tools, then Services. Find the service names that start with "Oracle". Choose Stop for each one.

    Note:

    To stop an Oracle database, first stop the database service (OracleServiceservice_name), then stop the database listener (OracleOraDb11g_homeTNSListener).
  3. To start the installation, go to the Examples installation directory and run SETUP.EXE.

    Oracle Universal Installer displays the Specify Install Location page. Specify the Oracle base and Oracle home provided in the database software installation (step 8).

    Do not assume that the directories displayed by the Installer are correct.

    Click Next.

Optionally Install Oracle Data Miner

Instructions for downloading and installing Oracle Data Miner are available at http://www.oracle.com/technetwork/database/options/odm/dataminerworkflow-168677.html. Additional details are available in the online help for Oracle Data Miner.

Note:

Installation of Oracle Data Miner is not required. Oracle Data Mining supports a comprehensive SQL-based API and a Spreadsheet Add-In that supports limited data mining capabilities in Microsoft Excel.

See Oracle Data Mining User's Guide for an introduction to the SQL and PL/SQL interfaces to Oracle Data Mining.

Optionally Install the Spreadsheet Add–In

The Oracle Spreadsheet Add–In for Predictive Analytics adds predictive analytics features to Microsoft Excel. Using simple "one click" data mining for PREDICT, EXPLAIN, PROFILE, and EXPORT/IMPORT operations, you can mine data stored in Excel or in an Oracle database.

Note:

Installation of the Spreadsheet Add-In is not required. Oracle Data Mining supports a comprehensive SQL-based API as well as a full-featured graphical interface, Oracle Data Miner.

See Oracle Data Mining User's Guide for an introduction to the SQL and PL/SQL interfaces to Oracle Data Mining.

See Also:

Oracle Data Mining Concepts for information about Oracle predictive analytics

Spreadsheet Add–In: Requirements

The Spreadsheet Add-In requires the following:

  • Access to an instance of Oracle Database installed with the Data Mining option.

  • A user ID with the privileges described in Chapter 4.

  • Microsoft Excel 2000 or later.

  • Oracle Objects for OLE and Oracle Net Configuration Assistant.

    To obtain these components, Oracle Client must be present on the computer where Excel and the Spreadsheet Add–In are installed. For Oracle Client installation instructions, see Chapter 3.

  • An Oracle Net Service Name for the database connection. Instructions for creating an Oracle Net Service Name are provided in Chapter 3.

Spreadsheet Add–In: Install Steps

To install Oracle Spreadsheet Add–In for Predictive Analytics:

  1. Ensure that your system meets the requirements described in "Spreadsheet Add–In: Requirements".

  2. Download the Spreadsheet Add–In from the Oracle Data Mining Web site at http://www.oracle.com/technetwork/database/options/odm/odm-pred-analytics-addin-092973.html.

  3. Open the zip file and extract the files to the Microsoft Office Library directory, which has a path such as this one:

    C:\Program Files\Microsoft Office\Office\Library
    

    The zip file contains the following files:

    • Predictive_Analytics.xla if you have Microsoft Excel 2000, 2002, or 2003

    • Predictive_Analytics_2007.xla if you have Microsoft Excel 2007

    • PAhelp.chm, the help file for the Spreadsheet Add–In

    • A readme (which you can copy to the directory of your choosing).

  4. Open Excel and click Tools > Add–Ins. Select Oracle Predictive Analytics from the Add–Ins dialog box.

    Description of addin1.gif follows
    Description of the illustration addin1.gif

    Note:

    If the Spreadsheet Add–In was previously installed on your computer, uncheck Oracle Predictive Analytics and click OK to close the Add–Ins dialog. Then reopen the dialog and check the Oracle Predictive Analytics box.
  5. The OraclePA menu is added to the Excel toolbar.

  6. Although the Add–In may use data stored in Excel or in Oracle Database, a connection to Oracle Database is required. For instructions, see "Connect the Spreadsheet Add–In".

Start Data Mining in Excel

Although the Spreadsheet Add–In may use data stored in Excel or in Oracle Database, a connection to Oracle Database is always required. Once you have created the connection, you can use the PREDICT, EXPLAIN, PROFILE, and export/import operations provided by the Add–In.

To create the connection and install the Add–In in Excel, follow the instructions in "Connect the Spreadsheet Add–In".

Note:

The first time you use the Add–In, you will be prompted to provide the path to the Java executable. Specify the full path of jdk\bin\java.exe under Oracle home.

For the installation described in "Install Oracle Database", the path would be:

C:\app\myuser\product\11.2.0\dbhome_1\jdk\bin\java.exe