Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 


ISBN 10: 
0-9844282-0-8
ISBN 13:
978-0-9844282-0-5
Library of Congress Number: 2010941002
300 pages
Perfect Bind- 9x7
PD 0511
Shelving:  Database Oracle In-Focus Series #39

 

Oracle Enterprise Manager Grid Control
Advanced OEM Techniques for the Real World

Covers the NEW Enterprise Manager Grid Control 11g released in April 2010

Porus Homi Havewala
Oracle Certified Master (OCM) & Oracle Employee ACE

Senior Manager, Oracle Corporation


Retail Price $27.95 /  £20.95
 

 

     
Key Features About the Author Reader Comments
Table of Contents Index Topics Errata
     

Oracle’s Enterprise Manager Grid Control is recognized as the IT Industry’s leading Oracle database administration and management tool. It is unrivalled in its ability to monitor, manage, maintain and report on entire enterprise grids that comprise hundreds (if not thousands) of Oracle databases and servers following an approach that is consistent and repeatable.
 
However, Enterprise Manager Grid Control may seem daunting even to the most advanced Oracle Administrator. The problem is you know about the power of Enterprise Manager but how do you unleash that power amongst what initially appears to be a maze of GUI-based screens that feature a myriad of links to reports and management tasks that in turn lead you to even more reports and management tasks? 
 
This book shows you how to unleash that power. 
 
Based on the Author’s considerable and practical Oracle database and Enterprise Manager Grid Control experience you will learn through illustrated examples how to create and schedule RMAN backups, generate Data Guard Standbys, clone databases and Oracle Homes and patch databases across hundreds and thousands of databases. You will learn how you can unlock the power of the Enterprise Manager Grid Control Packs, PlugIns and Connectors to simplify your database administration across your company’s database network, as also the management and monitoring of important Service Level Agreements (SLAs), and the nuances of all important real-time change control using Enterprise Manager.
 
There are other books on the market that describe how to install and configure Enterprise Manager but until now they haven’t explained using a simple and illustrated approach how to get the most out of your Enterprise Manager. This book does just that. 
 
The book also covers the NEW Enterprise Manager Grid Control 11g released in April 2010. 


 

 

Key Features

  • Covers the NEW Enterprise Manager Grid Control 11g released in April 2010
  • Understanding Enterprise Manager Grid Control
  • Enterprise Manager Grid Control scalable architecture
  • Automating RMAN backups with Enterprise Manager Grid Control
  • Database patching using Enterprise Manager Grid Control
  • Generating Data Guard Standbys using Enterprise Manager Grid Control
  • Troubleshooting using Enterprise Manager Grid Control
  • Managing and Monitoring Service Level Agreements using Enterprise Manager Grid Control
  • Using the Enterprise Manager Grid Control Management Packs, PlugIns and Connectors

 

About the Author:



Porus Homi Havewala


Emloyee ACE

 

 

Porus Homi Havewala, OCM, works as a Senior Manager (Database Management) in the Enterprise Technology team of Oracle Corporation based in Singapore, and specializes in Oracle Enterprise Manager.  He is an Oracle Employee ACE and was previously awarded the prestigious “Oracle ACE Director” title by Oracle USA. He has extensive experience in Oracle technology since 1994, including as a Senior Production DBA, Senior Database Consultant, Database Architect, E-Business Technical DBA, Development DBA, and Database Designer Modeler. He has also worked in Oracle India in the ACS (Advanced Customer Services) department and is an enthusiast for Oracle technology, especially Oracle Enterprise Manager Grid Control and RMAN, on which he has conducted seminars for large MNCs and implemented powerful enterprise tools.

