Oracle Enterprise Manager Administrator's Guide 
Release 1.6 
A63731-01
 
Library
 
Product
 
Contents
 

Prev 

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

A

ABORT mode, B-29
acknowledging events
Event menu, 5-12
Event window, 5-9, 5-23
Active Jobs page, 4-6
add a group to a map
Map menu, 3-6
adding privileges to a role, 9-22
adding privileges to a user, 9-15
adding roles to a user, 9-15
adding subroles to a role, 9-22
additional administration utilities, 1-9
additional services folders
Navigator tree, 2-2, 2-3
administration task
Navigator objects, 2-15
Administrator Toolbar, 1-7
application and float styles, 1-15
customize, 1-14
database list, 1-14
exiting, 1-15
menu options, 1-14
online help, 1-15
status of the default database, 1-15
administrators
setting up in Event system, 5-24
Advanced Mode
View menu, 1-12
Advanced mode, 7-17
Advanced Queuing, 11-40
agent
down, 5-4
intelligent, 6-2
out of sync with Console, 6-11
process, 6-2
UpDown Node event, 5-4
Alter Rollback Segment property sheet
about, 8-22
Storage page, 8-22
Application Pending Notifications
Daemon Manager, 6-6
apply (register) an event set, 5-19
applying edits, 10-13
ARCH background process
starting, B-5
ARCHIVE LOG command, B-6
about, B-3
ALL option, B-5
LIST option, B-4
NEXT option, B-5
START option, B-5
STOP option, B-5
Archived Logs Property Sheet
General Page, 12-19
Record Page, 12-19
archiving redo log files
about, B-3
archive location, B-4
device written to, B-6
re-archiving, B-5
stopping, B-5
Array Type
about, 11-10
create like, 11-12
editing, 11-12
Array Type property sheet, 11-11
Array Types, about, 11-10
audience for this guide, xxiv
Auto Extend page, 8-17
AUTORECOVERY option, B-21
Available Destinations list
Job system, 4-11

B

background processes
startup after abnormal termination, B-30
backing up a tablespace, 12-50
Backup Manager
menus, 12-38
starting, 12-2
Backup Manager, about, 7-5
Backup menu, 12-39
Backup Set Property Sheet
Channels Page, 12-27
Parameters Page, 12-27
Backup Set/Image Copy Property Sheet
Schedule Page, 12-28
Backup Tablespace Wizard
about, 12-50
Backup Wizard, 12-24
BackupSet Property Sheet
General Page, 12-26
Basic mode, 7-17
Broadcast Message task, 4-22

C

Catalog, 15-9
Catalog window, 15-3, 15-9
Channels Property Sheet
General Page, 12-20, 12-35
Limits Page, 12-21, 12-36
channels, creating, 12-35
CHAR datatype
displaying in line mode, B-21
in line mode, B-26
Cluster Property Sheet
General Page, 11-14
Clusters
editing, 11-16
Clusters folder
about, 11-12
Clusters Multi-column List, 11-13
Clusters, creating, 11-13
Column Details, 11-15
command buttons
dialog box, 7-16
property sheet, 7-19
command history
about, 13-12
and Worksheet menu commands, 13-13
retrieving a command from, 13-13
Command History dialog box, 13-12
commands
@ command, B-2
ARCHIVE LOG command, B-3
CONNECT command, B-6
DESCRIBE command, B-9
DISCONNECT command, B-11
EXECUTE command, B-12
executing, 13-10
executing in SQL worksheet, 13-8
EXIT command, B-12
PRINT command, B-13
RECOVER command, B-14
REMARK command, B-17
SET command, B-18
SHOW command, B-25
SHUTDOWN command, B-29
SPOOL command, B-30
STARTUP command, B-31
VARIABLE command, B-34
commands (Server Manager)
@ command, in a SQL Worksheet, 13-15
@@ command, 13-15, B-3
programs, setting characteristics of, B-18
Comments
in scripts, B-17
commit
forcing, 10-21
common services
and agents, 1-6
Enterprise Manager, 1-6
communication
Enterprise Manager, 1-6
Communication Daemon, 6-4
Enterprise Manager, 1-6
communication daemon
parameters, 6-7
populating Navigator, 2-3
composite job, 4-3
configure
mail services, 5-14
modem, 5-14
paging services, 5-14, 5-28
CONNECT command
about, B-6
INTERNAL option, B-7
user SYS, B-8
Connect dialog box, 1-23
connect string
Enterprise Manager, 1-19
connecting
as SYSOPER or SYSDBA, 1-24
File menu item, 7-10, 13-5
Navigator menu item, 2-6
service name, 1-24
to a database, 1-23
to a database instance in the Navigator, 2-6
to a repository, 1-19
connecting to a database, B-6
connections
changing, in a SQL Worksheet, 13-10
multiple, 1-25
Console
customize layout, 1-11
Enterprise Manager, 1-3
File menu, 1-11
Help menu, 1-12
menus, 1-10
user preferences, 1-25
using menus, 1-10
context-sensitive menus
Navigator, 1-10, 2-7
using, 7-13
using in the Navigator, 1-10
Controlfile Object and Property Sheet, 12-43
copying tree objects
Navigator, 2-16
create
event set, 5-13
job, 4-8
map, 3-6
or modify a job, 4-9
or modify an event set, 5-14
specified object type in the Navigator, 2-5
Create Cluster property sheet, 11-13
Create Datafile
General Page, 8-16
Create Datafile property sheet
Auto Extend page, 8-17
Create Index property sheet
Storage page, 11-24
create like
profile, 9-28
role, 9-20
user, 9-14
Create Like Cluster
Clusters
create like, 11-16
Create package body property sheet
General page, 11-34
Create Procedure property sheet
General page, 11-39
Create Profile property sheet, 9-25
profile name, 9-25
Create Redo Log Group property sheet
about, 12-50
Create Redo Log Member property sheet
about, 12-51
create refresh group property sheet
General page, 11-50
Snapshot page, 11-51
Create Role property sheet
General page, 9-20
Create Rollback Segment property sheet, 8-20
about, 8-19
create sequence property sheet
General page, 11-53
Create Snapshot Log property sheet
Storage page, 11-56
Create Snapshot property sheet
Cluster page, 11-62
General page, 11-61
Storage page, 11-60
Create Synonym property sheet
General page, 11-65
Create Table property sheet
Column Details property sheet, 11-73
General page, 11-70
Storage page, 11-69, 11-73
Create Tablespace
Extents page, 8-10
General page, 8-8
Create Trigger property sheet
General page, 11-77
Timing page, 11-78
Create User property sheet, 9-10
about, 9-8
adding quotas, 9-13
Default Roles page, 9-13
General page, 9-9
Privileges page, 9-10
Roles/Privileges page, 9-10
Create View property sheet
General page, 11-81
Creating a Channel, 12-35
cursors
disconnect and closing cursors, B-11
opened at CONNECT, B-8
customize and manage network views
Map system, 3-6

D

Daemon Manager
configuration parameters, 6-7
menu, 6-11
Data Manager
context-sensitive menus, 14-4
Export wizard, 14-5
Import wizard, 14-6
Load wizard, 14-7
menus, 14-4
starting, 14-2
window, 14-3
Data Manager, about, 7-6
database
changing connections, 13-10
mounting, 10-10, B-32
opening, 10-10, B-32
recovering from SQL worksheet, 13-11
shutting down, 10-10
database administration applications
DBA, 1-12
Database Fault Management Events, 5-31
database files
recovering, B-14
Database folder
mounting a database, 10-10
opening a database, 10-10
shutting down a database, 10-10
database instance property sheet
accessing from a map, 3-5
Database Link
create like, 11-19
database link folder
creating a database link, 11-17
Database Link Property Sheet
General Page, 11-18
Database Links folder
about, 11-16
Database Links Multi-column List, 11-17
Database menu, 12-40
database name
at startup, B-31
Database Property Sheet
Information Page, 12-11, 12-42
Status Page, 12-10, 12-41
Database Resource Management Events, 5-32
Database Space Management Events, 5-32
database tools, 1-7
application folders, 7-3
folders, 7-3
quitting, 7-10
database tools and utilities, 1-7
about, 7-2
dialog boxes, 7-15
property sheets, 7-17
Databases folder
Navigator tree, 2-2
datafiles
adding, 8-13
altering, 8-18
creating, 8-16
creating like, 8-18
multi-column list, 8-15
renaming, 8-16
Datafiles folder
about, 8-15
altering a datafile, 8-18
create like datafile, 8-18
Datafiles Property Sheet
General Page, 12-15
DATE datatype
in line mode, B-22, B-26
DBA
database administration application, 1-7
DBA mode, B-32
DBA privilege, 1-20, B-32
DBA tools
menus, 7-10
Deinstall Product Task, 15-31
delete
group, 3-6
Delete option
Daemon Manager, 6-11
removing job or event operations, 6-11
Delete Package Task, 15-33
DESCRIBE command, B-9
destination
archive, B-6
overriding default, B-6
dialog box
about, 7-15
command buttons, 7-16
dialog boxes, 7-15
differences
between SQL*DBA and Server Manager, C-1
DISCONNECT command, B-11
disconnecting, B-11
Navigator menu item, 2-6
discovered nodes
saving a list, 1-21
discovering services
communication daemon, 1-4, 2-3
Navigator, 2-8
SQL*Net network, 2-3
discovery
problems, 2-13
discovery cache
Enterprise Manager, 1-6
providing network information, 1-6
Distribute Package Task, 15-34
distribution host
and the software distribution process, 15-14
definition, 15-14
drag and drop
Navigator, 2-16
Navigator objects, 2-2
drawers
opening, 7-20

E

Edit menu, 13-6
elapsed timing, B-24, B-28
email
configuring, 5-27
EMS
Event Management system, 5-1
Enterprise Manager
components, 1-2
connect string, 1-19
database administration, 1-7
installing, 1-19
introduction, 1-2
launch palettes, 1-13
Oracle releases supported by, 1-2
privileges needed to use, 1-20
quitting, 1-11
repository, 1-19
starting, 1-19
starting up, 1-19
toolbars, 1-13
event
destination requirements, 5-20
numeric pager event Ids, 5-33
set, 5-3
Event History page
Event window, 5-10
Event Management, 5-1
categories of events, 5-6
configuring paging services, 5-28
creating an event set, 5-14
defining administrators, 5-24
Enterprise Manager, 1-5
fault management, 5-6
introduction, 5-1
menu, 5-12
modifying a registered event set, 5-19
modifying an event set, 5-14
Oracle events, 5-31
parameter settings, 5-17
performance management, 5-7
process, 5-2
registering an event set, 5-19
resource management, 5-7
space management, 5-7
types of events, 5-6
viewing a registered event set, 5-19
viewing an event set, 5-11
window, 5-8
Event Set Library page
Event window, 5-11
predefined event sets, 5-11
Event Set Management property sheet
creating an event, 5-13
modifying a new event, 5-13
example
creating an event set, 5-17
group, 3-13
Job Scheduling, 4-15
Map, 3-9
Navigator, 2-17
registering an event, 5-22
EXECUTE command, B-12
EXIT command, B-12
exiting an application, 7-10
exiting Enterprise Manager, 1-11
expanding
container in Navigator, 2-15
map objects, 3-4
possible delays with a container, 2-15
Export
predefined task, 14-8
exporting
a full database to a file, 14-8
data to a file, 14-5
objects to a file, 14-8
owners to a file, 14-8
tables to a file, 14-8

F

Fault Management events, 5-6
fetching rows in a query
setting MAXDATA, B-23
File menu, 13-5
DBA tools, 7-10
filter
Navigator, 2-4
Navigator tree, 2-7
filtering folders
Navigator, 2-18
fixit job, 4-3, 5-1
creating, 4-10
events, 5-16
removing, 5-16
submitting, 5-16
with events, 5-1
folder pull-down menus
about, 7-5
folder tabs, 7-20
folders
opening, 7-4
pull-down menu, 7-5
FORCE option, B-32
forcing the retry of operations
Daemon Manager, 6-11
Function
altering, 11-22
create like, 11-21
Function Property Sheet
General Page, 11-21
Functions folder
about, 11-19
creating a function, 11-20

G

General page
job, 4-10
group
add or delete, 3-11
bitmap background, 3-12
create, 3-10
example, 3-13
job destination, 4-11
modify, 3-12
user-defined, 3-3
Groups folder
Navigator tree, 2-2

H

Help menu, 7-12
Help system
using, 1-8, 1-12, 7-12
Host Folders icon, 15-4
host name, B-7

I

