OLAP Analytic Workspace INVALID after Upgrade from 188.8.131.52; ORA-33874: AGGRSTORE is not the name of a valid option
(Doc ID 1938124.1)
Last updated on OCTOBER 22, 2014
Applies to:Oracle OLAP - Version 184.108.40.206 and later
Information in this document applies to any platform.
After an upgrade from 220.127.116.11 OLAP Analytic Workspace shows as INVALID in dba_registry. Before the upgrade, all OLAP components were valid. The upgrade log shows a failure to build the EXPRESS AW.
. . .
SQL> execute dbms_aw_build.init('EXPRESS');
PL/SQL procedure successfully completed.
SQL> execute dbms_aw_build.build('EXPRESS', FALSE);
BEGIN dbms_aw_build.build('EXPRESS', FALSE); END;
ERROR at line 1:
ORA-33874: AGGRSTORE is not the name of a valid option.
ORA-06512: at "SYS.DBMS_AW_BUILD", line 107
ORA-06512: at line 1
Database upgrade from 18.104.22.168.
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|