|
|
ISBN 10:
0-9844282-0-8
ISBN 13:
978-0-9844282-0-5 |
Library of
Congress Number: xxx |
300
pages
Perfect Bind- 9x7 |
PD 1010 |
|
Shelving:
xxx |
Oracle In-Focus Series #xx |
|
|
Oracle Enterprise Manager Grid Control
Advanced OEM Techniques for the Real World
Porus Homi Havewala
Oracle ACE Director
Retail Price
$xx.xx
/ £xx.xx
|
|
This book will serve as a solid introduction
to the many possibilities of Oracle Enterprise Manager Grid
Control. With corporations looking for ways to streamline
mundane DBA tasks, this book will demonstrate the many benefits of
Grid Control for that purpose.
Enterprise Manager Grid Control today is Oracle’s Flagship
Enterprise-class management and monitoring toolset for
corporate-wide Oracle Databases and other third-party
databases, Application Servers, Application software such as
Oracle E-Business, People Soft, Siebel, as well as the host
servers themselves, the disparate storage systems such as
SAN or NAS filers, and also load balancers, with an
ever-expanding list of Plug-Ins by Oracle or by Third-party
vendors.
To get the most from this book, the
reader should have preliminary exposure to Oracle concepts.
This book is intended for
Database Managers, Database Architects, IT Management –
Medium to Senior level, Database Administrators – Oracle or
Sql Server, System Admins – Unix or Linux or Windows with
beginner to medium levels of experience.
|
|
•
Understand corporate benefits of using
Grid Control. •
Learn the practical architecture of Grid Control. •
Learn how to automate mundane DBA tasks.
|
About the Author:
|
Porus Homi Havewala
Director |
|
Porus Homi Havewala
is a Principal Consultant with 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 Modeller. He
has worked in Oracle India in the ACS (Advanced Customer Services)
department and is an enthusiast for Oracle technology, especially
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.
Mr. Havewala has been awarded the prestigious
“Oracle ACE Director” title by Oracle USA. There are only about 80
ACE Directors in the entire world and Mr. Havewala is the first
ACE Director in Singapore – a recognition of his outstanding
achievements in the Oracle world. He is currently employed at S&I
Systems, an Oracle Platinum partner in Singapore.
|
| |
|
|
Table of Contents:
|
Chapter 1 - Introduction,
System Requirements and Installation
Thanks are in order
About Enterprise
Manager
About the Author
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
Chapter 2 -
Scalable
Architecture
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
Chapter 3 -
How Grid Control
helps in RMAN backups
Command line Issues
Early Days of Database Backups
RMAN
enters the fray
History repeats itself
How we did it in
the old days – Shell Scripts
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
Admin
Configuring the Backup in Grid Control
Backup
Settings
Oracle Secure Backup – the welcome alternative
Configure Oracle Secure Backup
Entering and testing Host
Credentials
Backup Policy
Redudancy or Recovery Window
Archived Redo Log Deletion policy
Control File Configuraton
Settings
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
|
Chapter 5 -
Database
Patching and the Patch Advisory
The Early Days
Complexities of Patching
The Saviour
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
Chapter 6 -
NEXT GENERATION
Patching - 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
ITIL
Compatibility
Report on Applied Interim Patches
Patch
Advisory Smarts
Patch Reports Customization
More
sophisticated customization
The Repository Views
Analyze
before you Deploy
What we Learned
Chapter 7 -
Set up Data
Guard Standbys using Grid Control
Early Days of Oracle DR
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
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
|
|
|
Index:
Reader
Comments: Errata: |
