Book Image

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

By : PORUS HOMI HAVEWALA
Book Image

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

By: PORUS HOMI HAVEWALA

Overview of this book

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.
Table of Contents (19 chapters)
Oracle Enterprise Manager Cloud Control 12: Managing Data Center Chaos
Credits
About the Author
Acknowledgements
About the Reviewers
www.PacktPub.com
Preface
Index

Test Data Management


Enterprise Manager Cloud Control 12c provides a new licensed pack, known as the Test Data Management Pack. This is mainly used for the purpose of data subsetting, that is, to create a relationally intact subset of data from production.

For this purpose, an Application Data Model (ADM) needs to be created and stored in Enterprise Manager. This is a new concept in Cloud Control 12c. This model defines the database schema with all its relations. You can then define the subset of the data that is required from the model. At the same time, you can define the data-sensitive columns in the tables, such as a credit card number. This information will then be used to create the subset of data for testing, and also to mask sensitive data using the Data Masking Pack (as we will see in the next chapter).

Creating packages

A prerequisite to using the new facility of Test Data Management is to create special packages in each database that will be used for this scenario. These packages...