1. technology and computing
2. software
3. databases

EM12c: Cloud Management Pack
for Oracle Database
Feature Overview
Product Management
January 2015
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Safe Harbor Statement
The following is intended to outline our general product direction. It is intended for
information purposes only, and may not be incorporated into any contract. It is not a
commitment to deliver any material, code, or functionality, and should not be relied upon
in making purchasing decisions. The development, release, and timing of any features or
functionality described for Oracle’s products remains at the sole discretion of Oracle.
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
2
Program Agenda
1
Current Challenges
2
EM 12c Solution Overview
3
Solution Details
4
Customer Stories
5
Summary
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Evolution of Datacenter
Changing Dynamics of Database Maintenance
END
USERS
PORTAL
DBAs
END
USERS
RAC
Cloud & Consolidation
2014
RAC
DBAs
Goals
•Higher Agility- Self Service, Elasticity
•Lower cost- Shared Resources,
Automation
•Reduced Risk – High Availability
END
USERS
DBAs
Grid, Clustering, Virtualization
2008, ….
Internet
2003
Challenges
• Lengthy process, mostly manual
• Lack of scalability
• Operations are at single target level
Volume
Complexity
Challenges
• Complex process
• Time Consuming
• Need mass automation
• Downtime management
Volume
Complexity
Copyright © 2014 Oracle Corporation | Oracle Confidential
Volume
Complexity
4
Key Challenges and Solutions
Unmanaged asset sprawl
28% have an annual database
instance growth of more than
20%
• Less than 50% have
consolidated
•
Consolidation
Configuration Pollution
•
•
Too many versions, patch
levels and sizes
400 variants out of 1400+
across 3 major releases for a
large telecom customer
Slow time to delivery
•
Days to Weeks to provision new
database services or clone
production databases for key
projects
Standardization
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Automation
*IOUG Survey, 2013
Consolidation Planning and Testing
Enterprise Manager 12c provides
 Consolidation Planning for physical to virtual, commodity to
Engineered Systems and dedicated to multitenant database
 Validation of the database consolidation architecture with
Database Consolidation Planner
 Validation of SQL performance and identification of
regressions using SQL Performance Analyzer
 Testing of consolidated workload by capturing and replaying
real workload using Real Application Testing
Allied Irish Bank (AIB) consolidated its Oracle Database
platform with the help of Real Application Testing and 25%
less testing resources
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Configuration Standardization
Enterprise Manager 12c enables
 Single Service Catalog with predefined configurations and
sizes to minimize variants
 Ongoing Compliance checks to detect violations and
mapping to industry standards like STIG and PCI
 Drift management to detect differences across a fleet of
databases
 Automated patch management under minimum downtime
to bring configurations back to compliance
Telecom Italia has created a single Service Catalog to
streamline operations that previously hosted 700 different
configurations across 1000+ databases
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Automation for Database
Enterprise Manager 12c enables
 Single click deployment of single instance, RAC, pluggable
databases and schemas, optionally with DR setup
 Intelligent placement and governance through access
control, quota and showback
 Instant, storage efficient cloning of databases using Snap
Clone
 Automation of lifecycle operations like backup, restore,
patching, upgrade
 RESTFUL APIs for integrating with orchestration services
NAV reduced new database provisioning time from 6-7 days to
18 minutes using Enterprise Manager 12c
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Solution Details
1
Service Catalog and Self Service Portal
2
Data Clone and Refresh
3
Monitoring and Management
4
APIS
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Solution Details
1
Service Catalog and Self Service Portal
2
Data Clone and Refresh
3
Monitoring and Management
4
APIS
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Service Catalog
Definition
• A collection of standardized services available to selected consumers for on
demand, self service provisioning
Benefits
• Establish and enforce effective standardization
• Repeatable and predictable deployment
• Helps identify service costs
• Helps reduce the database management overhead
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
EM12c DBaaS Service Catalog for Provisioning
Service Definition
Define service tiers to
simplify your offerings
Technical Service
Establish the technical
footprint of each service tier
Service Model
Determine the individual
services to be provisioned
Bronze
 RAC
 Data Guard
 Backups
PDB
Resource Pools
Align services with resource
pools
12.1.0.1
11.2.0.4
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Silver
Gold
Small
Large
Medium X-Large
Database
Schema
10.2.0.5
11.2.0.4
Define Database Service Tiers
Satisfy application availability needs
Primary
Standbys
EM12c
Deploy Services across regions
1
SI/SIHA
-
BRONZE

2
SI/SIHA
SI/SIHA

3
RAC
-
SILVER

4
RAC
SI

5
RAC
RAC
GOLD

Size
CPU
Core
RAM
GB
Storage
6
RON
-

S
1
6
50 GB
7
RON
RON

M
2
12
250 GB
L
4
24
1,250 GB
XL
16
48
5 TB
SI – Single Instance
RON – RAC One Node
Bangalore DC
Austin DC
Set your own sizes
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
13
Consolidation: DBaaS Architectures
EM12c Supports Database Versions 10gR2 to 12c
Virtual Machines
Share servers
Dedicated DBs
Share servers and
OS
Dedicated Schema(s)
Share servers, OS
and database
Increasing Consolidation
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Pluggable DBs
Share servers, OS
and database
EM12c DBaaS: Unmatched Architectural Choices
Virtual
Machines
Dedicated DB
Dedicated
Schemas
Pluggable DB
Consolidation
Density
Low-Moderate
High
Highest
Highest
Management
Very complex (VM
Sprawl)
Easy
Easy to Involved (based
on required resource
isolation)
Easy
Isolation
Excellent
Good
Least
Good
Implementation
& Onboarding
Easy
Easy
Difficult
Easy
Application
Suitability
Some (workload
dependent)
All
Home grown; requires
app validation
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
All but have to be
certified for Database
12c
DBaaS Resource Pools
 Database Resource Pool
11.2.0.3 DB OH Pool
12c CDB Pool
10.2.0.4 DB Pool
11.2.0.2 RAC DB Pool
11.2.0.2 RAC DB
Pool
10.2.0.5 DB Pool
A group of homogeneous clustered or nonclustered resources exhibiting common
characteristics. Example:
 Pool of 11.2 Database Oracle Homes
(for dedicated databases)
 Pool of 12c Container Databases
(for
PDBs)
 Zone
A logical grouping of cloud infrastructure
resources based on QOS, functional,
departmental or geographic boundaries.
Example, Finance Zone, East Coast Zone
 Self-Service users provision into a Zone
 Zones can also be used to enforce access
