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 19c, and in each release supported for upgrading to Oracle Database 19c:
Table 7-1 The COMPATIBLE Initialization Parameter
| Oracle Database Release | Default Value | Minimum Value | Maximum Value |
|---|---|---|---|
| Oracle Database 19c |
|
|
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) |
|
|
|
|
Oracle Database 12c Release 1 (12.1) |
|
|
|
|
Oracle Database 11g Release 2 (11.2) |
|
|
|
Parent topic: Checking Compatibility Before Upgrading Oracle Database