Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

PACKAGE BODY CWM2_OLAP_INSTALLER created with compilation errors.

edited Aug 20, 2021 10:16AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered ✓

While migrating OLAP as a part of oracle database 11.2.0.4 32-bit to 64-bit migration, running %ORACLE_HOME%\olap\admin\olap.sql gives error message:

Warning: Package Body created with compilation errors.

SQL> show errors;

Errors for PACKAGE BODY CWM2_OLAP_INSTALLER:

LINE/COL ERROR                                                                                                        

-------- -----------------------------------------------------------------                                            

118/7    PL/SQL: SQL Statement ignored                                                                                

120/22   PL/SQL: ORA-00942: table or view does not exist                                                              

132/7    PL/SQL: SQL Statement ignored                                                                                

134/22   PL/SQL: ORA-00942: table or view does not exist                                                              

SQL> execute sys.cwm2_olap_installer.Validate_CWM2_Install;

BEGIN sys.cwm2_olap_installer.Validate_CWM2_Install; END;

*

ERROR at line 1:

ORA-04063: package body "SYS.CWM2_OLAP_INSTALLER" has errors

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center