ORA-01031: Insufficient Privileges During Database Upgrade (Doc ID 1301700.1)

Last updated on MARCH 24, 2011

Applies to:

Oracle OLAP - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms


=== ODM Issue Clarification ===
During  database upgrade,  the following error is logged in the Oracle Server log.


95 select owner, dimension_name, hierarchy_name, solvedcode, -- parent_level_name, ADD SOLVEDCODE
96 child_level_name, position
97 from olapsys.ODM$olap2_dim_hier_level_uses -- SEE ABOVE
98 with read only;
dba_users u
*
ERROR at line 18:
ORA-01031: insufficient privileges


Preupgrade script shows all objects are valid.

You can also check if you are hitting this problem by running the following select statement as OLAPSYS:

select * from dba_users;




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