control and chargeback
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Self Service Provisioning and Service Catalog
• Out-of-box self service portal
• Catalog of different database configuration with
varied datasets
• Resource quota based on role
• Integrated monitoring, snapshot/rollback, etc
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Automation for Databases
Consolidation Planning and Real App
Testing
Service Provisioning incl’ REST APIs
Service Governance: Access Controls, Compliance,
Quota, Showback, etc
Elasticity
Ongoing Operations and Performance
Management
Database Private Cloud
Dedicated
Databases
Schemas
Pluggable
Databases
Clones
Runs on any Infrastructure : Physical,
Virtual, Engineered Systems
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Intelligent Service Placement
The Best Fit Rule
Automatically find suitable target for placement:
• nodes for single instance and RAC databases
• databases for schema
• container database for PDBs*
Current Load
CPU, Memory, and
Storage usage
Current
Population
No. of Service Instances
Placement
Constraints
Limits set on zones
and pools
* PDBaaS allows for custom placement - selection of the container database
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
EM12c Release 4 Plug-in Update
Incremental Enhancements
• Add & remove standby
• Externalized DB Size
– Separate from service template
– EMCLI verbs
• Improved customization:
– Target Properties
– Sql post script
– Custom placement of PDBs
emcli create_database_size
-name=Small
-description="Small size database"
-attributes="cpu:4;storage:50;memory:4"
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle Confidential – Internal/Restricted/Highly Restricted
20
Solution Details
1
Service Catalog and Self Service Portal
2
Data Clone and Refresh
3
Monitoring and Management
4
APIS
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
A Large Financial Institution – Storage Challenges
SPARC
Oracle DB
Size
Very Small (less < 1 TB)
Small (1TB to 5TB)
Medium (5TB to 10TB)
Large (10TB to 15TB)
Very Large (>15TB)
Total:
Number
x86
of
Applications
1,400
500
75
25
20
Average
DB Size
(GB)
Average
Number of
Non-prod
Environments
300
3,000
7,500
12,500
20,000
5
5
7
7
7
2,020
5 to 7 non-prod clones per production database
18 of 30 PB for non-prod Oracle environments
$122M of $198M for non-prod clones
Storage Team: “We haveEstimated
50 PB SAN. Annual OP
Ave
Annual growth has ranged from
Estimated
1 - 20-35%”
3 Years
Storage (GB) Non Production
Applications Team: “1300 Apps
Environments
Requirements
are utilizing private Cloud”
Per En
Per A
2,100,000
$13,860,000
7,500,000
$49,500,000
Database
Team:
“delivering
3,937,500
3 – 5$25,987,500
Years
test
data for UAT is a focus
for private Cloud
2,187,500
$14,437,500
this
year ”
2,800,000
$18,480,000
$
$
$
$
18,525,000
$
$122,265,000
Storage Cost / GB = $6.6/year
Estimated Annual Storage OPX
Cost “$198M/year” for Oracle
Environments
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Process Challenges
70000
RMAN
refresh/year
full clones
2000+
10 - 20
Dev/Test DB
3 – 5 TB
Typical DB size
“Database Refresh
is a
necessary evil!”
issues/day
EMC & NetApp
storage
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
- Christian Bilien,
Global Head of
Database Team
EM Solution – Data Clone and Refresh
Supports full and snap (thin) database clones
Technology (and Storage) Agnostic
End-to-End Automation – Prod to Test/Dev
Designed for DBAs
Integrated Masking & Patching (PSUs and Patch
Sets)
Available via Admin Flows and Self Service portal
EMCLI and REST API
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Data Movement
Source
Database
NAME
SSN
Test Master
Database
Masking &
Sub setting
SALARY
NAME
AGUILAR 203-33-3234 40,000
BENSON 323-22-2943 60,000
SSN
SALARY
MILLER 112-23-4567
40,000
SMITH
60,000
111-22-3333
010110011
101001010
000111010
Data Guard Standby
Source DB
Backups
Mask / Subset
Test Master
Refresh
Clones
Refresh
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Data Movement
Activity Breakdown
• Source DB – Identify production database for cloning
• Backups – Take regular backups [RMAN, datapump exports, etc]
• Mask / Subset – Mask sensitive data. Optionally, subset to reduce storage footprint
• Test Master – Sanitized copy of production data for use in dev / test environments OR
a Data Guard Standby database
• Clones – Full clones for performance / stress testing; snap clones for functional testing
• Refresh - Keep in sync with data changes in production
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
26
Deployment Scenarios for Test Master
Snap Clones
Source
Database
Continuous or Discrete Replication
Private backups
(snapshots) for SSA
user
Standby / Test
Master Database
Replication Types:
Continuous
Discrete
Technology
Data Guard, Golden Gate
RMAN, Snap Mirror, import/export …
Data Refresh
Automatic and instantaneous
Manual and at scheduled intervals
Masking and
Subsetting
Not possible
At source (in production), or in place at test
master
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Full or Snap Clone: How it Works?
Scheduled or Manual Storage Snapshots or RMAN Backups of the test master database, called Profiles
Standby /
Test Master
Test master is
regularly
refreshed with
current data
from production
t1
t0
….
t2
Clones
Private backups
tN
• Clones can be created from a
library of profiles
• Each user gets a personal readwrite database clone
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Database Clones from Self Service Portal
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Refresh Clones
• One-click refresh of clones
• Library of Profiles to choose from
– snapshots / backups / Image copies
• The identity and configuration of the
clone retained as before
• REST APIs
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
30
Non Self Service (Admin) Flows
Its not all Cloudy!
• Non Self Service (Admin) flows
• Ideal for POCs, one-off clones, and for test
master creation
• Clone from a snapshot or to a point-intime or SCN
• Integrated Masking and Patching (PSUs and
Patch Sets)
• One-click refresh of clones from source
• EMCLI verbs
emcli create_clone
-inputFile="File containing properties required
for cloning a database."
emcli refresh_database
-target_name="database target
name"
-target_type="database target type"
-input_file=data:"file:path"
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle Confidential – Internal/Restricted/Highly Restricted
31
DB Clone and Refresh – Admin Flow
Mask
Subset
Production Database
Clone / Test Master
Update [Patch or Upgrade]
Change Configuration [SI / RAC]
Snap Clone
Use as Test Master
Version: 11.2.0.3
Version: 11.2.0.4
Config: 3 Node RAC
Config: Single Instance
Data: RMAN Backup1
Data: RMAN Backup1
t0
t1
t2
….
tN
RMAN Backup / Storage Snapshot
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Integrated Data Masking
Mask
Dev
Clone
Test
Test Master
Production
Data Masking Template
DEPT
LAST_NAME SSN
SALARY
10
SMITH
111—23-1111
40,000
10
JOHNSON
222-34-1345
60,000
• Supports use of EM Data Masking template (requires Oracle Data Masking and Subset
Pack), or running custom sql scripts
• Mask sensitive data as part of one-off clone or test master creation
• For Snap Clone, it is recommended to only mask the test master, so as to retain
storage savings post snap clone
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal
Supported Cloning Options
Full Clones
Snap (Thin) Clones
Database Native [Storage Agnostic]
RMAN
Restore
RMAN
Duplicate
Software Solution [Vendor Agnostic]
Data Pump
• Leverage your existing investments
• Cater to both functional and stress testing needs
• Maximize for best performance
Hardware Solution [Vendor Specific]
NAS
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
SAN
Snap Clone using Solaris File System (ZFS)
• Uses a single stock Solaris 11.1+ image – physical or virtual [NOT the Oracle
Sun ZFSSA or ZS3 Appliance ]
• Supports any kind storage – NAS or SAN
• For SAN, mount luns as raw disk and format with ZFS filesystem
• Does NOT require the snapshot/clone licenses from the storage vendor,
these features are available for free
• Additional features include compression, deduplication, IO caching, etc
• HA has to be handled externally either via Solaris Clusters, or by using HA
features of the underlying hypervisor
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Solaris File System with SAN Storage Network Diagram
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
36
CloneDB using DNFS
• Ability to create thin databases from • Advantages
RMAN image copies
– Easy to setup
• Uses NFS v3 client embedded in
database
• Supported configurations
– Single instance databases
– Note: Only file system support for this
setup (No ASM)
• Supported Versions: 11.2.0.3+, 12.1
– No special storage software needed
– Works on all platforms
– Time efficient: Instantaneous cloning
– Space efficient: Create multiple clones
based on one backup
– Uses dNFS to improve performance,
high availability, and scalability of NFS
storage
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
NAS Network Diagram
• Rapid clones of databases
running on NFS mounted
file systems
• NAS storage array
registration using an EM
agent as proxy
• Monitoring and Summary
views for storage array
• Seamless automation
across storage, host, &
database layers –
snapshot, clone, mount,
create db, etc
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
38
Snap Clone on ASM + EMC Storage
• Ability to create ‘live’ thin clones
of databases on ASM
• Live clone of the DB, NOT
snapshot based
• Clone can be within the same or
on a different cluster
• EMC VMAX (with Time Finder
VPSnap) and VNX storage
appliances
• Supports SI and RAC databases
• Supported Versions: DB = 10.2.0.5
or higher; GI = 11.2 and higher
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Summary of Database Cloning Choices
Option 1: Snap Clones
Continuous or Discrete Replication
Source Database
Masking and Subsetting using EM
Option 1: Snap Clone
•Storage based technology
• Saves space and time
• Ideal for "use and throw“ i.e.
short lived databases
• Suited for functional testing with
minor updates
• Storage Admin involved in setup
Private backups
(snapshots) for SSA
user
Test Master
Database
Option 2: Full Clone
•Oracle Database based technology; Storage
neutral
• Restore time proportional to backup size
• Leverages existing technology and
infrastructure
• Suited for intense load and functional testing
• Completely managed by DBAs
Private backup for
SSA user
Option 2: Full Clones
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Snap Clone Vs Competition
 Scale, Scale, Scale
 Supports 1 to 1000s of clones
 Protects your existing investments
 Choice between hardware and software solution
 Use of trusted technologies like data guard for test master refresh
 Part of Enterprise Manager 12c
 Oracle’s flagship management product for all your database needs
 In sync with DB releases (support for PDBs on day 1)
 Secure and role based access control; used by Fortune 1000 customers
 Protection from unnecessary point tools; reduce TCO
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Snap Clone with Oracle Engineered Systems
External Storage
Exadata
• Compute nodes are used to run snap
clone databases
• The storage is external to Exadata
and served over NFS
• In case of ZS3 storage, all traffic over
infiniband
SuperCluster
• Solaris Zones or LDOMS used to run
snap clone databases
• Embedded ZS3-ES storage served
over infiniband
Test Master
Database
/source [nfs]
010110011
101001010
000111010
/clone1 [nfs]
/clone2 [nfs]
Oracle Virtual Compute Appliance
• Oracle VMs used to run snap clone
databases
• Embedded ZS3-ES storage served
over infiniband
.. more
Enterprise Manager
12c
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Solution Details
1
Service Catalog and Self Service Portal
2
Data Clone and Refresh
3
Monitoring and Management
4
APIS
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Metering and Showback
Tailored for different use cases and user types
 Showback based on fixed, utilization or configuration
 Database performance metrics, configuration items, feature-usage
 Can be extended to leverage other metrics, e.g: business transactions
 Rollups based on LDAP
 Tailored reporting for different user personas
