Oracle Enterprise Manager Administrator's Guide Go to Product Documentation Library
Library
Go to books for this product
Product


Title

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
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
Status Option
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
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
Tcl Script Examples
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 Tree List Objects
Backup Manager
Data Manager
Instance Manager
Schema Manager
Security Manager
Software Manager
Storage Manager
SQL Worksheet
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
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
Backup Manager: Oracle8 Recovery Manager Subsystem
Recovery Catalog
Recovery Catalog 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 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
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
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
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

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
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


Oracle Corporation
Copyright © 1997 Oracle Corporation
500 Oracle Parkway, Redwood City, CA 94065


Go to Product Documentation Library
Library
Go to books for this product
Product