Contents

Title and Copyright Information

Send Us Your Comments

Preface

Part I Oracle Enterprise Manager Console

1 Console

Enterprise Manager Console

Components

Navigator

Detail Pane

Console Menus

Context-Sensitive Menus

File Menu

Object Menu

Configuration Menu

Tools Menu

Help Menu

Toolbars/Tool Drawers

Managing Enterprise Manager Administrators

Types of Enterprise Manager Administrators

Managing Administrator Accounts

Creating or Editing an Administrator Account

Granting Access to Targets

Reassigning Object Ownership

Changing Administrator Preferences

General

Notification

Filters

Email

Paging

Paging Status Codes for Numeric Pages

Email/Paging Message Body Definition

Schedule

Access

Preferred Credentials

Setting Administrator Credentials

Saving Logon Information as a Preferred Credential

Saving the Contents of a List

Configuring Enhanced Notifications (Paging/Email)

Management Regions

Defining a New Management Region

Adding a Management Server to a Region

Adding Discovered Nodes to a Management Region

Removing a Management Region

Managing HTTP Servers

Discovering HTTP Servers

Starting Up or Shutting Down a HTTP Server

Determining the Status of HTTP Servers

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

Target-level Blackouts

2 The Standalone Console

Choosing to Launch the Console Standalone

Starting the Standalone Console

Adding Databases to the Tree in the Standalone Console

Connecting to a Database in the Standalone Console

Connecting to the Database As a Different User

Viewing If You Are Connected As SYSDBA

Removing a Database from the Tree

Changing from Using the Console to the Standalone Console

Editing Local Preferred Credentials in the Standalone Console

Changing from Using the Standalone Console to the Console

3 Navigator

Navigator Pane

Populating the Navigator Tree

Expanding Objects in the Navigator

Launching Tools

Navigator Menu

Discovering Targets

Adding a Service

Refreshing a Target

Removing a Target

Pinging the Intelligent Agent

Determining Node Properties

Manipulating Objects in the Navigator

Administering Objects

Copying Navigator Objects

Removing a Node from the Navigator

Node Removal Failure

4 Groups

Group View Pane

Managing Groups

Automatic Group Refresh

Manual Refresh

Automatic Refresh

Creating a Group

Group General Page

Group Access Page

Manipulating Group Views

Monitoring Status

Expanding Objects

Groups

Databases and Other Discovered Targets

Launching Applications from a Group

Adding Objects to a Group

Deleting Objects from the Group

Modifying a Group

Removing Groups

Viewing Reports for Targets within a Group

5 Jobs

Job Process

Job Tasks

Writing SQL*Plus Scripts

Job Credentials

Submitting Jobs

Cancelling Jobs

Job Detail View

Active Job Page

Context-sensitive Menu options

History Page

Refreshing the History Page

Clearing the History Page

Displaying Job Output

Context Menu options

Job Menu

Job Library

Creating, Modifying, or Viewing a Job

Creating a New Job

General Page

Job Task Page

Job Parameters Page

Job Schedule Page

Job Access Page

Skipped Job Notification

Job Progress Page

Job Output Dialog Box

Modifying Active Jobs

Alternative Method of Modifying an Active Job

Viewing Job Details

Example: Creating a Job

Required Administrator Permissions

Oracle Job Tasks

Oracle Database Tasks

Enterprise Manager Wizard Database Tasks

Operating System or Node Tasks

Tcl Script Examples

Listener Tasks

HTTP Servers

Job Tasks Run through Wizards

6 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 Unsolicited Events

Raising Unsolicited Events through the Enterprise Manager Job System

Unsolicited Event Caveats

User-Defined Monitoring

User-Defined SQL Event Test

Support for PL/SQL Functions

User-Defined Event Tests

Creating Your Monitoring Script

Register the user-defined event in the Console

User-Defined Event Parameters

Output

Bundled User-Defined Event Sample

Creating and Registering an Event

Dynamic Modification of Registered Events

General Behavior

Event Detail View

Alerts Page

Viewing Alerts

History Page

Registered Page

Event Menu

Context-Sensitive Menus

