1. Using AutoUpgrade to Upgrade and Convert Non-CDBs to a PDB with the Same Operating System
  2. Checking Compatibility Before Upgrading Oracle Database

1 Checking Compatibility Before Upgrading Oracle Database

Check the Oracle Database server upgrade compatibility matrix before upgrading the Oracle Database.

Checking the Compatibility Level of Oracle Database

Use this SQL query to check that the compatibility level of your database corresponds to the value of the COMPATIBLE initialization parameter: 

SQL> SELECT name, value FROM v$parameter
         WHERE name = 'compatible';

Values for the COMPATIBLE Initialization Parameter in Oracle Database

Review to find the default, minimum, and maximum values for the COMPATIBLE initialization parameter for Oracle Database 19c.

Default and Minimum COMPATIBLE Parameter Values

The COMPATIBLE parameter should not be changed for an RU or an RUR, either for CDB or Non-CDB instances. The following table lists the default and minimum values for the COMPATIBLE parameter in Oracle Database 19c, compared to earlier releases supported for direct upgrade:

Table 1-1 The COMPATIBLE Initialization Parameter

Oracle Database Release Default Value Minimum Value
Oracle Database 19c

19.0.0

11.2.0

Oracle Database 12c Release 2 (12.2)

12.2.0

11.2.0

Oracle Database 12c Release 1 (12.1)

12.0.0

11.0.0

Oracle Database 11g Release 2 (11.2)

11.2.0

10.0.0