1Z0-083 practice question 19 of 35

Choose the best. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable…

Full set: 286 questions

Choose the best. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment: $ export ORACLE_SID=cdb1 $ sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED -------------------------------- -----------------¬-------------2 PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YES SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered. SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?

Answer options
A:

A. It fails because PDB$SEED is in MIGRATE state.

B:

B. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.

C:

C. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.

D:

D. It fails because PDB2 is not in UPGRADE state.

Correct answer
E:

E. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.

F:

F. Only CDB$ROOT and PDB$SEED are upgraded.

Correct Answer:
D. D. It fails because PDB2 is not in UPGRADE state.
Explanation

The parallel upgrade utility, catctl.pl, requires that any Pluggable Database (PDB) it is instructed to upgrade must first be opened in UPGRADE mode. The command sequence shows that PDB1 was correctly placed in UPGRADE mode, but PDB2 was left in the MOUNTED state. The subsequent catctl.pl -C 'PDB2' command specifically targets PDB2 for an upgrade. Because PDB2 is not in the required UPGRADE state, the catctl.pl script will fail, as its prerequisite check for the target PDB will not pass.

Why Incorrect

A. PDB$SEED must be in MIGRATE state for a CDB upgrade to proceed; this is the correct and expected state.
B. The command catctl.pl -C 'PDB2' explicitly targets PDB2, not PDB1. Therefore, the script would not attempt to upgrade PDB1.
C. This would be the outcome if PDB2 had been correctly opened in UPGRADE mode prior to running catctl.pl.
E. The command only targets PDB2 for the PDB upgrade portion. It would not upgrade PDB1, and the entire operation fails due to PDB2's state.
F. The script was explicitly invoked to process PDB2. It will fail on that PDB rather than skipping it and only upgrading the root and seed.

References

Oracle Database Upgrade Guide, 18c, Chapter 4, "Upgrading a Multitenant Database with catctl.pl". The section "Running the Parallel Upgrade Utility on a CDB" states: "For each PDB that you want to upgrade, you must also open the PDB in UPGRADE mode: SQL> ALTER PLUGGABLE DATABASE pdbname OPEN UPGRADE;". This prerequisite was not met for PDB2.

Scroll to Top