nerdexam
Oracle

1Z0-062 · Question #234

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…

The correct answer is A. Run catuppst.sql to perform revalidation actions. After an Oracle database upgrade reports invalid components, the first step to fix this issue is to execute catuppst.sql to revalidate and clean up the database.

Performing Database Maintenance

Question

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?

Options

  • ARun catuppst.sql to perform revalidation actions
  • BRun utluiobj.sql to filter outobjects that were invalidated by the upgrade process.
  • CRun preupgrd.sql and then execute the generated "fix-up" scripts to resolve status issues.
  • DRun utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

How the community answered

(45 responses)
  • A
    89% (40)
  • B
    7% (3)
  • C
    2% (1)
  • D
    2% (1)

Why each option

After an Oracle database upgrade reports invalid components, the first step to fix this issue is to execute catuppst.sql to revalidate and clean up the database.

ARun catuppst.sql to perform revalidation actionsCorrect

The catuppst.sql script is specifically designed to be run after a database upgrade to perform post-upgrade actions, including revalidating invalid components and ensuring the database is in a consistent state.

BRun utluiobj.sql to filter outobjects that were invalidated by the upgrade process.

utluiobj.sql is not a standard script for resolving invalid component status post-upgrade; its purpose is unrelated to component revalidation.

CRun preupgrd.sql and then execute the generated "fix-up" scripts to resolve status issues.

preupgrd.sql is run *before* the upgrade to identify potential issues, not *after* the upgrade to fix invalid component status.

DRun utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

While utlrp.sql is used to recompile invalid objects, catuppst.sql is the recommended and comprehensive script for resolving component validation issues specifically after an upgrade, as it addresses a broader range of post-upgrade tasks.

Concept tested: Oracle database post-upgrade tasks

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/post-upgrade-tasks.html#GUID-7B42D2A5-812C-4A2D-A208-41E950005E98

Topics

#database upgrade#post-upgrade#invalid objects#utlrp.sql

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice