Oracle Enterprise Manager

Introducing Enterprise Manager

Enterprise Manager's Components

Console

Map

Administrator Toolbar

Database Administration Tools

Server Manager Line Mode

Online Help

Value Added Products

Console Menus

Context-Sensitive Menus

Toolbars and Launch Palettes

Toolbars

Launch Palettes

Oracle Administrator Toolbar

Application Bar/Float Bar

Help

Exit

ToolBar Customize: General Page

ToolBar Customize: Applications Page

ToolBar Customize: Database Page

Getting Started

Launching Enterprise Manager

Connecting to a Repository

Privileged Operations

Repository Manager Wizard

Creating, Validating, or Dropping a Repository

Saving a List of Discovered Nodes

Logging into a Repository

Launching Tools

Administration of a Remote Database

Connecting to an Instance

Multiple Connections

Console User Preferences

Setting User Preferences

Navigator Window

Expanding Objects in the Navigator

Populating the Navigator Tree

Viewing Specific Tree Objects

Launching Tools

User-defined Groups

Creating Maps

Navigator Menu

Navigator Context-Sensitive Menus

Discovering Services

Discover New Services Wizard

Refresh Services Wizard

Manually Define Services Wizard

Status Option

Update Network Configuration Option

Destination Validation Dialog

Manipulating Objects in the Navigator

Expanding and Collapsing Objects

Administering Objects

Copying Tree Objects

Example: Using the Navigator

Filtering Folders

Keystroke Shortcuts

Map Window

Manipulating Map Views

Launching Tools from a Map

Map Menu

Creating, Modifying, and Removing Maps

Creating a Map

Adding Objects in a Map

Deleting Objects in a Map

Modifying a Map

Removing a Map

Example: Creating a Map

Creating, Modifying, and Removing Groups

Creating a Group in the Current Map or Group

Creating a Group in the Navigator Tree

Adding Objects in a Group

Deleting Objects in a Group

Modifying a Group

Removing Groups

Example: Creating a Group

Job Scheduling Process

Job Window

Job Menu

Creating, Modifying, or Viewing a Job

Creating a New Job

Modifying a Saved Job

Example: Creating a Job

Oracle Job Tasks

Oracle Database Tasks

Operating System or Host Tasks

Tcl Script Examples

Listener Tasks

Event Management Process

Determining Administrators

Event Categories and Types

Fault Management Events

Space Management Events

Resource Management Events

Performance Management Events

Event Window

Outstanding Events Page

Acknowledging Events

Event History Page

Viewing Acknowledgments

Saving Event History

Registrations Page

Modify Registrations Property Sheet

Event Set Library Page

Event Set Property Sheet

Oracle Event Sets

Event Menu

Context-Sensitive Menus

Creating or Modifying an Event Set

Event Set Management General Page

Event Set Management Events Page

Event Set Management Parameters Page

Choose Fixit Job

Frequency

Parameters

Example: Creating an Event Set

Creating, Modifying, or Viewing an Event Registration

Registering an Event Set

Modify or Viewing An Event Set

Registrations General Page

Registrations Notification Page

Registrations Status Page

Example: Registering an Event Set

Acknowledging an Event

Acknowledge Event General Page

Acknowledge Event Notification Page

Managing Administrators

Adding New Administrators

Modifying Administrators

Deleting Administrators

Administrator General Page

Paging Information:

EMailing Information:

Administrator Systems Page

Administrator Availability Page

Configuring Mail Services

MAPI Setup

Configuring Paging Services

Adding New Paging Services

Modifying Paging Services

Deleting Paging Services

Paging Services Configuration Dialog

Oracle UpDown Events

Database Fault Management Events

Node Fault Management Events

Listener Fault Management Events

Numeric Pager Event Ids

Agents

Event and Job Support

Network Encryption

SNMP Support

Communication Daemon

Daemon Manager

Agent Pending Operations

Application Pending Notifications

Monitored Nodes

Daemon Configuration Parameters

View and Updating Parameters

Daemon Manager Menu

Introduction

Application Objects

Types of Objects

Manipulating Tree List Objects

Backup Manager

Data Manager

Instance Manager

Schema Manager

Security Manager

Software Manager

Storage Manager

SQL Worksheet

Application Menus

Context-Sensitive Menus

Multi-Column Lists

Dialog Boxes

Property Sheets

Spreadsheets

Property Sheet Buttons

Starting an Application

Starting Storage Manager

Storage Menus

Tablespace Menu

Datafile Menu

Rollback Menu

Tablespaces Folder

Tablespaces Multi-Column List

Creating A Tablespace

Showing Tablespace Dependencies

Editing a Tablespace

