{"id":305,"date":"2015-07-21T07:55:15","date_gmt":"2015-07-21T07:55:15","guid":{"rendered":"http:\/\/blog.tiran.info\/?p=305"},"modified":"2017-12-05T14:17:04","modified_gmt":"2017-12-05T13:17:04","slug":"installation-de-oracle-data-miner-4-0","status":"publish","type":"post","link":"https:\/\/blog.tiran.stream\/?p=305","title":{"rendered":"Installation de Oracle Data Miner 4.0"},"content":{"rendered":"

Oracle Data Miner est un GUI permettant d’interagir avec l’option Oracle Data Mining (ODM). Celui-ci est distribu\u00e9 en tant que module de SQLDeveloper<\/a>.<\/p>\n

L’outil requiert un repository h\u00e9berg\u00e9 dans un sch\u00e9ma ODMRSYS au sein de chaque base ou l’on souhaite mettre en oeuvre des m\u00e9canismes ODM. Ce repository est cr\u00e9\u00e9 directement via l’interface SQLDeveloper. Cf. Data Miner Installation and Administration Guide<\/a><\/p>\n

 <\/p>\n

V\u00e9rification des\u00a0pr\u00e9requis<\/strong><\/p>\n

Oracle Data Miner requiert que l’option Data Mining (faisant elle-m\u00eame partie de l’option Advanced Analytics) soit activ\u00e9e sur la base cible. De plus les composants Oracle Text et XMLDB doivent aussi \u00eatre install\u00e9s:<\/p>\n

P:\\>sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 2 11:12:58 2015\r\n\r\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\r\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\r\n\r\nSQL> col PARAMETER format a20\r\nSQL> col VALUE format a20\r\nSQL> \r\nSQL> SELECT *\r\n  2    FROM v$option\r\n  3   WHERE parameter IN ('Advanced Analytics', 'Data Mining');\r\n\r\nPARAMETER            VALUE                    CON_ID\r\n-------------------- -------------------- ----------\r\nAdvanced Analytics   TRUE                          0\r\nData Mining          TRUE                          0\r\n\r\nSQL>\r\nSQL> col COMP_ID format a15\r\nSQL> col COMP_NAME format a20\r\nSQL> col VERSION format a15\r\nSQL> col STATUS format a15\r\nSQL>\r\nSQL> SELECT comp_id,\r\n  2         comp_name,\r\n  3         version,\r\n  4         status\r\n  5    FROM dba_registry\r\n  6   WHERE comp_id in ('CONTEXT','XDB');\r\n\r\nCOMP_ID         COMP_NAME            VERSION         STATUS\r\n--------------- -------------------- --------------- ---------------\r\nCONTEXT         Oracle Text          12.1.0.2.0      VALID\r\nXDB             Oracle XML Database  12.1.0.2.0      VALID\r\n\r\nSQL><\/pre>\n
Cr\u00e9ation\u00a0du\u00a0repository<\/strong><\/p>\n
L’acc\u00e9s au module Data Miner est r\u00e9alis\u00e9 via Affichage > Data Miner > Connexions Data Miner:<\/p>\n
\"first-cnx\"<\/a><\/p>\n
On indique alors la connexion \u00e0 utiliser:<\/p>\n
\"cnx-choix\"<\/a><\/p>\n
Comme il s’agit de la premi\u00e8re connexion \u00e0 la base depuis le module Data Miner, celui-ci d\u00e9tecte que le repository est absent et il propose sa cr\u00e9ation:<\/p>\n
\"no-repo\"<\/a><\/p>\n
En cliquant OK, j’obtiens un message bizarre…<\/p>\n
\"err-msg\"<\/a><\/p>\n
L’utilisateur RAFA dispose pourtant bien d’un tablespace par d\u00e9faut sur lequel il peut \u00e9crire (via le privil\u00e8ge UNLIMITED TABLESPACE):<\/p>\n
SQL> SELECT default_tablespace\r\n  2    FROM dba_users\r\n  3   WHERE username = 'RAFA';\r\n\r\nDEFAULT_TABLESPACE\r\n------------------------------\r\nTS_DATA\r\n\r\nSQL> SELECT *\r\n  2    FROM dba_sys_privs\r\n  3   WHERE privilege = 'UNLIMITED TABLESPACE'\r\n  4     AND grantee   = 'RAFA';\r\n\r\nGRAN PRIVILEGE            ADM COM\r\n---- -------------------- --- ---\r\nRAFA UNLIMITED TABLESPACE NO  NO\r\n\r\nSQL><\/pre>\n
Pour contourner le probl\u00e8me je lui octroie explicitement un quota illimit\u00e9 sur le tablespace en question.<\/p>\n
SQL> ALTER USER rafa QUOTA UNLIMITED ON ts_data;\r\n\r\nUser altered.\r\n\r\nSQL><\/pre>\n
L’installeur accepte alors de poursuivre l’op\u00e9ration.
\nUne fois indiqu\u00e9 le mot de passe de SYS et les param\u00e8tres de stockage confirm\u00e9s, l’installation peut d\u00e9marrer:<\/p>\n
\"sys-cnx\"<\/a><\/p>\n
\"repo-params\"<\/a><\/p>\n
Elle dure quelques minutes et \u00e0\u00a0l’issue, on peut acc\u00e9der au menu contextuel de cr\u00e9ation de projets ODM:<\/p>\n
\"odm-menu\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle Data Miner est un GUI permettant d’interagir avec l’option Oracle Data Mining (ODM). Celui-ci est distribu\u00e9 en tant que<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[5,7],"tags":[],"class_list":["post-305","post","type-post","status-publish","format-standard","hentry","category-odm","category-oracle-advanced-analytics"],"_links":{"self":[{"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=\/wp\/v2\/posts\/305","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=305"}],"version-history":[{"count":2,"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=\/wp\/v2\/posts\/305\/revisions"}],"predecessor-version":[{"id":1158,"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=\/wp\/v2\/posts\/305\/revisions\/1158"}],"wp:attachment":[{"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}