Chargeback Administrator
Self-Service Portal User
Line of Business User
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
DBaaS Chargeback Metrics (Out-of-the-Box)
Fixed
VM
Database Instance
DB Service (*)
Pluggable Database
Base Charge
Base Charge
Base Charge
Base Charge
Allocated Memory
Allocated Storage
Configuration
HA
IP Address
Size
vCPU Count
Usage
Edition
Memory Usage
Edition
Option
Option
RAC Node Count
RAC Node Count
Release
Release
Storage Usage
Tablespace Allocation
Version
Edition
Option
Release
RAC Node Count
Tablespace Allocation
Version
CPU Time
CPU Time
CPU Time
CPU Time
CPU Utilization (%)
CPU Utilization (%)
CPU Utilization (%)
CPU Utilization (%)
Disk Space Utilization (%)
DB Time
DB Time
DB Time
Disk Usage
Disk Read (Physical) Operations
Memory Used
Disk Write (Physical) Operations
Disk Read (Physical)
Operations
Disk Read (Physical)
Operations
Memory Utilization (%)
Network IO
Disk Write (Physical)
Operations
Disk Write (Physical)
Operations
Network IO
SQL Executes
SQL Executes
SQL Executes
User Transactions
User Transactions
User Transactions
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
EM12c Release 4 Plug-in Update
• Improved Homepage
– Getting started section
– Target and Cost Center assignment summary
– ETL job details
• Extensibility
– Registration of any target type
– Promote any monitoring /configuration metric to a
chargeback metric
– Enable chargeback on abstract entities e.g. backup
requests, job executions, no. of tests, etc
• Lifecycle management through EMCLI
– Add Targets, Assign Plans and Cost Centers
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Cloud Resource and Request Management
• Manage Cloud Zones and underlying
resources
– Database Pools, servers, storage
• Track resource flux, tenants, policy
violations, etc
• Drill down into individual resources
for deeper monitoring
• Monitor requests and failure rates
and remediate bottlenecks
• Deep software and hardware
management for Exadata
– Hardware schematics, Software Topology,
ASRs..
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Incident Management
Monitoring by Exceptions
• Setup and apply monitoring templates based
on desired SLAs
• Manage exceptions
‒ View, manage, diagnose and resolve
incidents from one console
‒ Assign, acknowledge, prioritize, track
status, escalate, suppress
• Accelerated resolution with “My Oracle
Support” integration
• Integrated with external Helpdesk Systems
‒ Out of box connectors for Remedy, HP
Service Center
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Database Fleet Maintenance
Self service maintenance for Database Cloud
End Users
Process
1. Pools subscribe to DB and GI images
2. New images automatically get deployed to
servers in the pool
3. Self Service users or Admin can choose to
migrate DBs over to the new home
Benefits:
– Scale: Subscription based, automated
deployment and at mass scale
– Reduced Downtime: Out of place patching and
upgrade
– Isolation & Flexibility: Users to move to new
software version on their terms
– Compliance: Drift tracking and real time reporting
11.2.0.3 DB Home
11.2.0.4 DB Home
11.2.0.3 GI Home
11.2.0.4 GI Home
Admin
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Image Library
Solution Details
1
Service Catalog and Self Service Portal
2
Data Clone and Refresh
3
Monitoring and Management
4
APIS
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
APIs for DBaaS Providers and Consumers
 Request DBs
 List Zones
 List Service Templates