Dropping a Tablespace

Adding a Datafile to a Tablespace

Adding a Rollback Segment to a Tablespace

Changing a Tablespace to Online or Offline Status

Making a Tablespace Read-Only

Making a Tablespace Writeable

Datafiles Folder

Datafiles Multi-Column List

Creating a Datafile

Creating a Datafile Like an Existing Datafile

Editing an Existing Datafile

Placing a Datafile Online

Taking a Datafile Offline

Rollback Segments Folder

Rollback Multi-Column List

Creating a Rollback Segment

Altering a Rollback Segment

Dropping a Rollback Segment

Shrinking a Rollback Segment

Changing a Rollback Segment to Online or Offline Status

Starting Security Manager

Security Manager Menus

User Menu

Role Menu

Profile Menu

Security Manager Objects and Folders

Users Folder

Users Multi-Column List

Adding Privileges or Roles to Users

Removing Privileges or Roles from a User

Privileges Multi-Column Lists

Roles Granted

System Privileges Granted

Object Privileges Granted

Roles Folder

Roles Multi-Column List

Adding Privileges or Roles to Roles

Removing Privileges or Roles from a Role

Profiles Folder

Profile Multi-Column Lists

Creating a Profile

Create Like Profile

Altering a Profile

Showing Profile Dependents and Dependencies

Removing a Profile

Assigning a Profile to Users

Starting Instance Manager

Instance Manager Menus

Database Object

Starting Up a Database

Shutting Down a Database

Mounting or Opening a Database

Initialization Parameters Folder

Initialization Parameters Property Sheet

Editing Initialization Parameters

Resetting Edits

Applying Edits

Stored Configurations

Stored Configuration Folder

Creating a Stored Configuration

Stored Configuration Property Sheet

Editing a Stored Configuration

Deleting Parameters from a Stored Configuration

Adding a Parameter to a Stored Configuration

Creating a File from a Stored Configuration

Deleting a Stored Configuration

Sessions Folder

Sessions Multi-column List

Disconnecting a User's Session

Restricting or Allowing Sessions

In-Doubt Transactions Folder

In-Doubt Transactions Multi-column List

In-Doubt Transactions Property Sheet

Forcing a Commit or Rollback

Starting Schema Manager

Schema Menus

Schema Folders

Schema Property Sheets

Explicit

Auto Calculation

Array Types Folder

Array Types Multi-column List

Creating an Array Type

Create Like Array Type

Editing an Array Type

Clusters Folder

Clusters Multi-column List

Creating a Cluster

Column Details Dialog Box

Create Like Cluster

Editing a Cluster

Database Links Folder

Database Links Multi-column List

Creating a Database Link

Create Like Database Link

Viewing a Database Link

Functions Folder

Functions Multi-column List

Creating a Function

Create Like Function

Altering a Function

Indexes Folder

Indexes Multi-column List

Creating an Index

Create Like Index

Altering an Index

Object Types Folder

Object Types Multi-column list

Creating an Object Type

Adding Attributes to Object Types

Editing or Removing Object Attributes

Adding Methods to Object Types

Editing or Removing Object Methods

Package Bodies Folder

Package Bodies Multi-column List

Creating a Package Body

Create Like Package Body

Editing a Package Body

Packages Folder

Packages Multi-column List

Creating a Package

Create Like Package

Editing a Package

Procedures Folder

Procedures Multi-column List

Creating a Procedure

Procedures Property Sheet: General Page

Create Like Procedure

Altering a Procedure

Queue Tables

Queues Multi-column List

Creating a Queue Table

Create Like Queue Table

Altering a Queue Table

Creating a Queue

Create Like Queue

Altering a Queue

Refresh Groups Folder

Refresh Groups Multi-column List

Creating a Refresh Group

Create Like Refresh Group

Altering a Refresh Group

Sequences Folder

Sequences Multi-column List

Creating a Sequence

Create Like Sequence

Altering a Sequence

Snapshot Logs Folder

Snapshot Logs Multi-column List

Creating a Snapshot Log

Create Like Snapshot Log

Altering a Snapshot Log

Snapshots Folder

Snapshots Multi-column List

Creating a Snapshot

Create Like Snapshot

Editing a Snapshot

Synonyms Folder

Synonyms Multi-column List

Creating a Synonym

Create Like Synonym

Viewing a Synonym

Table Types Folder

Table Types Multi-column List

Creating a Table Type

Create Like Table Type

Editing a Table Type

Tables Folder

Tables Multi-column List

Creating a Table

Dropping a Constraint on a Table

Removing a Constraint Definition (Create Mode Only)

Create Like Table

Altering a Table

