CATPROC Invalid due to Invalid SYS.MDX_ODBO* Objects
(Doc ID 2914897.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
CATPROC is INVALID in Data Dictionary-
Comp ID Component Status Version Org_Version Prv_Version
------- ---------------------------------- --------- -------------- -------------- --------------
APEX Oracle Application Express VALID 3.2.1.00.12
APS OLAP Analytic Workspace VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
CATALOG Oracle Database Catalog Views VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
CATJAVA Oracle Database Java Packages VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
CATPROC Oracle Database Packages and Types INVALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0 <<<<<<
CONTEXT Oracle Text VALID 19.0.0.0.0 19.0.0.0.0
JAVAVM JServer JAVA Virtual Machine VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
ORDIM Oracle Multimedia VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
OWM Oracle Workspace Manager VALID 19.0.0.0.0 11.2.0.4.0 11.2.0.4.0
RAC Oracle Real Application Clusters VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
SDO Spatial VALID 19.0.0.0.0 19.0.0.0.0
XDB Oracle XML Database VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
XML Oracle XDK VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
XOQ Oracle OLAP API VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
------- ---------------------------------- --------- -------------- -------------- --------------
APEX Oracle Application Express VALID 3.2.1.00.12
APS OLAP Analytic Workspace VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
CATALOG Oracle Database Catalog Views VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
CATJAVA Oracle Database Java Packages VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
CATPROC Oracle Database Packages and Types INVALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0 <<<<<<
CONTEXT Oracle Text VALID 19.0.0.0.0 19.0.0.0.0
JAVAVM JServer JAVA Virtual Machine VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
ORDIM Oracle Multimedia VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
OWM Oracle Workspace Manager VALID 19.0.0.0.0 11.2.0.4.0 11.2.0.4.0
RAC Oracle Real Application Clusters VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
SDO Spatial VALID 19.0.0.0.0 19.0.0.0.0
XDB Oracle XML Database VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
XML Oracle XDK VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
XOQ Oracle OLAP API VALID 19.0.0.0.0 11.2.0.3.0 11.2.0.4.0
Few INVALID SYS Objects also noticed-
OWNER OBJECT_NAME OBJECT_TYPE
------------ ---------------------------------------- ----------------------------------------
SYS MDX_ODBO_CUBES VIEW
SYS MDX_ODBO_DIMENSIONS VIEW
SYS MDX_ODBO_PROPERTIES VIEW
SYS MDX_ODBO_LEVELS VIEW
SYS MDX_ODBO_MEASURES VIEW
SYS MDX_ODBO_HIERARCHIES VIEW
6 rows selected.
Changes
Attempts to compile the objects shows ORA-01417
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |