2 Installing the Oracle Database Software

This chapter is intended for anyone who wishes to install Oracle Data Mining 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/db111/db111.homepage

This chapter contains the following sections:

Install Oracle Database
Verify the Data Mining Installation
Install Oracle Database Examples
Install Oracle Data Miner
Install the Spreadsheet Add–In

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.

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:

Oracle Database Installation Guide for Microsoft Windows

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

Oracle Database 2 Day DBA

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

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

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.
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.
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).
To start the installation, run SETUP.EXE from the Database installation directory.

Oracle Universal Installer opens and displays the Select Installation Option page.

Description of the illustration db1of9.gif

Choose Create and Configure a Database. This will cause the Installer to launch Oracle Database Configuration Assistant once the software has been installed. Database Configuration Assistant will create a starter database.

Click Next.
The Installer displays the System Class page.

Description of the illustration db2of7.gif

Select Desktop Class. Click Next.
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. (See "Conventions" for more information.)
- Software Location — The 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.
  
  By convention, Oracle home is referred to as ORACLE_BASE\ORACLE_HOME. (See "Conventions" for more information.)
- 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 the illustration db3of7.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.

Description of the illustration db3of7tooltip.gif

After you have provided the information, click Next.
The Installer analyzes your computer to determine if you have the resources needed for the installation. It displays the results on the Perform Prerequisite Checks page. If the prerequisite checks are successful, click Next. If not, click Fix and Check Again.

Description of the illustration db4of7.gif

Click Next.
The Summary page displays information about the installation.

Description of the illustration db5of7.gif

Click Finish.
The Install Product page displays the progress of the installation.

Description of the illustration db6of7.gif

When the installation is complete, click Finish.
Once the software has been copied to your computer, the Database Configuration Assistant creates and starts the starter database.

Description of the illustration dbconfigassist1.gif
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 provided with 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 the illustration dbconfigassist3.gif

Click OK to return to the Database Configuration Assistant page. Click OK to return to Oracle Universal Installer.
On the Finish page, click Close.
Now the database is running and ready to accept connections.

To verify that the Data Mining option is enabled, type the following in SQL*Plus:
```
SQL>SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Data Mining';

VALUE
------------------------------------------------------------------
TRUE 
```
If this SQL query returns TRUE, then the Data Mining option is enabled.

See Also:
Chapter 3 to learn how to connect to the database using SQL*Plus and other client tools.
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.

See:

Appendix A, "Verifying Your Data Mining Installation"

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.

Install Oracle Data Miner

Oracle Data Miner is a graphical tool for developing data mining models within Oracle Database. You can deploy the models from within Oracle Data Miner or from SQL or Java. You can use the Oracle Data Miner Code Generators to capture data mining activities as code for deployment in external applications.

Data Miner: Requirements

Oracle Data Miner requires the following:

Access to an instance of Oracle Database with the Data Mining option.
A user ID with the privileges described in Chapter 4.
Java JDK version 1.5 or greater.

To check the version of Java on your system, you can execute the following at the command prompt:
```
> java -version
```
SQL*Loader is required if you wish to import data from text files. SQL*Loader is installed with Oracle Client. See Chapter 3.

Data Miner: Installation Steps

To install Oracle Data Miner:

Ensure that your system meets the requirements described in "Data Miner: Requirements".
Go to the Oracle Data Miner page on the Oracle Technology Network:

http://www.oracle.com/technology/products/bi/odm/odminer.html

You will find the following available for download:
- Oracle Data Miner
- Oracle Data Miner Tutorial
- Oracle Data Miner PL/SQL Code Generator for JDeveloper
- Oracle Data Miner PL/SQL Code Generator for SQL Developer
Download Oracle Data Miner and unzip to a new, empty directory. The zip file includes a readme.
If you wish to use the tutorial, download and unzip the file. The zip file includes sample data, a readme, and the tutorial PDF.
If you wish to use the code generators, follow the installation instructions in the Oracle Data Miner readme.

Start Oracle Data Miner

To start Oracle Data Miner:

Navigate to the bin subdirectory of the Oracle Data Miner installation directory.
Double click odminerw.exe to launch Oracle Data Miner.
Note:
The first time you start Oracle Data Miner, 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\demotest\product\11.2.0\db_1\jdk\bin\java.exe
```
Note:
The odminer.exe executable, also in the bin subdirectory, displays a console window that can be used for troublshooting.
Follow the instructions in "Connect Oracle Data Miner".

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 Oracle Database.

Predictive analytics provides automated methodologies that simplify data mining.

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:

Ensure that your system meets the requirements described in "Spreadsheet Add–In: Requirements".
Download the Spreadsheet Add–In from the Oracle Data Mining Web site at http://www.oracle.com/technology/products/bi/odm/index.html.
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).
Open Excel and click Tools > Add–Ins. Select Oracle Predictive Analytics from the Add–Ins dialog box.

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.
The OraclePA menu is added to the Excel toolbar.
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\demotest\product\11.2.0\db_1\jdk\bin\java.exe