Expert Oracle Enterprise

Expert

Oracle

_Enterprise

Manager

12c

Kellyn

Pot'vin

Anand

Akela

Gokhan

Atil

Bobby

Curtis

Alex Gorbachev

Niall Litchfield

Leighton

Nelson

Pete

Sharman

Contents

J

About the Authors

xv

About the

Technical

Reviewer

xix

Chapter

1:

_{Enterprise Manager}

Cloud Control 12c Architecture

1

Architecture

Overview

2

The Cloud ControlConsole 3

Oracle

_Management

Agents

3

Oracle

_Management

Service 4

Oracle

_Management

Repository

4

Plug-ins

5

A

_{High-Availability}

EM12c

_{Configuration}

5

Level 1 6

Level 2 '. 6

Level 3 7

Level 4 7

The Software

_Library

8

Management

Tools

9

Command-Line Tools

10

Repository

Users

10

Repository

Views

11

Communication Flow

11

Protocols • 11

Ports 12

Firewalls 12

CONTENTS

Authentication

in

EM12c

13

Summary

14

Chapter

2:

Installation and

_{Agent Deployment}

15

Meeting

Hardware

_Requirements

16

Hardware

_Requirements

for OMS 16

Hardware

_Requirements

for

_{Management Repository}

16

Hardware

_Requirements

for

Management Agents

16

Installing Management

Repository

17

Using

theOracle-ValidatedRPM

_Package

and YUM 17

Creating

OracleUserand

_Groups

18

Setting

Kernel Parameters 18

Creating Required

Directories 19

Installing

the Oracle Database Software 19

Creating

the

_Repository

Database 30

Installing

Oracle

_{Enterprise Manager}

12c

38

Creating

the Oracle User and

Groups

38

Creating Required

Directories 38

Installing

Oracle

_{Enterprise Manager}

39

Deploying Management Agents

53

Using

the Add Host

_Targets

Wizard 53

Using

RPM ₅₇

Using

the

_{AgentPull Script}

60

Using

the

_agentDeploy

_Script

61

Summary

64

Chapter

3:

_Management

of the OMS

and

_Repository

65

Oracle

_{Management Agent}

₆₅

Agent Management

with the Console 65

Agent Management

with the Command Line ₇₃

2CONTENTS

Oracle

_Management

Service

78

OMS

_Management

withthe Console 78 OMS

Management

with the Command Line 82

Oracle

Management Repository

88

Repository Management

with the Console 88

Repository Management

withtheCommand Line 91

Repository

Views 94

Troubleshooting

95

Summary

97

Chapter

4:

_Interacting

with the EM 12c Console

99

A Brief

_History

of EM

99

Technology

100

Interface 101

Cloud Control 105

Cloud Control Menu Bar

106

Security Management

107

Configuration

of

Support

Integration

115

Proxy

Configuration

115

Notifications 118

Management

PackAccess 122

Navigation

Menu Bar

124

Enterprise

Menu 124

Targets

Menu 132

Favorites

Menu 136

History

Menu 136

Search Box 137

Target Management

Menu Bar

138

Monitoring

Setup

140

Diagnostics

143

CONTENTS

Target

State and Notification Control 145

Log

Review 146

Target Setup

147

Customization 148

Summary

151

Chapter

5: Cloud

Lifecycle Management

153

What Is Cloud

_Computing?

153

EssentialCharacteristics 154

Service Models 154

Deployment

Models 155

Enterprise

PrivateCloud 155

Complete

Cloud

_{Lifecycle Management}

156

Planning

the Cloud 157

Setting Up

the Cloud 158

Building

theCloud 161

Testing

in the Cloud 163

Deploying

the Cloud 164

Monitoring

the Cloud 165

Managing

the Cloud 166

Metering

and

_Chargeback

169

Optimizing

the Cloud 179

Consolidation Planner

179

Summary

186

Chapter

6:

Software

_{Library, Patching,}

and

_Provisioning

187

Software

_Library

187

Configuring

theSoftware

_Library

189

Using

Software

Library

Entities 192

Performing

Tasksvia theSoftware

_Library

Home

_Page

194

Maintaining

the Software

_Library

208

CONTENTS

Patching

211

Patch

_Management

211

Configuration

of

_My

Oracle

_Support

212

Patch Plans 213

CreationofaPatch Plan 214

Plan

_Templates

222

Saved Patches 225

Additional

_Patching

Procedures 226

Roles Needed for

Patching

226

Provisioning

227

Overviewof Database

_Provisioning

227

Supported Targets

and

_Deployment

Procedures 229

Setup

for Database

_Provisioning

230

Summary

244

Chapter

7:

_Managing

and

_Monitoring

Best Practices

245

Metric Thresholds

245

Monitoring Templates

248

Administration

_Groups

252

Planning

the

_Hierarchy

252

Implementing

the

_Hierarchy

254

Joining

Administration

_Groups

257

Template

Collections

260

Synchronization

Schedule

262

Incident

_Management

Recommendations

264

Events,

Incidents,

and Problems 264

Rules and Rule Sets 266

Metric

Collection

Errors 269

Summary

269

a CONTENTS

Chapter

8:

