EM12c: Cloud Management Pack for Oracle Database Feature Overview

(1)

EM12c: Cloud Management Pack

for Oracle Database

Product Management

January 2015

(2)

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.

(3)

Program Agenda

1

2

3

4 Current Challenges

EM 12c Solution Overview

Solution Details

Customer Stories

Summary

(4)

Evolution of Datacenter

Changing Dynamics of Database Maintenance

Internet

2003

END

USERS

DBAs

Challenges

• Lengthy process, mostly manual

• Lack of scalability

• Operations are at single target level

Goals

•Higher Agility- Self Service, Elasticity

•Lower cost- Shared Resources,

Automation

•Reduced Risk – High Availability

Challenges

• Complex process

• Time Consuming

• Need mass automation

• Downtime management

RAC RAC

END

USERS

DBAs

4

Volume

Complexity

Volume

Complexity

Volume

Complexity

DBAs

Cloud & Consolidation

2014

PORTAL

END

USERS

Grid, Clustering, Virtualization

(5)

Unmanaged asset sprawl

Configuration Pollution

• 28%

have an annual database

instance growth of more than

20%

• Less than

50%

have

consolidated

• Too many

versions, patch

levels and sizes

• 400 variants

out of 1400+

across 3 major releases for a

large telecom customer

Key Challenges and Solutions

Slow time to delivery

• Days to Weeks

to provision new

database services or clone

production databases for key

projects

(6)

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

(7)

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

(8)

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

(9)

Solution Details

1

2

3

4 Service Catalog and Self Service Portal

Data Clone and Refresh

Monitoring and Management

APIS

(10)

Solution Details

1

2

3

4 Service Catalog and Self Service Portal

Data Clone and Refresh

Monitoring and Management

APIS

(11)

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

(12)

EM12c DBaaS Service Catalog for Provisioning

Service Definition

Technical Service

Service Model

Resource Pools

Define service tiers to

simplify your offerings

Establish the technical

footprint of each service tier

Determine the individual

services to be provisioned

Align services with resource

pools

Bronze

Silver

Gold

Small

Large

Medium X-Large



RAC



Data Guard



Backups

PDB Database Schema

11.2.0.4 _11.2.0.4

(13)

Define Database Service Tiers

Primary

Standbys

EM12c

SI/SIHA

-



SI/SIHA



RAC

-



RAC

SI



RAC



RON

-



RON



SI – Single Instance

Deploy Services across regions

Set your own sizes

1

2

3

4

5

6

7 Size

CPU

Core

RAM

GB

Storage

S

1

6 50 GB

M

2

12 250 GB

L

4

24 1,250 GB

XL

16

48 5 TB

BRONZE

SILVER

GOLD

Austin DC

Bangalore DC

(14)

Consolidation: DBaaS Architectures

EM12c Supports Database Versions 10gR2 to 12c

Virtual Machines

Share servers

Dedicated Schema(s)

Share servers, OS

and database

Increasing Consolidation

Dedicated DBs

Share servers and

OS

Pluggable DBs

Share servers, OS

and database

(15)

EM12c DBaaS: Unmatched Architectural Choices

Virtual

Machines

Dedicated DB

Dedicated

Schemas

Pluggable DB

Consolidation

Density

Low-Moderate

High

Highest

Management

Very complex (VM

Sprawl)

Easy

to

Involved

(based

on required resource

isolation)

Easy

Isolation

Excellent

Good

Least

Good

Implementation

& Onboarding

Easy

Difficult

Easy

Application

Suitability

Some (workload

dependent)

All

Home grown; requires

app validation

All

but have to be

certified for Database

(16)

DBaaS Resource Pools



Database Resource Pool

A group of homogeneous clustered or

non-clustered 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

11.2.0.3 DB OH Pool

10.2.0.4 DB Pool

12c CDB Pool

10.2.0.5 DB Pool

11.2.0.2 RAC DB Pool

11.2.0.2 RAC DB

Pool

(17)

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

(18)

Automation for Databases

Dedicated

Databases

Schemas

Pluggable

Databases

Clones

Runs on any Infrastructure : Physical,

Virtual, Engineered Systems

Service Governance: Access Controls, Compliance,

Quota, Showback, etc

Elasticity

Service Provisioning incl’ REST APIs

Ongoing Operations and Performance

Management

Consolidation Planning and Real App

Testing

(19)

Intelligent Service Placement

The Best Fit Rule

Placement

Constraints

Current

Population

Current Load

CPU, Memory, and

Storage usage

No. of Service Instances

Limits set on zones

and pools

Automatically find suitable target for placement:

• nodes for single instance and RAC databases

• databases for schema

• container database for PDBs*

(20)

EM12c Release 4 Plug-in Update

• Add & remove standby

• Externalized DB Size

–

Separate from service template

–

EMCLI verbs

• Improved customization:

–

Target Properties

–

Sql post script

–

Custom placement of PDBs

Oracle Confidential – Internal/Restricted/Highly Restricted 20

Incremental Enhancements

emcli create_database_size

-name=Small