Image Copy Property Sheet
General Page, 12-30
Schedule Page, 12-30
IMMEDIATE mode, B-30
Import
predefined task, 14-8
importing
a full database from a file, 14-8
data from a file, 14-6
tables from a file, 14-8
user objects, 14-8
Index
altering, 11-26
create like, 11-26
Index Property Sheet
General Page, 11-25
Indexes folder
creating an index, 11-24
Indexes Multi-column List, 11-23
in-doubt transactions
forcing a commit, 10-21
forcing a rollback, 10-21
Initialization Parameters
about, 10-11
Initialization parameters
displaying, B-27
initialization parameters
editing, 10-13
INIT.ORA file, B-32
Install Package Task, 15-29
installing
Enterprise Manager, 1-19
Intelligent Agent, 6-2
Instance Manager, about, 7-6
instances
connecting, 1-23, B-6
default, B-26
displaying current, B-26
shutting down, B-29
starting, B-31
Intelligent Agent, 1-6, 6-2
Enterprise Manager, 1-6
with events, 5-4
IP address
listening address, 6-8

J

job
alter, 4-8
composite, 4-3
create, 4-8
manage, 4-8
modify, 4-8
view, 4-8
Job History page, 4-7, 4-8
Job Library, 4-7
job output
Progress Page, 4-15
Job Scheduling, 4-1
credential preference, 4-3, 4-12
destination requirements, 4-11
Enterprise Manager, 1-4
example, 4-15
Failed to Authenticate User error, 4-3
General page, 4-10
job destination, 4-10
job destinations, 4-11
job name, 4-10
job tasks, 4-11
job type, 4-10
managing jobs, 4-4
menu, 4-8
saving history, 4-8
scheduling jobs, 4-4
scheduling process, 4-2
task parameters, 4-12
window, 4-5
Job Scheduling system, 15-24
Job system
and the software distribution process, 15-21
tasks used with Oracle Software Manager, 15-21
Jobs Property Sheets
Backup Manager, 12-22

K

keystrokes
Navigator, 2-19

L

launch palettes, 1-13
launching a database tool, 1-22
from a map, 3-5
from the Console, 2-4
from the Navigator, 1-4
Navigator, 2-4
with the right-mouse button, 2-4
line mode
about, A-1
entering commands in, A-2
entering PL/SQL in, A-2
entering SQL in, A-2
running scripts from, A-2
Server Manager, 1-8
starting, A-2
using, A-2
list of saved maps
Map menu, 3-6
LIST option, B-4
Listener Fault Management Events, 5-32
Listeners folder
Navigator tree, 2-2
Listening Address
communication parameter, 6-8
loading
data from an external file, 14-7
Log menu, 7-12
log sequence numbers
for manual archiving, B-5
listing, B-4
LOG_ARCHIVE_DEST parameter
ARCHIVE LOG LIST, B-4
overriding, B-6
LOG_ARCHIVE_START parameter, B-6
ARCHIVE LOG command, B-5
Logfile menu, 12-7
login information, 1-25

M

mail
configuring, 5-27
mail engine
event system notification, 5-27
Management Information Base (MIB)
with SNMP, 6-3
manipulation of the objects
in the Navigator, 2-15
Manual Backup Operations, 12-26
Map, 3-1
bitmap background, 3-10
create, 3-2
creating with dragging and dropping, 3-2
customized views, 3-1
example, 3-9
expanding objects, 3-4
modify, 3-8
status of objects, 3-4
types of views, 3-3
user-defined views, 3-3
window, 3-2
MAPI
mail engine, 5-27
menus
Console, 1-10
context-sensitive, 7-13
context-sensitive, using, 7-13
File menu, 1-11, 7-10
folder pull-down, about, 7-5
Help menu, 1-12, 7-12
Job, 4-8
Security Manager, 9-4
View, 1-11
View menu, 7-11
modem
changing settings, 5-14
modify
event set, 5-13
group, 3-6
map, 3-6
registered events, 5-13
monitoring
tools, 1-9
utilities, 1-9
mounting a database, B-32
multiple database connections, 1-25
multiple tasks
submitting a job, 4-9
multi-selection
Navigator, 2-2

N

