Oracle® Data Mining Administrator's Guide(1)

字数 22517阅读 7004评论 0赞 0

1 Installing Oracle Database for Data Mining
This chapter explains <a id="sthref11" name="sthref11"></a>how to 
install Oracle Database to support Data Mining applications and 
development. It is directed primarily at users who want to install 
Oracle Database on a personal <a id="sthref12" name="sthref12"></a>computer or laptop for their own use.
This chapter contains the following topics:
<ul><li>
<a>Who Needs to Install Oracle Database?</a>
</li><li>
<a>Understanding Oracle Universal Installer</a>
</li><li>
<a>Preparing for Installation</a>
</li><li>
<a>Installing the Data Mining Option</a>
</li><li>
<a>Installing the Data Mining Scoring Engine</a>
</li><li>
<a>Verifying Installation of Data Mining Components</a>
</li><li>
<a>Tips for Linux Installations</a>
</li><li>
<a>Upgrading from Oracle Database 10g Release 1 (10.1)</a>
</li></ul>
<div class="infoboxnote">
Note:
You should use this chapter along with your Oracle Database installation
 documentation. This chapter does not attempt to provide comprehensive 
installation instructions for Oracle Database.</div>
<a id="BABEEJJA" name="BABEEJJA"></a>
<div class="sect1"><a id="sthref13" name="sthref13"></a>
Who Needs to Install Oracle Database?
If you want to use Oracle Data Mining, then you must have access to 
Oracle Database. You may be able to access an existing installation 
instead of installing Oracle Database yourself. Contact your Oracle 
database administrator and inquire whether you can access an instance of
 Oracle Database 10g Release 2 that is operating in 10.1 or later compatibility mode.
<a id="sthref14" name="sthref14"></a>If you can access an existing installation, then ask your Oracle DBA to do the following:
<ol><li>
Install the <a id="sthref15" name="sthref15"></a>Sample Schemas, if they are not already installed.
</li><li>
Install the Data Mining demo programs, as described in <a>"Installing Oracle Database Companion"</a>.
</li><li>
Create a user name. See<a>"Creating Data Mining Users"</a> and <a>"Creating a Demo User"</a>.
</li><li>
Provide you with the connection information.
</li></ol>
Meanwhile, you can install a Data Mining client on your personal computer, as described in <a>Chapter 3</a>.
If you do not have access to an existing installation, then follow the instructions provided in this chapter for installing Oracle Database.
</div>

<a id="BABCAHHE" name="BABCAHHE"></a>
<div class="sect1"><a id="sthref16" name="sthref16"></a>
Understanding Oracle Universal Installer
<a id="sthref17" name="sthref17"></a>To install Oracle Database, you 
use Oracle Universal Installer. This installation program is nearly the 
same on all platforms, with differences that arise because of the 
differences in the operating systems. See <a>"Oracle Universal Installer"</a>
This chapter provides step-by-step instructions for using Oracle 
Universal Installer to install Oracle Database on a Microsoft Windows 
platform. If you use a different platform, you can still derive the 
preferred settings for Data Mining from these instructions. However, you
 should be careful to perform any pre- and post-installation steps 
specific to your platform, because they may be critical to a successful 
installation. Refer to the Installation Guide for your platform.
<div class="infoboxnotealso">
See Also:
<ul><li>
<a class="olink NTQIG" href="http://www.oracle.com/pls/db102/lookup?id=NTQIG">Oracle Database Quick Installation Guide for Microsoft Windows (32-Bit)</a>
</li><li>
<a class="olink NTDBI">Oracle Database Installation Guide for Microsoft Windows (32-Bit)</a>
</li><li>
<a class="olink ADMQS">Oracle Database 2 Day DBA</a>
</li></ul>
</div>
<div class="sect2"><a id="sthref18" name="sthref18"></a>
Installation Directories
<a id="sthref19" name="sthref19"></a>There are four sets of 
installation media for Oracle Database. If you download the software 
instead of installing from a physical media pack, you will create four 
separate installation directories on your <a id="sthref20" name="sthref20"></a>computer.
<ul><li>
Database: I<a id="sthref21" name="sthref21"></a>nstallation directory for Oracle Database 10g Release 2 (10.2)
</li><li>
Companion: <a id="sthref22" name="sthref22"></a>Installation directory for demo program files. See <a>Chapter 4</a>.
</li><li>
Client: Installation <a id="sthref23" name="sthref23"></a>directory for client tools. Required by <a id="sthref24" name="sthref24"></a>Oracle Spreadsheet Add-In for <a id="sthref25" name="sthref25"></a>Predictive Analytics (See <a>Chapter 3</a>).
</li><li>
Doc: <a id="sthref26" name="sthref26"></a>Installation directory for documentation
</li></ul>
</div>

