Patch 6678700 : 11i to 12.1 Upgrade : Fails with ORA-33292 "Insufficient Permissions" in script MSDX
(Thread created by Oracle Support on behalf of Customer)
Hi there
Upgrading from 11.5.10.2 to R12 when applying patch 6678700 fails with:
sqlplus -s APPS/***** @/u01/DEV4/apps/apps/apps_st/appl/msd/12.0.0/patch/115/sql/MSDXWDEVKIT.sql
begin
*
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 977
ORA-06512: at "SYS.DBMS_AW", line 954
ORA-06512: at line 9
We found and followed this note but it hasn't solved our problem:
"Error On Msdxwdevkit.Sql Upgrading From 11.5.10.2 To 12.1.1" [ID 1084759.1]