ODM Got Invalid In DBA_REGISTRY After Patching To 10.1.0.5.0 (Doc ID 821598.1)

Last updated on JULY 31, 2012

Applies to:

Oracle Data Mining - Version 10.1.0.5 and later
Information in this document applies to any platform.
Reviewed for relevance on 31-JUL-2012

Symptoms

Applied 10.1.0.5 database patchset.

After executing post installation steps of the 10.1.0.5 database patchset, ODM - Data Mining component shows status INVALID without displaying version information:

COMP_NAME                           STATUS      VERSION ----------------------------------- ----------- ---------- Oracle Data Mining INVALID 

SQL*Plus banner and V$OPTION indicates that the component is installed.

Tried re-installation of Data Mining to the database as SYS AS SYSDBA using steps from <Note 420791.1>:

 

SQL> run $ORACLE_HOME/dm/admin/dminst.sql SYSAUX TEMP
SQL> run $ORACLE_HOME/dm/admin/odmpatch.sql
SQL> run $ORACLE_HOME/dm/admin/utlrp.sql

 

Both dminst.sql and odmpatch.sql error out in their last step when those try to execute SYS.VALIDATE_ODM procedure (which is supposed to validate the ODM component):

BEGIN sys.validate_odm; END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.VALIDATE_ODM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Changes

Applied 10.1.0.5 database patchset.
Then to solve invalidity of ODM component, attempted to reinstall ODM to the database.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms