Amazon RDS for Oracle
Amazon RDS supports DB instances that run the following versions and editions of Oracle Database:
-
Oracle Database 21c (21.0.0.0)
-
Oracle Database 19c (19.0.0.0)
Note
Oracle Database 11g, Oracle Database 12c, and Oracle Database 18c are legacy versions that are no longer supported in Amazon RDS.
Before creating a DB instance, complete the steps in the Setting up your Amazon RDS environment section of this guide. When you create a DB instance using your master account,
the account gets DBA privileges, with some limitations. For example, the master user can't perform operations that
require SYSDBA privileges, and access to certain Oracle-supplied packages and tables is restricted. For more
information, see RDS for Oracle users and privileges. Use this
account for administrative tasks such as creating additional database accounts. You can't use SYS, SYSTEM, or other
Oracle-supplied administrative accounts. To grant privileges on objects owned by SYS, use the
rdsadmin.rdsadmin_util.grant_sys_object procedure. For more information, see How to manage privileges on SYS objects.
You can create the following:
-
DB instances
-
DB snapshots
-
Point-in-time restores
-
Automated backups
-
Manual backups
You can use DB instances running Oracle Database inside a VPC. You can also add features to your DB instance by enabling various options, such as Oracle Spatial or Oracle Statspack. To use an option, you create an option group, add the option to it, and associate the option group with your DB instance. For more information, see Adding options to Oracle DB instances. Amazon RDS supports Multi-AZ deployments for Oracle as a high-availability, failover solution.
Important
To deliver a managed service experience, Amazon RDS doesn't provide shell access to DB instances. It also restricts access to certain system procedures and tables that need advanced privileges. You can access your database using standard SQL clients such as Oracle SQL*Plus. However, you can't access the host directly by using Telnet or Secure Shell (SSH).