Navigator, 2-1
connecting to a database, 2-6
Enterprise Manager, 1-4
example, 2-17
filtering, 2-4
filtering folders, 2-18
keystrokes, 2-19
manipulating objects, 2-15
menu, 2-5
multi-selection, 2-2
new view, 2-6
objects, 1-4
splitting the tree, 2-4, 2-6
user-defined map groups, 3-3
window, 2-2
navigator objects
manipulating, 7-4
Navigator window, 15-3, 15-4
network, 15-22
container, 2-2
encryption, 6-3
estblishing communication, 15-22
flow of information, 15-23
specifying service names, 1-24
Networking Polling Timer
communication parameter, 6-8
new view
Navigator tree, 2-6
NLS environment, 6-3
Node Fault Management Events, 5-32
Node Heartbeat Interval
communication parameter, 6-9
Node Heartbeat Timer
communication parameter, 6-9
Nodes folder
Navigator tree, 2-2
NORMAL mode, B-30
NUMBER datatype
in line mode, B-23, B-27
Number of Cached Connections
communication parameter, 6-8
Number of Worker Threads
communication parameter, 6-9

O

object lists
about, 7-4
refreshing, 7-11
selecting from, 7-13
sorting, 7-14
Object Type property sheet, 11-28
Object Types
about, 11-26
adding attributes, 11-29
adding methods, 11-30
online help, 1-8, 1-12, 7-12
accessing, 1-8
online redo log files
re-archiving, B-5
opening a database, B-32
Operation and Notification Queries folder, 6-6
Operation Retry Timer
communication parameter, 6-9
Oracle Client Software Manager (OCSM), 15-7
Oracle Daemon Manager, 6-6
Oracle DB Fault
event profile, 5-12
Oracle DB Resource
event profile, 5-12
Oracle DB UpDown
event profile, 5-12
Oracle Enterprise Manager, job system, 15-21
Oracle Enterprise Manager/Oracle Software Manager network, 15-22
establishing communication, 15-22
flow of information, 15-23
Oracle events, 5-31
Oracle Expert, 1-9
Oracle File Packager, 15-15
Oracle Host UpDown
event profile, 5-12
Oracle Installer, 15-31
Oracle Listener UpDown
event profile, 5-12
Oracle Lock Manager, 1-9
Oracle Multi-Protocol Interchange
and Communication Daemon, 6-4
Oracle Parallel Servers
administering, 1-2
Oracle Performance Pack, 1-9
Oracle Remote Operations
and Communication Daemon, 6-4
Oracle Secure Network Services (SNS)
and Communication Daemon, 6-4
Oracle Server releases
supported by Enterprise Manager, 1-2
Oracle Software Manager, 15-1
and Oracle Enterprise Manager, 15-22
Catalog window, 15-10
distribution host, 15-14
drag and drop behavior, 15-11
Host Folder Properties, 15-5
Host Folders, 15-4
Hosts folder, 15-4
network, 15-22
Oracle Home Properties, 15-6
Oracle Homes folder, 15-4
Preferences, 15-10
PRODINFO.ORA, 15-16
Product Properties, 15-7
release, 15-9
Releases folder, 15-4
response file, 15-20
software package, 15-9
Software Packages folder, 15-4
World folder, 15-4
Oracle Tablespace Map, 1-9
Oracle TopSessions, 1-9
Oracle Trace, 1-9
oratab, 2-6
OraTcl
event scripts, 5-3
job scripts, 4-2
Output Dialog box
Job Scheduling, 4-15
Outstanding Events page
Event system, 5-9

P