Mr. Havewala has worked with the first production Grid Control site in the world, Telstra the largest telecommunications company in Australia. He has published numerous articles on Grid Control and RMAN on OTN, and created the world's first blog dedicated to Grid Control, showcasing podcasts exclusively based on this technology. There are only about 100 Oracle ACE Directors in the entire world and Mr. Havewala was the very first Oracle ACE and ACE Director in Singapore – a recognition of his outstanding achievements in the Oracle world. Prior to Oracle Corporation, he was employed at S&I Systems, an Oracle Platinum partner in Singapore.

     

 Table of Contents:

Chapter 1:  System Requirements and Installation

 

Introduction

About OEM

A Word About Licensing

What You Need to Download

Using 11g as the Repository Database

Database Creation and Configuration

Installing the 10.2.0.5 Patch

Using a New Database for the Repository

Installing the Agent on Your Target Servers

The GUI Method

The Agent Pull Method

Agent Push or Agent Deploy Method

NFS Agent Installation

Agent Cloning

Agents in Gold Copies

Agent Deployment Best Practices

Conclusion

 

Chapter 2:  Scalable Architecture for Large Sites

 

First Production Grid Control Site in the World

Benefits to Management

Architectural Design:  The Incorrect Approach

Reasons for Project Failure

Recommendations for Production

The New Architecture of Grid Control

The Installation Technique

Scale-Out and Load Balancing

IP Assignments to Load Balancers

Virtual Servers and Pools

Issues Faced in Production

On Your Way to the Largest Grid Control Site

Conclusion

 

Chapter 3:  How Grid Control Helps in RMAN Backups

 

Command Line Issues

Early Days of Database Backups

RMAN Enters the Fray

History Repeats Itself

Shell Scripts (How It Was Done in the Old Days)

Netapps Filer Mounts

RMAN Backup Shell Script

What the Steps Mean

Issues with Manual Steps

The Enterprise Manager Way

Security Concerns

Pre-Install Steps

Using a Separate Group and Adminstrator

Configuring the Backup in Grid Control

Backup Settings

Oracle Secure Backup:  The Welcome Alternative

Entering and Testing Host Credentials

Backup Policy

Redudancy or Recovery Window

Archived Redo Log Deletion Policy

Control File Configuraton Settings

Conclusion

 

Chapter 4:  Database Backup Strategies Using Grid Control

 

Schedule the Backup

Review of Backup Job

Editing the Generated Script

Initial Issues

Encryption Wallet

Job Success

Understanding RMAN Output

Importance of Maintenance

Reopening the Wallet

Scheduling the Job for Each Day

DBCA and Automatic Backups

Backup Strategy

Creating a Level 0 Backup

Creating a Level 1 Backup

Scheduling Monday to Friday

Upgrading is a Good Idea

Examining the Backup Jobs List

Creating an Image Copy Backup

Refreshing the Image Copy

Backing Up the Flash Recovery Area

Backing Up Using Snapshots

Basic Snapshot Setup

Setting Up Filer Snapshots in Grid Control

Script Mechanism

The New Way:  ACFS Snapshots

Backup Strategies:  Recap

The Numerous Advantages of Using Grid Control

Conclusion

 

Chapter 5:  Database Patching and the Patch Advisory

 

The Early Days

Complexities of Patching

The Savior Arrives:  Grid Control

Proof of Concept:  Patching via Grid Control

Offline Update of the Patch Advisory

Patch Advisory and Earlier CPUs

RPM Patching at the LINUX level

RefreshFromMetalink Job Success

Applying the Remedy

Brave New World of Deployment Procedures

Conclusion

Chapter 6:  Next Generation Deployment Procedures

 

Executing the Deployment Procedure

First Attempt Results

Workaround for the Locking Issue

Deployment Procedures:  Customization

Raw Power of Deployment Procedures

Manually Download Patches

Patch Deletion

Report on Applied Interim Patches

Patch Advisory Smarts

Patch Reports Customization

More Sophisticated Customization

The Repository Views

Analyze Before You Deploy

What Was Learned

Conclusion

 

Chapter 7:  Set Up Data Guard Standbys and Other Provisioning

 

