Upgrading Oracle Grid Infrastructure 19c Correct Statements

1Z0-078 By islever Editorial Last updated

Grid Infrastructure upgrades and patching

Short answer

AB The Cluster Verification Utility verifies readiness and generates fixup scripts, while environment variables must be unset for out-of-place upgrades.

Question

Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)
  1. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade. Correct Answer
  2. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster. Correct Answer
  3. The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
  4. The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
  5. The upgrade must be done in-place.

Key Takeaways

The exam tests knowledge of Grid Infrastructure upgrade steps, specifically the role of cluvfy.sh and the requirement to unset ORACLE_HOME/SID for modern out-of-place upgrades.

This question tests the correct procedures for upgrading Oracle Grid Infrastructure 19c, focusing on pre-upgrade verification and environment configuration. The page establishes that CVU is used for verification and fixups, while environment variables must be unset for out-of-place upgrades.

Common mistake: Candidates often select options suggesting that ORACLE_SID or ORACLE_HOME must be set (C, D) or that in-place upgrades are mandatory (E), failing to recognize that modern GI upgrades are out-of-place and require clean environments.

Expert Analysis

Why the Answer Is Correct

The Cluster Verification Utility (cluvfy.sh) is essential for verifying cluster readiness before an upgrade (A). It can also generate fixup scripts to resolve detected issues automatically (B). Modern Oracle Grid Infrastructure upgrades (including 19c) are performed out-of-place, meaning you install the new version in a separate home directory, making option E false. Options C and D are incorrect because environment variables like ORACLE_SID and ORACLE_HOME must be unset or not point to the old home during the upgrade process to avoid conflicts with the new installation owner's environment.

Why the Other Options Are Wrong

Option C is wrong because setting ORACLE_SID to the ASM instance SID is not required and can interfere with the installer if it points to an existing instance. Option D is wrong because ORACLE_HOME should not be set to the old Grid Infrastructure home; the installer manages paths internally. Option E is wrong because in-place upgrades are legacy practices; 19c mandates out-of-place upgrades for better reliability and rollback capabilities.

Community Comment Notes

Community consensus strongly supports A and B as correct. Several users note that C and D are traps because environment variables should be unset. One user noted "All environment variable must be unset" highlighting the critical pre-upgrade step. Another user confirmed that "Grid upgrades are always out-of-place" reinforcing why E is incorrect.

Exam Strategy

Always distinguish between 'in-place' and 'out-of-place' upgrade methodologies. For Grid Infrastructure 12c and later, assume out-of-place. Remember that CVU is your friend for both verification and remediation (fixup scripts).

Frequently Asked Questions

Why must ORACLE_HOME be unset during GI 19c upgrade?

Because upgrades are out-of-place; the installer uses its own path resolution. Setting ORACLE_HOME to the old home can cause conflicts or incorrect file selection.

Can cluvfy.sh fix issues automatically?

Yes, cluvfy.sh can generate fixup scripts that you can execute to resolve configuration issues detected during the verification phase.

More 1Z0-078 FAQ →

Discussion 5 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 5

  1. lcoleandro 👍 2
    A. True. The Cluster Verification Utility (CVU) can be used to verify that the cluster is properly configured for an upgrade. B. True. CVU can generate fixup scripts to resolve issues detected during the verification process. D. True. The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory during the upgrade process. F. True. The Oracle Universal Installer (OUI) can be used to perform upgrade validation, which includes invoking CVU. Regarding the other options: C. False. The ORACLE_SID environment variable does not need to be set to the SID of the ASM instance for the upgrade process. E. False. An in-place upgrade is not mandatory; out-of-place upgrades are also supported. G. False. The upgrade does not have to be done out-of-place; both in-place and out-of-place upgrades are possible.
  2. piontk 👍 1
    Grid upgrades are always out-of-place and you need to unset the environment variables in the preupgrade phase.
  3. 217972f 👍 1
    100% ABFG. All environment variable must be unset
  4. Jaroslav113 👍 1
    ABFG , ORACLE_HOME should be unset.
  5. Test_1 👍 1
    ABFG correct answer

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Which Three Resources Use Global Concurrency Control in 19c RAC?

S-grade

Which Task Must Precede OPatch Patching of Grid Infrastructure 19c?

S-grade

What Does opatch apply Do in a Four-Node RAC Cluster?

S-grade

ACFS Encryption True Statements

S-grade

← Back to 1Z0-078 Study Guide