ORA-33292: Insufficient permissions to access analytic workspace APPS.ODPCODE
                                                 Last update (2012-11-21 09:03:09)
                                                                                                                   Date added (2012-11-20 14:29:08)

Summary
During the upgrade from 11.5.10 -> R12.1.1 and from R12.1.1 -> R12.1.3 i faced two times the same problem:

Worker fails with:
@/d01/apps12r/apps/apps_st/appl/msd/12.0.0/patch/115/sql/MSDODPCODE.sql
ERROR at line 1:
ORA-33292: Insufficient permissions to access analytic workspace APPS.ODPCODE
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 977
ORA-06512: at "SYS.DBMS_AW", line 930
ORA-33262: Analytic workspace APPS.ODPCODE does not exist.
ORA-06512: at "SYS.DBMS_AW", line 901
ORA-06512: at "APPS.MSD_AW_LOADER", line 10
ORA-06512: at line 3
Oracle Support has an article about this issue: MSDODPCODE.SQL Fails Applying U6678700.Drv [ID 1151274.1]

There are 2 options

First option is to run adctrl and press the hidden options with number 8 and skip/restart the failed worker.

The second option, that worked for me is
sql> grant olap_dba to apps;
login as APPS user and execute: sqlplus>exec dbms_aw.AW_ATTACH('ODPCODE',true,true,'wait');
Logout, don't forget to logout from the sqlplus session.
Check for locks (in case there are, kill the sessions)
select username, sid, serial#, owner||'.'||daws.aw_name aw, 
decode(attach_mode,'READ WRITE','RW','READ ONLY','RO',attach_mode) attch 
from dba_aws daws,v$aw_olap vawo, v$aw_calc vawc,v$session 
where  daws.aw_number=vawo.aw_number and sid=vawo.session_id 
and vawc.session_id=sid 
order by username, sid, daws.aw_name;
Restart the failed worker.

After doing the workaround i didn't have to do it again for the upgrade from R12.1.1->R12.1.3.

Tip: You can do the workaround before hitting the error (before upgrade driver 6678700 or 9239090)
sql> grant olap_dba to apps;
login as APPS user and execute:
sqlplus>exec dbms_aw.AW_ATTACH('ODPCODE',true,true,'wait');
logout from the sqlplus session.
Reviews
Filters
Search