Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12.1.1 upgrade fails on zpbsecupg.sql

edited Oct 10, 2012 9:44AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered
R12.1.1 upgrade fails on zpbsecupg.sql
Problem Summary
---------------------------------------------------
R12.1.1 upgrade fails on zpbsecupg.sql

Problem Description
---------------------------------------------------
worker fails with
sqlplus -s APPS/***** @/trv/trn/app/apps/apps_st/appl/zpb/12.0.0/patch/115/sql/zpbsecupg.sql
DECLARE
*
ERROR at line 1:
ORA-33262: Analytic workspace ZPB.ZPBANNOT2 does not exist.
aw attach ZPB.ZPBANNOT2 rw
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
ORA-06512: at "APPS.ZPB_AW", line 24
ORA-06512: at "APPS.ZPB_AW", line 465
ORA-06512: at line 23


Error Codes
---------------------------------------------------
ORA-33262


Looked at the code in the failing script.  The analytic workspace it is looking for doesn't exist. The value of data_aw is NOT ZPB but ZPBDATA2.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center