My Oracle Support Banner

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

Last updated on MARCH 24, 2011

Applies to:

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


=== 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;


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.