Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Creating a DB Instance Running the Oracle Database Engine

The basic building block of Amazon RDS is the DB instance. This is the environment in which you run your Oracle databases.

Important

You must complete the tasks in the Setting Up for Amazon RDS section before you can create or connect to a DB instance.

For an example that walks you through the process of creating and connecting to a sample DB instance, see Creating an Oracle DB Instance and Connecting to a Database on an Oracle DB Instance.

AWS Management Console

To launch an Oracle DB instance

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the top right corner of the AWS Management Console, choose the region in which you want to create the DB instance.

  3. In the navigation pane, choose DB Instances.

  4. Choose Launch DB Instance to start the Launch DB Instance Wizard.

    The wizard opens on the Select Engine page. The Oracle editions that are available vary by region.

    
						Engine selection
  5. In the Select Engine window, choose the Select button for the Oracle DB engine you want to use.

  6. The next step asks if you are planning to use the DB instance you are creating for production. If you are, choose Yes. By choosing Yes, the failover option Multi-AZ and the Provisioned IOPS storage option will be preselected in the following step.

  7. Choose Next to continue. The Specify DB Details page appears.

    On the Specify DB Details page, specify your DB instance information. For information about each setting, see Settings for Oracle DB Instances.

    
						DB instance details
  8. Choose Next to continue. The Configure Advanced Settings page appears.

    On the Configure Advanced Settings page, provide additional information that RDS needs to launch the DB instance. For information about each setting, see Settings for Oracle DB Instances.

    
						Additional Configuration panel
  9. Choose Launch DB Instance.

  10. On the final page of the wizard, choose Close.

On the RDS console, the new DB instance appears in the list of DB instances. The DB instance has a status of creating until the DB instance is created and ready for use. When the state changes to available, you can connect to the DB instance. Depending on the DB instance class and storage allocated, it could take several minutes for the new instance to be available.


				My DB instances list

CLI

To create an Oracle DB instance by using the AWS CLI, call the create-db-instance command with the parameters below. For information about each setting, see Settings for Oracle DB Instances.

  • --db-instance-identifier

  • --db-instance-class

  • --db-security-groups

  • --db-subnet-group

  • --engine

  • --master-user-name

  • --master-user-password

  • --allocated-storage

  • --backup-retention-period

Example

The following command will launch the example DB instance.

For Linux, OS X, or Unix:

Copy
aws rds create-db-instance \ --engine oracle-se1 \ --db-instance-identifier mydbinstance \ --allocated-storage 20 \ --db-instance-class db.m1.small \ --db-security-groups mydbsecuritygroup \ --db-subnet-group mydbsubnetgroup \ --master-username masterawsuser \ --master-user-password masteruserpassword \ --backup-retention-period 3

For Windows:

Copy
aws rds create-db-instance ^ --engine oracle-se1 ^ --db-instance-identifier mydbinstance ^ --allocated-storage 20 ^ --db-instance-class db.m1.small ^ --db-security-groups mydbsecuritygroup ^ --db-subnet-group mydbsubnetgroup ^ --master-username masterawsuser ^ --master-user-password masteruserpassword ^ --backup-retention-period 3

This command should produce output similar to the following:

DBINSTANCE  mydbinstance  db.m1.small  oracle-se1  20  sa  creating  3  ****  n  11.2.0.4.v1
SECGROUP  default  active
PARAMGRP  default.oracle-se1-11.2  in-sync

API

To create an Oracle DB instance by using the Amazon RDS API, call the CreateDBInstance action with the parameters below. For information about each setting, see Settings for Oracle DB Instances.

  • AllocatedStorage

  • BackupRetentionPeriod

  • DBInstanceClass

  • DBInstanceIdentifier

  • DBSecurityGroups

  • DBSubnetGroup

  • Engine

  • MasterUsername

  • MasterUserPassword

Example

Copy
https://rds.amazonaws.com/ ?Action=CreateDBInstance &AllocatedStorage=250 &BackupRetentionPeriod=3 &DBInstanceClass=db.m1.large &DBInstanceIdentifier=mydbinstance &DBSecurityGroups.member.1=mysecuritygroup &DBSubnetGroup=mydbsubnetgroup &Engine=oracle-se1 &MasterUserPassword=masteruserpassword &MasterUsername=masterawsuser &SignatureMethod=HmacSHA256 &SignatureVersion=4 &Version=2014-10-31 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20140305/us-west-1/rds/aws4_request &X-Amz-Date=20140305T185838Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=b441901545441d3c7a48f63b5b1522c5b2b37c137500c93c45e209d4b3a064a3

Settings for Oracle DB Instances

The following table contains details about settings that you choose when you create an Oracle DB instance.

Setting Setting Description
Allocated Storage

The amount of storage to allocate your DB instance (in gigabytes). In some cases, allocating a higher amount of storage for your DB instance than the size of your database can improve I/O performance.

