nerdexam
Oracle

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.

Performing Database Maintenance

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)
  • A
    4% (1)
  • C
    88% (22)
  • D
    8% (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.

Ashutting down the database instance that is being upgraded

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.

Bexecuting the catctl.pl script to run the upgrade processes in parallel

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.

Crunning the Pre-Upgrade Information ToolCorrect

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.

Dcopying the listener.ora file to the new ORACLE_HOME

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

#Database upgrade#DBUA#Pre-Upgrade Information Tool#Oracle 11gR2 to 12c

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice