Problem : 
Msdxwdevkit.Sql fails when upgrading from 11.5.10.2 to 12.1.1
Error : 

<code lang=”sql”>ERROR at line 1:
ORA-33292: Insufficient permissions to access analytic workspace APPS.XWDEVKIT
using the specified access mode.
ORA-06512: at “SYS.DBMS_AW”, line 67
ORA-06512: at “SYS.DBMS_AW”, line 131
ORA-06512: at “SYS.DBMS_AW”, line 960
ORA-06512: at line 9</code>

Solution : 
Grant olap_user role to apps use
<code lang=”sql”>SQL> Grant olap_user to APPS;</code>
Restart the failed worker using adctrl

Tagged with →  
Share →
0 comments
Skip to toolbar