Step 01: Ensure that your ORACLE_HOME and ORACLE_SID environmental variable setup is correct.
On unix/linux issue,
$ echo $ORACLE_HOME
$ echo $ORACLE_SID
Step 02: Start Sql*plus and connect with sys user as sysdba privilege.
$ sqlplus /nolog
SQL> conn / as sysdba
Step 03: Execute dminst.sql, odmpatch.sql and utlrp.sql scripts like below.
On Unix - Linux,
SQL> run $ORACLE_HOME/dm/admin/dminst.sql SYSAUX TEMPOn Windows,
SQL> run $ORACLE_HOME/dm/admin/odmpatch.sql
SQL> run $ORACLE_HOME/dm/admin/utlrp.sql
SQL> start %ORACLE_HOME%\dm\admin\dminst.sql SYSAUX TEMPStep 04: Ensure that 'Oracle Data Mining' is at Valid status in dba_registry by executing the following query,
SQL> start %ORACLE_HOME%\dm\admin\odmpatch.sql
SQL> start %ORACLE_HOME%\dm\admin\utlrp.sql
SQL> select COMP_NAME,VERSION,STATUS from dba_registry where COMP_NAME='Oracle Data Mining';
Manually Install Oracle Data Mining for RDBMS 10.2.x
Step 01: Ensure that your ORACLE_HOME and ORACLE_SID environmental variable setup is correct.
On unix/linux issue,
$ echo $ORACLE_HOME
$ echo $ORACLE_SID
Step 02: Start Sql*plus and connect with sys user as sysdba privilege.
$ sqlplus /nolog
SQL> conn / as sysdba
Step 03: Execute dminst.sql, odmpatch.sql and utlrp.sql scripts like below.
On Unix/Linux issue,
SQL> run $ORACLE_HOME/rdbms/admin/dminst.sql SYSAUX TEMP
SQL> run $ORACLE_HOME/rdbms/admin/odmpatch.sql
SQL> run $ORACLE_HOME/rdbms/admin/utlrp.sql
On Windows,
SQL> start %ORACLE_HOME%\rdbms\admin\dminst.sql SYSAUX TEMP
SQL> start %ORACLE_HOME%\rdbms\admin\odmpatch.sql
SQL> start %ORACLE_HOME%\rdbms\admin\utlrp.sql
Step 04: Ensure that 'Oracle Data Mining' is at Valid status in dba_registry by executing the following query,
SQL> select COMP_NAME,VERSION,STATUS from dba_registry where COMP_NAME='Oracle Data Mining';
No comments:
Post a Comment