Oracle Enterprise Manager Administrator's Guide Release 1.4.0 A53702_01

Library Product Index

Contents

Title and Copyright Information

Preface

Part I Oracle Enterprise Manager and Console

1 Overview of Oracle Enterprise Manager

Introducing Enterprise Manager

Enterprise Manager's Components

Console

Navigator

Map

Job Scheduling

Event Management

Repository

Communication Daemon

Discovery Cache

Intelligent Agents

Administrator Toolbar

Database Administration Tools

Server Manager Line Mode

Online Help

Value Added Products

Console Menus

Context-Sensitive Menus

File Menu

View Menu

Tools Menu

Applications

Performance Pack

Daemon Manager

Help Menu

Toolbars and Launch Palettes

Toolbars

Launch Palettes

Oracle Administrator Toolbar

Toolbar Menu

Customize

Databases

Database Status

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

Adding Services to the Navigator

Launching Tools

Privileged Operations

Administration of a Remote Database

Connecting to an Instance

Multiple Connections

Console User Preferences

Setting User Preferences

2 Navigator

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

Update Network Configuration Option

Destination Validation Dialog

Manipulating Objects in the Navigator

Expanding and Collapsing Objects

Administering Objects

Copying Tree Objects

Filtering Folders

Keystroke Shortcuts

3 Map

Map Window

Manipulating Map Views

User-Defined Groups

Status Monitors

Expanding Objects

Groups

Nodes

Databases

Launching Tools from a Map

Map Menu

Creating, Modifying, and Removing Maps

Create Map

Adding or Deleting Objects in a Map

Modify Map

Remove Map

Creating, Modifying, and Removing Groups

Creating a Group

Creating a Group with the Navigator

Adding or Deleting Objects in a Group

Modify Group

Remove Groups

4 Job Scheduling

Job Scheduling Process

Job Tasks

Job Credentials

Submitting Jobs

Job Window

Active Jobs

Job History

Saving Job History

Job Library

Job Menu

Creating, Modifying, or Viewing a Job

Creating a New Job

Modifying a Saved Job

Viewing Job Details

Job General Page

Job Task Page

Job Parameters Page

Job Schedule Page

Job Progress Page

Output Dialog Box

Oracle Job Tasks

Oracle Database Tasks

Operating System or Host Tasks

Listener Tasks

5 Event Management

Event Management Process

Determining Administrators

Using Event Sets

Creating Events

Registering Events

Event Occurrences

Event Notifications

Interpreting Events

Correcting Problems

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

Creating, Modifying, or Viewing an Event Registration

Registrations General Page

Registrations Notification Page

Registrations Status Page

Acknowledging an Event

Acknowledge Event General Page

Acknowledge Event Notification Page

Managing Administrators

Adding Administrators

Modifying Administrators

Deleting Administrators

Administrator General Page

Paging Information:

EMailing Information:

Administrator Systems Page

Administrator Availability Page

Configuring Mail Services

MAPI Setup

SMTP Setup

Configuring Paging Services

Adding Paging Services

Modifying Paging Services

Deleting Paging Services

Communication Settings

Configuring the Modem

Modem Settings

Oracle Events

Database Fault Management Events

Database Space Management Events

Database Resource Management Events

Database Performance Management Events

Node Fault Management Events

Node Space Management Events

Node Performance Management Events

Listener Fault Management Events

6 Agents and Communication Daemon

Agents

Characteristics

Event and Job Support

Network Encryption

SNMP Support

Installing the Agent

Communication Daemon

Message Queues

Failed Queue

Notification Queue

Connection Cache

Daemon Manager

Agent Pending Operations

Application Pending Notifications

Monitored Nodes

Daemon Configuration Parameters

View and Updating Parameters

Daemon Manager Menu

Part II The Database Administration Tools

7 Overview of the Database Tools

Introduction

Application Objects

Types of Objects

Manipulating Navigator Objects

Instance Manager

Schema Manager

Security Manager

Storage Manager

SQL Worksheet

Backup Manager

Data Manager

Application Menus

File Menu

View Menu

Log Menu

Help Menu

Additional Menus

Context-Sensitive Menus

Multi-Column Lists

Dialog Boxes

Property Sheets

Spreadsheets

Property Sheet Buttons

Starting an Application

8 Managing Database Storage

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

9 Managing Database Security

Starting Security Manager

Security Manager Menus

User Menu

Role Menu

Profile Menu

Security Manager Objects and Folders

Users Folder

Users Multi-Column List

Creating a User

Create Like User

Altering a User

Removing a User

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

Creating a Role

Create Like Role

Modifying a Role

Removing a Role

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

10 Managing Instances and Sessions

Starting Instance Manager

Instance Manager Menus

Database Menu

Sessions Menu

Transactions Menu

Configuration Menu

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

11 Managing Schema Objects

Starting Schema Manager

Schema Menus

Schema Objects Folder

Schema Property Sheets

Schema Object Property Sheet: Storage Page

Explicit

Auto Calculation

Schema Object Property Sheet: Options Page

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

Function Property Sheet: General Page

Create Like Function

Altering a Function

Indexes Folder

Indexes Multi-Column List

Creating an Index

Create Like Index

Altering an Index

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

Queues Folder

Queues Multi-column List

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

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

12 Managing Backup and Recovery

Starting Backup Manager

Oracle8 Recovery Manager

Oracle8 Recovery Manger Setup and Configuration

Setting Up the Recovery Catalog

Configuring a Database for Remote SYSDBA Access

Registering the Recovery Catalog with Oracle8 Recovery Manager (GUI)

Oracle8 Recovery Manager User Interface

Oracle8 Recovery Manager Menu Options

Recover Menu

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

Datafiles Property Sheets

General Page

Backups Page

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

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

Archived Logs Property Sheets

Channels Container

Channels Multi-column list

Jobs Object

Jobs Property Sheets

Oracle8 Recovery Manager: Backup and Restore Wizards

Backup Wizard

Restore Wizard

Manual Backup Operations

Managing Restore and Recover Operations

Maintaining the Recovery Catalog

Database Operations

Creating a Channel

Operating System Backup

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

Enterprise Backup Utility: Installation and Configuration

Creating an Enterprise Backup Utility Catalog

Configuring the PC for Enterprise Backup Utility

13 Using the SQL Worksheet

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

14 Managing and Moving Data

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

15 Managing Software Distribution

The Oracle Software Manager Application

Navigator Window

Creating a Host Folder

Viewing the Oracle Home Properties

Viewing the Product 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

Determining the Job Name, Destination Type, and Job Destination

Choosing a Task

Setting Parameters

Saving and Submitting the Job

Custom Configurations

Response File Generator

Modifying a Response File

Response File Generator for UNIX

Creating Staging Areas with Oracle File Packager

The Oracle Enterprise Manager/Oracle Software Manager Network

Establishing Communication in the Network

Flow of Information

Part III Reference

A Using Server Manager in Line Mode

Starting Server Manager in Line Mode

Using Server Manager in Line Mode

Entering Server Manager Commands

Entering SQL or PL/SQL Code

Running Scripts

B DBA Command Reference

DBA Commands

@ (at symbol)

ARCHIVE LOG

CONNECT

DESCRIBE

DISCONNECT

EXECUTE

EXIT

PRINT

RECOVER

REMARK

SET

SHOW

SHUTDOWN

SPOOL

STARTUP

VARIABLE

C Compatibility with SQL*DBA

Obsolete Functionality

Operational Differences

Index

Next

Copyright © 1997 Oracle Corporation. All Rights Reserved.

Library Product Index