<div class="sect2"><a id="sthref27" name="sthref27"></a>
Installation Methods
Oracle Universal Installer provides two methods <a id="sthref28" name="sthref28"></a>for installing the Oracle Database software:
<ul><li>
Basic: <a id="sthref29" name="sthref29"></a>This
 installation method can be accomplished quickly and requires minimal 
user input. It installs the software and optionally creates a 
general-purpose database. <a id="sthref30" name="sthref30"></a>It is the default installation method.
</li><li>
Advanced: <a id="sthref31" name="sthref31"></a>This
 installation method offers a number of choices and may take longer to 
complete. It installs the specified software components and optionally 
creates a database. You can choose a general-purpose database, or you 
can specify that the database be optimized for data warehousing or 
transaction processing.
</li></ul>
You can use either the Basic or the Advanced method to install Oracle
 Database with support for Data Mining. This chapter provides 
instructions for performing a Basic installation.
To install the Data Mining Scoring Engine, you must use the Advanced method.
</div>

<div class="sect2"><a id="sthref32" name="sthref32"></a>
Installation Types
Whether you <a id="sthref33" name="sthref33"></a>use the Basic or Advanced installation method, you can specify one of the following installation types for Oracle Database:
<ul><li>
<a id="sthref34" name="sthref34"></a>Enterprise Edition: <a id="sthref35" name="sthref35"></a>Installs licensable Oracle Database options, including Data Mining. Includes configuration and management tools in <a id="sthref36" name="sthref36"></a>addition to all of the products that are installed during a Standard Edition installation.
</li><li>
<a id="sthref37" name="sthref37"></a>Standard Edition: <a id="sthref38" name="sthref38"></a>Installs an integrated set of management tools, web features, and facilities for creating business applications.
</li><li>
<a id="sthref39" name="sthref39"></a>Personal Edition: <a id="sthref40" name="sthref40"></a>Installs Enterprise Edition software, but supports only a single user development and deployment environment.
</li><li>
<a id="sthref41" name="sthref41"></a>Custom: <a id="sthref42" name="sthref42"></a>Installs the individual components that you specify.
</li></ul>
Data Mining is only available in the Enterprise Edition. See <a>"Installing the Data Mining Option"</a>.
To install the Data Mining Scoring Engine, you must perform a Custom installation. See <a>"Installing the Data Mining Scoring Engine"</a>.
</div>

<div class="sect2"><a id="sthref43" name="sthref43"></a>
Creating a Database During Installation
Both the <a id="sthref44" name="sthref44"></a>Basic and <a id="sthref45" name="sthref45"></a>Advanced
 installation methods offer the option of creating a starter database 
during the installation process. If you choose to create a starter 
database, Oracle Universal Installer uses <a id="sthref46" name="sthref46"></a>Database Configuration Assistant (DBCA) to create it.
DBCA is an administrative tool that is provided with Oracle Database.
 If you do not create a database during the installation process, you 
can use DBCA to create it afterwards. See <a>"Database Configuration Assistant"</a>.
</div>
</div>