Triggers Folder

Triggers Multi-column List

Creating a Trigger

Create Like Trigger

Altering a Trigger

Views Folder

Views Multi-column List

Creating a View

Create Like View

Altering a View

Starting Backup Manager

Backup Manager: Oracle8 Recovery Manager Subsystem

Recovery Catalog

Registering a Database with the Recovery Catalog

Oracle8 Recovery Manager Subsystem User Interface

Oracle8 Recovery Manager Menu Options

Tree List Objects and Containers

Tablespace Containers, Multi-column Lists and Property Sheets

Multi-column List for the Tablespaces Container

Datafiles Container, Multi-column Lists and Property Sheets

Backups Page

Redo Log Groups Container, Multi-column Lists, and Property Sheets

Archived Logs Container, Property Sheets, and Multi-column lists

Channels Container

Jobs Object

Jobs Property Sheets

Oracle8 Recovery Manager Wizards

Backup Wizard

Restore Wizard

Report Wizard

Manual Backup Operations

Managing Restore and Recover Operations

Maintaining the Recovery Catalog

Database Operations

Creating a Channel

Creating Stored Scripts

Backup Manager: Operating System Backup Subsystem

Operating System Backup User Interface

Backup Manager Menu Options

Controlfile Object and Property Sheet

Tablespace Container, Multi-column List, and Property Sheets

Redo Log Group Container, Multi-column List, and Property Sheet

Redo Log Members Multi-column List

Redo Log Member Property Sheet

Selected Backup Manager Tasks

Shutting Down the Database

Starting Up the Database

Backing Up Tablespaces of the Database

Performing Recovery

Backup Manager: Enterprise Backup Utility Subsystem

Creating an Enterprise Backup Utility Catalog

Configuring the PC for Enterprise Backup Utility

Overview of the SQL Worksheet

Starting a SQL Worksheet

Using the SQL Worksheet

File Menu

Edit Menu

Worksheet Menu

Executing Commands in the SQL Worksheet

Entering Commands in the Input Pane

Executing Commands in the Input Pane

Executing Server Manager DBA Commands

Connecting from a Worksheet

Performing Recovery from the SQL Worksheet

Using the Command History

Retrieving a Selection from the Command History

Retrieving a Command Using the Worksheet Menu

Saving Your Work

Running Scripts from the SQL Worksheet

Starting Data Manager

Data Manager Window

Data Manager Menus

Data Manager Icons

Exporting Data to a File

Importing Data from a File

Loading Data from an External File

Data Manager Tasks

Software Manager Introduction

The Software Manager Interface

Navigator Window

Creating a Host Folder

Viewing the Oracle Home Properties

Viewing the Product Properties

Viewing the Release Properties

Catalog Windows

Choosing the Catalog View

Setting Preferences

Toolbar

Drag and Drop

The Software Distribution Process

Specify Distribution Hosts

Create Releases

Creating a Release

Displaying the Properties of a Release

Removing a Release from the Releases Catalog Window

Create Software Packages

Creating a Software Package

Deleting a Software Package

Distribute and Install Software Packages

The Oracle Software Manager Network

Setting up a Software Distribution Network

Establishing Communication in the Network

Flow of Information

Software Manager Tasks

Determining the Job Name, Destination Type, and Job Destination

Choosing a Task

Setting Parameters

Install Package Task

Deinstall Product Task

Delete Package Task

Distribute Package Task

Saving and Submitting the Job

Custom Configurations

Response File Generator

Modifying a Response File

Creating Staging Areas with Oracle File Packager

Starting Server Manager in Line Mode

Using Server Manager in Line Mode

Entering Server Manager Commands

Entering SQL or PL/SQL Code

Running Scripts

DBA Commands

@ (at symbol)

ARCHIVE LOG

CONNECT

DESCRIBE

DISCONNECT

EXECUTE

EXIT

PRINT

RECOVER

REMARK

SET

SHOW

SHUTDOWN

SPOOL

STARTUP

VARIABLE

Obsolete Functionality

Operational Differences

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Part I Oracle Enterprise Manager and Console

1 Overview of Oracle Enterprise Manager

2 Navigator

3 Map

4 Job Scheduling

5 Event Management

6 Agents and Communication Daemon

Part II The Database Administration Tools

7 Overview of the Database Tools

8 Managing Database Storage

9 Managing Database Security

10 Managing Instances and Sessions

11 Managing Schema Objects

12 Managing Backup and Recovery

13 Using the SQL Worksheet

14 Managing and Moving Data

15 Managing Software Distribution

Part III Reference

A Using Server Manager in Line Mode

B DBA Command Reference

C Compatibility with SQL*DBA