About Converting Databases During Upgrades

Review these topics to determine which is the best path for you to select to upgrade Oracle Databases.

Software-Only Manual Upgrades Using DDLs

If you perform a software-only non-CDB installation, without creating a database, and instead use DDL statements to create a database, then special considerations apply for Oracle Database 12c Release 2 (12.2).

If you perform a software-only installation of a non-CDB Oracle Database 12c Release 2 (12.2) Oracle home, and then use exported data definition language (DDL) statements to create a database in the new Oracle Database home, then ensure that you complete that procedure using the following steps:

  1. Install Oracle Database 12c Release 2 (12.2); do not create the database.
  2. Patch the database using the relevant Database release update (RU). For example, patch it with the 12.2.0.1 Database Release Update (12.2.0.1.181016) bundle patch.
  3. Create the database using CREATE DATABASE DDLs
  4. Manually run utlrp.sql
  5. Run datapatch.pl.