8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » Vm » Here

Amazon Web Services (AWS) : Relational Database Services (RDS) for Oracle

This article describes the creation of a database using Amazon Web Services (AWS) Relational Database Services (RDS) for Oracle, a Database as a Service (DBaaS) offering.

Related articles.

Create a New Oracle Service

Select the RDS option from the service catalog.

AWS Services

If this is your first RDS service, click the "Get Started Now" button.

Get Started

Select the "Oracle EE" option by clicking the "Oracle" tab and clicking the "Select" button next to the "Oracle EE" option.

Select Engine

Decide if you want the service to be production or non-production. This will affect the high availability and storage performance options available later. In this case I'm using the Dev/Test option. When you've made your choice, click the "Next Step" button.

Production?

Enter the database details. If you are trialling the service, be careful about the options you pick. If you pick the on-demand license model your service costs will include the Oracle licensing, making the hourly cost significantly more expensive. Once you are happy with the settings click the "Next Step" button.

Specify DB Details

Enter the advanced settings, making sure the character set, backup and maintenance settings are correct for your service. Once you are happy with the settings click the "Launch DB Instance" button.

Configure Advanced Settings

Click the "View Your DB Instances" button to see the status of your service.

Created

The resulting page shows the status of your services. Once the status is "available", you can connect to the service. If you want to see the monitoring information for the specific service, click the checkbox next to the service and click the "Show Monitoring" button.

Complete

The following picture shows the monitoring graphs.

Monitoring

To display the configuration details of the service,select the "Instance Actions > See Details" option.

Monitoring

Connecting to the Service

Once the service is available you can connect to it using a regular TNS connection, using either the EZconnect URL or a "tnsnames.ora" entry.

# EZconnect
//obtest.cqafmtkif9ob.us-west-2.rds.amazonaws.com:1521/obtest

# tnsnames.ora
aws_obtest=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=obtest.cqafmtkif9ob.us-west-2.rds.amazonaws.com)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SERVER=dedicated)
      (SERVICE_NAME=obtest)
    )
  )

Restrictions

There are a number of restrictions when using RDS for Oracle, most of which are to protect the service from you doing stupid things.

For more information see:

Hope this helps. Regards Tim...

Back to the Top.