Oracle Enterprise Manager Administrator's Guide -- Contents

What's New in this Release?

Enterprise Manager Framework

Database Management

Enterprise Manager Console

Components

Navigator

Detail Pane

Console Menus

Context-Sensitive Menus

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

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

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

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

Group View Pane

Managing Groups

Automatic Group Refresh

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

Job Process

Job Tasks

Writing SQL*Plus Scripts

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

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

What's New in Events

Event System Overview

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, Modifying, and Registering an Event

Event Detail View

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

Dynamic Modification of Registered Events

General Behavior

Event Progress Page

Administrator Event Notification

Oracle Event Tests

Numeric Pager Job/Event Ids

Event System Features and Requirements

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

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

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

Overview of Enterprise Security Manager

Introduction to Directory Servers

Entailing and Configuring Your Enterprise Security Environment

Task1: Configure an Oracle Internet Directory

Task2: Install Oracle Enterprise Manager

Task3: Configure Oracle Enterprise Manager for Enterprise User Security

Task3: Start Oracle Enterprise Security Manager

Task4: Log On To the Directory

Administering Users

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

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:

Common Features of DBA Management Functionality

Tree Views

General Information about Databases

Comprehensive Overview Pages

Property Sheets

Multi-Column Lists

Database Version Awareness

Database Reports

Logging of Database Changes

DB Search Capabilities

DBA Management Functionality and Wizards

Oracle9i Backup and Recovery Documentation Roadmap

Accessing the Backup Management Wizards and Property Sheets

Backup Wizard

Predefined Backup Strategy

Customize Backup Strategy

Recovery Wizard

Create Backup Configuration

Backup Set

Image Copy

Catalog Maintenance Wizard

Backup Configuration Library

Configuring a Remote Database for Backup or SYSDBA Administration

Server Side (Windows NT)

Server Side (UNIX)

Recovery Catalog Setup and Registration

9i Procedure

Pre-8i and 8i Procedures

Create a Tablespace

Create a User

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

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

Registering the Recovery Catalog

Dropping the Recovery Catalog

Upgrading the Recovery Catalog

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

Starting OEMUTIL

Using OEMUTIL

Performing a single command:

Performing Commands in Succession:

OEMUTIL Commands

OEMUTIL Issues

Administrator Views

Service Views

Group Views

Operational System Metrics

Job Definition Views

Event Definition Views

Capacity Planner and Data Gatherer Collections

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Part I Oracle Enterprise Manager Console

1 Console

2 The Standalone Console

3 Navigator

4 Working with Groups

5 Jobs

6 Events

7 Enterprise Manager Event Handler

8 Enterprise Manager Reporting

9 Enterprise Security Management

Part II Database Administration Tools

10 Database Administration

11 Managing Backup and Recovery

A Keyboard Navigation

B Firewalls and Virtual Private Networks

C OEMUTIL Utility

D Repository Views

Index