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

Oracle WebLogic clustering

Active/active high availability with Oracle Weblogic on AWS EC2 can be done with Oracle WebLogic Server clustering.  You must use unicast as multicast is not supported on AWS.

Copying 1 TB of data from on premise RDBMS to AWS/EC2

I often get asked how long it will take to transmit a 1 TB database (assumes that the database is actually 1 TB in size and not just allocated at 1 TB). Elapsed time is going to depend on many factors: speed of connection, compression used (if any), can load be done in parallel etc.  The fastest load times will happen using AWS import/export (http://aws.amazon.com/importexport/ ).  The next fastest will be using AWS Direct Connect (http://aws.amazon.com/directconnect). Direct Connect provides speeds of 1 Gbps to 10Gbps.  Using a 1 Gbps line, it would take about 3-4 hours (here is a good site: http://fasterdata.es.net/fasterdata-home/requirements-and-expectations/).    Assuming an internet connection speed of 100 Mbps (100Base-T connection) it would take about a day to transfer using a traditional connection to AWS/EC2  Both DirectConnect and Import/export provide a secure method of transfer. 

AWS Provisioned I/Os

Provisioned IOPS volumes are designed to deliver within 10% of the provisioned IOPS performance 99.9% of the time. Therefore, PIOPS are very good choice when running RDBMS systems like Oracle on EC2 or RDS.

Oracle Enterprise Manager on EC2 - IP address change after reboot

The script (/usr/local/bin/sethostname) to be run by cron:

·        Login as root.

·        vi /usr/local/bin/sethostname

·        Place the following line in the /usr/local/bin/sethostname

       echo desired_hostname > /proc/sys/kernel/hostname

·        chmod 755 /usr/local/bin/sethostname

·        Issue crontab –e and place the following line in the cron tab and save.

   # SET HOSTNAME

   * * * * * /usr/local/bin/sethostname >> /usr/local/bin/sethostname.log 2>&1

·        The desired_hostname and IP entry needs to be in the /etc/hosts file

desired_hostname = Hostname of your choice.

This is work around to this known limitation: http://taliphakanozturken.wordpress.com/2011/12/31/oem-configuration-when-the-database-host-name-or-ip-address-changes/

Oracle JD Edwards on AWS

JD Edwards EnterpriseOne licensing on SaaS offering from MPL Corporate Sofware can be found here https://aws.amazon.com/marketplace/pp/B009P2KJQE/ref=srh_res_product_title

Oracle Peoplesoft and Siebel on AWS Oracle RDS

DLZP has tested Oracle Peoplesoft running against Oracle on RDS.  Enterprise Beacon Software has tested Oracle Siebel against Oracle on RDS.