Index

communication daemon, 6-4

populating Navigator, 2-3

parameters, 6-7

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

SQL*Net 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

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

create like

profile, 9-23

role, 9-17

user, 9-11

Create package body property sheet

General page, 11-20

Create Procedure property sheet

General page, 11-24

Create Profile property sheet, 9-21, 9-22

profile name, 9-21

Create Redo Log Group property sheet

about, 12-44

Create Redo Log Member property sheet

about, 12-45

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

Storage page, 11-42, 11-43

Create Tablespace

Extents page, 8-7

General page, 8-6

Create Trigger property sheet

General page, 11-47

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

cursors

disconnect and closing cursors, B-11

opened at CONNECT, B-8

customize and manage network views

Map system, 3-6

Daemon Manager

configuration parameters, 6-7

menu, 6-9

Data Manager

about, 7-7

context-sensitive menus, 14-3

menus, 14-3

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 folder

creating a database link, 11-11

Database Links folder

about, 11-10

database name

at startup, B-31

database tools, 1-7

application folders, 7-3

folders, 7-3

quitting, 7-8

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

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

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

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

event

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

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

Fault Management events, 5-6

fetching rows in a query

setting MAXDATA, B-23

filter

folder pull-down menus

folders

forcing the retry of operations

Daemon Manager, 6-10

Functions folder

about, 11-13

creating a function, 11-14

General page

job, 4-10

group

add or delete, 3-10

bitmap background, 3-11

create, 3-9

job destination, 4-11

Groups folder

Help system

using, 1-8, 1-12, 7-10

Host Folders icon, 15-3

host name, B-7

illustrations

console user interface, 15-2

toolbar icons, 15-2

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

Indexes folder

creating an index, 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-3

Instance Manager

about, 7-5

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

credential preference, 4-3, 4-12

with events, 5-4

job

alter, 4-8

composite, 4-3

create, 4-8

manage, 4-8

modify, 4-8

scheduling process, 4-2

task parameters, 4-12

view, 4-8

Job History page, 4-6, 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

menu, 4-8

tasks used with Oracle Software Manager, 15-17

window, 4-4

keystrokes

Navigator, 2-18

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

list of saved maps

Listeners folder

Listening Address

communication parameter, 6-7

loading

data from an external file, 14-5

Log menu, 7-9

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, 12-35

login information, 1-24

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

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

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

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

container, 2-2

encryption, 6-3

estblishing communication, 15-33

flow of information, 15-34

new view

Nodes folder

NUMBER datatype

in line mode, B-23, B-27

object lists

about, 7-4

refreshing, 7-9

selecting from, 7-10

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

Oracle DB Resource

Oracle DB UpDown

Oracle Enterprise Manager, job system, 15-17

Oracle Enterprise Manager/Oracle Software Manager network, 15-33

establishing communication, 15-33

flow of information, 15-34

Oracle Expert, 1-9

Oracle File Packager, 15-12

Oracle Host UpDown

Oracle Installer, 15-24

Oracle Listener UpDown

Oracle Lock Manager, 1-9

Oracle Multi-Protocol Interchange

Oracle Performance Pack, 1-9

Oracle Parallel Servers

administering, 1-2

Oracle Remote Operations

Oracle Secure Network Services (SNS)

supported by Enterprise Manager, 1-2

Oracle Server releases

Oracle Software Manager, 15-1

Oracle Tablespace Map, 1-9

Oracle TopSessions, 1-9

OraTcl

Output Dialog box

Outstanding Events page

Event system, 5-9

Package Bodies folder

about, 11-19

creating a package body, 11-19

Packages folder

about, 11-21

creating a package, 11-21

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

Parameters Page

passwords

Performance Management events, 5-6

performance monitors, 1-9

pinging

checking node with pending operations, 6-10

platform-specific installation documentation, 6-3

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

Procedures folder

about, 11-23

creating a procedure, 11-24

profile

create like, 9-23

Profile Container

about, 9-20

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

property sheet, in-doubt transaction, 10-16

property sheets, 7-14

about, 7-14

page tabs, 7-14

pages, 7-14

Queues folder

about, 11-25

Quick Edit Tablespace property sheet

General page, 8-9

quitting an application, 7-8

quitting Enterprise Manager, 1-11

Quotas page, 9-8

RECOVER command, B-13

recovery

RECOVER command, B-13

SQL worksheet and, 13-9

redo log files

archiving, B-4

listing range of, B-4

re-archiving, B-5

redo log group

adding a new, 12-44

redo log group member

adding to an existing redo log group, 12-45

Redo Log Groups container

about, 12-14, 12-39

multi-column list, 12-14, 12-39

property sheet, 12-40

Redo Log Members container

property sheet, 12-41

refresh command

using, 7-9

Refresh Group folder

creating a refresh group, 11-27

Refresh Groups folder

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

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

right mouse button

Navigator tree, 2-7, 2-16

used in the Navigator, 1-10

right-mouse button

Related Tools menu, 2-4

role

Role Container

roles

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

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

rolling forward, B-13

running scripts

@ command, 13-13, B-3

@@ command, 13-14, B-3

saving

schedule

execution of a job, 4-13

job, 4-4

Schema Manager

about, 7-5

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

SELECT command

MAXDATA, B-23

Send Us Your Comments

boilerplate, i

Sequences folder

about, 11-29

creating a sequence, 11-30

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

shutting down a database, 10-7, 12-42

signal flag

on map objects, 3-4

SMTP

mail engine, 5-25

Snapshot folder

creating a snapshot, 11-36

Snapshot Log folder

creating a snapshot log, 11-33

Snapshot Log property sheet

Snapshot Logs folder

Snapshots folder

SNMP

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 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, 7-6, 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*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-42

STARTUP command, B-31

Startup Database, 4-18

Startup Listener, 4-22

status

of a map object, 3-4

of a registered event set, 5-3

Storage Manager

about, 7-6

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

supported Oracle releases, 1-2

Synonyms folder, 11-15

about, 11-38

creating a synonym, 11-39

SYS username

CONNECT INTERNAL, B-7

SYSDBA

SYSDBA roles

SYSOPER

SYSOPER role

System Global Area (SGA)

displaying, B-27

tables

DESCRIBE command, B-10

Tables folder, 11-40

creating a table, 11-41

Tablespace

menu, 8-3

Tablespace container

multi-column list, 8-5, 12-14

Tablespace containers

about, 12-11, 12-37

Tablespace folder

about, 8-5

Tablespaces

dropping, 8-9

tablespaces

adding a datafile to, 8-9

adding rolback segments, 8-10

backing up, 12-43

creating, 8-6

editiing, 8-9

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

TCP/IP Port

communication parameter, 6-8

terminals

redirecting output, B-24

third-party applications

notifications, 6-6

thrid-party events

creating, 5-15

timing

CPU and elapsed, B-24, B-28

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)