Event Library Dialog

Editing an Event in the Event Library

Oracle Event Tests

Event Viewer

Event Viewer: General Page

Event Viewer: Log Page

Event Viewer: Notification Details Page

Responding to Event Occurrences

Event General Page

Event Tests Page

Event Parameters Page

Parameters

Event Schedule Page

Event Access Page

Event Fixit Jobs Page

Event Progress Page

Administrator Event Notification

Oracle Event Tests

Numeric Pager Job/Event Ids

Event System Features and Requirements

7 Event Handler

Event Handler Overview

How the Event Handler Works

Setting Up the Event Handler

Quickstart Method (Default)

Customizing the Event Handler Setup

Event Handler Configuration Parameters

Blackouts

Filters

Templates

Command to Execute

Optional: length of execution time

Summary of Event Handler Configuration Commands

Enabling the Event Handler

Disabling the Event Handler

Viewing Current Event Handler Configuration Settings

Creating a Configuration File from the Current Event Handler Configuration Registry Entries

Importing a Configuration File

Troubleshooting Tips

Sample Filters and Templates:

Filters:

Templates

Known Issues

Differences between UNIX and Windows NT

Running the Event Handler in a multi-Management Server Environment

Migrating from Prior Releases

8 Enterprise Manager Reporting

Enterprise Manager Reporting

Key Concepts

What is a Report Definition?

What is a Report Element?

Ways to Select Targets for Report Generation

Configuring Enterprise Manager Reporting

Enterprise Manager Reporting Website

Creating a Report from an Existing Report Definition

Editing a Report Definition

Generating a Report from Enterprise Manager Applications

Creating a User-defined Report Definition

The Report Property Sheet

Report General Page

Report Elements Page

Report Parameters Page

Report Publish Page

Navigating the Enterprise Manager Reporting Website

9 Enterprise Security Management

Overview of Enterprise Security Manager

Introduction to Directory Servers

Entailing and Configuring Your Enterprise Security Environment

Task 1: Configure an Oracle Internet Directory

Task 2: Install Oracle Enterprise Manager

Task 3: Configure Oracle Enterprise Manager for Enterprise User Security

Task 4: Start Oracle Enterprise Security Manager

Task 5: Log On To the Directory

Administering Users

Oracle Wallets

Specifying a new User Name

Specifying a Directory Base

Specifying a new User Password

Specifying an Initial Enterprise Role Assignment

Specifying an Oracle Wallet

Browsing Users in the Directory

Administering Oracle Contexts

Oracle Context Versions

Specifying Properties of an Oracle Context

Specifying User Search Bases

Specifying Oracle Context Administrators

Accessible Domains

Managing Database Security

Registering a Database with an Oracle Context

Administering Databases

Managing Database Administrators

Managing Database Schema Mappings

Administering Enterprise Domains

Specifying Database Membership of an Enterprise Domain

Managing Database Security Options for an Enterprise Domain

Managing Enterprise Domain Administrators

Managing Enterprise Domain Database Schema Mappings

Administering Enterprise Roles

Creating a new Enterprise Role:

Removing an Enterprise Role:

Specifying Database Global Role Membership of an Enterprise Role

Removing a Database Global Role from an Enterprise Role:

Adding a Global Role to an Enterprise Role:

Managing Enterprise Role Grantees

Removing a User from the List of Enterprise Role Grantees:

Adding a New User to the list of Enterprise Role Grantees:

Command Line Tool

Part II Database Administration Tools

10 Database Administration

Common Features of Database Management Features

Tree Views

General Information about Databases

Comprehensive Overview Pages

Property Sheets

Multi-Column Lists

Database Version Awareness

Database Reports

Logging of Database Changes

Showing Object DDL

Show SQL

Show Dependencies

Right-Mouse Commands

DB Search Capabilities

Database Management Features and Wizards

Instance Management

Configuration Operations

Stored Configurations

Sessions List

Sessions Folder

Long Running Operations

Locks

In-Doubt Transactions

Resource Consumer Groups

Resource Plans

Resource Plan Schedule

Schema Management