-description="Small size database"

(21)

Solution Details

1

2

3

4 Service Catalog and Self Service Portal

Data Clone and Refresh

Monitoring and Management

APIS

(22)

A Large Financial Institution – Storage Challenges

1 - 3 Years

SPARC

_x86

3 – 5 Years

Storage Cost / GB = $6.6/year

Estimated Annual Storage OPX

Cost “$198M/year” for Oracle

Environments

Applications Team:

“1300 Apps

are utilizing private Cloud”

Storage Team:

“We have 50 PB SAN.

Annual growth has ranged from 20-35%”

Database Team:

“delivering

test data for UAT is a focus for private Cloud

this year ”

Non Production

Environments

Average Cost

Per Environment

Per Application

Very Small (less < 1 TB)

1,400

300

5 2,100,000

$13,860,000

$9,900

Small (1TB to 5TB)

500 3,000

5 7,500,000

$49,500,000

$99,000

Medium (5TB to 10TB)

75 7,500

7 3,937,500

$25,987,500

$346,500

Large (10TB to 15TB)

25 12,500

7 2,187,500

$14,437,500

$577,500

Very Large (>15TB)

20 20,000

7 2,800,000

$18,480,000

$924,000

Total:

2,020

18,525,000

$122,265,000

$60,527

Oracle DB

Size

Estimated

Storage (GB)

Requirements

Average

Number of

Non-prod

Environments

Average

DB Size

(GB)

Number

of

Applications

Estimated Annual OPX Costs

5 to 7

non-prod clones per production database

18 of 30 PB

for non-prod Oracle environments

(23)

Process Challenges

“Database Refresh

is a

necessary evil!”

70000

refresh/year

2000+

Dev/Test DB

3 – 5 TB

Typical DB size

RMAN

full clones

10 - 20

issues/day

EMC & NetApp

storage

- Christian Bilien,

Global Head of

(24)

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

(25)

Data Movement

Test Master

Database

NAME

SSN

SALARY

MILLER 112-23-4567 40,000

SMITH 111-22-3333 60,000

Masking &

Sub setting

Source

Database

010110011 101001010 000111010

NAME

SSN

SALARY

AGUILAR 203-33-3234 40,000

BENSON 323-22-2943 60,000

Source DB

Backups

Mask / Subset

Test Master

Clones

Refresh

Data Guard Standby

(26)

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}

(27)

Deployment Scenarios for Test Master

Continuous or Discrete Replication

_{Standby / Test}

Master Database

Source

Database

Snap Clones

Private backups

(snapshots) for SSA

user

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

(28)

Full or Snap Clone: How it Works?

Standby /

Test Master

t0

t1

t2

….

tN

Scheduled or Manual

Storage Snapshots

or

RMAN Backups

of the test master database, called

Profiles

Private backups

Clones

_•

_{Clones can be created from a}

library of profiles

• Each user gets a personal

read-write database clone

Test master is

regularly

refreshed with

current data

from production

(29)

(30)

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}

(31)

Non Self Service (Admin) Flows

• Non Self Service (

Admin

) flows

• Ideal for POCs, one-off clones, and for test

master creation

• Clone from a snapshot or to a

point-in-time

or SCN

• Integrated Masking and Patching (

PSUs and

Patch Sets

)

• One-click

refresh

of clones from source

• EMCLI verbs

Its not all Cloudy!

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"

(32)

DB Clone and Refresh – Admin Flow

Mask

Subset

Update [Patch or Upgrade]

Change Configuration [SI / RAC]

Snap Clone

Use as Test Master

Version: 11.2.0.3

Config: 3 Node RAC

Data: RMAN Backup1

Version: 11.2.0.4

Config: Single Instance

Data: RMAN Backup1

t0

t1

t2

….

tN

Production Database

Clone / Test Master

(33)

Integrated Data Masking

• 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

to only mask the test master, so as to retain

storage savings post snap clone

Production

Dev

Test

Clone

Test Master

Mask

DEPT

LAST_NAME SSN

SALARY

10 SMITH

111 —

23-1111

40,000

10 JOHNSON

222-34-1345

60,000

(34)

Supported Cloning Options

Software Solution

[Vendor Agnostic]

Hardware Solution

[Vendor Specific]

Full Clones

Snap (Thin) Clones

NAS

SAN

Database Native

[Storage Agnostic]

RMAN

Restore

RMAN

Duplicate

Data Pump

• Leverage your existing investments

• Cater to both functional and stress testing needs

• Maximize for best performance

(35)

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

(36)

Solaris File System with SAN Storage Network Diagram

(37)

• Ability to create thin databases from

RMAN image copies

• 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

• Advantages

–

Easy to setup

–

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

(38)

NAS Network Diagram

38

• 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

(39)

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

(40)

Continuous or Discrete Replication

Test Master

Database

Source Database

Masking and Subsetting using EM

Option 1: Snap Clones

Private backups

(snapshots) for SSA

user

Option 2: Full Clones

Summary of Database Cloning Choices

Private backup for

SSA user

•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

•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

(41)

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

(42)

Test Master

Database

010110011 101001010 000111010

Snap Clone with Oracle Engineered Systems

Enterprise Manager

12c

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

Oracle Virtual Compute Appliance

• Oracle VMs used to run snap clone

databases

• Embedded ZS3-ES storage served

over

infiniband

/source [nfs]

.. more

/clone1 [nfs]

External Storage

(43)

Solution Details

1

2

3

4 Service Catalog and Self Service Portal

Data Clone and Refresh

Monitoring and Management

(44)

Metering and Showback

Tailored for different use cases and user types

Chargeback Administrator

Self-Service Portal User

Line of Business User



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

(45)

DBaaS Chargeback Metrics (Out-of-the-Box)

VM

Database Instance

**DB Service (*)**

Pluggable Database

Fixed

Base Charge

Configuration

Allocated Memory

Allocated Storage

HA

IP Address

Size

vCPU Count

Edition

Memory Usage

Option

RAC Node Count

Release

Storage Usage

Version

Edition

Option

RAC Node Count

Release

Tablespace Allocation

Edition

Option

Release

RAC Node Count

Tablespace Allocation

Version

Usage

CPU Time

CPU Utilization (%)

Disk Space Utilization (%)

Disk Usage

Memory Used

Memory Utilization (%)

Network IO

CPU Time

CPU Utilization (%)

DB Time

Disk Read (Physical) Operations

Disk Write (Physical) Operations

Network IO

SQL Executes

User Transactions

CPU Time

CPU Utilization (%)

DB Time

Disk Read (Physical)

Operations

Disk Write (Physical)

Operations

SQL Executes

User Transactions

CPU Time

CPU Utilization (%)

DB Time

Disk Read (Physical)

Operations

Disk Write (Physical)

Operations

SQL Executes

User Transactions

(46)

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

(47)

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..

(48)

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

(49)

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

Database Fleet Maintenance

End Users

Self service maintenance for Database Cloud

11.2.0.3 DB Home

11.2.0.3 GI Home

11.2.0.4 DB Home

11.2.0.4 GI Home

Image Library

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

(50)

Solution Details

1

2

3

4 Service Catalog and Self Service Portal

Data Clone and Refresh

Monitoring and Management

(51)

APIs for DBaaS Providers and Consumers

DBaaS Providers:

• EMCLI Verbs for CRUD operations on Zones / Pools / Service templates / Profiles / Quota / etc

List

DBaaS

Portal API

Deploy

Delete

Manage



List Zones



List Service Templates



List Service Instances



Request DBs



Request PDBs



Request Schemas



Track request progress



Service Control (start/stop)



Backup



Restore



Snapshot



Get Chargeback info



Delete Service

(52)

Integration with 3

rd

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"

}

(53)

(54)

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

(55)

BENEFITS

Database as a Service

India’s second largest Private Bank with nearly 2800 branches, 11,000 ATMs

20 million customers

Employees: 56,000

Revenue: USD 5 Billion

FOCUS ON

Consolidation,

Self-Service Provisioning,

Lifecycle Management



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

Challenge:



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

Solution:



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

(56)

BENEFITS

FOCUS ON

Consolidation,

Standardization,

Self-Service and Chargeback



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

Challenges

:



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

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

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

(57)

Legacy/Traditional/AS – IS

• DB design specifically for single application

(traditional approach)

• Provisioning time of database: Weeks

• 700+ different combinations identified

(release-DB Version / Release-Version OS / Hardware)

• Standardized DB Service (Catalog of DB Services)

• Provisioning time of database: Hours

• 3 Service Classes on 5 standard configurations

Oracle Enterprise Manager 12c - DBaaS

Gold

Silver

Bronze

Server virtualization Database consolidation Schema Consolidation 1 2

4 5

3

• Strong under-utilization of allocated HW resources

• Shared HW resources with high utilization and efficiency

Telecom Italia

: Transformational Private DBaaS

Case

Study

COMPANY OVERVIEW

(58)

PNC Bank

Regional bank operating primarily in nineteen states and the District of

Columbia with more than 2,700 branches

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

Key Business Drivers

• Standardization and Simplification through

well-defined services: Gold, Silver, Bronze, Platinum

• Cost Savings

• Consolidation -- Infrastructure, People

• Automation -- Self Service

• Improved Customer Response Time

• Capacity on the floor vs purchasing per

project

• Showback

Case

Study

FOCUS ON

Monitoring, Provisioning

via Service Catalog

(59)

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

• 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

Case

Study

FOCUS ON

Storage Consolidation,

Snap Clone

(60)

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

• 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

Case

Study

FOCUS ON

Faster, and Repeatable

Automation

(61)

Cloud Management Pack for Oracle Database Summary

Metering, Chargeback

Supports Databases, Schema, and PDBs

Database Cloning

Full clones and Snap Clones (thin clones)

Quota and Policy based Management

Self-Service Provisioning

Enforces governance and control

Supports Database, Schema, and PDBs

Comprehensive REST and EMCLI APIs

For all self service and admin functions

(62)

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

(63)