<a id="CIHBFCIC" name="CIHBFCIC"></a>
<div class="sect1"><a id="sthref47" name="sthref47"></a>
Preparing for Installation
Several <a id="sthref48" name="sthref48"></a>preliminary steps are required before you begin the installation process.
<ul><li>
Verify that your computer meets the minimum hardware and software requirements
</li><li>
Ensure that you have administrative privileges on your computer
</li><li>
If you have other Oracle products installed on your computer, stop the Oracle services
</li><li>
If your computer has a <a id="sthref49" name="sthref49"></a>dynamic IP address, install a <a id="sthref50" name="sthref50"></a>loopback adapter
</li><li>
If you are installing from a network drive, use Windows File Manager to map that drive to your computer.
</li></ul>
<div class="sect2"><a id="sthref51" name="sthref51"></a>
Hardware Requirements
<a id="sthref52" name="sthref52"></a>Verify that your computer meets the following requirements:
<ul><li>
Processor: 550 MHz minimum
</li><li>
Available hard disk space: 2 GB, including 125 MB temp disk space
</li><li>
RAM: 256 MB minimum, 512 MB recommended
</li><li>
Virtual memory: double the amount of RAM
</li><li>
Video adapter: 256 color
</li></ul>
</div>

<div class="sect2"><a id="sthref53" name="sthref53"></a>
Software Requirements
<a id="sthref54" name="sthref54"></a>The following operating systems are among those supported for Oracle Database:
<ul><li>
Windows XP Professional
</li><li>
Windows 2000 with service pack 1 or higher
</li></ul>
</div>

<a id="CIHICDHA" name="CIHICDHA"></a>
<div class="sect2"><a id="sthref55" name="sthref55"></a>
Preexisting Oracle Products
<a id="sthref56" name="sthref56"></a>If any Oracle products are 
already installed on your computer, you must disable them before 
installing Oracle Database. You need to stop any Oracle services that 
are currently running, and you need to delete the ORACLE_HOME 
environment variable if it is defined.
<a id="CIHBECJG" name="CIHBECJG"></a>
<div class="sect3"><a id="sthref57" name="sthref57"></a>
Stop Oracle Services
<ol><li>
<a id="sthref58" name="sthref58"></a>From the Control Panel, choose Administrative Tools, then Services.
</li><li>
On the Services page, scroll down the list of names and locate those that begin with Oracle. Select those services and choose Stop.
</li></ol>
See <a>"Oracle Services"</a> for a list of Oracle <a id="sthref59" name="sthref59"></a>services.
</div>

<div class="sect3"><a id="sthref60" name="sthref60"></a>
Delete the <a id="sthref61" name="sthref61"></a>ORACLE_HOME Environment Variable
<ol><li>
From the Control Panel, <a id="sthref62" name="sthref62"></a>choose System.
</li><li>
On the Advanced tab of the System Properties page, choose Environment Variables.
</li><li>
If ORACLE_HOME is included in the list of System Variables, select it and click Delete.
</li></ol>
</div>
</div>

<div class="sect2"><a id="sthref63" name="sthref63"></a>
Dynamic IP
Dynamic Host Configuration Protocol (<a id="sthref64" name="sthref64"></a>DHCP) assigns <a id="sthref65" name="sthref65"></a>dynamic
 IP addresses on a network. Dynamic addressing allows a computer to have
 a different IP address each time it connects to the network.
If you plan to install Oracle Database on a computer that uses the 
DHCP protocol, you need to install a loopback adapter to assign a local 
IP address to your computer.
You can determine if a <a id="sthref66" name="sthref66"></a>loopback 
adapter is already installed on your Windows computer by opening a 
command window, navigating to the system drive (typically c:), and 
executing the following command.
ipconfig /all

You can find complete instructions for installing a loopback adapter in the <a class="olink NTDBI">Oracle Database Installation Guide for Microsoft Windows (32-Bit)</a>
</div>
</div>

<a id="CIHFCJIJ" name="CIHFCJIJ"></a>
<div class="sect1"><a id="sthref67" name="sthref67"></a>
Installing the Data Mining Option
<a id="sthref68" name="sthref68"></a>The simplest w<a id="sthref69" name="sthref69"></a>ay to install Oracle <a id="sthref70" name="sthref70"></a>Database is to perform a Basic installation. This installation method provides the Data Mining <a id="sthref71" name="sthref71"></a>option and the sample schemas by default.
<a id="sthref72" name="sthref72"></a>Follow these <a id="sthref73" name="sthref73"></a>steps to perform a Basic installation with a starter database on a Windows platform:
<ol><li>
Check the pre-installation requirements described in <a>"Preparing for Installation"</a>.
</li><li>
Logon as Administrator.
</li><li>
From the Database installation directory, run SETUP.EXE.
Oracle Universal Installer opens and displays the Select Installation Method page. Choose Basic Installation. Specify the Oracle <a id="sthref74" name="sthref74"></a>home directory. Choose Enterprise Edition as the Installation Type. Check the Create Starter Database box. Provide a global database name and a password for the system accounts.
<div class="infoboxnote">
Note:
You will have the opportunity to change the passwords for the system accounts at a later time.</div>
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install1.gif" alt="basic database installation: first screen" title="basic database installation: first screen" height="505" width="647" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install1.gif" alt="basic database installation: first screen" title="basic database installation: first screen" height="505" width="647" ></a> </li><li>
On the Product-Specific Prerequisite Checks page, verify that all 
checks succeeded. If any checks failed, then you must correct the 
problem before proceeding.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install2.gif" alt="basic database installation: second screen" title="basic database installation: second screen" height="523" width="646" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install2.gif" alt="basic database installation: second screen" title="basic database installation: second screen" height="523" width="646" ></a> </li><li>
The Summary page displays the settings and components for the installation. Click the Install button to proceed.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install3.gif" alt="basic database installation: third screen" title="basic database installation: third screen" height="523" width="646" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install3.gif" alt="basic database installation: third screen" title="basic database installation: third screen" height="523" width="646" ></a> </li><li>
The Installer proceeds with the installation.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install4.gif" alt="basic database installation: fourth screen" title="basic database installation: fourth screen" height="523" width="646" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install4.gif" alt="basic database installation: fourth screen" title="basic database installation: fourth screen" height="523" width="646" ></a> </li><li><a id="CIHEFCDA" name="CIHEFCDA"></a>
After installing the software, the Installer invokes the Configuration Assistants to create the starter database.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install5.gif" alt="basic database installation: fifth screen" title="basic database installation: fifth screen" height="523" width="646" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install5.gif" alt="basic database installation: fifth screen" title="basic database installation: fifth screen" height="523" width="646" ></a> </li><li>
The <a id="sthref75" name="sthref75"></a>Database Configuration Assistant copies <a id="sthref76" name="sthref76"></a>the files for the <a id="sthref77" name="sthref77"></a>starter database.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install6.gif" alt="basic database installation: DBCA create starter database" title="basic database installation: DBCA create starter database" height="425" width="575" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install6.gif" alt="basic database installation: DBCA create starter database" title="basic database installation: DBCA create starter database" height="425" width="575" ></a> </li><li>
The Database Configuration Assistant displays information about the starter database. Click the Password Management
 button. Unlock the DMSYS account and any other accounts that you plan 