Package
create like, 11-37
editing, 11-38
Package Bodies folder
about, 11-33
creating a package body, 11-34
Package Bodies Multi-column List, 11-33
Package Body
create like, 11-35
editing, 11-35
Packages folder
about, 11-36
creating a package, 11-36
Packages Multi-column List, 11-36
Packages Property Sheet
General Page, 11-37
page tabs, 7-17
pages, 7-17
paging
communication settings, 5-30
configuration, 5-28
GSM protocol, 5-29
numeric event Ids, 5-33
pager type, 5-29
settings, 5-28
TAP protocol, 5-29
Paging Services Configuration
Event menu, 5-14
parameter files (INIT.ORA files)
specifying alternate, B-32
parameters
communication daemon, 6-7
Daemon Manager, 6-7
events, 5-16
jobs, 4-12
Parameters Page
job, 4-12
passwords
CONNECT command, B-7
Performance Management events, 5-6
performance monitors, 1-9
pinging
checking node with pending operations, 6-12
platform-specific installation documentation, 6-2
Pre-defined Profiles
Event system, 5-12
preferred credentials
connecting in a map, 3-5
connecting to a database, 2-15
Console, 1-25
PRINT command, B-13
privileges
needed to use Enterprise Manager, 1-20
system, 1-20
Privileges page, 9-10
problem
job or event operations, 6-11
problems
Navigator discovery, 2-13
Procedure
altering, 11-40
create like, 11-40
Procedures folder
about, 11-38
creating a procedure, 11-39
Procedures Multi-column List, 11-38
profile
create like, 9-28
Profile Container
about, 9-24
Profile Dependencies
showing, 9-29
profiles
altering, 9-28
assigning to a user, 9-29
creating, 9-25
Profiles folder
altering a profile, 9-28
creating a profile, 9-25
removing a profile, 9-29
programs
setting characteristics of, B-18
Progress page
job, 4-14
Property sheet
Create Tablespace, 8-7
property sheet
command buttons, 7-19
property sheet, in-doubt transaction, 10-20
property sheets, 7-17
about, 7-17
page tabs, 7-17
pages, 7-17
purpose of this guide, xxiv

Q

Queue Tables
about, 11-40
creating, 11-41
Queues
adding subscribers, 11-46
creating, 11-45
Queues Folder, 11-40
Queues folder
about, 11-40
Queues Multi-column List, 11-41
Quick Edit Tablespace property sheet
General page, 8-12
quitting an application, 7-10
quitting Enterprise Manager, 1-11
Quotas page, 9-10

R

RECOVER command, B-14
Recover Property Sheet
General Page, 12-33
recovery
RECOVER command, B-14
SQL worksheet and, 13-11
Recovery Catalog, 12-4
maintaining, 12-34
registering, 12-5
redo log files
archiving, B-4
listing range of, B-4
re-archiving, B-5
redo log group
adding new, 12-50
redo log group member
adding to an existing redo log group, 12-51
Redo Log Group Property Sheet, 12-46
General Page, 12-17
Redo Log Groups container
about, 12-16, 12-45
multi-column list, 12-45
property sheet, 12-46
Redo Log Members container
property sheet, 12-47
refresh command
using, 7-11
Refresh Group
altering, 11-51
Refresh Group folder
creating a refresh group, 11-49
Refresh Groups folder
about, 11-48
Refresh Groups Multi-Column List, 11-49
Register User at Startup
communication parameter, 6-9
registered destination
map objects, 3-4
registering events
Event menu, 5-13
Registrations page
Event window, 5-10
related publications, xxx
release
and the software distribution process, 15-15
definition, 15-15
Releases Catalog window, 15-9
REMARK command, B-17
removing
a split page in the Navigator, 2-6
job with Remove menu item, 4-8
problems with a job, 4-8
problems with an event, 5-13
registered events, 5-13
removing privileges from a role, 9-23
removing privileges from a user, 9-17
removing roles from a user, 9-17
removing subroles from a role, 9-23
Report Wizard, 12-25
repository
connecting to, 1-19
creating and upgrading, 1-20, 1-21
dropping, 1-21
Enterprise Manager, 1-5
information, 1-6
tables, 1-5
unique username, 1-20
Repository Manager Wizard, 1-21
resetting defaults, B-23
resetting edits, 10-13
Resource Management events, 5-6
Response File Generator, 15-37
Restore and Recover Operations, 12-31
Restore Property Sheet
Channels Page, 12-32
General Page, 12-31
Rename Page, 12-31
Restore Wizard, 12-24
right mouse button
Navigator tree, 2-7, 2-16
used in the Navigator, 1-10
right-mouse button
Related Tools menu, 2-4
role
create like, 9-20
Role Container
about, 9-18
roles
altering, 9-21
creating, 9-19
DBA and RESOURCE, 9-16
granting UNLIMITED TABLESPACE, 9-16
Roles folder
adding privileges or roles to a role, 9-22
altering a role, 9-21
creating a role, 9-19
removing a role, 9-21
removing privileges or subroles from a role, 9-23
rollback
forcing, 10-21
Rollback folder
about, 8-19
altering a rollback segment, 8-22
creating a rollback segment, 8-19
object list, 8-19
pending offline, 8-23
placing rollback segment online, 8-23
removing a rollback segment, 8-22
taking rollback segment offline, 8-23
rollback segments
altering, 8-22
creating, 8-19
placing online, 8-23
removing, 8-22
taking offline, 8-23
rolling forward, B-14
Run DBA Script task, 4-19
Run OS Command task, 4-22
Run SQL*Plus task, 4-18
Run Tcl Script task, 4-22
running scripts
@ command, 13-15, B-3
@@ command, 13-15, B-3

