1Z0-062 · Question #282
You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use? (Choose two.)
The correct answer is D. Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle E. Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle. Upgrading an Oracle 9i database to Oracle 12c requires an indirect approach because 9i is not directly supported, necessitating either a multi-step upgrade or a data migration to a newly created database.
Question
You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use? (Choose two.)
Options
- APerform a rolling upgrade.
- BPerform a direct upgrade by running the Database Upgrade Assistant (DBUA).
- CPerform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the
- DInstall the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle
- EUpgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle
How the community answered
(34 responses)- A3% (1)
- B6% (2)
- C12% (4)
- D79% (27)
Why each option
Upgrading an Oracle 9i database to Oracle 12c requires an indirect approach because 9i is not directly supported, necessitating either a multi-step upgrade or a data migration to a newly created database.
A rolling upgrade is typically used in Oracle Real Application Clusters (RAC) environments to minimize downtime during direct upgrades between compatible versions, which 9i to 12c is not.
The Database Upgrade Assistant (DBUA) facilitates direct upgrades, but Oracle Database 9i is too old to be directly upgraded to Oracle Database 12c using DBUA.
Manually running `catctl.pl` and `catupgrd.sql` are steps for a direct database upgrade, which is not supported for a 9i to 12c upgrade path.
For significant version jumps or unsupported direct paths, a common upgrade method involves installing the new Oracle 12c software, creating an empty 12c database, and then migrating data from the 9i database using utilities like Oracle Data Pump (expdp/impdp) or transportable tablespaces.
Oracle Database 9i is not a direct upgrade path to Oracle Database 12c. An intermediate upgrade to a supported release, such as Oracle Database 10.2.0.5 or 11.2.0.4, is necessary before performing a final upgrade to 12c.
Concept tested: Oracle database upgrade paths and methods
Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/overview-oracle-database-upgrade.html#GUID-E1A0F495-2E51-4E66-8A63-9D275A0CC480
Topics
Community Discussion
No community discussion yet for this question.