For more information, see Storage for Amazon RDS.

Auto Minor Version Upgrade

Amazon RDS does not support automatic minor version upgrades for DB instances running Oracle. You must modify your DB instance manually to perform a minor version upgrade.

Some options, such as Oracle Locator, Oracle Multimedia, and Oracle Spatial, require that you enable automatic minor version upgrades. Upgrades for DB instances that use these options are installed during your scheduled maintenance window, and an outage occurs during the upgrade. You can't disable automatic minor version upgrades at the same time as you modify the option group to remove such an option.

Availability Zone

The availability zone for your DB instance. Use the default of No Preference unless you need to specify a particular Availability Zone.

For more information, see Regions and Availability Zones.

Backup Retention Period

The number of days that you want automatic backups of your DB instance to be retained. For any non-trivial instance, you should set this value to 1 or greater.

For more information, see Working With Backups.

Backup Window

The time period during which Amazon RDS automatically takes a backup of your DB instance. Unless you have a specific time that you want to have your database backup, use the default of No Preference.

For more information, see Working With Backups.

Character Set Name

The character set for your DB instance. The default value of AL32UTF8 is for the Unicode 5.0 UTF-8 Universal character set. You cannot change the character set after the DB instance is created.

For more information, see Oracle Character Sets Supported in Amazon RDS.

Copy Tags To Snapshots

Select this option to copy any DB instance tags to a DB snapshot when you create a snapshot.

For more information, see Tagging Amazon RDS Resources.

Database Name

The name for the database on your DB instance. The name must begin with a letter and contain up to 8 alpha-numeric characters. You can't specify the string NULL, or any other reserved word, for the database name. If you do not provide a name, Amazon RDS does not create a database on the DB instance you are creating.

Database Port

The port that you want to access the DB instance through. Oracle installations default to port 1521.

DB Engine Version

The version of Oracle that you want to use.

DB Instance Class

The DB instance class that you want to use.

For more information, see DB Instance Class and DB Instance Class Support for Oracle.

DB Instance Identifier

The name for your DB instance. The name must be unique for your account and region. You can add some intelligence to the name, such as including the region and DB engine you chose, for example oracle-instance1.

DB Parameter Group

A parameter group for your DB instance. You can choose the default parameter group or you can create a custom parameter group.

For more information, see Working with DB Parameter Groups.

Enable Encryption

Yes to enable encryption at rest for this DB instance.

For more information, see Encrypting Amazon RDS Resources.

Enable Enhanced Monitoring

Yes to gather metrics in real time for the operating system that your DB instance runs on.

For more information, see Enhanced Monitoring.

License Model

The license model that you want to use. Choose license-included to use the general license agreement for Oracle. Choose bring-your-own-license to use your existing Oracle license.

For more information, see Oracle Licensing.

Maintenance Window

The 30 minute window in which pending modifications to your DB instance are applied. If the time period doesn't matter, choose No Preference.

For more information, see The Amazon RDS Maintenance Window.

Master User Name

The name that you use as the master user name to log on to your DB instance with all database privileges. This user account is used to log into the DB instance and is granted DBA privileges.

For more information, see Oracle Security.

Master User Password

The password for your master user account. The password must contain from 8 to 30 printable ASCII characters (excluding /,", and @).

Multi-AZ Deployment

Yes to create a standby replica of your DB instance in another availability zone for failover support. We recommend Multi-AZ for production workloads to maintain high availability. For development and testing, you can choose No.

For more information, see Regions and Availability Zones.

Option Group

An option group for your DB instance. You can choose the default option group or you can create a custom option group.

For more information, see Working with Option Groups.

Publicly Accessible

Yes to give your DB instance a public IP address. This means that it is accessible outside the VPC (the DB instance also needs to be in a public subnet in the VPC). Choose No if you want the DB instance to only be accessible from inside the VPC.

For more information, see Hiding a DB Instance in a VPC from the Internet.

Storage Type

The storage type for your DB instance.

For more information, see Amazon RDS Storage Types.

Subnet Group

This setting depends on the platform you are on. If you are a new customer to AWS, choose default, which is the default DB subnet group that was created for your account. If you are creating a DB instance on the previous E2-Classic platform and you want your DB instance in a specific VPC, choose the DB subnet group you created for that VPC.

VPC

This setting depends on the platform you are on. If you are a new customer to AWS, choose the default VPC. If you are creating a DB instance on the previous E2-Classic platform, choose Not in VPC.

For more information, see Amazon Virtual Private Cloud (VPCs) and Amazon RDS.

VPC Security Group

If you are a new customer to AWS, choose the default VPC. If you have created your own VPC security group, choose the VPC security group you previously created.

For more information, see Working with DB Security Groups (EC2-Classic Platform).

Related Topics