S

saving
event history, 5-10
job history, 4-7, 4-8
SQL worksheet, 13-14
schedule
and manage jobs, 4-4
execution of a job, 4-13
job, 4-4
Schema Manager, about, 7-7
Schema Menus, 11-4
Schema Objects folder
about, 11-6
scripts
running, B-3
running from line mode, A-2
running from SQL worksheet, 13-15
Security Manager, about, 7-8
SELECT command
MAXDATA, B-23
Send Us Your Comments, xxi
Sequence
altering, 11-55
create like, 11-54
Sequences folder
about, 11-51
creating a sequence, 11-53
Sequences Multi-Column List, 11-52
Server Manager
line mode operation, 1-8
starting, 1-8
Server Manager Line Mode
platforms, A-1
Server Manager/LineMode
about, A-1
SERVEROUTPUT
SET, B-24
SHOW, B-27
Service Discovery, 1-4, 2-3
Navigator menu option, 2-6
Service Discovery Timer
communication parameter, 6-8
Service Name, 1-25
service name
in window titles, 1-25
specifying, 1-24
Service Type, 1-25
services and agents, 6-1
Sessions folder
about, 10-17
disconnecting user session, 10-18
restricting sessions, 10-19
SET command
about, B-18
INSTANCE option, B-26
SERVEROUTPUT, B-24
setting a bitmap background
Map menu, 3-7, 3-8, 3-10, 3-12
setting up administrators, 5-24
short-cut menu, 1-10
SHOW command, B-25
Show SQL button, 7-19
showing SQL statements, 7-19
shrinking a rollback segment, 8-22
SHUTDOWN command, B-29
Shutdown Database task, 4-20
Shutdown Listener task, 4-24
shutting down a database, 10-10, 12-48
signal flag
on map objects, 3-4
SMTP
mail engine, 5-27
Snapshot
create like, 11-62
editing, 11-63
Snapshot folder
creating a snapshot, 11-60
Snapshot Log
altering, 11-58
create like, 11-57
Snapshot Log folder
creating a snapshot log, 11-56
Snapshot Log property sheet
General page, 11-57
Snapshot Logs folder
about, 11-55
Snapshot Logs Multi-column List, 11-56
Snapshots folder
about, 11-59
Snapshots Multi-column List, 11-59
SNMP
and agents, 6-3
software distribution process, 15-12
about, 15-12
creating releases, 15-15
creating software packages, 15-18
specifying distribution hosts, 15-14
using the Oracle Enterprise Manager job system, 15-21
Software Manager, 15-1
Software Manager, about, 7-8
software package
and the software distribution process, 15-18
definition, 15-18
Software Packages Catalog window, 15-9
Space Management event, 5-6
specifying service names, 1-24, 1-26
split (new) view
Navigator, 2-6
splitting the Navigator tree, 2-4, 2-6
new view, 2-6
SPOOL command, B-30
long lines of text, B-31
spooling multiple log files, B-6
spreadsheets, 7-18
DBA tools, 7-18
SPX
listening address, 6-8
SQL
showing generated, 7-19
SQL error
job task, 4-19
SQL statements
showing, 7-19
SQL Worksheet
about, 13-2
connecting from, 13-10
Edit menu, 13-6
entering commands, 13-8
executing commands, 13-10
executing commands in, 13-8
File menu, 13-5
input pane, 13-8
recovering a database, 13-11, 13-13
running scripts from, 13-15
starting, 13-2
using, 13-2
Worksheet menu, 13-6
SQL worksheet
saving work, 13-14
SQL Worksheet, about, 7-9
SQL*DBA and Server Manager
differences, C-1
SQL*Net network
services, 2-3
starting Enterprise Manager, 1-19
starting up a database, 10-9, 12-49
STARTUP command, B-31
Startup Database task, 4-20
Startup Listener task, 4-25
status
of a map object, 3-4
of a registered event set, 5-3
Storage Manager, about, 7-8
stored configurations, 10-14
adding parameters, 10-15
creating, 10-14
creating a file from, 10-16
deleting, 10-15, 10-16
editing, 10-15
stored configurations property sheet, 10-14
Stored Scripts, creating, 12-37
summary of the pending jobs
Active Jobs page, 4-6
supported Oracle releases, 1-2
Switch Property Sheet
General Page, 12-33
Synonyms folder, 11-22
about, 11-64
creating a synonym, 11-64
Synonyms Multi-column List, 11-64
SYS username
CONNECT INTERNAL, B-8
SYSDBA
role, 3-5
SYSDBA roles
connect as, 1-24
SYSOPER
role, 3-5
SYSOPER role
connect as, 1-24
System Global Area (SGA)
displaying, B-28