High Availability

Early Days of Oracle Disaster Recovery

Enter Enterprise Manager

Standby Oracle Home Creation

Gold Copies

Creating the Standby Database

Choosing the Standby Type:  Physical or Logical

Backup Type

Standby Redo Log Files

Standby Database File Locations

Standby Database Configuration Page

Management Options for Data Guard

Data Guard Management Page

Verify Configuration

Editing Data Guard Properties

Procedures for Database Provisioning

Customize Any Procedure

Deploy the Procedure

Provision Multiple Targets

Database Configuration

Provisioning Launch

Manual Copy Not Supported

Database Gold Copy

Bare Metal Provisioning

Conclusion

 

Chapter 8:  Grid Control for Everyone

 

Grid Control for System Administrators

Grid Control for DBA Troubleshooters

Extreme Control – Grid Control for Regulators

Grid Control for IT Managers

Real User Experience Insight (RUEI)

Monitoring Entire Systems and Services

Root Cause Analysis (RCA)

Service Level Agreements (SLAs)

Reports That Save Money

Public Access to Enterprise Manager Reports

Enterprise Manager Management Packs

Diagnostics and Tuning Packs

Finding Performance Issues Quickly

The New Real-Time SQL Monitoring

Provisioning and Patch Automation Pack

Configuration Management Pack

Change Management Pack

Data Masking Pack

Other Management Packs

Management Connectors

System Monitoring Plug-ins

Present Uptake and Future of Enterprise Manager

Conclusion

 

Chapter 9:  The New Enterprise Manager Grid Control 11g

 

Highlights of the New Version

Improved Middleware Management

New Database Management Capabilities

New Features in the Data Masking Pack

New Features in Change Management

Widespread Management of Hardware, Virtualization and Operating System

Enhancements to Application Testing Suite (ATS)

Installation Techniques for the New Version

Installing Oracle WebLogic Server

Applying Oracle WebLogic Patches

Installing Database and Patches

Oracle Enterprise Manager 11g Install

Close Integration with My Oracle Support

Grid Control Administration Changes

Controlling the Oracle Management Service (OMS)

Setting Parameters for the OMS

Changed Locations of Log and Trace Files

High Availability Console

Book Conclusion

Index:

A

accelerators

ACFS Snaphots

Active Reports

active-passive failover

Additional Management Agent

ADDM

Advanced Security Option

Agent Cloning Method

Agent Configuration Assistant

Agent Deploy

Agent Home

Agent Pull Method

Agent Push

Agent uploads

analyze mode

and Patch Automation Pack

Application Management Suites

Application Server

Application Testing Suite (ATS)

application waits

Apply Patches

architectural design

architecture

Archived Redo Log Deletion Policy

Automatic Storage Management (ASM)

 

B

Backup Policy

backup script

Backup Settings

Bare Metal Provisioning

bare-metal provisioning

BIG-IP

Business Transaction Management (BTM)

BZIP2 compression algorithm

 

C

cache fusion

Change Management Pack

Clone Wizard

compare configuration

compare products

Compliance Dashboard

Configuration Assistants

Configuration Change

Configuration Change console

configuration management

Configuration Management Pack

Console Dashboard

Console Home Page

Controlfile Autobackup

CPUs

Critical Patch Update

Critical Patch Updates (CPUs)

crontab file

custom policies

Customer Support Identifier (CSI)

customize

customized report

 

D

Data Guard

Data Guard Broker

Data Masking Pack

Data Modeler

Database Area

Database Configuration

Database Configuration Assistant (DBCA)

Database Control

database patching

database performance

database provisioning

datafile copies

Definitive Software Library (DSL)

de-installation

deployment procedure

deployment procedures

Deployment Summary

deployment targets

destination targets

Diagnostic and Tuning Packs

Diagnostics Pack

differential backup

Disaster Recovery (DR)

DLL file

DLLs (Dynamic-Link Libraries).

 

