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



Go to previous file in sequence

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-21
Active Jobs page, 4-6
add a group to a map
Map menu, 3-6
adding privileges to a role, 9-18
adding privileges to a user, 9-12
adding roles to a user, 9-12
adding subroles to a role, 9-18
additional administration utilities, 1-9
additional services folders
Navigator tree, 2-2
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-22
Advanced Mode
View menu, 1-11
Advanced mode, 7-14
Advanced Queuing, 11-25
agent
down, 5-4
intelligent, 6-2
out of sync with Console, 6-10
process, 6-2
UpDown Node event, 5-4
Alter Rollback Segment property sheet
about, 8-17
Storage page, 8-18
Application Pending Notifications
Daemon Manager, 6-6
apply (register) an event set, 5-18
applying edits, 10-10
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-17
Record Page, 12-18
archiving redo log files
about, B-3
archive location, B-4
device written to, B-5
re-archiving, B-5
stopping, B-5
Auto Extend page, 8-13
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-44
Backup Manager
menus, 12-34
starting, 12-2
Backup Manager, about, 7-5
Backup menu, 12-34
Backup Set Property Sheet
Channels Page, 12-24
Parameters Page, 12-24
Backup Set/Image Copy Property Sheet
Schedule Page, 12-25
Backup Tablespace Wizard
about, 12-44
Backup Wizard, 12-22
BackupSet Property Sheet
General Page, 12-23
Basic mode, 7-14
Broadcast Message, 4-21

C