to use. If you plan to use the demo programs, you must unlock the SH 
account. Click OK.
<div class="infoboxnotealso">
Tip:
In the Password Management dialog, you can specify new passwords for the system accounts.</div>
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install7.gif" alt="basic database installation: DBCA complete starter database" title="basic database installation: DBCA complete starter database" height="375" width="550" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_db_install7.gif" alt="basic database installation: DBCA complete starter database" title="basic database installation: DBCA complete starter database" height="375" width="550" ></a> </li><li>
The final screen displays the URLs for <a id="sthref78" name="sthref78"></a>Enterprise Manager <a id="sthref79" name="sthref79"></a>Database Control and for <a id="sthref80" name="sthref80"></a>iSQL*Plus. See <a>"Remote Administration"</a>.
Tip: Print a screen shot of this page or write down the information it contains for future reference.
Click Exit to exit the Installer.
</li></ol>
Upon completion, the Installer displays the login page for the Database Control.
You can verify your Data Mining installation by querying the V$OPTION view, as described in <a>"Verifying Installation of Data Mining Components"</a>.
<div class="infoboxnote">
Note:
In <a id="sthref81" name="sthref81"></a><a id="sthref82" name="sthref82"></a><a id="sthref83" name="sthref83"></a><a id="sthref84" name="sthref84"></a><a id="sthref85" name="sthref85"></a><a id="sthref86" name="sthref86"></a>Oracle Database 10.1, Data Mining was installed in <a id="sthref87" name="sthref87"></a>ORACLE_HOMEdm. In Oracle 10g Release 2 (10.2), Data Mining is installed in ORACLE_HOMERDBMS.</div>
<a id="CIHGHDHE" name="CIHGHDHE"></a>
<div class="sect2"><a id="sthref88" name="sthref88"></a>
Adding the Data Mining Option to a Database
<a id="sthref89" name="sthref89"></a>Once you have installed the 
Oracle Database software, you can build databases as needed. You might 
build a database without the Data Mining option but later decide to add 
it. To add the <a id="sthref90" name="sthref90"></a>Data Mining option, use <a id="sthref91" name="sthref91"></a>Database Configuration Assistant (DBCA).
Follow these steps:
<ol><li>
Logon as Administrator.
</li><li>
Stop any Oracle services that are currently running. See <a>"Stop Oracle Services"</a>.
</li><li>
Open DBCA from the Windows Start menu.
Click Start > Programs > Oracle– oracle_home > Configuration and Migration Tools > Database Configuration Assistant.
The Welcome page appears. <a id="sthref92" name="sthref92"></a>Click Next.
</li><li>
Choose Configure Database Options.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_dbca1.gif" alt="DBCA: add data mining option" title="DBCA: add data mining option" height="448" width="686" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_dbca1.gif" alt="DBCA: add data mining option" title="DBCA: add data mining option" height="448" width="686" ></a> </li><li>
Choose the database to configure, and provide system credentials.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_dbca2.gif" alt="DBCA: select database to configure" title="DBCA: select database to configure" height="448" width="686" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_dbca2.gif" alt="DBCA: select database to configure" title="DBCA: select database to configure" height="448" width="686" ></a> </li><li>
Select Oracle Data Mining. Select <a id="sthref93" name="sthref93"></a>Sample Schemas, if the samples are not already installed and you wish to run the demo programs.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_dbca_components.gif" alt="DBCA: select data mining and sample schemas to add" title="DBCA: select data mining and sample schemas to add" height="496" width="593" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_dbca_components.gif" alt="DBCA: select data mining and sample schemas to add" title="DBCA: select data mining and sample schemas to add" height="496" width="593" ></a> </li><li>
Specify dedicated or shared server mode. Click the Finish button.
</li></ol>
</div>

<div class="sect2"><a id="sthref94" name="sthref94"></a>
Removing the Data Mining Option
You can use <a id="sthref95" name="sthref95"></a>Oracle Universal <a id="sthref96" name="sthref96"></a>Installer to remove components of an Oracle installation.If you wish to deinstall the Data Mining option, take these steps:
<ol><li>
Logon as Administrator.
</li><li>
Stop any Oracle <a id="sthref97" name="sthref97"></a>services that are currently running. (See <a>"Stop Oracle Services"</a>.)
</li><li>
Open Universal Installer from the Windows Start menu.
Click Start > Programs > Oracle– oracle_home > Oracle Installation Products > Universal Installer.
</li><li>
On the Welcome page, click Deinstall Products.
</li><li>
In the Inventory box, choose Oracle Data Mining RDBMS Files and click Remove.
</li><li>
Oracle Universal Installer removes the Data Mining option and returns to the Inventory page. Click Close. To exit the Installer, click Cancel.
</li></ol>
</div>
</div>

<a id="CIHFHJEJ" name="CIHFHJEJ"></a>
<div class="sect1"><a id="sthref98" name="sthref98"></a>
Installing the Data Mining Scoring Engine
<a id="sthref99" name="sthref99"></a>The Data Mining Scoring Engine 
scores data using models that were created by Oracle Data Mining. You 
should only install the Data Mining <a id="sthref100" name="sthref100"></a>Scoring
 Engine on computers where you intend to apply models that were built on
 another computer system. For information on importing models from 