Deploy
List
 Request Schemas
 List Service Instances
 Track request progress
DBaaS
Portal API
 Service Control (start/stop)
 Backup
 Delete Service
 Extend reservation
 Request PDBs
Delete
Manage
 Restore
 Snapshot
 Get Chargeback info
DBaaS Providers:
•EMCLI Verbs for CRUD operations on Zones / Pools / Service templates / Profiles / Quota / etc
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Integration with 3rd Party Tools
OR
Out of box Self Service Portal
POST :
https://example.oracle.com/em/cloud/dbaas/zone/82CF1C28FA20A18
3C99D138FF8065F19
Authorization: basic ZGVtb3VzZXI6ZGVtb3VzZXI=
Content-Type:
application/oracle.com.cloud.common.DbPlatformInstance+json
Accept:
application/oracle.com.cloud.common.DbPlatformInstance+json
Body:
{
"based_on":
"/em/cloud/dbaas/dbplatformtemplate/CC3BBB665A6BC6FFE040F00AEF
252456",
"name": "<Request name>",
"description": "<Request Description>",
"params":
{ "username": "Master Account username for the DB",
"password": "Password for the Master Account on the DB"
}
}
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Customer Stories
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal
Reference Guide
1. Let us start with two customers: HDFC Bank and NAV whose focus was on massive consolidation of
commodity infra into Exadata with appropriate consolidation testing and the rapid provisioning of
databases. In case of HDFC, it reduced from days to hours and in case of NAV from days to minutes.
The time difference is because HDFC is doing RMAN based cloning while NAV is provisioning binaries.
2. The second set of customers, Telecom Italia, PNC Bank focuses on standardization via Service Catalog
as evident from the slides. Their aim is to reduce the number of configuration variants. In case of PNC
bank, they also provision Standby environments via the Service Catalog, the first customer to do so.
Telecom Italia has 200 DBs in the cloud environment today, will move to 2000 by early 2015.
3. Then we get into customers whose use case centers around data refresh. Societe Generale used to
spend lot of time and labor just doing refresh for their DevOps environment. They are now using Snap
Clone to perform agile data refresh in a storage efficient way. While Energy Transfer spent significant
time refreshing their production-like databases in UAT. With EM12c, they can refresh all their
databases using RMAN backups in a few clicks.
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Case Study
Database as a Service
FOCUS ON
India’s second largest Private Bank with nearly 2800 branches, 11,000 ATMs
20 million customers
Employees: 56,000
Revenue: USD 5 Billion
Consolidation, SelfService Provisioning,
Lifecycle Management
Challenge:
Solution:
 Database sprawl over 168 racks of real estate
 Hitting performance ceiling on existing infrastructure
 Rollout of new database services often wait on
