This discussion is archived
5 Replies Latest reply: Oct 15, 2012 1:51 PM by Srini Chavali-Oracle RSS

Upgrade from 10gR2 to 11gR2 Aborts Upgrade

782622 Newbie
Currently Being Moderated

OS: Solaris 10 update 10
Database: 10gR2

When trying to upgrade my database from 10gR2 to 11gR2 the upgrade aborts when running the " ?/rdbms/admin/xdbuuc2.sql " portion of the upgrade. I figured this out by performing a manual upgrade and spooling the output to a upgrade.log. Running the " xdbuuc2.sql " was the last thing it before it aborted the upgrade.

I then looked into the " xdbuuc2.sql " SQL script and it states " This procedure checks for non-system (user) dependents of a schema and raises an error if any are found. This will abort upgrade "

So I'm fairly confident this is the cause of my problem. My question is, how can I identify these dependencies and remove them.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points