_{Managing Engineered Systems}

271

Types

of

_{Engineered Systems}

271

Engineered Systems Lifecycle

272

Supported

HardwareandSoftware 273

Planning

and

_Setup

Phase

274

Installing

the

_{Management Agent}

274

Launching

Autodiscovery

275

Specifying Component

Credentials 277

Reviewing

Configuration

and

Completing Setup

278

Testing

Phase

280

Identifying Applications

toBe

_Migrated

₂₈₀

Creating

aTest Environment 287

Validating Application

Performance ₂₈₉

Management

Phase

₂₉₀

I/O

Resource

_Manager

₂₉₂

Maintenance Phase

₂₉₃

Compliance

Framework ₂₉₄

Configuration

Management

295

Defect

_Diagnostics

₂₉₈

Automated Patch

_Management

₃₀₀

Summary

300

Chapter

9:

Performance

_Pages

and

ASH

_Analytics

₃₀₁

Licensing

Requirements

301

Host Performance

₃₀₂

Performance

Home

₃₀₄

Throughput

₃₀₆

I/O ₃₀₇

Parallel Execution ₃₀₇

Services

₃₀₇

CONTENTS

Top Activity

308

Top

SQL Pane ₃₁₀

SQL

Details

_Page

₃₁₀

SQL

_Activity

₃₁₁

Top

Sessions Pane 315

ASH

_Analytics

₃₁₈

The Load

_Map

₃₂₂

SQL

_Monitoring

₃₂₃

SQL Performance

₃₂₆

SQL Performance

_Analyzer

₃₂₆

SQL

AccessAdvisor ₃₂₇ SQL

_Tuning

Sets ₃₂₇

SQL

Plan Control ₃₂₇

Optimizer

Statistics ₃₂₈

Cloud

Control SQL

_History

₃₂₉

Advisor Central ₃₃₀

Emergency Monitoring

331

Real-Time

ADDM

₃₃₁

ADDM

Comparison

Report

333

Summary

338

Chapter

10: Metric Extensions and

_Management

_Plug-ins

339

Metric

Extensions

₃₃₉

Your First Metric

Extension

340

SQL Adapter

347

OS Command

_Adapters

₃₄₈

SNMP Adapter

351

JMX

_Adapter

₃₅₁

Adapters

and

Target

Types

351

Management

Plug-ins

352

Getting

Started with the

_{Extensibility}

Framework 352

Basic

_Plug-in

_{Target Types}

and Metrics ₃₅₅

CONTENTS

Target Type

Metadata 358

DefaultCollection Metadata 365

Packaging

the

_Plug-in

368

Agent's

Metric Browser 369

Underthe Hood of Metric Extensions 369

Summary

383

Chapter

11:

_{Enterprise Manager}

Jobs

•

385

Why

Use EM12c

Jobs

386

Enterprise Manager

Job Architecture

386

EM Job

_{System Components}

387

EMJobs Service 387

Monitoring Configuration

389

TheJob

_{Activity Page}

₃₉₀

The

Enterprise

Manager

Job

_Library

392

EM Job Schema

₃₉₃

Job Creation

₃₉₆

Types

of Jobs

₄₀₁

Effective

_Monitoring

and Job Status

₄₀₂

Permissions

₄₀₄

EM

Jobs Service Charts and Metrics

₄₀₅

EM Jobs Service Charts ₄₀₆

Performance Metrics ₄₀₆

Usage

Metrics ₄₀₇

Migrating

Scripts

to the

EM

Job

_System

₄₀₈

Managing

EM12c Jobs

₄₀₉

Viewing

Job Results ₄₀₉

Editing

Jobs from the

_Activity

View ₄₁₀

Stopping

a

_Running

Job ₄₁₀

Suspending

Jobs ₄₁₀

CONTENTS

Copying

to the

_Library

411

Deleting

Jobs 411

Managing

the

_Manager

411

Troubleshooting

the EM12c Job

_System

411

Performing

the Installation 412

Using

the EMDIAG with EM12c 413

Blackouts and

EM12c

Job

_Impact

419

Controlling Multiple Management Agents Through

EM Jobs

421

Summary

422

Chapter

12: Incident

_Management

423

Incident

_{Manager Terminology}

423

Events andIncidents 423

Problems 425

Incident RuleSets 426

Incident

_Manager

User Interface

428

Creating

Incident

Rules 428

Looking

at the Details ofan Incident 436

Creating

aCustomView 439

Prioritization of Rules and Notifications

441

Backward

_{Compatibility}

441

Incident

_Manager

Guidelines

442

Managing

Events and Incidents 442

Rule Set Recommendations 443

Summary

444

Chapter

13:

_{High Availability,}

_Backup,

and

_Recovery

445

High

Availability

445

Oracle

_{Management Agent}

447

Management Repository

447

Management

Service 450

Software

_Library

487

CONTENTS

Backup

488

Repository Backup

488

Oracle

_Management

_{Service Backup}

491

Management Agent Backup

492

Recovery

492

Repository Recovery

492 Oracle

_Management

Service

_Recovery

494

Management

Agent

Recovery

495

Switchover andFailover 496

Summary

502

Index

503