Oracle Database 12c: Installation and Administration — Question 197

Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle
Database 12c?

Answer options

• A. shutting down the database instance that is being upgraded
• B. executing the catctl.pl script to run the upgrade processes in parallel
• C. running the Pre-Upgrade Information Tool
• D. copying the listener.ora file to the new ORACLE_HOME

Correct answer: C

Explanation

The correct action is to run the Pre-Upgrade Information Tool, as it provides essential information about the current database configuration and any necessary steps for a successful upgrade. Shutting down the database instance is not a prerequisite for using DBUA, executing the catctl.pl script is not necessary until after the upgrade process starts, and copying the listener.ora file, while important, is not a required task before initiating the upgrade.