1. Migrating Non-CDBs to New Hardware with the Same Operating System and for a New Release
  2. Checking Compatibility Before Upgrading Oracle Database
  3. Values for the COMPATIBLE Initialization Parameter in Oracle Database

Values for the COMPATIBLE Initialization Parameter in Oracle Database

Review to find the default, minimum, and maximum values for the COMPATIBLE initialization parameter.

The following table lists the default, minimum, and maximum values for COMPATIBLE in Oracle Database 18c, and in each release supported for upgrading to Oracle Database 18c:

Table 7-1 The COMPATIBLE Initialization Parameter

Oracle Database Release Default Value Minimum Value Maximum Value
Oracle Database 18c

18.0.0

11.2.0

The COMPATIBLE parameter should not be changed for an RU or an RUR, either for CDB or Non-CDB instances.

Oracle Database 12c Release 2 (12.2)

12.2.0

11.2.0

12.2.0

Oracle Database 12c Release 1 (12.1)

12.0.0

11.0.0

12.1.0

Oracle Database 11g Release 2 (11.2)

11.2.0

10.0.0

11.2.0

Parent topic: Checking Compatibility Before Upgrading Oracle Database