Catalog, 15-7
Catalog window, 15-2, 15-7
Channels Property Sheet
General Page, 12-19, 12-31
Limits Page, 12-20, 12-32
channels, creating, 12-31
CHAR datatype
displaying in line mode, B-21
in line mode, B-26
Cluster Property Sheet
General Page, 11-8
Clusters
editing, 11-10
Clusters folder
about, 11-7
Clusters Multi-column List, 11-7
Clusters, creating, 11-8
Column Details, 11-9
command buttons
dialog box, 7-13
property sheet, 7-16
command history
about, 13-10
and Worksheet menu commands, 13-12
retrieving a command from, 13-12
Command History dialog box, 13-10
commands
@ command, B-2
ARCHIVE LOG command, B-3
CONNECT command, B-6
DESCRIBE command, B-9
DISCONNECT command, B-11
EXECUTE command, B-11
executing, 13-8
executing in SQL worksheet, 13-6
EXIT command, B-12
PRINT command, B-13
RECOVER command, B-13
REMARK command, B-17
SET command, B-18
SHOW command, B-24
SHUTDOWN command, B-29
SPOOL command, B-30
STARTUP command, B-31
VARIABLE command, B-35
commands (Server Manager)
@ command, in a SQL Worksheet, 13-13
@@ command, 13-14, B-3
programs, setting characteristics of, B-18
Comments
in scripts, B-17
commit
forcing, 10-16
common services
and agents, 1-6
Enterprise Manager, 1-6
communication daemon, 6-4
Enterprise Manager, 1-6
parameters, 6-7
populating Navigator, 2-3
composite job, 4-3
concurrency
instances, multiple, B-33
configure
mail services, 5-14
modem, 5-14
paging services, 5-14, 5-26
CONNECT command
about, B-6
INTERNAL option, B-7
user SYS, B-7
Connect dialog box, 1-22
connect string
Enterprise Manager, 1-19
connecting
as SYSOPER or SYSDBA, 1-23
File menu item, 7-8, 13-4
Navigator menu item, 2-6
service name, 1-23
to a database, 1-22
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-9
multiple, 1-24
Console
about, 15-2
customize layout, 1-11
Enterprise Manager, 1-3
File menu, 1-11
Help menu, 1-12
menus, 1-10
user preferences, 1-24
using menus, 1-10
context-sensitive menus
Navigator, 1-10, 2-7
using, 7-11
using in the Navigator, 1-10
Controlfile Object and Property Sheet, 12-38
Copying Tree Objects, 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-8
Create Datafile
General Page, 8-12
Create Datafile property sheet
Auto Extend page, 8-13
Create Index property sheet
Storage page, 11-16
create like
profile, 9-23
role, 9-17
user, 9-11
Create Like Cluster
Clusters
create like, 11-10
Create package body property sheet
General page, 11-19
Create Procedure property sheet
General page, 11-24
Create Profile property sheet, 9-21
profile name, 9-21
Create Redo Log Group property sheet
about, 12-45
Create Redo Log Member property sheet
about, 12-46
create refresh group property sheet
General page, 11-27
Snapshot page, 11-28
Create Role property sheet
General page, 9-17
Create Rollback Segment property sheet, 8-16
about, 8-15
create sequence property sheet
General page, 11-30
Create Snapshot Log property sheet
Storage page, 11-33
Create Snapshot property sheet
Cluster page, 11-37
General page, 11-36
Storage page, 11-36
Create Synonym property sheet
General page, 11-39
Create Table property sheet
Column Details property sheet, 11-43
General page, 11-41
Storage page, 11-41, 11-43
Create Tablespace
Extents page, 8-7
General page, 8-6
Create Trigger property sheet
General page, 11-46
Timing page, 11-47
Create User property sheet, 9-8
about, 9-6
adding quotas, 9-10
Default Roles page, 9-10
General page, 9-6
Privileges page, 9-8
Roles/Privileges page, 9-8
Create View property sheet
General page, 11-50
Creating a Channel, 12-31
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-9
Data Manager
context-sensitive menus, 14-4
Export wizard, 14-4
Import wizard, 14-5
Load wizard, 14-6
menus, 14-3
starting, 14-2
window, 14-3
Data Manager, about, 7-5
database
changing connections, 13-9
mounting, 10-7, B-32
opening, 10-7, B-33
recovering from SQL worksheet, 13-9
shutting down, 10-7
database administration applications
DBA, 1-12
database files
recovering, B-13
Database folder
mounting a database, 10-7
opening a database, 10-7
shutting down a database, 10-7
database instance property sheet
accessing from a map, 3-5
Database Link
create like, 11-12
database link folder
creating a database link, 11-11
Database Link Property Sheet
General Page, 11-12
Database Links folder
about, 11-10
Database Links Multi-column List, 11-11
database name
at startup, B-31
Database Property Sheet
Information Page, 12-10, 12-37
Status Page, 12-10, 12-36
database tools, 1-7
application folders, 7-3
folders, 7-3
quitting, 7-9
database tools and utilities, 1-7
about, 7-2
dialog boxes, 7-12
property sheets, 7-14
Databases folder
Navigator tree, 2-2
datafiles
adding, 8-9
altering, 8-14
creating, 8-12
creating like, 8-14
multi-column list, 8-11
renaming, 8-12
Datafiles folder
about, 8-11
altering a datafile, 8-14
create like datafile, 8-14
Datafiles Property Sheet
General Page, 12-13
DATE datatype
in line mode, B-22, B-26
DBA
database administration application, 1-7
DBA mode, B-32
DBA privilege, 1-21, B-32
DBA tools
menus, 7-8
Deinstall Product Task, 15-24
delete
group, 3-6
Delete option
Daemon Manager, 6-10
removing job or event operations, 6-10
Delete Package Task, 15-26
DESCRIBE command, B-9
destination
archive, B-6
overriding default, B-6
dialog box
about, 7-12
command buttons, 7-13
dialog boxes, 7-12
differences
between SQL*DBA and Server Manager, C-1
DISCONNECT command, B-11
disconnecting, B-11
Navigator menu item, 2-6
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-27
distribution host
and the software distribution process, 15-11
definition, 15-11
drag and drop, 2-16
Navigator objects, 2-2
drawers
opening, 7-16

E

Edit menu, 13-5
elapsed timing, B-24, B-28
email
configuring, 5-25
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-21
quitting, 1-11
repository, 1-19
starting, 1-19
starting up, 1-19
toolbars, 1-13
event
destination requirements, 5-19
introduction, 5-1
parameter settings, 5-17
process, 5-2
set, 5-3
Event History page
Event window, 5-10
Event Management system, 5-1
categories of events, 5-6
configuring paging services, 5-26
configuring the modem, 5-28
creating an event set, 5-14
defining administrators, 5-22
Enterprise Manager, 1-5
fault management, 5-6
menu, 5-12
modifying a registered event set, 5-18
modifying an event set, 5-14
performance management, 5-7
process, 5-2
registering an event set, 5-18
resource management, 5-7
space management, 5-7
types of events, 5-6
viewing a registered event set, 5-18
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
EXCLUSIVE mode, B-33
EXECUTE command, B-11
EXIT command, B-12
exiting an application, 7-9
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-6
exporting
a full database to a file, 14-6
data to a file, 14-4
objects to a file, 14-6
owners to a file, 14-6
tables to a file, 14-6