another database, see <a>"Exporting and Importing Data Mining Models"</a>.
The Scoring Engine is an Enterprise Edition component that can be installed only during a <a id="sthref101" name="sthref101"></a>Custom installation.
<div class="infoboxnote">
Note:
In most cases, you will find no advantage in installing the Scoring 
Engine. The Data Mining option, which is included by default in Oracle 
Database Enterprise Edition, provides the full range of data mining 
functionality, including model scoring.
The Data Mining option and the Scoring Engine are mutually exclusive.
 When you install one, you automatically deinstall the other. Oracle 
Data Mining is the only database option affected by installation of the 
Scoring Engine.
</div>
<a id="CIHCIDBA" name="CIHCIDBA"></a>
<div class="sect2"><a id="sthref102" name="sthref102"></a>
Performing a Custom Installation
Follow <a id="sthref103" name="sthref103"></a>these steps to start the installation of Oracle Database with the Data Mining Scoring Engine:
<ol><li>
Review <a>"Preparing for Installation"</a>.
</li><li>
Logon as Administrator.
</li><li>
From the Database installation directory, run SETUP.EXE.
Oracle Universal Installer opens <a id="sthref104" name="sthref104"></a>and displays the Select Installation Method page. Choose Advanced Installation and click Next.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_score_install1.gif" alt="advanced database installation: first screen" title="advanced database installation: first screen" height="505" width="647" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_score_install1.gif" alt="advanced database installation: first screen" title="advanced database installation: first screen" height="505" width="647" ></a> </li><li>
On the Select Installation Type page, choose Custom. Click Next.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_score_install2.gif" alt="advanced database installation: choose custom" title="advanced database installation: choose custom" height="523" width="646" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_score_install2.gif" alt="advanced database installation: choose custom" title="advanced database installation: choose custom" height="523" width="646" ></a> </li><li>
On the Specify Home Details page, specify the location of a new Oracle home directory.
</li><li>
On the Available Product Components page, select Data Mining Scoring Engine along with the other components to include in your database. Click Next to continue the installation process.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_score_install3.gif" alt="custom database installation: choose data mining scoring engine" title="custom database installation: choose data mining scoring engine" height="523" width="646" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_score_install3.gif" alt="custom database installation: choose data mining scoring engine" title="custom database installation: choose data mining scoring engine" height="523" width="646" ></a> </li></ol>
</div>

<div class="sect2"><a id="sthref105" name="sthref105"></a>
Adding the Scoring Engine to an Existing Installation
To add the <a id="sthref106" name="sthref106"></a>Data Mining Scoring Engine to an existing installation of Oracle Database, take these steps:
<ol><li>
Logon as Administrator.
</li><li>
Stop any Oracle services that are currently running. (See <a>"Stop Oracle Services"</a>.) .
</li><li>
Open Oracle Universal Installer from the Windows Start menu.
Click Start > Programs > Oracle– oracle_home > Oracle Installation Products > Universal Installer.
</li><li>
Choose Advanced for the installation method and Custom for the installation type.
</li><li>
On the Specify Home Details page, select the Oracle home directory in which you previously installed Oracle Database 10g Release 2 (10.2). Do not rely on the default setting to be correct.
</li><li>
On the Available Product Components page, select Data Mining Scoring Engine. Click Next to continue the installation process.
</li></ol>
</div>

<a id="CIHCGGAI" name="CIHCGGAI"></a>
<div class="sect2"><a id="sthref107" name="sthref107"></a>
Removing the Scoring Engine
If you wish to deinstall the <a id="sthref108" name="sthref108"></a>Scoring Engine, take these steps.
<ol><li>
Logon as Administrator.
</li><li>
Stop any Oracle services that are currently running. (See <a>"Stop Oracle Services"</a>.)
</li><li>
Open Universal Installer from the Windows Start menu.
Click Start > Programs > Oracle– oracle_home > Oracle Installation Products > Universal Installer.
</li><li>
On the Welcome page, click Deinstall Products.
</li><li>
In the Inventory box, choose Data Mining Scoring Engine and click Remove.
Note that Oracle Data Mining RDBMS Files is a separate component. It is not removed when you remove the Scoring Engine.
<a class="example-image-link" href="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_score_remove.gif" alt="database installation inventory" title="database installation inventory" height="565" width="409" data-lightbox="example-set"><img class="example-image" src="file:///D:/oracle/10.2/%E5%AE%98%E6%96%B9%E6%96%87%E6%A1%A3/datamine.102/b14338/img/ch1_score_remove.gif" alt="database installation inventory" title="database installation inventory" height="565" width="409" ></a> </li><li>
Oracle Universal Installer removes the Scoring Engine and returns to the Inventory page. Click Close. To exit the Installer, click Cancel.
</li></ol>
</div>
</div>

