Oracle Support Master Note for Oracle Data Mining
By LajosV-Oracle on Sep 01, 2010
The complete and the most recent version of this article can be viewed
from My Oracle Support Knowledge Section.
Master Note for Oracle Data Mining (Doc ID 1087643.1)
Applies to:Oracle Data Mining - Version: 10.1.0.2 to 188.8.131.52 - Release: 10.1 to 11.2
Information in this document applies to any platform.
Documentation - Licensing
Documentation - Guides, References
The Oracle Data Mining Option is installed by default with Oracle Database Enterprise Edition.
The Oracle Data Mining Administrators Guide (refer to the Documentation section above) tells how to install a database and set up a user account.
Installing Data Miner (10.2 - Oracle by Example tutorial)
Note 420791.1 How To Manually Install Data Mining (versions 184.108.40.206 - 220.127.116.11)
Note.749821.1 How To Install The Database 11g Examples
Note 297551.1 How To Remove the Data Mining Option from the Database (versions 18.104.22.168 - 22.214.171.124)
The ODM Application Developer's Guide along with the Oracle Data Mining sample codes for various versions gets you started writing SQL- or Java-based data mining applications.
Also other Data Mining sample programs are installed with Oracle Database Examples. (Instructions for installing Database Examples and using the ODM sample programs are in the ODM Administrator's Guide.)
Demonstrations / Viewlets (real life examples including text mining, buyer attribute importance, fraud prediction).
Data Mining Algorithms (a short introduction to the data mining algorithms).
Performance Improvement of Model Building in Oracle 11.1 Data Mining (white paper, May 2008)Oracle Data Mining Frequently Asked Questions (FAQ) (written for 10g, provides answers to frequently asked overview and technical questions.)
Invalid objects, Data Mining component invalid in the dba_registryStarting from 11g, ODM, Oracle Data Mining component is not necessarily appear in the dba_registry even if the Oracle Data Mining is installed into the database. In 11g the Data Mining repository is moved under the SYS schema, and no longer has a dedicated schema (e.g. DMSYS in 10g) for it. In case upgrading from earlier version to 11g, once you verified that the Data Mining upgrade is complete (see documentation), you can drop the DMSYS schema from the database. Once DMSYS is removed, the dba_registry will no longer list Oracle Data Mining as a component.
Generic approach to diagnose invalid database objects is discussed in the following note:
NOTE 300056.1 Debug and Validate Invalid Objects
Usually invalid Data Mining objects or component mean improper installation of the Data Mining specific objects into the database. Re-Installing the Data Mining objects into the database manually (see Installation section above) often eliminates the problem.
Other known issues include the following:
Note 373157.1 Data Mining Component Becomes Invalid After EBS Database Upgrade (from version 10.1 to 10.2)
Note 731454.1 Invalid Objects in DMSYS after EBS Database Upgrade (from version 9i to 10.2)
Note 727867.1 PLS-00201: identifier 'DBMS_RANDOM' must be declared When Compiling Invalid Data Mining Objects
Note 378159.1 Oracle Text breaks if Data Mining is deinstalled