Follow these steps to install the data mining sample programs:
Install or obtain access to Oracle Database 12c Enterprise Edition with the Advanced Analytics option. To install the Database, see the installation instructions for your platform at http://www.oracle.com/pls/db121/homepage
.
Ensure that the sample schemas are installed in the database. The sample schemas are installed by default with Oracle Database. See Oracle Database Sample Schemas for details about the sample schemas.
Verify that Oracle Database Examples has been installed with the database, or install it locally. Oracle Database Examples loads the Database sample programs into the rdbms/demo
directory under Oracle home. See Oracle Database Examples Installation Guide for installation instructions.
Verify that a data mining user account has been created, or create it yourself if you have administrative privileges. See "Creating a Data Mining User".
Ask your system administrator to run dmshgrants.sql
, or run it yourself if you have administrative privileges. dmshgrants
grants the privileges that are required for running the sample programs. These include SELECT
access to tables in the SH
schema as described in "The Data Mining Sample Data" and the system privileges listed in Table A-1.
Pass the name of the data mining user to dmshgrants
.
SQL> CONNECT sys / as sysdba Enter password: sys_password Connected. SQL> @ $ORACLE_HOME/rdbms/demo/dmshgrants dmuser
Table A-1 System Privileges Granted by dmshgrants.sql to the Data Mining User
Privilege | Allows the data mining user to |
---|---|
|
log in to a database session |
|
create tables, such as the settings tables for |
|
create views, such as the views of tables in the |
|
create data mining models |
|
execute procedures in the |
Connect to the database as the data mining user and run dmsh.sql
. This script creates views of the sample data in the schema of the data mining user.
SQL> CONNECT dmuser
Enter password: dmuser_password
Connected.
SQL> @ $ORACLE_HOME/rdbms/demo/dmsh