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

Oracle Enterprise Manager Administrator's Guide
Purpose of this Guide
Audience
How the this Guide Is Organized
How to Use This Guide
Conventions Used in This Guide
Product Documentation
Related Publications
Your Comments Are Welcome
Oracle Enterprise Manager and the Console
Chapter 1 Overview of Oracle Enterprise Manager
Introducing Enterprise Manager
Enterprise Manager's Components
Console
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
Help Menu
Toolbars and Launch Palettes
Toolbars
Launch Palettes
Running Enterprise Manager
Privileged Operations
Administration of a Remote Database
Starting Enterprise Manager
Launching Tools
Connecting to an Instance
Multiple Connections
Console User Preferences
Setting User Preferences
Chapter 2 Navigator
Navigator Window
Tree Population
Viewing Specific Tree Objects
Launching Tools
User-defined Groups
Creating Maps
Navigator Menu
Navigator Context-Sensitive Menus
Manipulating Objects in the Navigator
Discovering Services
Expanding and Collapsing Objects
Administering Objects
Copying Tree Objects
Filtering Folders
Chapter 3 Map
Map Window
Manipulating Map Views
User-Defined Groups
Status Monitors
Expanding Objects
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
Adding or Deleting Objects in a Group
Modify Group
Remove Groups
Chapter 4 Job Scheduling
Job Scheduling Process
Job Tasks
Job Credentials
Submitting Jobs
Job Window
Active Jobs
Job History
Job Library
Job Menu
Context-Sensitive Menus
Creating, Modifying, or Viewing a Job
Creating a New Job
Modifying a Saved Job
Viewing Job Details
General Page
Task Page
Parameters Page
Schedule Page
Progress Page
Chapter 5 Event Management
Event Management Process
Determining Administrators
Using Event Sets
Interpreting Events
Notifying Administrators
Correcting Problems
Event Categories and Types
Fault Management Events
Space Management Events
Resource Management Events
Performance Management Events
Event Window
Outstanding Events Page
Event History Page
Registrations Page
Event Set Library Page
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
Registering, Modifying, or Viewing an Event Set
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
Administrator Systems Page
Administrator Availability Page
Configuring Mail Services
Configuring Paging Services
Adding Paging Services
Modifying Paging Services
Deleting Paging Services
Communication Settings
Configuring the Modem
Modem Settings
Chapter 6 Agents and Communication Daemon
Agents
Characteristics
Network Encryption
SNMP Support
Event and Job 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
Daemon Manager Menu
The Database Administration Tools
Chapter 7 Overview of the Database Tools
Introduction
Application 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
Context-Sensitive Menus
Multi-Column Lists
Dialog Boxes
Property Sheets
Spreadsheets
Property Sheet Buttons
Starting an Application
Chapter 8 Managing Database Storage
Starting Storage Manager
Storage Menus
Tablespace Menu
Datafile Menu
Rollback Menu
Tablespaces Folder
Tablespaces Multi-Column List
Creating A Tablespace
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
Creating a Tablespace Backup Script
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 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
Chapter 9 Controlling Database Security
Starting Security Manager
Security Manager Menus
Users Menu
Roles Menu
Profile Menu
Security Manager Icons
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 Folder
Roles Multi-Column Lists
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
Removing a Profile
Assigning a Profile to Users
Chapter 10 Managing Instances and Sessions
Starting Instance Manager
Instance Manager Menus
Database Menu
Sessions Menu
Transactions Menu
Configuration Menu
Database Folder
Database Property Sheet
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
Sessions Property Sheet
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
Chapter 11 Managing Schema Objects
Starting Schema Manager
Schema Menus
Schema Objects Folder
Schema Property Sheets
Storage
Options
Clusters Folder
Clusters Multi-Column List
Creating a Cluster
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
Create Like Procedure
Altering a Procedure
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
Chapter 12 Managing Backups and Archiving
Starting the Backup Manager
Tablespace Folders and Multi-column Lists
Tablespace Folder
Multi-column List for the Tablespaces Folder
Multi-column List for an Individual Tablespace
Redo Log Folders, Lists, and Property Sheets
Redo Log Group Folders
Multi-column List for the Redo Log Groups Folder
Multi-column List for the Redo Log Members Folder
Property Sheet for a Particular Redo Log Group
Property Sheet for a Particular Redo Log Member
Backup Manager Menus
Backup Menu Member
Logfile Menu
Selected Backup Manager Tasks
Shutting Down the Database
Starting Up the Database
Backing Up Tablespaces of the Database
Displaying Archive Log Information
Manually Archiving Redo Log Files
Adding a New Redo Log Group
Adding a New Member to an Existing Redo Log Group
Chapter 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
Chapter 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
Chapter 15 Managing Software Distribution
The Oracle Enterprise Manager/Oracle Software Manager Network
Establishing Communication in the Network
The Oracle Software Manager Console
Navigator Window
Catalog Windows
Toolbar
Drag and Drop
The Software Distribution Process
Specify Distribution Hosts
Create Releases
Create Software Packages
Use the Oracle Enterprise Manager Job System
Modify File for Custom Configurations
Terms used with OSM
Reference
Chapter 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
Chapter B DBA Command Reference
DBA Commands
@ (at symbol)
ARCHIVE LOG
CONNECT
DESCRIBE
DISCONNECT
EXECUTE
EXIT
PRINT
RECOVER
REMARK
SET
SHOW
SHUTDOWN
SPOOL
STARTUP
VARIABLE
Chapter C Compatibility with SQL*DBA
Functional Differences
Cosmetic Differences
Unsupported Options
Obsolete Functionality
Operational Differences

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

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