My Oracle Support Banner

Invalid OLAP Objects After Upgrade From 10g To 11.2.0.3 (Doc ID 1449652.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle OLAP - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

Prior to the Upgrade, OLAP was removed as per <Note: 565773.1>
Directly after the upgrade, invalid Objects show up

SQL> select owner, object_name, object_type from dba_objects where status <> 'VALID' order by owner, object_type

OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- -------------------
PUBLIC GENREMOTETASKINTERRUPTEDEXCEPT SYNONYM
PUBLIC GENCURSORMANAGERSEQUENCE SYNONYM
PUBLIC GENCONNECTIONSTRUCT SYNONYM
PUBLIC GENREMOTEAUTHENTICATIONEXCEPTI SYNONYM
PUBLIC GENREMOTEAPIVERSIONMISMATCHEXC SYNONYM
PUBLIC GENMETADATAPROPERTYVALUESUNION SYNONYM
PUBLIC GENMETADATAPROPERTYSTRUCT SYNONYM
PUBLIC GENMETADATAPROPERTYSEQUENCE SYNONYM
PUBLIC GENMETADATAPROPERTYBAGUNION SYNONYM
PUBLIC GENMETADATAPROPERTYBAGSEQUENCE SYNONYM
PUBLIC GENREMOTESPECIFICATIONUPDATENE SYNONYM
PUBLIC GENCURSORVALUESUNION SYNONYM
PUBLIC GENDATABLOCKSTRUCT SYNONYM
PUBLIC GENDATABLOCKSEQUENCE SYNONYM
PUBLIC GENPARENTSTARTENDBLOCKUNION SYNONYM
PUBLIC GENPARENTSTARTENDBLOCKSEQUENCE SYNONYM
PUBLIC GENCURSORBLOCKSTRUCT SYNONYM
PUBLIC GENINVALIDINDEXSPECIFICATIONEX SYNONYM
PUBLIC GENCURSORBLOCKSEQUENCE SYNONYM
PUBLIC GENCURSORVALUES2UNION SYNONYM
PUBLIC GENDATABLOCK2STRUCT SYNONYM
PUBLIC GENDATABLOCK2SEQUENCE SYNONYM
PUBLIC GENPARENTSTARTENDBLOCK2UNION SYNONYM
PUBLIC GENPARENTSTARTENDBLOCK2SEQUENC SYNONYM
PUBLIC GENCURSORBLOCK2STRUCT SYNONYM
PUBLIC GENCURSORBLOCK2SEQUENCE SYNONYM
PUBLIC GENCONSTANTLISTVALUESUNION SYNONYM
PUBLIC GENCONSTANTLISTDEFINITIONSTRUC SYNONYM
PUBLIC GENDEFINITIONUNION SYNONYM
PUBLIC GENDEFINITIONSEQUENCE SYNONYM
PUBLIC GENUNMATCHEDINPUTSEXCEPTION SYNONYM
PUBLIC GENDEFINITIONPOST92UNION SYNONYM
PUBLIC GENDEFINITIONPOST92SEQUENCE SYNONYM
PUBLIC GENCONNECTIONPARAMETERINFOSEQU SYNONYM
SYS GENINTERRUPTABLEINTERFACE PACKAGE
SYS DEFINITIONMANAGERINTERFACE PACKAGE BODY
SYS CURSORMANAGERINTERFACE PACKAGE BODY
SYS METADATAPROVIDERINTERFACE PACKAGE BODY
SYS SERVERINTERFACE PACKAGE BODY
SYS DATAPROVIDERINTERFACE PACKAGE BODY
SYS DATABASEINTERFACE PACKAGE BODY
SYS INTERRUPTABLEINTERFACE PACKAGE BODY
SYS GENINTERRUPTABLEINTERFACE PACKAGE BODY
SYS CONNECTIONINTERFACE PACKAGE BODY
SYS GENREMOTEAPIVERSIONMISMATCHEXC TYPE
SYS GENMETADATAPROPERTYVALUESUNION TYPE
SYS GENMETADATAPROPERTYSTRUCT TYPE
SYS GENMETADATAPROPERTYSEQUENCE TYPE
SYS GENMETADATAPROPERTYBAGUNION TYPE
SYS GENMETADATAPROPERTYBAGSEQUENCE TYPE
SYS GENREMOTESPECIFICATIONUPDATENE TYPE
SYS GENCURSORVALUESUNION TYPE
SYS GENDATABLOCKSTRUCT TYPE
SYS GENDATABLOCKSEQUENCE TYPE
SYS GENPARENTSTARTENDBLOCKUNION TYPE
SYS GENPARENTSTARTENDBLOCKSEQUENCE TYPE
SYS GENCURSORBLOCKSTRUCT TYPE
SYS GENINVALIDINDEXSPECIFICATIONEX TYPE
SYS GENCURSORBLOCKSEQUENCE TYPE
SYS GENCURSORVALUES2UNION TYPE
SYS GENDATABLOCK2STRUCT TYPE
SYS GENDATABLOCK2SEQUENCE TYPE
SYS GENPARENTSTARTENDBLOCK2UNION TYPE
SYS GENPARENTSTARTENDBLOCK2SEQUENC TYPE
SYS GENCURSORBLOCK2STRUCT TYPE
SYS GENCURSORBLOCK2SEQUENCE TYPE
SYS GENCONSTANTLISTVALUESUNION TYPE
SYS GENCONSTANTLISTDEFINITIONSTRUC TYPE
SYS GENDEFINITIONUNION TYPE
SYS GENDEFINITIONSEQUENCE TYPE
SYS GENUNMATCHEDINPUTSEXCEPTION TYPE
SYS GENDEFINITIONPOST92UNION TYPE
SYS GENDEFINITIONPOST92SEQUENCE TYPE
SYS GENCURSORMANAGERSEQUENCE TYPE
SYS GENREMOTEAUTHENTICATIONEXCEPTI TYPE
SYS GENCONNECTIONSTRUCT TYPE
SYS GENCONNECTIONPARAMETERINFOSEQU TYPE
SYS GENCONNECTIONPARAMETERINFOSTRU TYPE
SYS GENDATA2SEQUENCEUNION TYPE
SYS GENDATASEQUENCEUNION TYPE
SYS GENINVALIDMETADATAEXCEPTION TYPE
SYS GENREMOTETASKINTERRUPTEDEXCEPT TYPE
SYS GENEXPRESSEXCEPTION TYPE
SYS GENREMOTEOBJECTCLOSEDEXCEPTION TYPE

84 rows selected.

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
Cause
Solution
References


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