You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.
What must you do first in this situation to attempt to fix this problem?
A.
Run catuppst.sql to perform revalidation actions
B.
Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.
C.
Run preupgrd.sql and then execute the generated “fix-up” scripts to resolve status issues.
D.
Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.
I would suggest A
– C and D should’ve been done before the upgrade
– The catuppst.sql script generates informational messages and log files during the upgrade. DBUA and catctl.pl automatically run catuppst.sql. Run this script separately if any errors occurred during the manual upgrade.
I would suggest B.
– https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD52887
– https://docs.oracle.com/database/121/UPGRD/preup.htm#UPGRD52881
I think A is correct.
https://oracle-base.com/articles/12c/upgrading-to-12c#manual-upgrades
A is correct