Oracle Database on Amazon Web Services Book

The first book that covers running Oracle on Amazon Web Services:
http://www.amazon.com/Oracle-Databases-Amazon-Web-Services/dp/012800956X

Written by these companies:
http://www.appsassociates.com/awslabs/
http://aws.amazon.com/rds/partners/dbvisit/
http://www.e-dba.com/oracle_labs_aws.html

Oracle Collaborate 2014 AWS sessions

Here are the three AWS focused sessions at Oracle Collaborate http://collaborate14.com

564: Best Practices for Running Oracle Databases on Amazon Web Services (AWS)   -- Speakers: Abdul Sait
Date: 04/11/2014
Time: 8:30 AM
Location: Level 3, Lido 3101B

Deploying PeopleSoft to the Amazon Cloud  --  Speakers: Abdul Sait, David Brunet

9 Apr 08:30 AM-09:30 AM

Session ID: 106940
Room: Level 4, Lando 4301B

OEM 12c session with Oracle Product Management and App Associates:

Workshop: Simplify, Automate, and Enhance Management of E-Business Suite (EBS) Applications

Monday, April 7 1:00 PM - 4:00 PM

Level 1 Sands 101

15526

This is a paid workshop.  More information here:
https://blogs.oracle.com/oem/entry/focus_on_oracle_applications_management

Oracle Database AMIs

An easy way to Bring Your Own License (BYOL) to AWS and start running the Oracle Database is to utilize the AWS Marketplace AMIs.  There are six AMIs for Oracle 12c and 11g.  Standard Edition One, Standard Edition and Enterprise Edition versions are available for both 12c and 11g. All these Marketplace AMIs, use PIOPS with a provisioning of 500 IOPS.  The OS system is Red Hat Enterprise Linux 6.5. The AWS Marketplace AMIs can be found here:

https://aws.amazon.com/marketplace/search/results/ref=sp_navgno_search_box?page=1&searchTerms=oraclempbyol

Oracle Database on SSD

New options for running the Oracle Database on EC2 using SSD storage for your database. The I2 instances feature the latest generation of Intel Ivy Bridge processors - each virtual CPU (vCPU) is a hardware hyperthread from an Intel Xeon E5-2670 v2 (Ivy Bridge) processor. I2 instances are available in four sizes as listed in the table below. Instance Type vCPUs ECU Rating Memory (GiB) Instance Storage SSD (GB) Note           i2.xlarge 4 14 30.5 1 x 800 800 GB of SSD i2.2xlarge 8 27 61 2 x 800 1.6 TB of SSD i2.4xlarge 16 53 122 4 x 800 3.2 TB of SSD. hi.4xlarge with 2 TB  of SSD was previously largest SSD instance type i2.8xlarge 32 104 244 8 x 800 6.4 TB of SSD The i2.8xlarge instance size is capable of providing over 365,000 4 kilobyte (KB) random read IOPS and over 315,000 4 KB random write IOPS.   Great for Oracle databases that have high IO requirements.  This document has more on configuring Oracle Databases on EC2 and using SSD based instances : http://cloudconclave.blogspot.com/2013/11/aws-database-reference-implementation.html

Oracle Database 12c features for AWS

Here are some Oracle 12c features which may be of most interest to customers running Oracle Database on AWS:

-Multi tenant database : http://www.oracle.com/technetwork/database/multitenant/overview/index.html
-Active Data Guard far sync : http://docs.oracle.com/cd/E16655_01/server.121/e17640/create_fs.htm#SBYDB5416
-in memory column database : http://www.oracle.com/us/corporate/press/2020717

Oracle Database on AWS white paper

This white paper is a great resource for Oracle DBAs and developers:

http://media.amazonwebservices.com/AWS_RDBMS_Oracle.pdf

Best Practices for running Oracle Database on EC2

Register for this session on Tuesday, October 8TH:

https://www2.gotomeeting.com/register/196955594

Oracle on AWS webinar recordings

Here are the three Oracle on AWS recorded to date:
1. http://www.youtube.com/watch?v=t2UcCdnNsRc&feature=youtu.be - Smarter Agent, AWS and smartShift Technologies provides an overview of how they fully migrated their customer's, Smarter Agent, Oracle database to AWS to provide a scalable and cost effective hybrid implementation

2. http://youtu.be/XSBND55sghc - Listen to this webinar, presented by Amazon Web Services (AWS) and Apps Associates, an AWS Partner Network (APN) Advanced Consulting Partner, to hear how you can leverage the AWS platform to run a centralized OEM 12c environment to free up your administrative resources.

3. http://mfile.akamai.com/23543/wmv/citrixvar.download.akamai.com/23543/www/729/667/988620541967729667/2-988620541967729667-13e6bb61c33.asx