infrastructure; taking and average time of 3 days
 Run new database applications on Exadata while legacy
applications run on IBM AIX
 EM 12c based Self-Service Provisioning of databases
 EM 12c Lifecycle Management features for Discovery,
Compliance, Patching, etc
BENEFITS
 Reduced new database rollout time from 3 days to 3.5 hours
 Standardized database offering for Developers and QA reducing any significant
configuration drift and compliance challenges
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Case Study
Database as a Service
Norwegian Labor and Welfare Administration
Pension services, Sickness/Unemployment benefits & Occupational rehabilitation for entire Norway population
450 local offices all across Norway - 14.000 Employees
Administers one third of the national budget
FOCUS ON
Consolidation,
Standardization, SelfService and Chargeback
Challenges:
Solution:




 Consolidate databases on Oracle Exadata and Sun Server
X2-8 (8) w/HP 3PAR storage on Oracle Linux
 EM 12c with High Availability Level III
 Self-Service Provisioning of databases with a well-defined
service catalog of pre-defined configuration [Small to Large]
 Migrate existing databases into the cloud platform
Lack of consolidation due to heterogenous platforms
High complexity and disproportionate costs of legacy systems
Database provisioning average time: 6 – 7 days
Database Sprawl – Non-standard configurations and licensing
needs
 Lack of accountability at department level for resource demand
and usage
BENEFITS


