Problem : 

Patch 6678700 Worker Fails On Applying MSDODPCODE.sql With ORA-33292
Insufficient Permissions To Access Analytic Workspace APPS.ODPCODE


Solution : 
1) Verify the status for the account OLAPSYS, checking that the account is not EXPIRED or LOCKED:

select username ,account_status from dba_users where username like '%OLAP%';

If the above query showed that the user is locked, unlock using the following sql command:

ALTER USER OLAPSYS IDENTIFIED BY "newpassword" ACCOUNT UNLOCK;

2) Please run the following as APPS User in SQL*Plus to create the analytic workspace (AW) odpcode:

begin
dbms_aw.execute('aw create odpcode');
end;

3) Bounce the database
4) Continue with upgrade/retest, and restart the failing worker using adctrl.

Reference : Metalink Id 1054417.1

Tagged with →  
Share →
0 comments
Skip to toolbar