Oracle Database 12c: Installation and Administration — Question 242

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?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D, as running utlrp.sql is necessary to recompile any invalid PL/SQL and Java objects after the upgrade, which is a standard procedure. Options A and B do not address the need for recompilation, while option C is not the first necessary step to resolve the INVALID status.