Oracle Enterprise Manager Administrator's Guide

• Oracle Enterprise Manager^(tm) Administrator's Guide

• Preface
  • Purpose of this Guide
  • Audience
  • How the Oracle Enterprise Manager Administrator's Guide Is Organized
  • How to Use This Guide
  • Conventions Used in This Guide
  • Documentation Set
  • Related Publications

• Overview of Enterprise Manager
  • Introducing Enterprise Manager
  • Enterprise Manager's Components
  • Console Menus
  • Toolbars and Launch Palettes
  • Using Enterprise Manager
  • Connecting to an Instance
  • Console User Preferences

• Navigator
  • Navigator Window
  • Manipulating Objects in the Navigator
  • Navigator Menu
  • Navigator Context-Sensitive Menus
  • Filtering Folders

• Map
  • Map Window
  • Map Menu
  • Creating, Modifying, and Removing Maps
  • Creating, Modifying, and Removing Groups

• Job Scheduling
  • Job Scheduling Process
  • Job Window
  • Job Menu
  • Creating, Modifying, or Viewing a Job

• Event Management
  • Event Management Process
  • Predefined Events
  • Event Window
  • Event Menu
  • Creating or Modifying an Event Set
  • Registering, Modifying, or Viewing an Event Set
  • Acknowledging an Event
  • Managing Administrators
  • Configuring Mail Services
  • Configuring Paging Services
  • Configuring the Modem

• Agents and Communication Daemon
  • Agents
  • Communication Daemon
  • Daemon Manager
  • Configuration Files

• Overview of the Database Tools
  • Introduction
  • Application Objects
  • Application Menus
  • Multi-Column Lists
  • Dialog Boxes
  • Property Sheets
  • Starting an Application

• Managing Database Storage
  • Starting Storage Manager
  • Tablespaces Container
  • Tablespaces Multi-Column List
  • Tablespaces Menu Options
  • Datafiles Container
  • Datafiles Multi-Column List
  • Datafiles Menu Options
  • The Rollback Container
  • Rollback Multi-Column List
  • Rollback Menu Options

• Controlling Database Security
  • Starting Security Manager
  • Users Containers
  • Users Multi-Column List
  • Users Menu Options
  • Privileges Multi-Column Lists
  • Role Containers
  • Role Multi-Column Lists
  • Role Menu Options
  • Profile Containers
  • Profile Multi-Column Lists
  • Profile Menu Options

• Managing Instances and Sessions
  • Starting Instance Manager
  • Instance Menus and Options
  • Instance Containers
  • Database
  • Initialization Parameters
  • Sessions
  • In-Doubt Transactions

• Managing Schema Objects
  • Starting the Schema Manager
  • Schema Menus
  • Schemas and Schema Objects Container
  • Clusters Container
  • Database Links Container
  • Functions Container
  • The Indexes Container
  • Package Bodies Container
  • Packages Container
  • Procedures Container
  • Refresh Groups Container
  • Sequences Container
  • Snapshot Logs Container
  • Snapshots Container
  • Synonyms Container
  • Tables Container
  • Triggers Container
  • Views Container

• Managing Backups and Archiving
  • Starting the Backup Manager
  • Tablespace Containers and Multi-column Lists
  • Redo Log Group Containers, Multi-column Lists and Property Sheets
  • Backup Manager Menus
  • Selected Backup Manager Tasks

• Using the SQL Worksheet
  • Overview of the SQL Worksheet
  • Executing Commands in the SQL Worksheet
  • Using the Command History
  • Saving Your Work
  • Running Scripts from the SQL Worksheet

• Managing and Moving Data
  • Starting the Data Manager
  • Exporting Data to a File
  • Importing Data from a File
  • Loading Data from an External File
  • Data Manager Tasks

• Managing Software Distribution
  • What is Software Manager?
  • Software Distribution
  • The Distribution Network
  • Software Manager Interface
  • Software Manager Tasks
  • Using Software Manager Online Help

• Using Server Manager in Line Mode
  • Starting Server Manager in Line Mode
  • Using Server Manager in Line Mode

• DBA Command Reference
  • DBA Commands
  • @ (at symbol)
  • ARCHIVE LOG
  • CONNECT
  • DESCRIBE
  • DISCONNECT
  • EXECUTE
  • EXIT
  • PRINT
  • RECOVER
  • REMARK
  • SET
  • SHOW
  • SHUTDOWN
  • SPOOL
  • STARTUP
  • VARIABLE

• Compatibility with SQL*DBA
  • Functional Differences
  • Cosmetic Differences
  • Unsupported Options
  • Obsolete Functionality
  • Operational Differences

• Starting Enterprise Manager
  • From Windows File Manager
  • From Windows Program Manager
  • From the Windows MS-DOS Prompt

• Predefined Job Tasks
  • Oracle Database Tasks
  • Operating System or Host Tasks
  • SQL*Net Listener Tasks

• Predefined Events
  • Event Categories
  • Event Information
  • Event Return Values and Output
  • Corrective Actions
  • Database Events
  • Node Events
  • Listener Events