Can Not Use OLAP After Upgrading To OLAP 10.2.0.3.0 Due to INVALID OLAP Option And Errors Like ORA-04063
(Doc ID 421671.1)
Last updated on MARCH 10, 2020
Applies to:Oracle OLAP - Version 10.2.0.3 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious
data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
After installing a patchset on a Microsoft Windows platform, attempts to connect to the instance using the OLAP component (Analytic Workspaces) fail and the OLAP Analytic Workspace component is marked as INVALID.
An example for a patch that may cause this behaviour is:
5846376 ORACLE 10G 10.2.0.3 PLACE HOLDER BUG FOR PATCH 2 ON WINDOWS 32 BIT
Error messages may indicate <> indicating that the SYS.DBMS_AW has errors.
-- Steps To Reproduce:
- Connect to the instance as sysdba using SQLPlus
SQL>set serverout on SQL>call dbms_aw.execute('show tod')
- If you receive an error message about the SYS.DBMS_AW containing errors, proceed.
SQL> select comp_name, version, status from dba_registry where comp_name like '%OLAP%';
If the OLAP Analytic Workspace component is marked as 10.2.0.x, but INVALID, this is an
indication that this component has not been upgraded properly. Step 2 confirms that the problem is actually with the DBMS_AW package.
Installation of these patches may trigger this issue:
<Patch 5846376> ORACLE 10G 10.2.0.3 PLACE HOLDER BUG FOR PATCH 2 ON WINDOWS 32 BIT
<Patch 5746153> OLAP A PATCH FOR 10.2.0.3.0
Any other upgrade / patch affecting the OLAP component APS (OLAP Analytic Workspace)
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