Time to provision databases reduced from 6.8 days to 18 minutes
Funding for additional resources is now targeted at the actual
divisions/groups consuming them
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Case
Study
Telecom Italia: Transformational Private DBaaS
COMPANY OVERVIEW
Large Telecom provider in Italy with 7 Data Centers and 4 Service Centers
Legacy/Traditional/AS – IS
•
DB design specifically for single application
(traditional approach)
•
Provisioning time of database: Weeks
•
700+ different combinations identified (releaseDB Version / Release-Version OS / Hardware)
Oracle Enterprise Manager 12c - DBaaS
•
Standardized DB Service (Catalog of DB Services)
•
Provisioning time of database: Hours
•
3 Service Classes on 5 standard configurations
Server
virtualization
Database
consolidation
Schema
Consolidation
1
Gold
3
2
Silver
4
5
Bronze
•
Strong under-utilization of allocated HW resources
•
Shared HW resources with high utilization and efficiency
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
57
Case
Study
PNC Bank
Regional bank operating primarily in nineteen states and the District of
Columbia with more than 2,700 branches
Key Business Drivers
• Standardization and Simplification through welldefined services: Gold, Silver, Bronze, Platinum
• Cost Savings
• Consolidation -- Infrastructure, People
• Automation -- Self Service
FOCUS ON
Monitoring, Provisioning
via Service Catalog
EM Environment
• EM on Engineered Systems managing 5000+ targets
• EM12c application running on Exa providing single
console enterprise view of operations.
• Exalogic and Exadata on Infiniband Network
• Three environments: Prod, DR, QA/Test
• Improved Customer Response Time
• Capacity on the floor vs purchasing per
project
• Showback
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Case
Study
One of the largest European financial services groups, with group net income
of €23 billion 2012.
54,000 employees, 76 countries, and 32 million clients worldwide
Customer Pains
• Societe Generale (SG) had been experiencing
long delays to provide a complete DB
Environment, with complex request procedures
for its developers that handle 2,000+ developers
• 70000+ full DB refreshes/year
• 10-20 cloning issues/day
• Majority refreshes scheduled; 10% on demand
FOCUS ON
Storage Consolidation,
Snap Clone
• Solution
• Enterprise Manager Snap Clone on
NetApp
• Refresh takes couple of minutes
• Cloning from Standby databases; no
impact on production
• Using REST APIs; zero manual
intervention
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Case
Study
One of the largest and most diversified midstream service providers in the
country. Over 71,000 miles of natural gas, natural gas liquids (NGLs), refined
products, and crude oil pipelines today.
Customer Pains
• Energy Transfer (ET) DBA team needs to clone and
refresh databases for non- production use.
• 200+ databases running on ASM on Solaris, Linux,
and Windows
• 72 refreshes per year for a single group; unable to
scale to other groups
• Avg. takes 16 hrs end-to-end to refresh a single
database; mostly manual and requires significant
post processing steps
• Using RMAN duplicate or Imp/Exp; unnecessary
load on production databases
FOCUS ON
Faster, and Repeatable
Automation
• Solution
• Enterprise Manager Data Cloning using
RMAN backups
• End-to-end automation - taking backups,
staging in central location, creation of
clones with custom modifications, notify via
email
• Faster, repeatable refresh process;
complete process takes only 8 hours
• Using APIs; minimal manual intervention
• Saved ~79K per year just for data refresh
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Cloud Management Pack for Oracle Database Summary
Self-Service Provisioning
Supports Databases, Schema, and PDBs
Database Cloning
Full clones and Snap Clones (thin clones)
Enterprise-wide Service Catalog
Role based, Single catalog, to enforce
standardization across the DB estate
Quota and Policy based Management
Enforces governance and control
Metering, Chargeback
Supports Database, Schema, and PDBs
Comprehensive REST and EMCLI APIs
For all self service and admin functions
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Key Takeaways
EM12c Cloud Management Pack for Database lets you …
• Jumpstart your journey to Private DBaaS
• Choose from various architectures: VMs, physical, schema, multitenant
databases
• Supports various service levels (single instance, HA, DR), and DB sizes
• Enables consolidation and saves $$$ for compute and storage
• Snap Clone or full clone databases for performance or functional testing
• Patch and maintain provisioned resources with near zero downtime and
minimal DBA time
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |