Index

communication

Communication Daemon, 6-4

populating Navigator, 2-3

communication daemon

parameters, 6-7

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

create

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

create like

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

Daemon Manager

configuration parameters, 6-7

menu, 6-11

Data Manager

context-sensitive menus, 14-4

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

datafiles

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

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

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

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

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

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

Fault Management events, 5-6

fetching rows in a query

setting MAXDATA, B-23

filter

filtering folders

folder pull-down menus

folders

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

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

Groups folder

Help system

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

Host Folders icon, 15-4

host name, B-7

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

Index

Index Property Sheet

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

Job History page, 4-7, 4-8

with events, 5-4

IP address

listening address, 6-8

job

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

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

keystrokes

Navigator, 2-19

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

list of saved maps

Listener Fault Management Events, 5-32

Listeners folder

Navigator tree, 2-2

Listening Address

data from an external file, 14-7

loading

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

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

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

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

Node Fault Management Events, 5-32

new view

Navigator tree, 2-6

NLS environment, 6-3

Node Heartbeat Interval

Node Heartbeat Timer

Nodes folder

Navigator tree, 2-2

NORMAL mode, B-30

NUMBER datatype

in line mode, B-23, B-27

Number of Cached Connections

Number of Worker Threads

Object Type property sheet, 11-28

object lists

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

Oracle Client Software Manager (OCSM), 15-7

Oracle Daemon Manager, 6-6

Oracle DB Fault

Oracle DB Resource

Oracle DB UpDown

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

Oracle Installer, 15-31

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

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

OraTcl

Output Dialog box

Outstanding Events page

Event system, 5-9

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

Parameters Page

passwords

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

Profile Container

Profile Dependencies

profiles

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

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

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

related publications, xxx

registered destination

map objects, 3-4

registering events

Event menu, 5-13

Registrations page

Event window, 5-10

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

Role Container

roles

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

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

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

disconnecting user session, 10-18

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

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

SMTP

Snapshot

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

SQL worksheet

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

SYSDBA roles

SYSOPER

SYSOPER role

System Global Area (SGA)

displaying, B-28

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

CPU and elapsed, B-24, B-28

terminals

redirecting output, B-24

third-party applications

notifications, 6-6

third-party events

creating, 5-15

with job task, 4-24

timing

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)