installodmr
script.Oracle Data Miner installation refers to installation of the Oracle Data Miner repository in an Oracle Database. The repository serves as application manager and workflow storage manager for Oracle Data Miner.
To install Oracle Data Miner:
Install Oracle Database. If you already have a database, verify that it meets the requirements.
Download SQL Developer.
Check the topic Prerequisites for Oracle Data Miner in Oracle Data Miner Release Notes
Install the Oracle Data Miner repository. You can use SQL Developer or you can run scripts to perform the installation.
Oracle Data Miner contains sample data that includes tables and views.
Note:
The SH sample schema is not shipped with Oracle Database 12.2. To install the sample schema, go to DB Sample Schemas.MINING_DATA_BUILD_V, MINING_DATA_TEST_V, MINING_DATA_APPLU_V:
These are views based on tables in the SH
schema. This data is used in Oracle Data Mining sample programs, as described in Oracle Data Mining Application Developer’s Guide and Oracle Data Mining Administrator’s Guide.
MINING_DATA_TEXT_BUILD_V, MINING_DATA_TEXT_TEST_V, MINING_DATA_TEXT_APPLU_V:
These are views based on tables in the SH
schema. The views include an additional COMMENTS
column that is used in text mining examples in OBEs and in Data Mining sample programs.
ODMR_CARS_DATA:
This is sample data about US automobiles, for experimenting with the Graph node.
INSUR_CUST_LVT_SAMPLE:
This is sample data used by the Oracle By Example (OBE) tutorials for Data Mining.
ODMR_SALES_JSON_DATA:
This is sample sales data for experimenting with the JSON query node in Oracle Database 12.1.0.2 and later.
ODMR_MINING_DATA_TEXT, ODMR_SALES_DATA:
This is sample data that can be used as a partial replacement, if SH schema is not easily available. It is loaded when Oracle Data Miner demo data is installed, without SH dependencies.
WIKISAMPLE:
This is sample data to demonstrate the Explicit Feature Extraction node.
Related Topics
Oracle SQL Developer is available for download free of charge from the Oracle Technology Network.
To install SQL Developer, simply download and unzip it on your system. SQL Developer does not include an installation program.
To download SQL Developer:
Go to the Downloads tab of the Oracle SQL Developer home page:
Select the documentation links to view the Release Notes, a list of new features, and the SQL Developer Documentation Library.
Note:
The documents in the Documentation Library are available for online viewing or for download in PDF, Mobi (for Kindle), or ePub (for iBook) format. You can bookmark the Documentation Library page for ease of access:
Select the installation instructions for your platform and follow the instructions to download and start SQL Developer.
Note:
SQL Developer requires the Java Development Kit (JDK) version 1.7 or later. If the JDK is not included in the SQL Developer software download bundle and you do not have it installed on your system, then you must download and install it separately.
The SQL Developer installation instructions include a link to the JDK download page.
The first time you start SQL Developer, you must supply the path to the JDK.
Related Topics
You can install the Oracle Data Miner repository by running the installodmr
script.
Note:
For Oracle Database 11.2.0.4 or later, the default tablespace for the repository must have auto
specified for segment space management.
To install the Oracle Data Miner repository:
Log in to the database with DBA role.
Run the installodmr
script.
installodmr.sql default_tablespace temp_tablespace
For example, if you have set the default search path, then the following statement installs the repository with default tablespace USERS
and temporary tablespace TEMP
:
@installodmr USERS TEMP
When the database is remote and the repository is using XML DB object-relational storage, the installation script takes approximately ten minutes to run. When the database is remote and the repository is using binary storage (Oracle Database 11.2.0.4 and later), the installation completes in approximately three minutes.
Note:
After installing the repository, you must enable Oracle Data Miner access for at least one database user.
After you install the repository using a script, you can run a second script to load the sample data that is used in Oracle Data Miner tutorials.
If you install the repository by using the SQL Developer GUI, then you can install the sample data by checking a check box.
The instDemoData
script prepares demo data for an Oracle Data Miner user. The script grants access to the data described. If the SH
schema is not present in the database, then the script prepares only the demo data that does not depend on SH
.
To install the Oracle Data Miner sample data for a user:
Log in to the database with DBA role.
Verify that the SH
schema is present in the database.
Run the instDemoData
script:
instDemoData.sql user
For example, if you have set the default search path, then the following statement installs the sample data for the user dmuser1
:
@instDemoData dmuser1
To drop the sample data for a user:
Log in to the database with DBA role.
Run the dropDemoData
script:
dropDemoData.sql user
For example, if you have set the default search path, then the following statement drops the sample data for the user dmuser1
:
@dropDemoData dmuser1
You can install the Oracle Data Miner repository using the SQL Developer graphical user interface.
In the Connections tab of SQL Developer, select an administrative connection to the target database, or create a new one.
Create an Oracle Data Miner user:
Drill on the administrative connection.
Right click Other Users and choose Create User.
Grant the CONNECT
role to the user, and for Default Tablespace, specify Unlimited Quota.
In the Connections tab, create a connection for the Oracle Data Miner user.
From the View menu, select Data Miner, and then Data Miner Connections.
The Data Miner Connections tab appears beneath the SQL Developer Connections tab.
Click the plus sign on the Data Miner tab to display the Select Connection dialog box. Choose the Data Miner user from the drop-down list.
The new connection appears on the Data Miner tab.
When you attempt to drill on the new connection, this dialog box is displayed:
Click Yes to install the repository.
After you provide the password, information about the repository is displayed. For example:
Figure 3-2 Repository Installation Settings
Click OK.
The Repository Installation Settings dialog box appears.
Select the Install Demo Data check box to install the sample data in the schema of the user connection. If the SH
schema is present in the database, then all sample data is installed. If SH
is not installed, then only ODMR_CARS_DATA
, INSUR_CUST_LVT_SAMPLE
, ODMR_SALES_JSON_DATA
ODMR_MINING_DATA_TEXT, ODMR_SALES_DATA,
and WIKISAMPLE
(Database 12.1 only) are installed.
Note:
The SH sample schema is not shipped with Oracle Database 12.2. To install the sample schema, go to DB Sample Schemas.Note:
The repository installation automatically grants the database privileges required by Oracle Data Miner.
The privileges required by Oracle Data Miner are different from the privileges required for using the Oracle Data Mining APIs directly.
When the installation is complete, click Close.
JSON query processing is available in Oracle Database 12.1.0.2 and later.
In Oracle Database 12.2 and later, you do not have to install the JSON parser as Oracle Data Miner uses the JSON parser provided by the database.
Note:
If you have installed or migrated the repository using scripts, then separate postinstallation step to enable JSON support in Oracle Data Miner is not required.Note:
You must have JVM installed in the Oracle Database.To verify if Oracle JVM is installed in the Oracle Database, run this query:
select * from registry$ where cid like '%JAVA%'
loadjsonschemagen.sql
and loadjsonschemagenWithSN.sql
install the JSON parser and schema generator for Oracle Data Miner.loadjsonschemagen
or loadjsonschemagenWithSN
scripts.loadjsonschemagen.sql
, validateODMRSYS.sql
, org.glassfish.javax.json.jar
, and JSONSchemaGenerator.jar.
Related Topics
To install JSON parser and the schema generator for Oracle Data Miner, two scripts are available.
The only difference between the two scripts in their arguments is that one accepts the Oracle SID, the other accepts the Oracle Service Name. You can choose the script that best suits your database installation. If you are using a pluggable database, then the Oracle Service Name is required.
Note:
You must use the SYS account to run these scripts.loadjsonschemagen.sql
uses the Oracle SID.
loadjsonschemagen.sql sysuser syspassword host port SID jar_path
loadjsonschemagenWithSN.sql
uses the Oracle Service Name.
loadjsonschemagenWithSN.sql sysuser syspassword host port service_name jar_path
org.glassfish.javax.json.jar
JSONSchemagenerator.jar
The scripts loadjsonschemagen.sql
and loadjsonschemagenWithSN.sql
install the JSON parser and schema generator for Oracle Data Miner.
To run the scripts, ensure the following requirements:
The jar_path argument must be a directory that is accessible to the current database system.
The Oracle database command-line utilities loadjava
and dropjava
must be available on the system where the script is run.
select * from registry$ where cid like '%JAVA%'
Sample output:
JAVAVM JServer JAVA Virtual Machine 0 0 12.1.0.2.0
CATJAVA Oracle Database Java Packages 0 0 12.1.0.2.0
You can install JSON support in a remote database by running the loadjsonschemagen
or loadjsonschemagenWithSN
scripts.