E

encryption wallet

Enterprise Edition (EE)

Enterprise Manager Console

Enterprise Manager Diagnostics (EMDIAG)

Event Details

existing database

 

F

failover

filer volume

flash recovery area

frequency type

 

G

GCDomain

generated script

GNU Wget

Gold copy

Gold Copy

Gold image

Grid Control

Grid Control Console

Group Dashboard

group targets

GUI wizards

 

H

High Availability

host configuration

Host configuration collection

host performance

 

I

Identity Management plug-in

Image copy backup

incremental backup

installation type

Integrated Application-to-Disk management

IT managers

ITIL (Information Technology Infrastructure Library)

 

J

Java Virtual Machine (JVM)

Job Activity

Jobs link

 

K

Key Performance Indicators (KPIs)

 

L

Level1  backup

Level1  incremental backup

load balancers

load balancing

LUN

 

M

Management Agent

management connectors

Master agent

Maximum Availability Architecture (MAA) Advisor

Merge Request

Middleware

My Oracle Support

N

NetApp

Network Protocol Analysis (NPA)

new database

NFS agent

N-tier model

 

O

OC4J_EM

OC4J_EM process

OEM Agent

OEM Grid Control

OEM Ops Center

OMS

OMS Home

opatch utility

Opatch utility

opmnctl

opmnctl command

Ops Center

Optimal Flexible Architecture (OFA)

Oracle Application Server

Oracle Automatic Storage Management Cluster File System (Oracle ACFS)

Oracle Coherence

Oracle Dataguard

Oracle Exadata

Oracle Fusion Middleware

Oracle Home

Oracle Homes

Oracle Installer

Oracle licensing

Oracle Management Service

Oracle Management Service (OMS)

Oracle Parallel Server (OPS)

Oracle Secure Backup (OSB)

Oracle Support

Oracle Technology Network (OTN)

Oracle WebLogic

Oracle WebLogic Server

Oracle WebLogic Server (WLS)

out-of-the-box reports

 

P

Patch Advisory

Patch Oracle Database

Patch Oracle Database procedure

Patch Set Updates (PSUs)

patches

performance metrics

physical standby

Plan Statistics

plug-ins

Policy Library

pool

Preferred Credentials

prerequisite checks

primary database

Process Explorer

Profile

Proof-of-Concept (POC)

Provisioning and Patch Automation Management Pack

Provisioning and Patch Automation Pack

Provisioning and Patch Management Pack

Public Access reports

 

R

RAC One Node

Real Application Cluster (RAC)

Real Application Clusters (RAC)

Real User Experience Insight (RUEI)

Real-Time SQL monitoring

Recovery Window

Red Hat Package Manager (RPM)

Redundancy

Remedy

Remedy Details

repository database

Retention Policy

RMAN

RMAN backup

RMAN backups

RMAN commands

RMAN configuration

RMAN output

RMAN script

Root Cause Analysis

 

S

SANs

scalable architecture

scalable architecure

schedule backup

Search Software Library

security updates

Service Level Agreements (SLAs)

Service Level Details

Service Level Management (SLM)

Service-Oriented Architecture (SOA)

Simplified Discovery

SLAs

snaphot

snapshot

SOA

SPFILE

SPFILE autobackup

SQL Developer

SQL Tuning Advisor

SQLNET

standby database

standby redo logs

svchost

System Administrators

 

T

Target Group

Target Groups

topology viewer

Tuning Pack

Tuning Sets

 

U

Unbreakable Linux Network (ULN)

UNIX shell scripts

Unlocker utility

upgrading

 

V

Verify Configuration

virtual servers

Vulnerability Management Dial

 

W

WebLogic Server

WebLogic Server (WLS)

Webtier Home

Windows Task Manager

 

X

XML files

 

Z

ZLIB compression algorithm

Reader Comments:

Errata:

   

 Copyright © 1996 -2011 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks