Managing the Oracle Database Lifecycle with Oracle Enterprise Manager 12

crookpatedspongySoftware and s/w Development

Dec 2, 2013 (3 years and 11 months ago)

88 views

Managing the Oracle Database Lifecycle with

Oracle Enterprise Manager 12
c


David Wolf

Principal Product Manager

Oracle

Scott McNeil

Principal Product
Director
Oracle

Challenge: Controlling Configuration Drift


Source:
Managing the Rapid Rise in Database Growth: 2011 IOUG Survey on Database Manageability

“Experienced unplanned downtime
due to configuration drift, which
resulted as changes were made.”

80%

Challenge: Patch Management


Source:
Managing the Rapid Rise in Database Growth: 2011 IOUG Survey on Database Manageability

“Number of DBAs who said
keeping databases at current
patch levels was their top
challenge.”

45%

Challenge: Change Management


Source:
Managing the Rapid Rise in Database Growth: 2011 IOUG Survey on Database Manageability

“Number of DBAs who said they
avoid making changes to
production databases because of
negatively impacting performance.”


50%

Performance
Management

Real
-
Time ADDM

Compare Period
ADDM

ASH Analytics

Oracle Enterprise Manager 12
c

Extending Database Self
-
Management Leadership



Lifecycle
Management

Configuration,
Change

and Compliance Mgt

Mass DB Patching &
Upgrade Automation

Database

Cloud
Services

Database
-
as
-
a
-
Service

Metering and
Chargeback

Engineered
Systems

Consolidation
Planner

Exadata
Management

Database
Lifecycle Management

Discovery and
Initial
Provisioning

Discover Assets and Provision Software on
them

Ongoing

Change
Management

End to End Management of patches,
upgrades, and schema changes

Continuous
Configuration and
Compliance
Management

Track inventory, configuration drifts and
compliance

Discovery and
Initial
Provisioning

Discover Assets and Provision Software on
them

Ongoing

Change
Management

End to End Management of patches,
upgrades, and schema changes

Continuous
Configuration and
Compliance
Management

Track inventory, configuration drifts and
compliance

Database
Lifecycle Management


Auto
-
discovery of servers,
virtual servers and services
using IP scan (NMAP, agent
-
less)


Integrated workflow for agent
deployment and target
discovery on selected auto
-
discovered hosts


Promote the targets from
“Unmanaged” to “Managed”

Discover
What’s Out There

Agentless Discovery


Agent push is fully integrated with target discovery


‘Add host’
not ‘
push agent



Promoting a host from unmanaged to managed integrates seamlessly with agent push
workflow


Multi
-
platform agent push in a single deployment session


Approved patches can be pushed to the agent during initial deployment


Sudo/Powerbroker integrated for locked accounts


Recommendations provided in cause of failure


Agent cloning also supported


Simpler manual deployment


Generate agent zip or RPM from EM and deploy



Mass
Agent Deployment

Integration
with
Target Discovery

Software Provisioning

Framework Enhancements


Separation of Designer and Operator Roles


Designer can modify Deployment Procedures


Operators can only execute Deployment Procedures


Input lock
-
down for end operators


Enforces standard deployments, minimizes errors


Fine grained privileges


Integration with new Credential Model


Extensibility


User
-
defined Deployment Procedures


For custom software deployments


EMCLI and web services interfaces for integration with other tools


Integration with Self Update


Update Deployment Procedures out
-
of
-
major
-
release cycles


Improved diagnosability


Integration with Incident framework


‘Debug’ mode


Better error messages



Single console for entity types like
components, directives, assemblies, etc.


Integrated with Self Update


Enhanced support for Storage types


File System


Shared between OMS


Agent served file system


Referenced locations


http, nfs, read
-
only agent file system


ideal for multi
-
location data centers


Support attachments and notes for
software library entities


Attach Readme to patch component


Improved search e.g., search by vendor
and version


Fine grained privileges for entities

Software
Library

Distributed and Scalable Across Data Centers


Enables gold image cloning


Standard image with specific patches, configuration, tuning


Create and store reference image in software library


Flexibility to include binaries, configuration, data


Use profiles to provision new components


Different instance level properties than gold image like directory paths,
host names, ports, storage

Provisioning
Profiles

Standardization and Simplification

Database Provisioning

Provisioning Designer to Operator
Workflow

Provisioning

Designer

Select Reference

DB Host

Use Profile to populate

Procedure Inputs

Publish to
Operator

Create Profile

Lock down inputs

and save Procedure

DB Host

DB Profile

Locked

Procedure

Best
Practice

Procedure

Database Provisioning

Provisioning Profiles and Lockdowns

Locked values shown in read
only mode


Capturing Provisioning
Profiles


Database
Lifecycle Management

Discovery and
Initial
Provisioning

Discover Assets and Provision Software on
them

Ongoing

Change
Management

End to End Management of patches,
upgrades, and schema changes

Continuous
Configuration and
Compliance
Management

Track inventory, configuration drifts and
compliance


Proactive advisories, recommendations, and analysis


One
-
off patches, patch set updates, and critical patch updates


Zero downtime patching for RAC


Integrated patch management & deployment automation


Patch intelligence and community


Streamlined conflicts and merge patch process


Automating Patching

Fully Integrated with My Oracle Support






Analyze





Test





Patch





Report

Stage




Stage

Provision





Patch Management

Simplified, Integrated, and Flexible


Step
1
: Select Patches and Targets


Step
2
: Choose options for Deployment (Deployment Procedures are auto picked)


(In
-
Place, Out
-
of
-
Place, Rolling, Non
-
Rolling)


Step
3
: Run Validations


Comprehensive Analysis for Patch conflicts and Target
level sanity


Step
4
: Review
-
> Pre Deploy
-
> Deploy


Pre
-
Deploy or Prepare ahead of Downtime for cases like Cloning and Patching cloned Oracle Homes





Switch instances to newly

cloned Oracle Home

Apply SQLs (as needed) to

the instances

3





ORACLE HOME A

DB(1)

DB(2)

ORACLE HOME

HOST

ORACLE HOME A

PATCH

DB(1)

DB(
2
)

ORACLE HOME

HOST

>Clone Oracle Home

>Patch Cloned Oracle Home

(No Downtime)

2

Multiple Databases running

from an Oracle Home

1





ORACLE HOME

DB(1)

DB(2)

HOST

Out
-
of
-
Place Patching

Minimum Downtime
Patching for Single Instance Databases

DB(1)

DB(2)

Patch Management

User Profiles Tailored for Data Centers


Maintains Cloud Control infrastructure


Creates users and assigns appropriate roles and
privileges

Site
Administrator

Patching

Designer

Patching
Operator


Senior DBA (Designer Role)


Identifies Patches for the patch cycle


Creates Patch Plan Templates


Provides Template access to Operators


Junior DBA / Application DBA (Operator Role)


Creates Patch Plans from Templates


Executes/Schedules patch rollouts on the
designated targets

Database
Upgrade

Overview



NEW

in EM12c: Mass
Upgrade of Oracle
Databases


Supports Single Instance Database in first
release


RAC (Upcoming
)


Upgrade from 10.2.0.x,11.1.0.x
-
>
11.2.0.x


Upgrade Software & Instances combined or
separate


Integrated with
My Oracle Support
Upgrade
Planner

Database Upgrade

Upgrade Wizard


Plan


Detect new DB versions in My Oracle Support


Suggest best upgrade path for patch
compatibility


In
-
context reference to Upgrade documentation

Analyze


Check DB for upgradeability (space, version,
etc.)


Support upgrade from
10.2.0.4
+ to
11.2

Deploy



Mass deploy binaries to targets and create out
-
of
-
place copies


Upgrade process can be paused/resumed

Switch


Switch instances to new installations


Easy switchback if needed

Automated Change Management

Reduce Time and Effort of Database Change Management

Change Automation


Automated process for capturing and p
ropagating

planned database schema changes from development
to production environments


Eliminates manual error
-
prone processes


Accelerate application upgrades by tracking impact of
upgrades on customizations


Reduce downtime and speeds up recovery by ensure
compliance of production environments with
established standards

Reporting

Production

Training

Stage

Disaster Recovery

Test

1001100101000

010111010011

10100110101

Development

Syncing Application Environments

Oracle Change Management



Promoting and tracking
changes
from testing to
production databases


Transferring
schema & other database changes to DR, training,
& reporting
environments


NEW

in EM12c: Change plans

allow users to specify, group, & package
object metadata changes to multiple targets


Create change plans from ad
-
hoc changes & comparison
-
based differences


Role
-
based workflow: developers create and submit change plans via SQL
Developer, DBAs review and apply change plans


Capture information on all schema
objects for an application:


Tables, Views, Indexes


Procedures, Packages, Triggers


Users, init.ora


Capture & Compare scope:


Database, Schema, Objects


Compare Modes


Baselines to Baselines


Baselines to Database


Database to Database

Schema Change Detection & Automation

Capture & Compare Application Baselines / Workflows


HR

Order
Entry

CRM

Baseline
1

Baseline 2

1100001110100

010111010011

10100110101

1100001110100

010111010011

10100110101

1100001110100

010111010011

10100110101

SALES

DEPT

EMP

ORDERS

PRODUCT

PRICE

Baseline 3

Database Change Management

Data Comparison


Data comparison fills a critical gap to allow:


Application vendors to compare seed data


Application customers to compare configuration data
between different sites


DBA’s to determine how seed data customizations will be
affected by application upgrades

Database B

Database A

“British Telecom uses Oracle Enterprise Manager to provide
database
-
as
-
a
-
service and middleware
-
as cloud service
offerings. We can now deploy a database in
20 minutes
whereas in the past it would have taken us a couple of weeks.
The business reaps the benefit in decreased costs of hardware,
being agile and being able to deliver services quickly to market.
BT are excited about the new features in Oracle Enterprise
Manager 12
c

such as customer self
-
service, templated
provisioning, agentless discovery, metering and chargeback

which we
expect to further help cut costs
."

Surren Partabh

CTO Core Technologies

British Telecom

Source:
BT Deploys Oracle Database as a Service, cutting provisioning time from weeks to minutes


http://streaming.oracle.com/ebn/podcasts/media/
10957726
_BT_
110911
.mp
3


Database
Lifecycle Management

Discovery and
Initial
Provisioning

Discover Assets and Provision Software on
them

Ongoing

Change
Management

End to End Management of patches,
upgrades, and schema changes

Continuous
Configuration and
Compliance
Management

Track inventory, configuration drifts and
compliance

Configuration Management

Discovery

and Asset

Tracking

Comparison,

History, and

Reporting

Configuration

Compliance

Real
-
Time

Config

Change

Detection

Hosts

and OS

Databases

Application

Servers

Applications

CLOUD READY

APPS/SYSTEM

CENTRIC

EXTENSIBLE

INTEGRATED

Configuration
Management

Comprehensive, Integrated, Automated

Build Search criteria for
Ad
-
hoc Search

Save Search Definition

Configuration
Management

Inventory Search and Reporting

Use Existing Relationships And
Properties

Population trend

Version Distribution

Configuration Details

Configuration
Management

Inventory
Reporting


Represent relationships
visually


Manage at system level, rather
than component level


Understand dependencies and
analyze impacts


Support relationships:


Out
-
of
-
box systems


‘Depends On’


‘Used By’


Create custom view to add
new targets to predefined
systems

Topology name

Host

Database

Listener

Configuration
Management

Topology Viewer




Configuration comparison and alerts for
drift detection


Compare configurations to “gold”
standards


Compare across Database lifecycles,
dev, test, production using ad
-
hoc or
scheduler


Compare using custom or out
-
of
-
box
templates


Ability to ignore certain differences


Useful in comparing multi
-
component
systems:


Oracle Database


Oracle Exadata


Weblogic Managed Servers


Fusion Applications


1
-
1
and
1
-
n comparisons

Configuration Comparison

Maintain Consistency and Prevent Drift

Ignore obvious differences
to prevent noise

Use pre
-
existing template

Apply constraints on
configuration value

Notify on
Difference

Oracle Exadata Comparisons


Baseline

Current

Gold Image

?

=

=

?

=

?

?

=

Storage Cell

To

Storage Cell

RAC

RAC

?

=

=

?

DB

DB

DB


Multiple hierarchies


Compliance Framework

Conceptual “folders” that map configuration
standards to real
-
world structure of
compliance frameworks (PCI, COBIT, HIPAA,
CIS, etc)


Compliance Standard

Collection of rules that gets associated to
multiple targets


Compliance Rule

Checks/Tests that are performed against
specific target types

Rules

Compliance
Standards

Compliance
Frameworks

DBAs, Admins,

IT Managers

Compliance

Manager,

Security
Auditors


Rich set of compliance reporting for Administrators and Security
Auditors


Self
-
Update features:


Notify new content availability


Assist in downloading new content

Compliance Enforcement


Checks / tests that are performed against the environment, e.g.: is a parameter value
set properly as per best practice guidelines?


Rich set of out
-
of
-
box rules mapped to out
-
of
-
box standards and frameworks


For Exadata configuration, CIS, PCI, etc


Is a change that happened authorized by a change request?


Target
-
type specific, not target
-
specific


Three types


Repository Rule


Evaluated against repository data


Repository browser to aid in rule creation


Real
-
time Rule


Detection of real time activities (file actions, schema actions, process actions)


Detection of “unauthorized” changes through automated correlation against
Change Management Systems


Weblogic Rule


BEA Guardian health checks integrated in Enterprise Manager

Configuration
Management

Compliance Rules

Rule

Standard

Framework

Configuration
Management

Compliance
Reporting



Integrated Management Synergies





38





Advise

Act

Audit

Core


Discover



Hosts & Applications



Dependencies and Relationships



Inventory


Collect



Deep configuration data



Parsed Configuration Files



Patches installed



Real
-
Time Monitoring


Who/When



Compliance Score



Best Practices



Oracle Recommendations



Regulatory ( PCI,Cobit)


Report



Inventory &Trend


Automatic Change Reconciliation



Authorization
vs.
Unauthorized





Patch Advisories via MOS



Upgrade Advisories from MOS



Configuration Policy Violations




Change/Patch Plans



Mass deployment



Schema Synchronization



Settings, Drift & Policy Actions



Configuration Changes



Topology guided Impact Analysis



Config Comparison for Drift Analysis



To Gold & Baseline



1
to
1
,
1
to N



Target and System



DB Change Management



Data Comparison



Change Plans



Patch Conflict and PreReq Analysis

Analyze


Comprehensive management solution

for configuration, patching,
provisioning, and change automation


Automated discovery capabilities to
know what’s out there


Integrated console for
simplified management


Rich out
-
of
-
box policy templates to
enforce compliance


Application centricity topology views and relationships for
better visibility

Comprehensive Database Lifecycle
Management

Only with Oracle Enterprise Manager
12
c

Oracle

Enterprise Manager
12
c

Resource Center

Access Videos, Webcasts, White Papers, and More

Oracle.com/goto/enterprisemanager

Business
-
Driven

IT Management

Questions