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

MOSC Banner

FAILED: file ADZDPREP.sql while applying Online Patch

edited Mar 15, 2019 12:29PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered ✓

Attempting an upgrade from 12.1.3 to 12..2 and I'm trying to apply patch 13543062:R12.AD.C.

I do see there is a DOC ID on this:

Online Patch Enabling Patch Is Failing on ADZDPREP.sql (Doc ID 1606431.1)

and it did point me to the fact I hadn't run these steps:

c) Perform the following steps (for customers on 12.1.0.2):

- run dbmsxdbschmig.sql, prvtxdbschmig.sql, utlrp.sql scripts:

I don't seem to have an adgrants.sql file which looks to be ok if running a 12.1.0.2 database?

At any rate after running those scripts I was able to run the suggested fix:

SQL> GRANT SELECT, UPDATE, DELETE, INSERT on sys.xdb$moveSchemaTab to apps;

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