F

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

G

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

H

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

I

illustrations
console user interface, 15-2
toolbar icons, 15-2
Image Copy Property Sheet
General Page, 12-26
Schedule Page, 12-27
IMMEDIATE mode, B-30
Import
predefined task, 14-6
importing
a full database from a file, 14-6
data from a file, 14-5
tables from a file, 14-6
user objects, 14-6
Index
altering, 11-18
create like, 11-18
Index Property Sheet
General Page, 11-17
Indexes folder
creating an index, 11-16
Indexes Multi-column List, 11-16
in-doubt transactions
forcing a commit, 10-16
forcing a rollback, 10-16
INIT.ORA file, B-32
Initialization Parameters
about, 10-8
Initialization parameters
displaying, B-27
initialization parameters
editing, 10-10
Install Package Task, 15-22
installing
Enterprise Manager, 1-19
intelligent agent, 6-4
Instance Manager, about, 7-6
instances
connecting, 1-22, B-6
default, B-26
displaying current, B-26
multiple, sharing a database, B-33
shutting down, B-29
starting, B-31
intelligent agent, 1-6, 6-2
Enterprise Manager, 1-6
with events, 5-4

J

job
alter, 4-8
composite, 4-3
create, 4-8
credential preference, 4-3, 4-12
destination requirements, 4-11
Failed to Authenticate User error, 4-3
manage, 4-8
modify, 4-8
saving history, 4-8
scheduling process, 4-2
task parameters, 4-12
view, 4-8
Job History page, 4-7, 4-8
Job Library, 4-7
job output
Progress Page, 4-14
Job Scheduling system, 15-18
Enterprise Manager, 1-4
Job system, 4-1
and the software distribution process, 15-17
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
scheduling jobs, 4-4
tasks used with Oracle Software Manager, 15-17
window, 4-5
Jobs Property Sheets
Backup Manager, 12-20

K

keystrokes
Navigator, 2-18

L

launch palettes, 1-13
launching a database tool, 1-20
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
Listeners folder
Navigator tree, 2-2
Listening Address
communication parameter, 6-7
loading
data from an external file, 14-5
Log menu, 7-10
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-8, 12-36
login information, 1-24

M

mail
configuring, 5-25
mail engine
event system notification, 5-25
Management Information Base (MIB)
with SNMP, 6-3
manipulation of the objects
in the Navigator, 2-15
Manual Backup Operations, 12-23
map
bitmap background, 3-9
create, 3-2
creating with dragging and dropping, 3-2
expanding objects, 3-4
modify, 3-8
status of objects, 3-4
types of views, 3-3
Map system, 3-1
customized views, 3-1
status of objects, 3-4
user-defined views, 3-3
window, 3-2
MAPI
mail engine, 5-25
menus
Console, 1-10
context-sensitive, 7-11
context-sensitive, using, 7-11
File menu, 1-11, 7-8
folder pull-down, about, 7-5
Help menu, 1-12, 7-10
Job, 4-8
Security Manager, 9-3
View, 1-11
View menu, 7-9
modem
changing settings, 5-14
information, 5-28
settings, 5-28
modify
event set, 5-13
group, 3-6
map, 3-6
registered events, 5-13
monitoring
tools, 1-9
utilities, 1-9
mounting
shared databases, B-34
mounting a database, B-32
multiple database connections, 1-24
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
filtering, 2-4
keystrokes, 2-18
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-2, 15-3
network, 15-32
container, 2-2
encryption, 6-3
estblishing communication, 15-32
flow of information, 15-33
new view
Navigator tree, 2-6
NLS environment, 6-3
Nodes folder
Navigator tree, 2-2
NORMAL mode, B-30
NUMBER datatype
in line mode, B-23, B-27

O

object lists
about, 7-4
refreshing, 7-9
selecting from, 7-11
sorting, 7-11
online help, 1-8, 1-12, 7-10
accessing, 1-8, 15-1
online redo log files
re-archiving, B-5
opening a database, B-33
Operation and Notification Queries folder, 6-6
Oracle Client Software Manager (OCSM), 15-6
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-17
Oracle Enterprise Manager/Oracle Software Manager network, 15-32
establishing communication, 15-32
flow of information, 15-33
Oracle Expert, 1-9
Oracle File Packager, 15-12
Oracle Host UpDown
event profile, 5-12
Oracle Installer, 15-24
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
about console user interface, 15-2
and Oracle Enterprise Manager, 15-32
Catalog window, 15-8
console user interface illustrated, 15-2
distribution host, 15-11
drag and drop behavior, 15-9
Host Folder Properties, 15-5
Host Folders, 15-3
Hosts folder, 15-3
network, 15-32
Oracle Home Properties, 15-6
Oracle Homes folder, 15-3
Preferences, 15-8
PRODINFO.ORA, 15-13
Product Properties, 15-6
release, 15-7
Releases folder, 15-3
response file, 15-16
software package, 15-7
Software Packages folder, 15-3
toolbar icons illustrated, 15-2
World folder, 15-3
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 system, 4-14
Outstanding Events page
Event system, 5-9

P

Package
create like, 11-22
editing, 11-23
Package Bodies folder
about, 11-18
creating a package body, 11-19
Package Bodies Multi-column List, 11-19
Package Body
create like, 11-20
editing, 11-20
Packages folder
about, 11-21
creating a package, 11-21
Packages Multi-column List, 11-21
Packages Property Sheet
General Page, 11-22
page tabs, 7-14
pages, 7-14
paging
communication settings, 5-27
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-10
platform-specific installation documentation, 6-4
Pre-defined Profiles
Event system, 5-12
preface
Send Us Your Comments, i
preferred credentials
connecting in a map, 3-5
connecting to a database, 2-15
Console, 1-24
PRINT command, B-13
privileges
needed to use Enterprise Manager, 1-21
system, 1-21
Privileges page, 9-8
problem
job or event operations, 6-10
problems
Navigator discovery, 2-13
Procedure
altering, 11-25
create like, 11-24
Procedures folder
about, 11-23
creating a procedure, 11-23
Procedures Multi-column List, 11-23
profile
create like, 9-23
Profile Container
about, 9-20
Profile Dependencies
showing, 9-24
profiles
altering, 9-24
assigning to a user, 9-25
creating, 9-21
Profiles folder
altering a profile, 9-24
creating a profile, 9-21
removing a profile, 9-25
programs
setting characteristics of, B-18
Progress page
job, 4-14
Property sheet
Create Tablespace, 8-6
property sheet
command buttons, 7-16
property sheet, in-doubt transaction, 10-16
property sheets, 7-14
about, 7-14
page tabs, 7-14
pages, 7-14

Q

Queues Folder, 11-25
Queues folder
about, 11-25
Queues Multi-column List, 11-25
Quick Edit Tablespace property sheet
General page, 8-9
quitting an application, 7-9
quitting Enterprise Manager, 1-11
Quotas page, 9-8

R

