Contents

Title and Copyright Information

Send Us Your Comments

Preface

Part I Oracle Enterprise Manager Framework

1 Console

Console Framework

Components

Navigator

Group

Jobs

Events

Console Menus

Context-Sensitive Menus

File Menu

View Menu

System Menu

Tools Menu

Database Applications

Service Management

Help Menu

Managing Enterprise Manager Administrators

Managing Administrators

Creating or Editing an Administrator Account

Reassigning Object Ownership

Administrator Preferences

General

Notification

Paging Information

Email Parameters

Schedule

Permissions

Preferred Credentials

Setting Administrator Credentials

Saving Logon Information as a Preferred Credential

Saving the Contents of a List

2 Navigator

Navigator Pane

Populating the Navigator Tree

Expanding Objects in the Navigator

Viewing Specific Tree Objects

Launching Tools

Groups

Navigator Menu

Discovering Services

Adding a Service

Refreshing a Service

Removing a Service

Ping Agent

Manipulating Objects in the Navigator

Administering Objects

Copying Navigator Objects

Paging/Email Blackout

Specifying Total Paging/Email Blackout

Defining a Paging/Email Blackout

Making a Copy of an Existing Blackout Schedule

Turning Blackout Schedules On and Off

Deleting Paging/Email Blackout Periods

Viewing Blackout Periods

3 Groups

Group Pane

Group Menu

Managing Groups

Creating a Group

Group General Page

Group Permissions Page

Manipulating Group Views

Monitoring Status

Expanding Objects

Groups

Nodes

Databases and Other Discovered Services

Launching Tools from a Group

Adding Objects to a Group

Deleting Objects in a Group

Modifying a Group

Removing Groups

Example: Creating a Group

4 Jobs

Job Process

Job Tasks

Writing SQL*Plus Scripts

Job Credentials

Submitting Jobs

Cancelling Jobs

Job Pane

Active Page

Context-sensitive Menu options

History Page

Job Menu

Job Library

Creating, Modifying, or Viewing a Job

Creating a New Job

Modifying a Saved Job

Viewing Job Details

General Page

Job Task Page

Job Parameters Page

Job Schedule Page

Job Permissions Page

Job Progress Page

Output Dialog Box

Example: Creating a Job

Oracle Job Tasks

Oracle Database Tasks

Enterprise Manager Wizard Database Tasks

Operating System or Host Tasks

Tcl Script Examples

Listener Tasks

5 Events

Event System Overview

Using Events

Creating Events

Registering Events

Event Occurrences

Event Notifications

Notifying Administrators

Interpreting Events

Correcting Problems

Event Categories and Types

Fault Management Event Tests

Space Management Event Tests

Resource Management Event Tests

Performance Management Event Tests

Unsolicited Event Tests

Registering Interest in an Unsolicited Event

Setting the Parameters Property Sheet for Unsolicited Events

Raising an Unsolicited Event Test

Raising Unsolicited Events Via Enterprise Manager Jobs

Unsolicited Event Caveats

Event Pane

Alerts Page

Viewing Alerts

History Page

Registered Page

Event Menu

Context-Sensitive Menus

Event Library Dialog

Editing an Event

Oracle Event Tests

Event Viewer

General

Log

Notification Details

Creating, Modifying, and Registering an Event

Event General Page

Event Tests Page

Event Parameters Page

Parameters

Event Permissions Page

Event Progress Page

Example: Creating and Registering an Event

Administrator Event Notification

Oracle Event Tests

Database Fault Management Event Tests

Node Fault Management Events

Listener Fault Management Events

Data Gatherer Fault Management Events

Numeric Pager Job/Event Ids

General Event System Troubleshooting Procedures

Obtaining Enterprise Manager Repository Status

Removing Old Job and Events

6 Management Server and Intelligent Agent

Oracle Intelligent Agent

Characteristics

Event and Job Support

Network Encryption

SNMP Support

Management Server

Message Queues

Failed Queue

Notification Queue

Connection Cache

Part II The Database Administration Tools

7 DBA Management Pack

DBA Studio

Common Features of DBA Management Pack Functionality

Tree Views and Property Sheets

Multi-Column Lists

Database Version Awareness

Show SQL

Show Dependencies

Right-Mouse Commands

Advanced Mode

DBA Management Pack Functionality and Wizards

Instance Management

Database Operations

Stored Configurations

Sessions

Resource Consumer Groups

Resource Plans

Schema Management

Tree List by Schema

Editing an Object

Creating Objects

Security Management

User Operations

Role Operations

Profile Operations

Storage Management

Controlfile Operations

Tablespace Operations

Datafile Operations

Rollback Segment Operations

Redo Log Group Operations

Archive Log Operations

SQL*Plus Worksheet

Wizards

Backup Management Tools

Data Management Tools

8 Managing Backup and Recovery

Accessing the Backup Management Wizards and Property Sheets

Backup Wizard

Predefined Backup Strategy

Customize Backup Strategy

Recovery Wizard

Create Backup Configuration

Catalog Maintenance Wizard

Backup Configuration Library

Configuring a Remote Database for Backup or SYSDBA Administration

Server Side (NT)

Server Side (UNIX)

Recovery Catalog Setup and Registration for Oracle8i

Create a Tablespace

Create a User

Run the catrman Script (for pre-8i only)

Create the Recovery Catalog (for 8i and later) on the Target Machine

Registering the Recovery Catalog

Dropping the Recovery Catalog

Upgrading the Recovery Catalog

A Enterprise Manager Event Handler

How the Event Handler Works

How to Set Up the Event Handler

Defining Event Filters

Filter Syntax

The Event Logger Templates

The Command Executor Templates

Starting up and Running the Event Handler

Starting the Event Handler

Stopping the Event Handler

Troubleshooting Tips

Tracing

Sample Filters and Templates:

Filters:

Templates

Known Issues

Differences between Solaris and Windows NT

Index