OraFAQ Forum: Server Administration » Oracle Data Mining component in 19c

Home » RDBMS Server » Server Administration » Oracle Data Mining component in 19c (Oracle 19c Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Data Mining component in 19c [message #681302]

Mon, 06 July 2020 15:11

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.

Report message to a moderator

Re: Oracle Data Mining component in 19c [message #681303 is a reply to message #681302]

Tue, 07 July 2020 00:26

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Oracle Data Mining component in 19c [message #681304 is a reply to message #681303]

Tue, 07 July 2020 00:41

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

Re: Oracle Data Mining component in 19c [message #681307 is a reply to message #681306]

Tue, 07 July 2020 02:34

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 12:09:49 CST 2025