Oracle on Amazon AWS RDS

By: | Tags: , | Comments: 0

Oracle on Amazon AWS RDS

Prepared by : Unni Kirandumkara

OOAC LLC was founded in 2002 as an information technology company based in Richmond Virginia.

The company is highly specialized in database services, software development, talent sourcing and application services.  Our client base includes Federal, State, and Local Governments, and commercial companies.

Oracle on the cloud is a paradigm shift and rapidly changing the way applications are accessed in the cloud. Customers have few options available to choose a cloud provider based on security, availability, TCO, scalability, simplicity, performance, backup, restore and compliance.

AWS is the market leader in the Cloud segment and so this blog is focused on how Oracle is run on Amazon AWS RDS cloud.

Our consultants have been providing support for Oracle products on-premise and the Cloud.  Whether it is the Federal or public cloud, we have extensive experience to simplify your environment and reduce TCO.

AWS RDS AMI for Oracle allows Oracle database installation on Amazon AWS.  The procedure helps to simplify the architecture and allow DBA to focus on mission-critical tasks for the organization.  The AWS features allow IT department to build highly available Oracle environment and deploy faster.  It helps to standardize the environment and easier management features and license.

oracle on AWS rds

The environment meets compliances like ISO27001, PCI Security Standard Council, Data Privacy, AICPA SOC, and HIPPA.

In Amazon AWS, security of the cloud is managed by Amazon and customer is in-charge of security in the Cloud.

Oracle on AWS is a shared model between RDS team and customer IT department.  RDS team is responsible for physical infrastructure controls, host access, OS version and patches for OS and database.  Customer Oracle team database users, privileges, access to data, database audit, network controls and when database patches are applied.

Our experience shows the clients can benefit running Oracle database on Amazon AWS RDS by taking advantage of the unique features both vendors provide.  The Amazon RDS platform offers better reliability, scalability, backup, and recovery compared to running from a private data center. Amazon RDS adds a layer of additional security, keeps the database on certified versions and total cost of ownership (TCO) is relatively lower.

AWS RDS team supports all Oracle versions which are supported.  When Oracle deprecates product release, the client is responsible for an upgrade to a certified release.  AWS RDS team handles upgrade upon a client request.  Some of the Oracle certified versions available on RDS are 11.2.0.3, 11.2.0.4,  and 12.2.0.1.

Amazon AWS features on auto-scaling, capacity expansion on demand, high availability using availability zones (AZ), Snapshot every five minutes, Transparent data encryption (TDE) for data at rest, and patching takes away most of the complexities of running Oracle database from DBA, System Administrator, Storage Administrator and Network Administrator.

When running Oracle Database on RDS, choose automatic memory management (AMM) as a standard feature.  RDS takes care of kernel parameters.  You can monitor effective utilization of CPU and Memory utilization using AWS CloudWatch.  You can also use Oracle Enterprise Manager (OEM) to monitor the health of Oracle database and tune the database.

AWS RDS limits DBAs making certain changes directly to the database, including ALTER SYSTEM, Install features, and ALTER DATABASE.  You can make parameter changes using RDS Parameter Groups.  If you want to make install features changes, use RDS Option Groups.  Oracle commands like ALTER DATABASE are executed using PL/SQL exec rdsadmin.rdsadmin_util command.

RDS storage encryption offers EBS volume encryption completely transparent to the host and database.  Amazon allows the customer to manage KMS.

OOAC Oracle team has deep experience in managing very large Oracle database in the cloud.  OOAC is currently managing a 200 TB database on Oracle release 11.2.0.4.0 and grid infrastructure release 12.1.0.2 at a U.S. Federal agency.