1Z0-062 · Question #162
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?
The correct answer is C. running the Pre-Upgrade Information Tool. Running the Pre-Upgrade Information Tool before using DBUA identifies compatibility issues, deprecated features, and required fixes that must be addressed for a successful upgrade.
Question
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?
Options
- Ashutting down the database instance that is being upgraded
- Bexecuting the catctl.pl script to run the upgrade processes in parallel
- Crunning the Pre-Upgrade Information Tool
- Dcopying the listener.ora file to the new ORACLE_HOME
How the community answered
(25 responses)- A4% (1)
- C88% (22)
- D8% (2)
Why each option
Running the Pre-Upgrade Information Tool before using DBUA identifies compatibility issues, deprecated features, and required fixes that must be addressed for a successful upgrade.
DBUA manages the database shutdown and startup sequence automatically as part of its upgrade workflow; manually shutting down the instance beforehand is not a required prerequisite step.
The catctl.pl script drives parallel upgrade processing during a manual command-line upgrade and is not a prerequisite task when the automated DBUA utility is used.
The Pre-Upgrade Information Tool (preupgrd.sql for 11g or preupcheck.jar for 12c+) analyzes the source database and generates a detailed report covering invalid objects, deprecated parameters, minimum patch level requirements, and timezone file checks - resolving these findings before invoking DBUA reduces the risk of upgrade failure.
DBUA includes a network configuration step in its wizard that handles listener setup for the new ORACLE_HOME; manually copying listener.ora is not a recommended or required pre-upgrade action.
Concept tested: Oracle DBUA pre-upgrade information tool requirement
Source: https://docs.oracle.com/database/121/UPGRD/preup.htm
Topics
Community Discussion
No community discussion yet for this question.