Tree List by Schema or Object

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

Distributed Management

Warehouse Management

OLAP Management

Summary Management

Workspace Management

XML Database

SQL*Plus Worksheet

SQL Scratchpad

Wizards

11 Managing Backup and Recovery

Introduction

Recovery Manager (RMAN)

About the RMAN Executable

About the Target Database

About Oracle Enterprise Manager

About the Recovery Catalog Database

About the Recovery Catalog Schema

About the Standby Database

About the RMAN Media Management Interface

About the Media Management Catalog

RMAN Backup

Backing Up a Database

Backing Up a Database Using a Predefined Strategy

Backing Up the Database with a Customized Strategy

Deleting Obsolete Backups and Copies

Selecting a Full or Incremental Backup

Choosing an Online or Offline Mode to Back Up Your Database

Backing Up Individual Files

Backing Up and Deleting Archived Logs

Backing Up Archived Logs

Deleting Archived Logs

Copying a Datafile

Overriding a Retention Policy in Backup for Special Cases

Overriding the Backup Policy

Overriding the Retention Policy

Viewing Current Policies

Restore and Recover

Recovering the Entire Database

Restoring the Entire Database

Recovering and/or Restoring Tablespaces or Datafiles

Restoring the Control File

Restoring Archive Log Files

Recovering Datablocks

Using a Corruption List for Data Block Recovery

Using Datafiles for Data Block Recovery

Using Tablespaces for Data Block Recovery

Maintenance Operations

Setting up Backup and Retention Policies in a Target Database

Configuring a Backup Policy

Configuring a Retention Policy

Performing Recovery Catalog Maintenance

Registering a Database

Resynchronizing the Catalog

Resetting the Database

Configuring the RMAN Environment

Creating a Backup Configuration

Specifying Disk Channel Device for Backup Set

Specifying Tape Channel Device for Backup Set

Setting Channel Limits

Specifying Channel Device for an Image Copy

Setting Up a Proxy Copy for a Tape Backup Set

Setting the Storage Parameters for the Current Backup Set

Setting Storage Parameters for Datafiles

Setting Storage Parameters for Archivelogs

Registering the Recovery Catalog

Setting Preferred Credentials for Running Backup Jobs

Registering Later Databases with the Recovery Catalog

Resynchronizing the Recovery Catalog with the Target Database

Setting Up the Recovery Catalog

9i Procedure

Pre-8i and 8i Procedures

Starting Up the Database

Starting the Database in Mount Mode

Starting the Database in Open Mode

Placing the Database in Mount

Setting the Database in ARCHIVELOG Mode

RMAN Job Script

Some Examples

Backing Up the Recovery Catalog

Recovery Without a Catalog

Skipping Tablespaces when Backing Up a Database

Backing Up Often-Used Tablespaces

Specifying the Device Type

Restarting a Backup

Spreading a Backup Across Multiple Disk Drives

Specifying the Size of Backup Sets

Performing a Non-Cumulative Incremental Backups

Performing Cumulative Incremental Backups

Determining How Channels Distribute a Backup Workload

Backing Up in NOARCHIVELOG Mode

Keeping a Long-Term Backup

Displaying Backups that are Exempt from the Retention Policy

Optimizing Database Backup

A Keyboard Navigation

B Firewalls and Virtual Private Networks

Firewall Communication for Enterprise Manager

Firewall Between the Console and Management Server

Firewall Between the Management Server and Agent(s) on Monitored Nodes

Firewalls and Network Address Translation (NAT)

Virtual Private Network Configuration for Enterprise Manager

VPN Connections Between the Enterprise Manager Client and Management Server

VPN Connections Between the Management Server and Intelligent Agents

Running the Console in Standalone Mode

Performance Manager, Capacity Planner, and Firewalls

C OEMUTIL Utility

Starting OEMUTIL

Using OEMUTIL

Performing a single command:

Performing Commands in Succession:

OEMUTIL Commands

D Repository Views

Administrator Views

Service Views

Group Views

Operational System Metrics

Job Definition Views

Event Definition Views

Capacity Planner and Data Gatherer Collections

Index