Home » RDBMS Server » Server Administration » Oracle Data Mining component in 19c (Oracle 19c Linux)
Oracle Data Mining component in 19c [message #681302] Mon, 06 July 2020 15:11 Go to next message
mar20
Messages: 2
Registered: July 2020
Junior Member
I am having trouble to install the "Oracle Data Mining" component in our new 19c db server.

Previously we can do this by running the dminst.sql script in rdbms/admin but this file no longer exists in 19c.

Can someone help to point me in the right direction how to add the "Oracle Data Mining" component in 19c that shows up in dba_registry?

Thanks.
Re: Oracle Data Mining component in 19c [message #681303 is a reply to message #681302] Tue, 07 July 2020 00:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

Re: Oracle Data Mining component in 19c [message #681304 is a reply to message #681303] Tue, 07 July 2020 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Oracle® Data Mining, Chapter 8 Administrative Tasks for Oracle Data Mining, section 8.1 Installing and Configuring a Database for Data Mining

Quote:
Oracle Data Mining is a component of the Oracle Advanced Analytics option to Oracle Database Enterprise Edition.
To install Oracle Database, follow the installation instructions for your platform. Choose a Data Warehousing configuration during the installation.

Database Installation Guide for Linux

[Updated on: Tue, 07 July 2020 00:41]

Report message to a moderator

Re: Oracle Data Mining component in 19c [message #681306 is a reply to message #681304] Tue, 07 July 2020 01:58 Go to previous messageGo to next message
mar20
Messages: 2
Registered: July 2020
Junior Member
Hi Michael, thank you for your replies.

I saw that link too, but not sure if that means "Oracle Data Mining" is no longer a component in Oracle 19c EE?

Do you know what would be the component name that shows up in dba_registry which implies that Data Mining is active?

I can see OLAP Analytic Workspace and Oracle OLAP API, does this mean Data Mining is already active?

Sorry 19c is new for me, the full version is 19.3.0.0 EE btw.
Re: Oracle Data Mining component in 19c [message #681307 is a reply to message #681306] Tue, 07 July 2020 02:34 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From Database Licensing Information User Manual, section 1.14 Oracle Database Options and Their Permitted Features:

Quote:
Oracle Machine Learning (formerly Advanced Analytics)
Included option: SE2, EE, EE-ES, DBCS SE, DBCS EE, DBCS EE-HP, DBCS EE-EP, ExaCS
Oracle Machine Learning includes the following features:
    In-database algorithms for Oracle Machine Learning for SQL (OML4SQL) (formerly Oracle Data Mining):
        Model build (accessed via the DBMS_DATA_MINING package)
        Data transformations (accessed via the DBMS_DATA_MINING_TRANSFORM package)
        Model scoring (accessed via SQL Scoring functions)
        Predictive Analytics (accessed via the DBMS_PREDICTIVE_ANALYTICS package)
...

You can see the installed options in v$option view.
You can also use McOptions.

Previous Topic: Wrongly compile function in SYS user now problem
Next Topic: no listener
Goto Forum:
  


Current Time: Thu Mar 28 06:27:43 CDT 2024