RECOVER command, B-13
Recover Property Sheet
General Page, 12-29
recovery
RECOVER command, B-13
SQL worksheet and, 13-9
Recovery Catalog, 12-3
registering, 12-6
setup, 12-4
redo log files
archiving, B-4
listing range of, B-4
re-archiving, B-5
redo log group
adding new, 12-45
redo log group member
adding to an existing redo log group, 12-46
Redo Log Group Property Sheet, 12-41
General Page, 12-15
Redo Log Groups container
about, 12-15, 12-40
multi-column list, 12-40
property sheet, 12-41
Redo Log Members container
property sheet, 12-42
refresh command
using, 7-9
Refresh Group
altering, 11-28
Refresh Group folder
creating a refresh group, 11-27
Refresh Groups folder
about, 11-26
Refresh Groups Multi-Column List, 11-26
Refresh Hosts, 15-29
registered destination
map objects, 3-4
registering events
Event menu, 5-13
Registrations page
Event window, 5-10
Related publications, viii
release
and the software distribution process, 15-12
definition, 15-12
Releases Catalog window, 15-7
REMARK command, B-17
Remote SYSDBA Access
SYSDBA access, 12-4
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-20
removing privileges from a user, 9-14
removing roles from a user, 9-14
removing subroles from a role, 9-20
repository
connecting to, 1-19
Enterprise Manager, 1-5
information, 1-6
tables, 1-5
unique username, 1-20
resetting defaults, B-23
resetting edits, 10-10
Resource Management events, 5-6
Response File Generator, 15-30
Restore and Recover Operations, 12-27
Restore Property Sheet
Channels Page, 12-28
General Page, 12-27
Rename Page, 12-28
Restore Wizard, 12-23
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-17
Role Container
about, 9-15
roles
altering, 9-17
creating, 9-16
DBA and RESOURCE, 9-13
granting UNLIMITED TABLESPACE, 9-13
Roles folder
adding privileges or roles to a role, 9-18
altering a role, 9-17
creating a role, 9-16
removing a role, 9-18
removing privileges or subroles from a role, 9-20
rollback
forcing, 10-16
Rollback folder
about, 8-15
altering a rollback segment, 8-17
creating a rollback segment, 8-15
object list, 8-15
pending offline, 8-19
placing rollback segment online, 8-19
removing a rollback segment, 8-18
taking rollback segment offline, 8-19
rollback segments
altering, 8-17
creating, 8-15
placing online, 8-19
removing, 8-18
taking offline, 8-19
rolling forward, B-13
Run DBA Script, 4-17
Run OS Command, 4-22
Run SQL*Plus, 4-16
Run Tcl Script, 4-22
running scripts
@ command, 13-13, B-3
@@ command, 13-14, B-3

S

saving
event history, 5-10
job history, 4-7, 4-8
SQL worksheet, 13-12
schedule
and manage jobs, 4-4
execution of a job, 4-13
job, 4-4
Schema Manager, about, 7-6
Schema Menus, 11-3
Schema Objects folder
about, 11-4
scripts
running, B-3
running from line mode, A-2
running from SQL worksheet, 13-13
Security Manager, about, 7-7
SELECT command
MAXDATA, B-23
Send Us Your Comments
boilerplate, i
Sequence
altering, 11-32
create like, 11-32
Sequences folder
about, 11-29
creating a sequence, 11-30
Sequences Multi-Column List, 11-29
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 Name, 1-24
service name
in window titles, 1-24
specifying, 1-23
Service Type, 1-24
services and agents, 6-1
Sessions folder
about, 10-13
disconnecting user session, 10-14
restricting sessions, 10-15
SET command
about, B-18
INSTANCE option, B-26
SERVEROUTPUT, B-24
setting a bitmap background
Map menu, 3-7, 3-8, 3-9, 3-11
setting up the administrators, 5-22
shared disk systems
mounting shared, B-34
shared mode
database, B-34
short-cut menu, 1-10
SHOW command, B-24
Show SQL button, 7-16
showing SQL statements, 7-16
shrinking a rollback segment, 8-18
SHUTDOWN command, B-29
Shutdown Database, 4-18
Shutdown Listener, 4-24
shutting down a database, 10-7, 12-43
signal flag
on map objects, 3-4
SMTP
mail engine, 5-25
Snapshot
create like, 11-37
editing, 11-37
Snapshot folder
creating a snapshot, 11-35
Snapshot Log
altering, 11-34
create like, 11-34
Snapshot Log folder
creating a snapshot log, 11-33
Snapshot Log property sheet
General page, 11-33
Snapshot Logs folder
about, 11-32
Snapshot Logs Multi-column List, 11-32
Snapshots folder
about, 11-34
Snapshots Multi-column List, 11-35
SNMP
and agents, 6-3
software distribution process, 15-10
about, 15-10
creating releases, 15-12
creating software packages, 15-15
specifying distribution hosts, 15-11
using the Oracle Enterprise Manager job system, 15-17
Software Manager, 15-1
Software Manager, about, 7-7
software package
and the software distribution process, 15-15
definition, 15-15
Software Packages Catalog window, 15-7
Space Management event, 5-6
specifying service names, 1-23, 1-25
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-15
DBA tools, 7-15
SQL
showing generated, 7-16
SQL error
job task, 4-17
SQL statements
showing, 7-16
SQL Worksheet
about, 13-2
connecting from, 13-9
Edit menu, 13-5
entering commands, 13-7
executing commands, 13-8
executing commands in, 13-6
File menu, 13-4
input pane, 13-7
recovering a database, 13-9, 13-12
running scripts from, 13-13
starting, 13-2
using, 13-2
Worksheet menu, 13-5
SQL worksheet
saving work, 13-12
SQL Worksheet, about, 7-8
SQL*DBA and Server Manager
differences, C-1
SQL*Net
specifying service names, 1-23
SQL*Net installation, 1-6
SQL*Net network
services, 2-3
starting Enterprise Manager, 1-19
starting up a database, 10-6, 12-43
STARTUP command, B-31
Startup Database, 4-18
Startup Listener, 4-24
status
of a map object, 3-4
of a registered event set, 5-3
Storage Manager, about, 7-7
stored configurations, 10-11
adding parameters, 10-12
creating, 10-11
creating a file from, 10-12
deleting, 10-12, 10-13
editing, 10-11
stored configurations property sheet, 10-11
summary of the pending jobs
Active Jobs page, 4-6
supported Oracle releases, 1-2
Switch Property Sheet
General Page, 12-29
Synonyms folder, 11-15
about, 11-38
creating a synonym, 11-39
Synonyms Multi-column List, 11-38
SYS username
CONNECT INTERNAL, B-7
SYSDBA
role, 3-5
SYSDBA roles
connect as, 1-23
SYSOPER
role, 3-5
SYSOPER role
connect as, 1-23
System Global Area (SGA)
displaying, B-27

