My Oracle Support Banner

Advanced Analytics/Data Mining Not Working In Database 19 Standard Edition (Doc ID 2769584.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Advanced Analytics/Data Mining Not Working In Database 19 Standard Edition


Below steps are executed to enable Analytics/Data Mining

  

chopt enable oaa

STARTUP UPGRADE

SQL>@$ORACLE_HOME/rdbms/admin/catodm.sql

SQL>@$ORACLE_HOME/rdbms/admin/dbmsodm.sql

SQL>@$ORACLE_HOME/rdbms/admin/prvtodm.plb

SQL>SHU IMMEDIATE

SQL>STARTUP

 

However, the Analytics and Data Mining options remain OFF.

SQL> select parameter, value from v$option where parameter in ('Data Mining','Oracle Database Vault','Oracle Label Security', 'OLAP','Partitioning','Real Application Testing', 'Advanced Analytics');

PARAMETER VALUE
------------------------------ -----
Partitioning FALSE
Oracle Label Security FALSE
OLAP FALSE
Advanced Analytics FALSE
Oracle Database Vault FALSE
Real Application Testing FALSE
Data Mining FALSE

Below command is generating errors


BEGIN
  DBMS_DATA_MINING.CREATE_MODEL(
  model_name => 'MD_GLM_MODEL',
  mining_function => DBMS_DATA_MINING.REGRESSION,
  data_table_name => 'VW_MATCHA_KUND',
  case_id_column_name => 'ID',
  target_column_name => 'DONE',
  settings_table_name => 'SETTINGS_GLM');
END;

Error report -
ORA-40107: Operation Requires Data Mining Option To Be Installed

ORA-06512: vid "SYS.DBMS_DATA_MINING", rad 355
ORA-06512: vid "SYS.DBMS_DATA_MINING", rad 605
ORA-06512: vid "SYS.DBMS_DATA_MINING", rad 564


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.