T

Table
altering, 11-75
create like, 11-75
dropping constraints, 11-74
Removing a Constraint Definition, 11-75
Table Property Sheet
Cluster Columns, 11-74
Table Types
about, 11-66
creating, 11-66
tables
DESCRIBE command, B-10
Tables folder, 11-68
creating a table, 11-69
Tables Multi-column List, 11-68
Tablespace
editing, 8-12
menu, 8-4
Tablespace container
multi-column list, 8-7, 12-16
Tablespace containers
about, 12-12, 12-43
Tablespace Dependencies
displaying, 8-11
Tablespace folder
about, 8-7
Tablespace Property Sheet
Extents Page, 8-10
General Page, 8-8, 12-13, 12-44
Tablespaces
dropping, 8-12
tablespaces
adding a datafile to, 8-13
adding rolback segments, 8-13
backing up, 12-50
creating, 8-7
making read-only, 8-14
making writeable, 8-15
placing online, 8-14
recovering, B-14
taking offline, 8-14
Tablespaces container
multi-column list, 12-12, 12-43
Tablespaces folder
taking tablespace offline, 8-14
tape drive
spooling multiple log files, B-6
task parameters
Job system, 4-12
Tcl
event scripts, 5-3
job scripts, 4-2
script examples, 4-23
scripts executed by agents, 6-3
TCP/IP
listening address, 6-8
TCP/IP Port
communication parameter, 6-8
terminals
redirecting output, B-24
third-party applications
notifications, 6-6
third-party events
creating, 5-15
with job task, 4-24
timing
CPU and elapsed, B-24, B-28
tnsnames.ora, 2-6, 2-10, 2-12, 2-13, 2-14
toolbar
icons, 1-13
options, 1-13
Tools menu, 1-12
topology file
topo_ops.ora, 1-4, 2-3
transactions
committing at disconnect, B-11
Transactions folder
about, 10-19
forcing a commit, 10-21
forcing a rollback, 10-21
object list, 10-19
Transparent Network Substrate (TNS)
and Communication Daemon, 6-4
Trigger
altering, 11-79
create like, 11-79
Triggers folder
about, 11-75
creating a trigger, 11-76
Triggers Multi-column List, 11-76
troubleshooting
job and event operations, 6-11

U

UpDown (Database) event, 5-32
UpDown (Listener) event, 5-32
UpDown (Node) event, 5-32
User
create like, 9-14
user preferences
jobs, 4-3, 4-12
when running jobs, 4-3, 4-12
user-defined groups
in the Navigator, 2-4
job destinations, 4-11
Navigator tree, 2-4
user-defined map views
creating, 3-3
Username, 1-25
usernames, B-7
Users
menu, 9-4
users
altering, 9-14
assigning profile to, 9-29
creating, 9-8
Users Folder
about, 9-7
Users folder
adding privileges or roles to a user, 9-15
altering a user, 9-14
creating a user, 9-8
dropping a user, 9-15
removing privileges or roles from a user, 9-17, 9-18

V

VARIABLE command, B-34
View
altering, 11-82
create like, 11-82
View menu, 7-11
Views folder
about, 11-79
creating a view, 11-80
Views Multi-column List, 11-80

W

window titles, 1-25
windows
Catalog, 15-9
Navigator, 15-4
Releases Catalog, 15-9
Software Packages, 15-9
Worksheet menu, 13-6
World folder icon, 15-4

 
Prev
 
Oracle 
Copyright © 1998 Oracle Corporation. 
All Rights Reserved. 
 
Library
 
Product
 
Contents