T

Table
altering, 11-45
create like, 11-45
dropping constraints, 11-44
Removing a Constraint Definition, 11-44
Table Property Sheet
Cluster Columns, 11-44
tables
DESCRIBE command, B-10
Tables folder, 11-40
creating a table, 11-41
Tables Multi-column List, 11-40
Tablespace
editing, 8-9
menu, 8-3
Tablespace container
multi-column list, 8-5, 12-15
Tablespace containers
about, 12-11, 12-38
Tablespace Dependencies
displaying, 8-8
Tablespace folder
about, 8-5
Tablespace Property Sheet
Extents Page, 8-7
General Page, 8-6, 12-12, 12-39
Tablespaces
dropping, 8-9
tablespaces
adding a datafile to, 8-9
adding rolback segments, 8-10
backing up, 12-44
creating, 8-6
making read-only, 8-11
making writeable, 8-11
placing online, 8-10
recovering, B-13
taking offline, 8-10
Tablespaces container
multi-column list, 12-12, 12-38
Tablespaces folder
taking tablespace offline, 8-10
tape drive
spooling multiple log files, B-6
task parameters
Job system, 4-12
Tcl
event scripts, 5-3
job scripts, 4-2
scripts executed by agents, 6-3
Tcl, script examples, 4-23
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-23
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-15
forcing a commit, 10-16
forcing a rollback, 10-16
object list, 10-15
Transparent Network Substrate (TNS)
and communication daemon, 6-4
Trigger
altering, 11-48
create like, 11-48
Triggers folder
about, 11-45
creating a trigger, 11-46
Triggers Multi-column List, 11-45
troubleshooting
job and event operations, 6-10

U

User
create like, 9-11
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-24
usernames, B-7
Users
menu, 9-3
users
altering, 9-11
assigning profile to, 9-25
creating, 9-6
Users Folder
about, 9-5
Users folder
adding privileges or roles to a user, 9-12
altering a user, 9-11
creating a user, 9-6
dropping a user, 9-12
removing privileges or roles from a user, 9-14, 9-15

V

VARIABLE command, B-35
View
altering, 11-51
create like, 11-51
View menu, 7-9
View Property Sheet
Advanced, 11-50
Views folder
about, 11-49
creating a view, 11-49
Views Multi-column List, 11-49

W

window titles, 1-24
windows
Catalog, 15-7
Navigator, 15-3
Releases Catalog, 15-7
Software Packages, 15-7
Worksheet menu, 13-5
World folder icon, 15-3


Go to previous file in sequence Prev Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index