2 Installing the Database to Support Oracle Data Miner
- Database Requirements for Oracle Data Miner
Oracle Data Miner 18.3 and later requires Oracle Database Enterprise Edition or Personal Edition 11.2.0.4 or later. - Oracle Text and Oracle Data Miner
Oracle Data Miner uses Oracle Text to support text mining. Oracle Text is included by default in Oracle Database Enterprise Edition and is required for installation of Oracle Data Miner. - XML DB and Oracle Data Miner
Oracle Data Miner uses XML DB to store workflows in the Oracle Data Miner repository. XML DB is typically included in Oracle Database Enterprise Edition and is required for installation of Oracle Data Miner. - Storage Configuration for Oracle Data Miner
The storage format used by Oracle Data Miner depends on the database version. - Installing Oracle Database 11.2.0.4 or Later
To install Oracle Database, follow the installation instructions for your platform and all additional instructions. - Connecting to an Oracle Cloud Database Schema
You can connect to an Oracle Cloud Database schema from SQL Developer interface.
2.1 Database Requirements for Oracle Data Miner
Oracle Data Miner 18.3 and later requires Oracle Database Enterprise Edition or Personal Edition 11.2.0.4 or later.
To verify that the database meets this requirement, query the database_compatible_level
setting. The value should be no lower than 11.2.
SELECT VALUE FROM database_compatible_level;
Note:
Some features of Oracle Data Miner 18.3 and later require Oracle Database 12.2 and later.
Table 2-1 lists the Database installation and configuration requirements for Oracle Data Miner.
Table 2-1 Database Requirements Checklist for Oracle Data Miner
Feature | Requirement | Links to More Information |
---|---|---|
Database version |
11.2.0.4 or later. |
|
Required for Oracle Data Miner installation. |
||
Required for Oracle Data Miner installation. |
||
Storage Configuration |
Must be configured for either binary XML storage or object-relational storage, depending on the version of the database. |
|
Required to support multibyte character data and other data formats Oracle highly recommends that you configure the database to support |
Oracle Database 19c: Oracle Database Globalization Support Guide Oracle Database 18c: Oracle Database Globalization Support Guide Oracle Database 12.2: Oracle Database Globalization Support Guide Oracle Database 12.1: Oracle Database Globalization Support Guide |
|
Required for execution of embedded R scripts in the Oracle Data Miner SQL Query node. |
Oracle Machine Learning for R Installation and Administration Guide |
|
Required for Oracle Data Miner sample data. May be required for Oracle Text Knowledge Base. |
Oracle Database 19c: Oracle Database Examples Installation Guide Oracle Database 18c: Oracle Database Examples Installation Guide Oracle Database 12.2: Oracle Database Examples Installation Guide |
|
Required for some Oracle Data Miner sample data. |
Oracle Database 12.2: The SH sample schema is not shipped with Oracle Database 12.2. To install the sample schema, go to Oracle Database Sample Schemas Oracle Database 12.1: Oracle Sample Database Sample Schemas |
Related Topics
Parent topic: Installing the Database to Support Oracle Data Miner
2.2 Oracle Text and Oracle Data Miner
Oracle Data Miner uses Oracle Text to support text mining. Oracle Text is included by default in Oracle Database Enterprise Edition and is required for installation of Oracle Data Miner.
Oracle Text Knowledge Base is required to support theme generation during text transformation. If you want to support this feature of Oracle Text and it is not already available in the Database, then you can obtain it with an installation of Oracle Database Examples. The Oracle Text Knowledge Base is available in English and French.
Related Topics
Parent topic: Installing the Database to Support Oracle Data Miner
2.3 XML DB and Oracle Data Miner
Oracle Data Miner uses XML DB to store workflows in the Oracle Data Miner repository. XML DB is typically included in Oracle Database Enterprise Edition and is required for installation of Oracle Data Miner.
To determine if XML DB is present in the database, or to manually install XML DB, follow the instructions in Oracle XML DB Developer’s Guide
Workflow documents in the Oracle Data Miner repository are of type XMLType
, an abstract data type that provides these storage models:
-
Object-relational storage:
XMLType
data is stored as a set of objects. -
Binary XML storage:
XMLType
data is stored in a post-parse, binary format specifically designed for XML data.
Oracle Data Miner uses object-relational storage in earlier versions of the Database and binary XML storage in later versions.
Related Topics
Parent topic: Installing the Database to Support Oracle Data Miner
2.4 Storage Configuration for Oracle Data Miner
The storage format used by Oracle Data Miner depends on the database version.
With Oracle Database 11.2.0.4 and later, Oracle Data Miner uses binary XML storage.
With binary storage, a tablespace allocation of 200MB can store approximately 1000 moderately complex workflows (about 35 nodes). To use binary storage, ODMRSYS
must be created in a tablespace managed with Automatic Segment Space Management (ASSM).
The following statement shows how to create an Oracle ASSM tablespace:
CREATE TABLESPACE DMUSER_AUTO DATAFILE 'DMUSER_AUTO.dat' size 20m
autoextend on next 32m maxsize UNLIMITED extent management local
AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;
Related Topics
Parent topic: Installing the Database to Support Oracle Data Miner
2.5 Installing Oracle Database 11.2.0.4 or Later
To install Oracle Database, follow the installation instructions for your platform and all additional instructions.
Installation instructions and all additional instructions are specified in the topic Database Requirements for Oracle Data Miner.
Links to some Oracle Database Installation guides are listed as follows:
-
Linux:
- Oracle Database 19c: Oracle Database Installation Guide for Linux
-
Oracle Database 18c: Oracle Database Installation Guide for Linux
-
Oracle Database 12.2: Oracle Database Installation Guide for Linux
-
Oracle Database 12.1: Oracle Database Installation Guide for Linux
-
Oracle Database 11.2.0.4: Oracle Database Installation Guide for Linux
-
Oracle Solaris:
- Oracle Database 19c: Oracle Database Installation Guide for Oracle Solaris
-
Oracle Database 18c: Oracle Database Installation Guide for Oracle Solaris
-
Oracle Database 12.2: Oracle Database Installation Guide for Oracle Solaris
-
Oracle Database 12.1: Oracle Database Installation Guide for Oracle Solaris
-
Oracle Database 11.2: Oracle Database Installation Guide for Oracle Solaris
-
Microsoft Windows:
-
Oracle Database 12.2: Oracle Database Installation Guide for Microsoft Windows
-
Oracle Database 12.1: Oracle Database Installation Guide for Microsoft Windows
-
Oracle Database 11.2.0.4: Oracle Database Installation Guide for Microsoft Windows
-
To install Oracle Database on other platforms, search the Oracle Help Center for your platform-specific installation instructions.
Related Topics
Parent topic: Installing the Database to Support Oracle Data Miner
2.6 Connecting to an Oracle Cloud Database Schema
You can connect to an Oracle Cloud Database schema from SQL Developer interface.
See Also:
For more information about how to create or edit a connection to an Oracle Cloud Database Schema Service instance, see Oracle SQL Developer User's Guide.Related Topics
Parent topic: Installing the Database to Support Oracle Data Miner