AWS is one of the major giants in Cloud technology today. In this post we will learn how to create a Relation Database Service on AWS.

To create a RDS service you should register on AWS and create a account. Amazon provide a free tier account which can be used for 12 months and has sufficient free services available to practise.

I am also using a free-tier AWS account for writing this post. 

Once we login to AWS account go to Services Tab and select RDS.













Select the instances Tab and Select Launch DB Instance












Oracle Enterprise Edition is included in free-tier. Select Oracle EE.
Fill the details as per you need.






 



DB instance creation will take some time. 















Once the instance is created it will be available.











Click on the instance name to see the details.














Select Instance Actions and select See Details for check further details.














Connecting to RDS instance using sqlplus or SQL Developer.

HostName: oraws.cyn2uth5ocpa.ap-south-1.rds.amazonaws.com
Port: 1521
Username: awsrds
Password : awsrds_password

Connection String:

PS E:\instantclient-basic-windows.x64-12.1.0.2.0\instantclient_12_1> ./sqlplus.exe awsrds/******@"(DESCRIPTI
ON=(ADDRESS=(PROTOCOL=TCP)(HOST=oraws.cyn2uth5ocpa.ap-south-1.rds.amazonaws.com)
>> (PORT=1521))(CONNECT_DATA=(SID=ORAWS)))"

SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 20 03:10:36 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Last Successful login time: Thu Apr 20 2017 03:10:03 +05:30

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name from v$database;

NAME
---------
ORAWS

I got "ORA-12170: TNS:Connect timeout occurred."error when connecting to Oracle Database on RDS
Solution:
Add entry in security group inbound connection tab.