Day: August 27, 2007

Installing Oracle Data Mining Manually

Published on by Advait1 Comment

Oracle Data Mining is one of the component of Oracle Database. When we create a database using DBCA it creates this component automatically. Even when we go for basic installation there is an option to select or de-select Oracle data mining. While doing Advanced installation, you need to go to “Custom” option on “Select Installation Type” screen and select Oracle Data Mining check box.

For more information please check Installation link.

Below are the simple steps for installing Oracle Data Mining manually using the scripts. This post is based on metalink Note ID: 420791.1

1) Install Oracle Data Mining

This is done by running a simple script dminst.sql present in ORACLE_HOME/rdbms/admin in case of
10.2.X database and in ORACLE_HOME/dm/admin in case of 10.1.X database.

This script needs 2 inputs. First is the name of SYSAUX tablespace name and second is TEMP tablespace name.

SQL> @$ORACLE_HOME/rdbms/admin/dminst.sql SYSAUX TEMP

2) odmpatch.sql should be run to make ODM at 10.2.0.X patch release level.

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

3) Compile the invalids

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

Check the component in DBA_REGISTRY

SQL> select COMP_NAME,VERSION,STATUS from dba_registry where COMP_NAME=’Oracle Data Mining’;

COMP_NAME
——————————————————————————–
VERSION                        STATUS
—————————— ———————————
Oracle Data Mining
10.2.0.3.0                     VALID

Advertisement