Oracle versions on Amazon RDS - Amazon Relational Database Service

Oracle versions on Amazon RDS

Amazon RDS for Oracle supports the following major database releases.

Oracle Database 21c with Amazon RDS

Amazon RDS supports Oracle Database 21c, which includes Oracle Enterprise Edition and Oracle Standard Edition Two. Oracle Database 21c (21.0.0.0) includes many new features and updates from the previous version. A key change is that Oracle Database 21c supports only the multitenant architecture: you can no longer create a database as a traditional non-CDB. To learn more about the differences between CDBs and non-CDBs, see Limitations of a single-tenant CDB.

In this section, you can find the features and changes important to using Oracle Database 21c (21.0.0.0) on Amazon RDS. For a complete list of the changes, see the Oracle database 21c documentation. For a complete list of features supported by each Oracle Database 21c edition, see Permitted features, options, and management packs by Oracle database offering in the Oracle documentation.

Amazon RDS parameter changes for Oracle Database 21c (21.0.0.0)

Oracle Database 21c (21.0.0.0) includes several new parameters and parameters with new ranges and new default values.

New parameters

The following table shows the new Amazon RDS parameters for Oracle Database 21c (21.0.0.0).

Name

Range of values

Default value

Modifiable

Description

blockchain_table_max_no_drop

NONE | 0

NONE

Y

Lets you control the maximum amount of idle time that can be specified when creating a blockchain table.

dbnest_enable

NONE | CDB_RESOURCE_PDB_ALL

NONE

N

Allows you to enable or disable dbNest. DbNest provides operating system resource isolation and management, file system isolation, and secure computing for PDBs.

dbnest_pdb_fs_conf

NONE | pathname

NONE

N

Specifies the dbNest file system configuration file for a PDB.

diagnostics_control

ERROR | WARNING | IGNORE

IGNORE

Y

Allows you to control and monitor the users who perform potentially unsafe database diagnostic operations.

drcp_dedicated_opt

YES | NO

YES

Y

Enables or disables the use of dedicated optimization with Database Resident Connection Pooling (DRCP).

enable_per_pdb_drcp

true | false

true

N

Controls whether Database Resident Connection Pooling (DRCP) configures one connection pool for the entire CDB or one isolated connection pool for each PDB.

inmemory_deep_vectorization

true | false

true

Y

Enables or disables the deep vectorization framework.

mandatory_user_profile

profile_name

N/A

N

Specifies the mandatory user profile for a CDB or PDB.

optimizer_capture_sql_quarantine

true | false

false

Y

Enables or disables the deep vectorization framework.

optimizer_use_sql_quarantine

true | false

false

Y

Enables or disables the automatic creation of SQL Quarantine configurations.

result_cache_execution_threshold

0 to 68719476736

2

Y

Specifies the maximum number of times a PL/SQL function can be executed before its result is stored in the result cache.

result_cache_max_temp_result

0 to 100

5

Y

Specifies the percentage of RESULT_CACHE_MAX_TEMP_SIZE that any single cached query result can consume.

result_cache_max_temp_size

0 to 2199023255552

RESULT_CACHE_SIZE * 10

Y

Specifies the maximum amount of temporary tablespace (in bytes) that can be consumed by the result cache.

sga_min_size

0 to 2199023255552 (maximum value is 50% of sga_target)

0

Y

Indicates a possible minimum value for SGA usage of a pluggable database (PDB).

tablespace_encryption_default_algorithm

GOST256 | SEED128 | ARIA256 | ARIA192 | ARIA128 | 3DES168 | AES256 | AES192 | AES128

AES128

Y

Specifies the default algorithm the database uses when encrypting a tablespace.

Changes for the compatible parameter

The compatible parameter has a new maximum value for Oracle Database 21c (21.0.0.0) on Amazon RDS. The following table shows the new default value.

Parameter name

Oracle Database 21c (21.0.0.0) maximum value

compatible

21.0.0

Removed parameters

The following parameters were removed in Oracle Database 21c (21.0.0.0):

  • remote_os_authent

  • sec_case_sensitive_logon

  • unified_audit_sga_queue_size

Oracle Database 19c with Amazon RDS

Amazon RDS supports Oracle Database 19c, which includes Oracle Enterprise Edition and Oracle Standard Edition Two.

Oracle Database 19c (19.0.0.0) includes many new features and updates from the previous version. In this section, you can find the features and changes important to using Oracle Database 19c (19.0.0.0) on Amazon RDS. For a complete list of the changes, see the Oracle database 19c documentation. For a complete list of features supported by each Oracle Database 19c edition, see Permitted features, options, and management packs by Oracle database offering in the Oracle documentation.

Amazon RDS parameter changes for Oracle Database 19c (19.0.0.0)

Oracle Database 19c (19.0.0.0) includes several new parameters and parameters with new ranges and new default values.

New parameters

The following table shows the new Amazon RDS parameters for Oracle Database 19c (19.0.0.0).

Name

Values

Modifiable

Description

lob_signature_enable

TRUE, FALSE (default)

Y

Enables or disables the LOB locator signature feature.

max_datapump_parallel_per_job

1 to 1024, or AUTO

Y

Specifies the maximum number of parallel processes allowed for each Oracle Data Pump job.

Changes to the compatible parameter

The compatible parameter has a new maximum value for Oracle Database 19c (19.0.0.0) on Amazon RDS. The following table shows the new default value.

Parameter name

Oracle Database 19c (19.0.0.0) maximum value

compatible

19.0.0

Removed parameters

The following parameters were removed in Oracle Database 19c (19.0.0.0):

  • exafusion_enabled

  • max_connections

  • o7_dictionary_access

Oracle Database 12c with Amazon RDS

Amazon RDS supports Oracle Database 12c for both Oracle Enterprise Edition and Oracle Standard Edition 2. However, Oracle Database 12c is on a deprecation path.

Oracle Database 12c Release 1 (12.1.0.2) with Amazon RDS

On July 31, 2022, Amazon RDS plans to deprecate support for Oracle Database 12c Release 1 (12.1.0.2) for BYOL and LI. For more information, see the end of support timeline on AWS re:Post and Preparing for the automatic upgrade of Oracle Database 12c . The following schedule includes upgrade recommendations.

Date Action or recommendation

Now–July 31, 2022

We recommend that you upgrade Oracle Database 12c Release 1 (12.1.0.2) DB instances manually to a higher release.

June 1, 2022

We recommend that you upgrade Oracle Database 12c Release 1 (12.1.0.2) DB snapshots manually to a higher release.

June 1, 2022

You can no longer create new Oracle Database 12c Release 1 (12.1.0.2) DB instances with Amazon RDS. Up to July 31, 2022, you can continue to restore 12.1.0.2 DB snapshots without being automatically upgraded.

July 31, 2022

Amazon RDS plans to deprecate support of Oracle Database 12c Release 1 (12.1.0.2). On this date, the release moves from Oracle Extended Support to Oracle Sustaining Support, indicating that Oracle Support will no longer release critical patch updates for this release.

August 1, 2022

Amazon RDS plans to start automatic upgrades of your Oracle Database 12c Release 1 (12.1.0.2) instances to the latest Release Update (RU) for Oracle Database 19c. The automatic upgrade occurs during maintenance windows. If maintenance windows aren't available when the upgrade needs to occur, Amazon RDS upgrades the engine immediately.

August 1, 2022

Amazon RDS plans to start automatic upgrades to Oracle Database 19c for any Oracle Database 12c Release 1 (12.1.0.2) DB instances restored from snapshots.

Oracle Database 12c Release 2 (12.2.0.1) with Amazon RDS

Oracle Corporation deprecated support for Oracle Database 12c Release 2 (12.2.0.1) for BYOL and LI on March 31, 2022. On this date, the release moved from Oracle Extended Support to Oracle Sustaining Support, indicating the end of support for this release. The following schedule describes the automatic upgrade schedule. For more information, see the end of support timeline on AWS re:Post and Preparing for the automatic upgrade of Oracle Database 12c .

Date Action or recommendation

April 1, 2022

Amazon RDS began automatic upgrades of your Oracle Database 12c Release 2 (12.2.0.1) instances to Oracle Database 19c.

April 1, 2022

Amazon RDS began automatic upgrades to Oracle Database 19c for any Oracle Database 12c Release 2 (12.2.0.1) DB instances restored from snapshots.