A good introduction to running Oracle databases & applications on Amazon Web Services platform.  Hear the answers to commonly asked questions like: Which Oracle products are available and possible to run on AWS?  What does support, pricing and licensing models look like? How to size Oracle on AWS?

Watch for more webinars after Oracle OpenWorld next week.

Oracle Enterprise Manager Solutions on AWS

Listen to this webinar, presented by Amazon Web Services (AWS) and Apps Associates, an AWS Partner Network (APN) Advanced Consulting Partner, to hear how you can leverage the AWS platform to run a centralized OEM 12c environment to free up your administrative resources:

http://youtu.be/XSBND55sghc

Oracle Database data masking on AWS

A popular first use case for migrating Oracle workloads is to move development, test and QA Oracle Databases to AWS.   This data needs to be protected using data masking.  Axis Technologies provides a technology that can mask data when an Oracle Database is hosted on AWS EC2.

More can be found here:
http://www.axistechnologyllc.com/solutions/cloudmigration

An introduction to running Oracle on AWS can be found here:
http://cloudconclave.blogspot.com/2013/06/oracle-enterprise-applications-on-aws.html

EMaaS : Oracle OEM 12c as a Service webinar

Learn how Oracle Enterprise Manager 12c Cloud Control enables you to monitor and manage the complete enterprise application stack, web tier to storage, for both dedicated and cloud-based infrastructure environments.

Join Amazon Web Services (AWS) and Apps Associates, an AWS Partner Network (APN) Advanced Consulting Partner to hear how you can leverage the AWS platform to run a centralized OEM 12c environment to free up your administrative resources.

Register here:

https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=641039&sessionid=1&key=C3BFA66F187A7E2A5DD0C6865B83A3E6&partnerref=AWSemail_v1&mkt_tok=3RkMMJWWfF9wsRow5%2FmYJoDpwmWGd5mht7VzDtPj1OY6hBkuIryWflL6iuNDGZQ7fbSfDAMKHJ52xQ5LH%2FKDdYNF6Q%3D%3D&sourcepage=register

Replay can be found here:
http://www.youtube.com/watch?v=XSBND55sghc

OEM 12c test drive on AWS

Now you can try out Oracle Enterprise Manager 12c on AWS:https://blogs.oracle.com/oem/entry/test_drive_oracle_enterprise_manager

Oracle Enterprise Manager Cloud Control 12c - Monitoring Essentials test drive lab

App Associates and AWS just announced a new test drive lab.  This test drive lab demonstrates how OEM 12c can be used to monitor and manage on premise Oracle environments in the cloud.

http://awslabs.appsassociates.com/oemdb-registration.php

Oracle on AWS costs of Oracle on AWS and licensing management

Here are two common questions in regards to Oracle pricing and licensing on AWS:

1. How can they determine the pricing for an instance launched from an Oracle AMI e.g. https://aws.amazon.com/amis/oracle-database-11g-release-2-11-2-0-1-enterprise-edition-64-bit?

The bottom line: The pricing are the standard EC2, data out traffic, and storage + cost of Oracle licenses (or no cost of Oracle licenses if they have their own)

2. How do they manage BYOL or using unused licenses in practical terms? (afaik they have to BYOL for Oracle on EC2)

The bottom line : It is up to the customer to make sure they are not violating Oracle licensing policies.

Gettings started with Oracle DB on AWS

Here are some links to get you started with Oracle database on AWS (EC2 and RDS):

• Oracle on AWS FAQ - http://www.oracle.com/technetwork/topics/cloud/faq-098970.html
• Landing page on AWS - http://aws.amazon.com/oracle/
• Oracle Amazon Machine Imagines - https://aws.amazon.com/amis?ami_provider_id=4&selection=ami_provider_id.  You can find the latest OEL AMIs, for OEL 5.9 and 6.4, at the bottom of this web page: http://aws.amazon.com/oracle/        
• Marketplace AMIs - Can be found here:  https://aws.amazon.com/marketplace/search/results/ref=srh_navgno_search_box?page=1&searchTerms=oracle+database+12c
• AWS EC2 Instances (you manage the database) - http://aws.amazon.com/ec2/instance-types/
• AWS EC2 Pricing - http://aws.amazon.com/pricing/ec2/
• AWS Pricing calculator - http://calculator.s3.amazonaws.com/calc5.html
• AWS RDS (managed database) - http://aws.amazon.com/rds/oracle/
• 10g Database - This can only be run on EC2 as RDS does not support 10g.
• Licensing - http://www.oracle.com/us/corporate/pricing/cloud-licensing-070579.pdf
• AWS RDS limitations - http://docs.amazonwebservices.com/AmazonRDS/latest/UserGuide/Concepts.DBEngine.Oracle.html
• Download and use the Oracle Database on AWS reference implementation - Oracle Database 11g on Amazon EC2 Implementation Guide
• Review the presentations here - http://www.slideshare.net/tomlaszewski