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 will use to 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.

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.

    
						DB instance details
  8. On the Specify DB Details page, specify your DB instance information. The following table shows the parameters you need to set to create a DB instance.

    For this parameter... ...Do this:

    License Model

    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.

    DB Engine Version

    Choose the Oracle version you want to use.

    DB Instance Class

    Choose the DB instance class you want to use.

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

    Multi-AZ Deployment

    Determine if you want to create a standby replica of your DB instance in another availability zone for failover support. This feature is available for Oracle and MySQL DB instances.

    For more information, see Regions and Availability Zones.

    Storage Type

    Choose the storage type you want to use.

    For more information, see Amazon RDS Storage Types.

    Allocated Storage

    Type a value to allocate of storage for your database (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.

    DB Instance Identifier

    Type a name for the DB instance that is unique for your account in the region you chose. You can add some intelligence to the name, such as including the region and DB engine you chose, for example oracle-instance1.

    Master User Name

    Type a name that you will 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.

    Master User Password and Confirm Password

    Type a password that contains from 8 to 30 printable ASCII characters (excluding /,", and @) for your master user password. Retype the password in the Confirm Password text box.

  9. Choose Next to continue.

    The Configure Advanced Settings page appears.

    
						Additional Configuration panel
  10. On the Configure Advanced Settings page, you provide additional information that RDS needs to launch the Oracle DB instance. The following table shows the additional parameters you provide for a DB instance.

    For this parameter Do this

    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.

    Subnet Group

    This setting depends on the platform you are on. If you are a new customer to AWS, choose default, which will be 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.

    Publicly Accessible

    Choose Yes to give the DB instance a public IP address, meaning that it will be accessible outside the VPC (the DB instance also needs to be in a public subnet in the VPC); otherwise, choose No, so the DB instance will only be accessible from inside the VPC.

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

    Availability Zone

    Use the default of No Preference unless you need to specify a particular Availability Zone.

    For more information, see Regions and Availability Zones.

    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.

    Database Name

    Type a name for your database that begins with a letter and contains up to 8 alpha-numeric characters. If you do not provide a name, Amazon RDS will not create a database on the DB instance you are creating.

    Database Port

    Specify the port you want to access the database through. Oracle installations default to port 1521.

    DB Parameter Group

    Choose a parameter group. You can choose the default parameter group or you can create a parameter group and choose that parameter group.

    For more information, see Working with DB Parameter Groups.

    Option Group

    Choose an option group. You can choose the default option group or you can create an option group and choose that option group.

    For more information, see Working with Option Groups.

    Copy Tags To Snapshots

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

    For more information, see Tagging Amazon RDS Resources.

    Character Set Name

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

    Enable Encryption

    Choose Yes to enable encryption at rest for this DB instance.

    For more information, see Encrypting Amazon RDS Resources.

    Backup Retention Period

    Set the number of days you want automatic backups of your database 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

    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.

    Enable Enhanced Monitoring

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

    For more information, see Enhanced Monitoring.

    Auto Minor Version Upgrade

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

    Maintenance Window

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

    For more information, see Amazon RDS Maintenance Window.

  11. Choose Launch DB Instance.

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

  13. On the RDS console, the new DB instance appears in the list of DB instances. The DB instance will have 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 a DB instance running the Oracle database engine, use the AWS CLI create-db-instance command with the following parameters:

  • --db-instance-identifier

  • --engine

Example

The following command will launch the example DB instance.

For Linux, OS X, or Unix:

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

For Windows:

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

This command should produce output similar to the following:

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

API

To create a DB instance running the Oracle database engine, use the Amazon RDS API CreateDBInstance action with the following parameters:

  • DBInstanceIdentifier = mydbinstance

  • Engine = oracle-se1

  • DBInstanceClass = db.m1.small

  • AllocatedStorage = 20

  • BackupRetentionPeriod = 3

  • MasterUsername = masterawsuser

  • MasterUserPassword = masteruserpassword

Example

Copy
https://rds.amazonaws.com/ ?Action=CreateDBInstance &AllocatedStorage=20 &BackupRetentionPeriod=3 &DBInstanceClass=db.m1.small &DBInstanceIdentifier=mydbinstance &DBName=mydatabase &DBSecurityGroups.member.1=mysecuritygroup &DBSubnetGroup=mydbsubnetgroup &Engine=oracle-se1 &MasterUserPassword=<masteruserpassword> &MasterUsername=<masterawsuser> &SignatureMethod=HmacSHA256 &SignatureVersion=4 &Version=2013-09-09 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20140202/us-west-2/rds/aws4_request &X-Amz-Date=20140202T190545Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=60e907d8d43fdc978941c1566f7b3c5054e0328622a871fb59b61782ee1f30d8

Related Topics