Wednesday, December 19, 2012

Oracle APEX on AWS

I only know of one documented public case study, but it is documented very well!  While at Oracle, I co-authored the book Migrating to the Cloud.  The Oracle partner JSA2 ( authored a chapter (13) in the book which goes into extensive detail on moving a Powerbuilder/Oracle/on premise application to APEX/Oracle/AWS.  The book can be found here:

Tuesday, December 18, 2012

AWS Partner Network Portal

AWS Partner Portal can be found here:

AWS EBS cross region migration

AWS offers the capability to migrate an EBS volume from one region to another.  The feature applies to any application or database data:

This can be used to move Oracle database EBS snapshot from one region to another for HA and DR.

Monday, December 17, 2012

Oracle Enterprise Manager and AWS EC2 instance restart

Question: An EC2 restart causes OEM to loss IP address of OEM management console - Is there a way to attach a static IP address to an EC2 instance instead the default o
Response: If you assign an Elastic IP address to the EC2 
instance before installing OEM, then you should have no problem.    
Once the EC2 instance has been created (without an EIP) and 
OEM has been installed there is no 
other way to do it except to use this workaround - 

Cloudwatch and benchmarking

Question: Can Cloudwatch provide enough metrics for an Oracle DB benchmarks? What are other tools that can be used?
Response: Cloud really does not provide much in terms of Oracle DB metrics.  Oracle AWR is the best option.  There is also a new OEM AWS plug for AWS:
Of course, there is the performance pack that is part of OEM.

Oracle on AWS - EBS mirroring

Question RAID and EBS Raid 1 - Does AWS EBS provide recovery from an EBS volume since the data is automatically mirrored by AWS?
Response:  It depends on whether  you want control over the recovery for mirroring.   Using the built in mirroring means you do not control the mirroring and therefore when recovery happens.  Other options include using Oracle Standby DB/DataGuard, GoldenGate or even EBS snapshots.

Oracle Database PIOPS and striping

A common question on PIOPS and striping:
Question: Striping with PIOPS - Is it necessary to stripe data when using PIOPS?
Response: It depends on how many PIOPS you are looking to achieve.  Since max PIOPS is per volume is 2000 PIOPS, if you need more then 2000 PIOPS then you would need to stripe.  Less than 2000 PIOPS then striping is not required. 

Wednesday, December 12, 2012

Oracle Enterprise Manager 12c AWS plug in

There is now a plug in for Oracle Enterprise Manager (OEM) so OEM 12c can be used to monitor Oracle technology running on AWS:

This plug in uses AWS CloudWatch metrics and can monitor EBS, EC2 and RDS. 

Thursday, December 6, 2012

Microsoft hourly pricing

announced this week -

Wednesday, December 5, 2012

Gettings stared with Oracle DB on AWS

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

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 ( ).  The next fastest will be using AWS Direct Connect ( 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:    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.