Download
running oracle in ec2 ahbaid gaffoor amazon com a9 com n.
Skip this Video
Loading SlideShow in 5 Seconds..
Running Oracle in EC2 Ahbaid Gaffoor Amazon.com/A9.com PowerPoint Presentation
Download Presentation
Running Oracle in EC2 Ahbaid Gaffoor Amazon.com/A9.com

Running Oracle in EC2 Ahbaid Gaffoor Amazon.com/A9.com

190 Vues Download Presentation
Télécharger la présentation

Running Oracle in EC2 Ahbaid Gaffoor Amazon.com/A9.com

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Running Oracle in EC2Ahbaid GaffoorAmazon.com/A9.com

  2. Overview • Section 1: Pricing and Licensing • Section 2: Getting Started with AWS • Section 3: Installing Oracle • Section 4: Secure Backup Oracle on EC2, NoCOUG Aug 20th 2009

  3. Section 1 Pricing and Licensing Oracle on EC2, NoCOUG Aug 20th 2009

  4. Section 1: Pricing and Licensing • Amazon Web Services (AWS) Overview • Pricing of relevant AWS Services • Oracle Licensing and Support • Oracle Secure Backup Cloud Module Oracle on EC2, NoCOUG Aug 20th 2009

  5. 1.1 AWS Overview: • Amazon Elastic Compute Cloud (EC2) • Amazon Simple Storage Service (S3) • Amazon Cloud Front • Amazon SimpleDB • Amazon Simple Queue Service (SQS) • Amazon Elastic MapReduce Oracle on EC2, NoCOUG Aug 20th 2009

  6. 1.2 AWS Pricing EC2: • Elastic Compute Cloud (EC2) • Prices http://aws.amazon.com/ec2/#pricing • Amazon Machine Image (AMI): • On Demand, Reserved 1 Year, 3 Years • Standard CPU AMI: • Small $0.10/hr, $325/yr ($0.03/hr),$500/3yr • Large $0.40/hr, $1300/yr($0.12/hr),$2000/3yr • XLarge $0.80/hr, $2600/yr($0.24/hr),$4000/3yr • High CPU AMI: • Medium $0.20/hr, $650/yr($0.06/hr),$1000/3yr • XLarge $0.80/hr, $2600/yr($0.24/hr),$4000/3yr Oracle on EC2, NoCOUG Aug 20th 2009

  7. 1.2 AWS Pricing EC2 (Cont’d): • Elastic Compute Cloud (EC2) • Elastic IP • Public, Static IP • IP Map/Re-map > 100/month $0.10 each • $0.01 non-attached per hour • Elastic Block Store (EBS) • $0.10 GB/month provisioned • $0.10 per 1MM/month I/O requests • EBS Snapshots to S3 • $0.15 GB/month • $0.01 per 1,000 PUT requests (when saving a snapshot) • $0.01 per 10,000 GET requests (when loading a snapshot) Oracle on EC2, NoCOUG Aug 20th 2009

  8. 1.2 AWS Pricing S3: • Simple Storage Service (S3) • Prices http://aws.amazon.com/s3/#pricing • Operations: PUT, GET, DELETE • Storage • $0.15GB/Month < 50TB • $0.14GB/Month > 50TB, < 400TB • $0.13GB/Month > 400TB, < 500TB • $0.12GB/Month > 500TB • Data Transfer • $0.10GB all data transfer in Oracle on EC2, NoCOUG Aug 20th 2009

  9. 1.2 AWS Pricing S3 (Cont’d): • Requests • $0.01 per 1,000 PUT, COPY, POST or LIST request • DELETES are free • $0.01 per 10,000 GET and all other requests • AWS Import/Export • Device Handling $80.00 each • Data loading $2.49 per hr (hourly increment) Oracle on EC2, NoCOUG Aug 20th 2009

  10. 1.2 AWS Pricing Import/Export: • Not Database exp/imp • AWS Import/Export • Device Handling $80.00 each • Data loading $2.49 per hr (hourly increment) • http://aws.amazon.com/importexport/ • Calculator: http://awsimportexport.s3.amazonaws.com/aws-import-export-calculator.html Oracle on EC2, NoCOUG Aug 20th 2009

  11. 1.2 AWS Data Transfer Pricing: • Data Transfer: • Regions: US, EU • Sub-region (zone) • Free within zones on private IP • Elastic IP or Public IP outside AWS, regional charges Oracle on EC2, NoCOUG Aug 20th 2009

  12. 1.3 Oracle Licensing: • Existing or New License • http://www.oracle.com/corporate/pricing/cloud-licensing.pdf • Cost of AMI • Pre-built Oracle AMI (11g) • Roll your own AMI Oracle on EC2, NoCOUG Aug 20th 2009

  13. 1.3 Oracle Support: • Virtualization Support – AWS • Database Support • Oracle Secure Backup Cloud Module • http://www.oracle.com/technology/tech/cloud/faq.html#support • No RAC Oracle on EC2, NoCOUG Aug 20th 2009

  14. 1.4 Oracle Secure Backup Cloud Module: • Backups to S3 via. RMAN • 9i R2 and higher • Pre-installed on Oracle AMIs • EC2 and non-EC2 databases • Requires S3 and OTN accounts • Integrated with Enterprise Manager Oracle on EC2, NoCOUG Aug 20th 2009

  15. Section 2 Getting Started with AWS Oracle on EC2, NoCOUG Aug 20th 2009

  16. Section 2: Getting Started with AWS • AWS account • AWS EC2 Console • EC2 Security Groups • EC2 Key Pairs • EC2 Amazon Machine Images (AMIs) • EC2 Elastic IP • EC2 EBS Volumes • EC2 Snapshots • Using EC2 Command Line tools Oracle on EC2, NoCOUG Aug 20th 2009

  17. 2.1 AWS account • Amazon.com account • Sign up for services at http://aws.amazon.com • EC2 Console: http://console.aws.amazon.com Oracle on EC2, NoCOUG Aug 20th 2009

  18. 2.2 AWS EC2 Console Oracle on EC2, NoCOUG Aug 20th 2009

  19. 2.2 AWS EC2 Console • Security Groups • Key Pairs • AMIs • Instances • Elastic IPs • EBS Volumes • EBS Snapshots Oracle on EC2, NoCOUG Aug 20th 2009

  20. 2.3 EC2 Security Groups Oracle on EC2, NoCOUG Aug 20th 2009

  21. 2.3 EC2 Security Groups - Create Oracle on EC2, NoCOUG Aug 20th 2009

  22. 2.3 EC2 Security Groups – Configuration Oracle on EC2, NoCOUG Aug 20th 2009

  23. 2.4 EC2 Key Pairs Oracle on EC2, NoCOUG Aug 20th 2009

  24. 2.4 EC2 Key Pairs – Create Oracle on EC2, NoCOUG Aug 20th 2009

  25. 2.4 EC2 Key Pairs – Save PEM file Oracle on EC2, NoCOUG Aug 20th 2009

  26. 2.4 EC2 Key Pairs – Save PEM file • Only one opportunity • Make a copy • Make another offline copy • Cannot be retrieved or restored • PEM? Oracle on EC2, NoCOUG Aug 20th 2009

  27. 2.5 EC2 AMIs Oracle on EC2, NoCOUG Aug 20th 2009

  28. 2.5 EC2 AMIs – List Options • Show/Hide (Owner, Platform, Architecture) • Oracle owner id = 725966715235 • Linux only Oracle on EC2, NoCOUG Aug 20th 2009

  29. 2.5 EC2 AMIs – Launch Instance Oracle on EC2, NoCOUG Aug 20th 2009

  30. 2.5 EC2 AMIs – Instance Options Oracle on EC2, NoCOUG Aug 20th 2009

  31. 2.5 EC2 AMIs – Availability Zones • us-east-1a • us-east-1b • us-east-1c • us-east-1d Oracle on EC2, NoCOUG Aug 20th 2009

  32. 2.5 EC2 AMIs – Instance Launch Oracle on EC2, NoCOUG Aug 20th 2009

  33. 2.5 EC2 Instances - Pending Oracle on EC2, NoCOUG Aug 20th 2009

  34. 2.5 EC2 Instances – Launched Oracle on EC2, NoCOUG Aug 20th 2009

  35. 2.5 EC2 Instances – Command Line Tools • Scriptable command line tools: • ec2-bundle-instance • ec2-confirm-product-instance • ec2-describe-instances • ec2-describe-reserved-instances • ec2-describe-reserved-instances-offerings • ec2-monitor-instances • ec2-purchase-reserved-instances-offering • ec2-reboot-instances • ec2-run-instances • ec2-terminate-instances • ec2-unmonitor-instances Oracle on EC2, NoCOUG Aug 20th 2009

  36. 2.6 EC2 Elastic IP • Static IP tied to account • Assign to any account instance • Unassigned is more expensive • Redirect failed services • Scriptable command line tools: • ec2-allocate-address • ec2-associate-address • ec2-disassociate-address • ec2-release-address Oracle on EC2, NoCOUG Aug 20th 2009

  37. 2.6 EC2 Elastic IPs Oracle on EC2, NoCOUG Aug 20th 2009

  38. 2.6 EC2 Elastic IP - Allocate Oracle on EC2, NoCOUG Aug 20th 2009

  39. 2.6 EC2 Elastic IP - Allocated Oracle on EC2, NoCOUG Aug 20th 2009

  40. 2.6 EC2 Elastic IP - Associate Oracle on EC2, NoCOUG Aug 20th 2009

  41. 2.6 EC2 Elastic IP - Associated Oracle on EC2, NoCOUG Aug 20th 2009

  42. 2.7 EC2 Elastic Block Store (EBS) Volumes • Persistent Storage • Pick zone and region • Assign to an instance within a zone • Scriptable command line tools: • ec2-create-volume • ec2-delete-volume • ec2-attach-volume • ec2-detach-volume • ec2-describe-volume Oracle on EC2, NoCOUG Aug 20th 2009

  43. 2.7 EC2 EBS Volumes Oracle on EC2, NoCOUG Aug 20th 2009

  44. 2.7 EC2 EBS Volumes - Create Oracle on EC2, NoCOUG Aug 20th 2009

  45. 2.7 EC2 EBS Volumes - Creating Oracle on EC2, NoCOUG Aug 20th 2009

  46. 2.7 EC2 EBS Volumes - Created Oracle on EC2, NoCOUG Aug 20th 2009

  47. 2.7 EC2 EBS Volumes - Attach Oracle on EC2, NoCOUG Aug 20th 2009

  48. 2.7 EC2 EBS Volumes - Attached Oracle on EC2, NoCOUG Aug 20th 2009

  49. 2.8 EC2 EBS Snapshots • Copy of EBS Volume into S3 • S3 replicates snapshots across zones • Snapshots restorable in any zone • Snapshots used to copy EBS volumes within zones • Scriptable command line tools: • ec2-create-snapshot • ec2-delete-snapshot • ec2-describe-snapshot Oracle on EC2, NoCOUG Aug 20th 2009

  50. 2.8 EC2 EBS Snapshots Oracle on EC2, NoCOUG Aug 20th 2009