5 Replies Latest reply: Oct 15, 2012 3:51 PM by Srini Chavali-Oracle RSS

    Upgrade from 10gR2 to 11gR2 Aborts Upgrade


      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.