<a id="BABEFHGC" name="BABEFHGC"></a>
<div class="sect1"><a id="sthref109" name="sthref109"></a>
Verifying Installation of Data Mining Components
To verify the<a id="sthref110" name="sthref110"></a> status of Data Mining in your database, <a id="sthref111" name="sthref111"></a>start SQL*Plus and log in as SYSDBA.
If Data Mining is installed, then the following SQL query returns TRUE.
SELECT VALUE FROM <a id="sthref112" name="sthref112"></a>V$OPTION WHERE PARAMETER = 'Data Mining';

If the Data Mining Scoring Engine is installed, then the next SQL query returns TRUE.
SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Data Mining <a id="sthref113" name="sthref113"></a>Scoring Engine';

For more detailed information, query <a id="sthref114" name="sthref114"></a>DBA_REGISTRY with a command such as this one.
SQL> SELECT COMP_ID, VERSION, STATUS FROM DBA_REGISTRY WHERE COMP_ID = 'ODM';
 
COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
ODM 10.2.0.0.0 VALID
</div>

<a id="BABCEGGC" name="BABCEGGC"></a>
<div class="sect1"><a id="sthref115" name="sthref115"></a>
Tips for Linux Installations
<a id="sthref116" name="sthref116"></a>The step-by-step<a id="sthref117" name="sthref117"></a> instructions in <a id="sthref118" name="sthref118"></a>this guide <a id="sthref119" name="sthref119"></a>are for installations on a Windows platform. The following are some tips <a id="sthref120" name="sthref120"></a>to help you with the differences between the Linux and Windows platforms.
<ul><li>
Follow the instructions in the installation guide for your platform. 
Be sure to set system variables and perform any other pre-installation 
tasks.
</li><li>
During the installation, you must run some SQL scripts as root, so make sure that you have root access.
</li><li>
<a id="sthref121" name="sthref121"></a>To run Oracle Universal Installer, type runInstaller from the installation disk or directory.
</li><li>
<a id="sthref122" name="sthref122"></a>Create a script for setting 
the appropriate environment variables, or include the settings in the 
initialization script for your operating system login (such as .profile or .cshrc). Perform any other post-installation tasks.
<a id="sthref123" name="sthref123"></a>The following is a sample script for setting environment variables:
setenv ORACLE_ROOT /dat1/10gR2
setenv ORACLE_BASE ${ORACLE_ROOT}
setenv ORACLE_HOME ${ORACLE_BASE}/oracle/product/10.2.0/db_1
setenv ORACLE_PORT 1521
setenv ORACLE_SID rel10g
setenv TNS_ADMIN ${ORACLE_HOME}/network/admin
setenv PATH ${ORACLE_HOME}/bin:${ORACLE_HOME}:$PATH
</li></ul>
<div class="infoboxnotealso">
See Also:
<ul><li>
<a class="olink LADQI">Oracle Database Quick Installation Guide for Linux x86</a> for a basic installation
</li><li>
<a class="olink LADBI">Oracle Database Installation Guide for Linux x86</a> for a custom installation, upgrade, or other variation
</li></ul>
</div>
</div>

<a id="BABDCAHG" name="BABDCAHG"></a>
<a id="sthref124" name="sthref124"></a>
Upgrading from Oracle Database 10g Release 1 (10.1)
<a id="sthref125" name="sthref125"></a>If Oracle Database 10g Release 1 is installed on your computer, then install Oracle Database 10g
 Release 2 into a separate Oracle home. A new version of the Data Mining
 option is installed along with the other components of Oracle Database.
