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:

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.

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.

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.

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.

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.

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.

The Installer copies the Database Examples files to the Oracle home that you specified in step 6 of the database installation.

Click Finish.

When the installation process has completed, click Finish to exit Oracle Universal Installer.

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).

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.

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.