Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos

Porus Homi Havewala

• Publisher: Packt Publishing
• Year: 2012
• ISBN:
  9781849684781
• Edition: 1
• Topic: Ciencia de la computación
• Subtopic: Aplicaciones empresariales

In Detail

Data centers around the world are experiencing an unprecedented era of growth due to expanding data volumes. There is also a corresponding increase in the number of databases and applications. In such rapid-growth centers, it is inevitable that fighting fires daily becomes a common occurrence. There is often no controlled method of performance management, neither is rapidly changing configuration information collected.

With the lack of automation and control, Data Centers do not often realize their intended cost-effectiveness and regress into a chaotic and uncontrolled day-to-day type of existence. This was the case until Oracle Enterprise Manager started being used as an Enterprise-wide central management solution, changing the whole game in the process.

In this brand new book by Porus Homi Havewala, one of the leading experts in the Oracle space, you will be introduced to the all-encompassing world of Oracle Enterprise Manager Cloud Control 12c, Oracle's premier product for managing and monitoring the Enterprise space. Drawing from the author's many years of experience in the real world, the book brings together the major capabilities of the latest Enterprise Manager software and demonstrates how to ease the growing pains of Data Centers.

The book takes you on a descriptive journey of what issues are normally experienced in the Data Center, and how Oracle Enterprise Manager Cloud Control 12c manages to address and resolve many of the issues.

The book introduces the reader to the typical chaos in Data Centers and discusses the way these common issues are normally resolved, by manual labor or manual scripting using extensive human resources. Then it will show you how Cloud Control 12c aids in Database Performance Management, Configuration Management, Security Compliance, Automated Provisioning, Automated Patching and Database Change Management.

You will learn how Cloud Control 12c allows Exadata Database Machine Monitoring and Management, Test Data Management for data subsetting of large databases, as well as Sensitive Data De-identification using Data Masking.

The book includes various real life examples and case studies of actual Oracle customers to show how they have benefited from using Oracle Enterprise Manager. It explores the strong standing of Oracle in the Enterprise Management  game, now also strengthened by the new Enterprise Manager Cloud Control 12c.

Approach

This book is a practical step-by-step tutorial with screenshots for carrying out tasks showing you how to manage and administer your data center with Oracle Enterprise Manager. 

It is packed with best practices and tips that will help you benefit from the author's extensive experience of working with Oracle Enterprise Manager since at least a decade, and combined with his 25+ years IT industry experience.

Who this book is for

If you are a Data Center, IT or Database Team manager who wants to take advantage of the automation and compliance benefits of Enterprise Manager 12c Cloud Control, then Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos is for you. CTOs will also find this book useful.

Experience of Enterprise Manager is not essential as the author's experience tells you all you need to know about getting started with Enterprise Manager. More experienced readers will learn about the brand new capabilities of the 12c release.

Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos

---

Table of Contents

Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos

Credits

About the Author

Acknowledgements

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. Chaos at Data Centers

Team effort

Common solutions used in data centers

Summary

2. Enter Oracle Cloud Control

The Grid – where the cloud came from

Overview of version 12c

Striking new features in 12c

Bonus sections

3. Ease the Chaos with Performance Management

Laying the foundation

Top activity

Testing infrastructure changes

SQL Monitoring

Doctor in the database

Real-Time ADDM

Compare Period ADDM

Active Session History (ASH) analytics

Summary

4. Ease the Chaos with Configuration Management and Security Compliance

Lifecycle management

Auto discovery

Inventory

Detailed configuration

Search capability

History and compares

Topology

Custom configurations

Client configurations

Compliance

Compliance library

Configuration and compliance reporting

Summary

5. Ease the Chaos with Automated Provisioning

Lifecycle management

First steps: Software Library

Provisioning library

Provisioning profiles

Deployment procedures

Customization

Lock down

Configuration details

Compliance standards

Granting permissions to the Provisioning Operator

Running EM as the Provisioning Operator

Running the procedure

Other possibilities

Summary

6. Ease the Chaos with Automated Patching

Recommended patches

Patch plan

Out-of-place patching

Pre-patching analysis

Deployment

Plan template

Patching roles

Refreshes

Other patching procedures

Reporting

Summary

7. Ease the Chaos with Change Management

Change management

Schema comparison

Schema Change Plan

Schema synchronization

Synchronization rules and mode

Synchronization results

Executing the synchronization

Synchronization without a Change Plan

Data comparison

Continuous comparison

Use cases

Summary

8. Ease the Chaos with Test Data Management

Test Data Management

Creating packages

Creating the Application Data Model

Data subsetting

Applications

Table rules

Rule parameters

Space estimates

Pre/Post subset script

Generate subset

Benefits and capabilities

Summary

9. Ease the Chaos with Data Masking

Finding sensitive data

Creating data masking definitions

New capabilities

Adding columns to mask

Defining the masking format

Advanced options

Generated Script

Scheduling the job

Testing the results

Format library

Benefits and capabilities

Summary

10. Ease the Chaos with Exadata Management

Meeting the challenges

Discovering Exadata

Adding the hosts

Adding non-host targets

Adding the cluster and databases

Monitoring and managing Exadata

Database machine resource utilization

Exadata grid

Infiniband network

Database performance pages

Total capabilities

Summary

11. Real-life Examples and Case Studies, and It's a Wrap: The Future is the Cloud

Case study – telecom

Case study – pharmaceutical

Case study – computer manufacturer

Case study – online store

Case study – financial institution

Case study – university

Future of cloud computing

Summary

Index

Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos

Copyright © Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: December 2012

Production Reference: 1111212

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-84968-478-1

www.packtpub.com

Cover Image by John M. Quick (<[email protected]>)

Credits

Author

Porus Homi Havewala

Reviewers

Kamran Agayev A.

Richard Ridge

Mark Fletcher

Acquisition Editors

Stephanie Moss

Robin de Jongh

Lead Technical Editor

Arun Nadar

Technical Editors

Charmaine Pereira

Prashant Salvi

Copy Editors

Brandt D'Mello

Insiya Morbiwala

Aditya Nair

Alfida Paiva

Project Coordinator

Joel Goveya

Proofreader

Kevin McGowan

Indexer

Tejal Soni

Production Coordinator

Nitesh Thakur

Cover Work

Nitesh Thakur

About the Author

Porus Homi Havewala works as the Senior Manager (for database management)in the Enterprise Technology Program Office of Oracle Corporation, based inSingapore, and specializes in Oracle Enterprise Manager. He is a double Oracle Certified Master (OCM) in 10g and 11g, as well as the first Oracle employee ACE in the country. He was awarded the prestigious Oracle ACE Director title by Oracle HQ in 2008. There are less than 150 Oracle ACE Directors in the entire world and Porus was the very first Oracle ACE and ACE Director in Singapore – a recognition of his outstanding achievements in the Oracle world.

Porus has had extensive experience in Oracle technology since 1994; this includes him working as a Senior Production DBA, Principal Database Consultant, Database Architect, E-Business Technical DBA, Development DBA, and Database Designer and Modeler (using Oracle Designer). He has published numerous articles on Oracle Enterprise Manager on OTN, and has created http://enterprise-manager.blogspot.com, one of the world's first blogs dedicated to Enterprise Manager (with Oracle Press Credentials). Porus is also the author of the book, Oracle Ente...

Table of contents

• Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos