Oracle Database 12c: Advanced Administration — Question 182

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single- instance database.
Which step should you perform next to start the upgrade of the database?

Answer options

• A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
• B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
• C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
• D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade

Correct answer: C

Explanation

The correct answer is C, as using the STARTUP UPGRADE command prepares the database for the upgrade and gathering fixed object statistics helps optimize the recompilation process. Options A and B involve scripts that are not the correct next step after shutting down the database, and option D does not mention gathering statistics, which is essential for minimizing downtime during the upgrade.