My Oracle Support Banner

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

Last updated on FEBRUARY 23, 2024

Applies to:

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


Applied database patchset.

After executing post installation steps of the 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>:


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


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.