ORA-01031: Insufficient Privileges During Database Upgrade
Last updated on MARCH 24, 2011
Applies to:Oracle OLAP - Version: 10.2.0.1 to 18.104.22.168 - 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;
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;
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