Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> I am trying to make enable Data Miner Option, Problem
AndrVerb
post Apr 4 2017, 10:17 PM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 3-April 17
Member No.: 51,880



I am trying to make enable Data Miner Option.

I used the following command: chopt

There are only the following options:

oaa = Oracle Advanced Analytics
olap = Oracle OLAP
partitioning = Oracle Partitioning
rat = Oracle Real Application Testing

Well,
I used the following variant:
chopt enable oaa

I got the following answer:
D:\app\USER\virtual\product\12.2.0\dbhome_3\bin\oradmop12.dll already exists, Skipping "move D:\app\USER\virtual\product\12.2.0\dbhome_3\bin\oradmop12.dll.dbl D:\app\USER\virtual\product\12.2.0\dbhome_3\bin\oradmop12.dll

This put me on alert. Nevertheless I continued.

I followed to the Example A-1 Commands To Verify Data Mining Installation
(https://docs.oracle.com/cd/E11882_01/datamine.112/e16807/appendix_a.htm#DMADM259)

After launching the following command:
SQL> EXEC dbms_data_mining.create_model('MAI','ATTRIBUTE_IMPORTANCE','MT',null,'T');

I got the message:
ORA-40107: operation requires Advanced Analytics option to be installed

How to cope with this problem?
Go to the top of the page
 
+Quote Post
burleson
post Apr 5 2017, 11:45 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,380
Joined: 26-January 04
Member No.: 13



Hi,

>> ORA-40107: operation requires Advanced Analytics option to be installed

Like it says, you need to install advanced analytics!

Beware, ODM is a very expensive tool.

http://www.oracle.com/technetwork/database...view/index.html

See ODM install details here:

http://www.oracle.com/technetwork/database...on-2080768.html









--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 28th April 2017 - 08:43 PM