Oracle Data Miner 18.1 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.1 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 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. |
||
|
Required for Oracle Data Miner sample data. May be required for Oracle Text Knowledge Base. |
Oracle Database 18c: Oracle Database Examples Oracle Database 12.2: Oracle Database Examples Installation Guide Oracle Database 12.1: 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
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.
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
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
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 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 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
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