Last updated on JUNE 27, 2012
Applies to:
Oracle OLAP - Version 11.1.0.7 and laterInformation in this document applies to any platform.
***Checked for relevance on 27-Jun-2012***
Symptoms
You migrate 32 bit to 64 bit.
All 3 Olap components are valid in the DBA_REGISTRY
SQL> select rpad(comp_name,35), status, version from dba_registry where
comp_name like '%OLAP%';
RPAD(COMP_NAME,35) STATUS VERSION
----------------------------------- ----------- ------------------------------
OLAP Analytic Workspace VALID 11.1.0.7.0
Oracle OLAP API VALID 11.1.0.7.0
OLAP Catalog VALID 11.1.0.7.0
However, you have the following 3 invalid OLAPSYS objects:
SQL> select owner, object_name, status from dba_objects where status = 'INVALID' and OWNER = 'OLAPSYS' ;
OLAPSYS CWM2_OLAP_OLAPAPI_ENABLE INVALID
OLAPSYS DBMS_AWM INVALID
OLAPSYS CWM2_OLAP_METADATA_REFRESH INVALID
When you try to manually compile the objects, you get errors:
SQL> alter package olapsys.DBMS_AWM compile body;
Warning: Package Body altered with compilation errors.
SQL> sho err
Errors for PACKAGE BODY OLAPSYS.DBMS_AWM:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2475/25 PL/SQL: SQL Statement ignored
2475/39 PL/SQL: ORA-00980: synonym translation is no longer valid
2482/5 PL/SQL: Statement ignored
2482/27 PLS-00364: loop index variable 'C_DIM_ENABLED' use is invalid
2492/5 PL/SQL: Statement ignored
SQL> alter package olapsys.CWM2_OLAP_METADATA_REFRESH compile body;
Warning: Package Body altered with compilation errors.
SQL> sho err
Errors for PACKAGE BODY OLAPSYS.CWM2_OLAP_METADATA_REFRESH:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2581/1 PL/SQL: SQL Statement ignored
2594/6 PL/SQL: ORA-00980: synonym translation is no longer valid
SQL> alter package olapsys.CWM2_OLAP_OLAPAPI_ENABLE compile body;
Warning: Package Body altered with compilation errors.
SQL> sho err
Errors for PACKAGE BODY OLAPSYS.CWM2_OLAP_OLAPAPI_ENABLE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
93/30 PL/SQL: SQL Statement ignored
93/57 PL/SQL: ORA-01775: looping chain of synonyms Changes
You upgraded your database from 32 bit to 64 bit.
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