AWS to Oracle Cloud Migration Gemma Wood 1 About Me Gemma Wood - - PowerPoint PPT Presentation

1

Gemma Wood

AWS to Oracle Cloud Migration

2

Confidential 2

• Gemma Wood
• Co-Founder of Cavanti, responsible for product development
• Oracle Developer since 1995, initially Oracle E-Business Suite.

Focused exclusively on Oracle APEX for the past 7 years

• Previously worked for Oracle, Accenture Enkitec and have been an

independent consultant for the majority of my career

• Originally from London, I spent 20 years in the United States. Now

based in the Algarve, Portugal gemma@cavanti.com @gemmawood

About Me

3

Confidential 3

• Software as a Service company
• Based in San Jose, California
• Founded in 2012
• 300+ customers in 15 countries
• Provide Practice Management solutions to animal practitioners

(veterinarians, chiropractors, physiotherapists, massage therapists, etc.)

• 24/7 availability
• e-DBA/Red Stack/Data Intensity client since founded

About Cavanti

4

Confidential 4

• Our environment
• Oracle DB, Oracle APEX (now running ORDS to use Rest services)
• Cavanti was a bootstrapped start-up – Price was a big factor on day 1!
• Matured from a start-up to a ”real” business

Our Journey

5

Confidential 5

• Pay as you go to avoid any upfront hardware or licensing costs
• Gave us own Oracle “database” on shared instance
• Solution worked pretty well
• Some constraints (no file system access, no data pump, no external

tables, no sys access, sharing hardware resources with other tenants, etc.)

• Great to get us started

Why Amazon RDS?

6

Confidential 6

• Needed to start development on a new product
• Needed some of the missing Oracle features that AWS RDS did not

support

• Grown into a real business and needed our own non shared

environment so we had control of patching, resource allocation, configuration, etc.

• Wanted own VMs, but cost was prohibitive on AWS (mainly from a

licensing perspective)

Why Move From AWS?

7

Confidential

Oracle Cloud

Technical Benefits

• Dedicated Virtual Machines so we

would be in full control of our own destiny

• Oracle DBCS would give us all the

features we were missing on AWS

• Full control over ORDS listener etc.

7

Commercial benefits!

• Pricing was extremely competitive and
• ffered massive savings over running

VM’s on AWS

• We can scale up as needed with no

upfront costs – great for a still growing business

• Data Intensity recommended running Oracle DBCS Standard

8

Confidential 8

• Immediate reaction was skepticism!
• Experience several years ago with the Oracle Cloud was not great. Environment was unavailable

45% during a 30 day trial period!

• General feedback over the last couple of years was that the Oracle Cloud was not production

ready

• Bad experiences with Oracle in the past from a commercial and support perspective - Concerned

that Oracle could change the game once we were on board, hike prices, etc.

• Felt like we didn’t have a great deal of choice!
• Didn’t have the budget for VMs on AWS
• Same was really applicable if we looked at other cloud providers as licensing costs were the

killer

• Reluctantly agreed to re-evaluate the Oracle Cloud

Concerns – The (Brutally) Honest View

9

Confidential 9

• Data Intensity handled provisioning of the environment
• Data Intensity dealt with Oracle with was fantastic!
• Cavanti took care of migrating the application
• Data Intensity and Cavanti worked together on the data

migration

Migration

10

Confidential 10

• Tried to migrate from Oracle 12.1 to Oracle 12.2 as part of the

migration

• Oracle 12.2 was not production ready at the time so reverted back to

Oracle 12.1

• Cavanti had 120GB+ of fairly static blob data and exporting/importing

this was going to result in an outage of 7+ hours. Not feasible in a 24/7 environment

• We imported blob data one day and then imported changed blob data

(and non blob data) when we went live

• Outage was less than 2 hours

Issues Faced

11

Confidential 11

• Fantastic! We were surprisingly happy with what we saw!
• The Oracle Cloud had grown up!
• Live now for 7 months. Environment has been very stable – 100%

uptime!

• Got everything we wanted
• Subsequently provisioned a second Virtual Machine running Oracle

12.2 and Oracle APEX 5.1 for development of a new product

• Data Intensity provide managed services of the environment and

subsequently deal with Oracle Support on any issues

Overall Experience

12

Confidential 12

• Recently tried to “kick the tyres” of Oracle Exadata Express on the Oracle

Cloud and provisioned the environment directly with Oracle – Big mistake!

• Working with Data Intensity was once again a fantastic experience. This was

highlighted further by my “kicking the tyres” experience with Oracle!

• The combination of Data Intensity and the Oracle Cloud is perfect
• You get extremely competitive pricing from Oracle as they are playing catch

up with the other cloud providers

• You get excellent service and support from Data Intensity who do a great job

at managing your environment and at dealing with Oracle on your behalf

Lessons Learnt

13

Confidential 13

• Oracle’s browser-based high productivity application development

platform

• Fully supported, no-cost feature of all Oracle databases (Oracle Cloud,
• n-premises, other clouds)
• Rapidly build beautiful, responsive web applications out-of-the box
• Extend with small amount of SQL, PL/SQL, JavaScript, CSS or HTML
• Scales to tens of thousands of users
• Hundreds of thousands of developers. Very active development

community, including the APEX Development team #orclapex

• https://apex.oracle.com - Sign up for free development service

One More Thing… Oracle Application Express Plug!