ORA-01031: Insufficient Privileges During Database Upgrade
(Doc ID 1301700.1)
Last updated on NOVEMBER 22, 2019
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;
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