During installation of release 10.2, Oracle Universal Installer will 
detect 10.1 databases and will prompt you to upgrade them. For 
upgrading, the Installer will open the Database Upgrade Assistant 
(DBUA). It automatically upgrades these Data Mining components:
<ul><li>
Databases
</li><li>
DMSYS repository schema
</li><li>
PL/SQL data models in user schemas
</li></ul>
<div class="infoboxnotealso">
See Also:
Oracle Database Upgrade Guide for complete upgrade instructions</div>
<div class="sect2"><a id="sthref126" name="sthref126"></a>
Post-Upgrade Steps for Data Mining
The data mining objects in these schemas require additional upgrade steps after upgrading the database:
<ul><li>
DMSYS Repository Schema. The odmu101s.sql script removes redundant release 10.1 objects.
</li><li>
User Schemas. The odmu101a.sql script re-creates the 
views of the Sales History sample schema for users who wish to run the 
Data Mining demo programs described in <a>Chapter 4</a>.
</li></ul>
To upgrade the DMSYS repository, follow these steps:
<ol><li>
Open SQL*Plus and connect to the database as the SYS user or another privileged account.
</li><li>
Verify that the compatibility mode is set to 10.2.x.x (such as 10.2.0.0).
SELECT name, value, description FROM v$parameter
 WHERE name='compatible';

If the compatibility model is incorrect, then edit the init.ora file for the database.
</li><li>
Run the odmu101s.sql script.
Issue this command on Windows platforms:
%ORACLE_HOME%rdbmsadminodmu101s.sql

Or this command on Linux platforms:
$ORACLE_HOME/rdbms/admin/odmu101s.sql

</li></ol>
To upgrade the Sales History demo views in the schemas of Data Mining users, take these steps for each schema:
<ol><li>
Backup the schema using the expdp command in Oracle Data Pump.
</li><li>
Open SQL*Plus and connect to the database as the SYS user or another privileged account.
</li><li>
Run the odmu101a.sql script, passing it two parameters: user_name and password.
Issue this command on Windows platforms:
%ORACLE_HOME%rdbmsadminodmu101a.sql user_name password

Or this command on Linux platforms:
$ORACLE_HOME/rdbms/admin/odmu101a.sql user_name password
</li></ol>
</div>

<div class="sect2"><a id="sthref127" name="sthref127"></a>
Upgrading PL/SQL Models
All data mining PL/SQL models residing in user schemas in a release 
10.1 database can be upgraded as part of the database upgrade. The 
upgrade of models is seamlessly integrated into the database upgrade 
process.
You can also export models from a release 10.1 database and import 
them into a release 10.2 database. The import process upgrades the 
models to release 10.2. Use the expdp and impdp
 command utilities in Oracle Data Pump. The Data Mining option or the 
Data Mining Scoring Engine option must be installed in the target 
database.
<div class="infoboxnote">
Note:
Java models cannot be upgraded. They must be re-created in Oracle Database 10.2.</div>
The Database Upgrade Assistant invokes procedures in the Data Mining DMP_SYS public package for upgrading and downgrading PL/SQL models between release 10.1 and 10.2.
The UPGRADE_MODELS procedure upgrades the Data Mining models from release 10.1 to 10.2, and has this syntax:
UPGRADE_MODELS (
 to_version IN VARCHAR2);

The DOWNGRADE_MODELS procedure downgrades models from release 10.2 to 10.1, and has this syntax:
DOWNGRADE_MODELS (
 from_version IN VARCHAR2);

These procedures are integrated with the Data Mining upgrade and downgrade processes and run as SYS. You do not need to run them manually.
</div>

<div class="sect2"><a id="sthref128" name="sthref128"></a>
Downgrading Oracle Data Mining
<a id="sthref129" name="sthref129"></a>You can downgrade a database from release 10.2 to release 10.1 if the compatibility setting is set to 10.1.x.x.
 Otherwise, the database will include incompatibilities that will 
prevent it from being downgraded. The Data Mining option and user-owned 
PL/SQL models will be downgraded as part of database downgrade.
<div class="infoboxnotealso">
See Also:
Oracle Database Upgrade Guide for complete downgrade instructions</div>
</div>

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

Oracle® Data Mining Administrator's Guide(1)

添加新评论0 条评论

作者其他文章