Oracle Support Master Note for Oracle Data Mining

++++++++++++++++++++++++++++++++++++++++++++++++++++
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 11.2.0.1 - Release: 10.1 to 11.2
Information in this document applies to any platform.

Purpose

This article is intended to assist finding the information for the most frequently asked questions, and point to the solutions for frequent issues.

Scope and Application

.

Master Note for Oracle Data Mining

CONCEPT

General Information

Oracle Data Mining product home on OTN

Oracle Data Miner

Oracle Data Mining Java API JDeveloper Extension

Oracle Spreadsheet Add-In for Predictive Analytics

Documentation - Licensing

 

Data Mining as an option in the Oracle Database (11.2, 11.1, 10.2, 10.1)

Feature Availability by Edition (11.2, 11.1, 10.2, 10.1)

Documentation - Guides, References

Administrator's Guide, Application Developer's Guide, Concepts, API Reference (11.2, 11.1, 10.2, 10.1)

DBMS_DATA_MINING package in PL/SQL Packages & Types Reference (11.2, 11.1, 10.2, 10.1)

Data Mining Functions in SQL Language Reference (11.2, 11.1, 10.2)

HOW TO

Installation

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)

Installing Oracle Data Mining Java API JDeveloper Extension

Note 420791.1 How To Manually Install Data Mining (versions 9.2.0.1 - 11.2.0.1)

Note.749821.1 How To Install The Database 11g Examples

De-Installation

Note 297551.1 How To Remove the Data Mining Option from the Database (versions 9.2.0.1 - 11.1.0.7)

Usability

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

TROUBLESHOOTING

Invalid objects, Data Mining component invalid in the dba_registry

Starting 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 727201.1 Data Mining Invalid After Revoking EXECUTE Permissions On SYS.UTL_FILE / SYS.UTL_HTTP

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

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

News and Troubleshooting tips for Oracle Database and Enterprise Manager

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today