Invalid OLAPSYS Objects After Upgrading TO 12C (Doc ID 1593666.1)

Last updated on APRIL 25, 2017

Applies to:

Oracle OLAP - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

 

After upgrading Oracle Database to 12C, you have the following invalid OLAP objects:

select owner, object_name, object_type from all_objects where status='INVALID' and owner like '%SYS%' order by owner;

OWNER      OBJECT_NAME                    OBJECT_TYPE
---------- ------------------------------ -----------------
OLAPSYS    CWM2_OLAP_VERIFY_ACCESS        PACKAGE BODY
OLAPSYS    CWM$EXPORT                     PACKAGE BODY
OLAPSYS    DBMS_AWM                       PACKAGE BODY
OLAPSYS    DBMS_AWM_PRV                   PACKAGE BODY
OLAPSYS    DBMS_AWM_PRV                   PACKAGE
OLAPSYS    CWM2_OLAP_OLAPAPI_ENABLE       PACKAGE BODY
OLAPSYS    DBMS_ODM                       PACKAGE BODY
OLAPSYS    OLAPDIMVIEW                    PACKAGE BODY
OLAPSYS    OLAPFACTVIEW                   PACKAGE BODY
OLAPSYS    CWM2_OLAP_METADATA_REFRESH     PACKAGE BODY
OLAPSYS    CWM2_OLAP_MR_SESSION_POP       PACKAGE BODY

OWNER      OBJECT_NAME                    OBJECT_TYPE
---------- ------------------------------ -----------------
OLAPSYS    CWM2_OLAP_MR_SECURITY_INIT     PACKAGE BODY
OLAPSYS    CWM2_OLAP_CLASSIFY             PACKAGE BODY
OLAPSYS    CWM2_OLAP_TABLE_MAP            PACKAGE BODY
OLAPSYS    CWM2_OLAP_DELETE               PACKAGE BODY
OLAPSYS    CWM2_OLAP_EXPORT               PACKAGE BODY
OLAPSYS    CWM2_OLAP_VALIDATE             PACKAGE BODY
OLAPSYS    CWM2_OLAP_VALIDATE_METADATA    PACKAGE BODY
OLAPSYS    CWM1_OLAP_VALIDATE_METADATA    PACKAGE BODY
OLAPSYS    CWM2_OLAP_VALIDATE_UTILITY     PACKAGE BODY
OLAPSYS    CWM2_OLAP_MEASURE              PACKAGE BODY
OLAPSYS    CWM2_OLAP_LEVEL_ATTRIBUTE      PACKAGE BODY

OWNER      OBJECT_NAME                    OBJECT_TYPE
---------- ------------------------------ -----------------
OLAPSYS    CWM2_OLAP_LEVEL                PACKAGE BODY
OLAPSYS    CWM2_OLAP_HIERARCHY            PACKAGE BODY
OLAPSYS    CWM2_OLAP_DIMENSION_ATTRIBUTE  PACKAGE BODY
OLAPSYS    CWM2_OLAP_DIMENSION            PACKAGE BODY
OLAPSYS    CWM2_OLAP_CATALOG              PACKAGE BODY
OLAPSYS    CWM2_OLAP_UTILITY              PACKAGE BODY
OLAPSYS    CWM2_OLAP_MANAGER              PACKAGE BODY
OLAPSYS    CWM2_OLAP_UTILITY              PACKAGE
OLAPSYS    CWM2_OLAP_VALIDATE_UTILITY     PACKAGE
OLAPSYS    CWM$UTIL                       PACKAGE BODY
OLAPSYS    CWM2_OLAP_CUBE                 PACKAGE BODY
OLAPSYS    CWM2_OLAP_INSTALLER          PACKAGE BODY


33 rows selected.

 

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