Oracle Database on AWS
Oracle Database Quick Start

Planning the Deployment

Before you deploy Oracle Database on AWS, please review the following sections for more information about the Oracle Database installation and deployment options.

Deployment Scenarios

This Quick Start provides two deployment options:

  • Deploy Oracle Database into a new VPC (end-to-end deployment). This option builds a new AWS environment consisting of the VPC, subnets, NAT gateways, security groups, bastion hosts, and other infrastructure components, and then deploys Oracle Database into that new VPC.

  • Deploy Oracle Database into an existing VPC. This option provisions Oracle Database in your existing AWS infrastructure.

The Quick Start provides separate templates for these options. It also lets you configure additional settings such as CIDR blocks and instance types, and install optional Oracle products, as discussed later in this guide.

Oracle Database 12c Editions

This Quick Start requires Oracle Database 12c Enterprise Edition, which is the only edition that includes Oracle Data Guard.

In Oracle Database 12c Enterprise Edition, you can choose to use the standard Linux file system (e.g., ext4) or Automatic Storage Management (ASM) to store your data files, redo logs, and archived logs. This Quick Start deploys an ASM infrastructure, which provides better performance and file management than the standard Linux file system. Oracle ASM supports automatic file management and data striping across multiple EBS volumes, providing high performance and an easy way to scale your storage area.

        Oracle Database installation summary

Figure 3: Oracle Database installation summary

Operating System for Deployment

You can use Linux or Microsoft Windows for your Oracle Database installation on AWS. This Quick Start deployment uses Linux. The Quick Start supports Red Hat Enterprise Linux (RHEL) version 7.2 and Oracle Linux 7.3.

Storage Management

This Quick Start uses Oracle ASM as the storage layer of the virtual machine, because ASM helps you add and reduce capacity easily. ASM’s striping feature, which spreads data across multiple disks in 1-MiB blocks, also supports distributed I/O across all the EBS volumes.

        ASM disk groups

Figure 4: ASM disk groups

This Quick Start gives you a choice of General Purpose SSD (gp2) volumes or Provisioned IOPS SSD (io1) volumes.

Setting an ASM disk group to several gp2 volumes provides a burst capability per EBS volume of up to 3,000 IOPS, which means 18,000 IOPS for a six-volume DATA disk group and 9,000 IOPS for a three-volume RECO disk group, even with disks as small as 1 GiB.

For sustained IOPS, each 1-GiB gp2 volume delivers 3 IOPS until the limit of 48,000 IOPS is reached. So with our six-volume data disks, the maximum I/O throughput is achieved with 2,666 GiB volumes (x 6 = 16,000 GiB disk group) or higher volumes.

For sustained IOPS that is higher than 3 IOPS/GiB, you can use io1 volumes. This option typically addresses the needs of critical business applications that require sustained IOPS performance or more than 10,000 IOPS or 160 MiB/s of throughput per volume, and can then achieve 500 MiB/s per volume for volumes created after June 12, 2017.

If you choose Provisioned IOPS (io1) volumes, you will need to provide the amount of IOPS desired for both DATA and RECO volumes.

ASM is part of Oracle Grid Infrastructure, which is provided as a standalone download, so this Quick Start installs Oracle Grid Infrastructure followed by Oracle Database 12c.

Oracle Memory Configuration

The Quick Start maps each instance type to an Oracle SGA size in megabytes (60% of available RAM in the instance) and SHMMAX kernel, using 75% of the memory available to allow further SGA growth. For more information, see the Oracle support document 1529864.1 (access to the document requires an Oracle account). The Quick Start provides default settings that you can revise; see the Mappings section of the AWS CloudFormation template.

"Mappings": { "AWSInstanceType2Value": { "t2.medium": { "sga": "2458", "shmall": "838861", "shmmax": "3221225472" }, ... "t2.large": { "sga": "4915", "shmall": "1677722", "shmmax": "6442450944" }, ... "r3.8xlarge": { "sga": "149914", "shmall": "51170509", "shmmax": "196494753792" }, ...

Backup Options

The Amazon S3 service provides an easy way to handle Oracle Database backups. AWS provides large network bandwidth from the EC2 instances deployed by the Quick Start to the S3 buckets.

Oracle also provides a product called Oracle Secure Backup (OSB) Cloud Module. This product is not included in Oracle Enterprise Edition and requires a separate license with Oracle. This Quick Start gives you the option to install the OSB Cloud Module. You can use the parameters in the Oracle Secure Backup Cloud Module section of the template to configure the settings for this module, including the name of the S3 bucket for storing your Oracle Database backups, your Oracle Technology Network (OTN) account and password, and an access key and secret key for accessing the bucket. See step 3 in the deployment steps for details. To register for an OTN account, see the Oracle documentation.

For more information about Oracle Database backup options after deployment, see the Backing Up Your Data section later in this guide.