Index

Oracle Enterprise Manager Administrator's Guide

Library

Product

Contents

Index

A

ABORT mode, B-30

acknowledging events

: Event menu, 5-11
: Event window, 5-9, 5-19

Active Jobs page, 4-5

add a group to a map

: Map menu, 3-6

Add Log Group, 12-10

Add Log Member, 12-10

adding privileges to a role, 9-17

adding privileges to a user, 9-11

adding roles to a user, 9-11

adding subroles to a role, 9-17

additional administration utilities, 1-9

administration task

: Navigator objects, 2-10

Administrator Toolbar, 1-7

: application and float styles, 1-8
: customize, 1-7
: database list, 1-7
: exiting, 1-8
: menu options, 1-7
: online help, 1-8
: status of the default database, 1-8

administrators

: setting up in Event system, 5-20

Advanced Mode

: View menu, 1-12

agent

: intelligent, 6-2
: Oracle Intelligent Agent, 15-4
: out of sync with Console, 6-10
: process, 6-2

Allow All Sessions, 12-8

Alter Rollback Segment property sheet

: about, 8-16
: Storage page, 8-16

Application Pending Notifications

: Daemon Manager, 6-7

apply (register) an event set, 5-16

applying edits, 10-11

ARCH background process

: starting, B-5

ARCHIVE LOG command, B-6

: about, B-4
: ALL option, B-5
: LIST option, B-4
: NEXT option, B-5
: START option, B-5
: STOP option, B-5

archiving redo log files

: about, B-4
: archive location, B-4
: device written to, B-6
: manually, 12-15
: re-archiving, B-6
: stopping, B-5

Auto Extend page, 8-12

AUTORECOVERY option, B-22

Available Destinations list

: Job system, 4-11

B

background processes

: startup after abnormal termination, B-30

backing up a tablespace, 12-12

Backup Control File, 12-9

Backup Manager

: about, 7-6
: menus, 12-7
: starting, 12-2

Backup menu, 12-8

Backup Tablespace Wizard, 12-8

: about, 12-12
: Page 1, 12-12
: Page 2, 12-13
: Page 3, 12-13
: Page 4, 12-14

Begin Online Backup, 12-8

C

Catalog, 15-7

Catalog window, 15-7

CHAR datatype

: displaying in line mode, B-22
: in line mode, B-26

Clusters container

: about, 11-6

Clusters, creating, 11-6

command buttons

: dialog box, 7-12
: property sheet, 7-14

command history

: about, 13-9
: and Worksheet menu commands, 13-11
: retrieving a command from, 13-11

Command History dialog box, 13-9

commands

: @ command, B-3
: ARCHIVE LOG command, B-4
: CONNECT command, B-7
: DESCRIBE command, B-9
: DISCONNECT command, B-11
: EXECUTE command, B-12
: executing, 13-8
: executing in SQL worksheet, 13-6
: EXIT command, B-13
: PRINT command, B-13
: RECOVER command, B-14
: REMARK command, B-18
: SET command, B-19
: SHOW command, B-25
: SHUTDOWN command, B-30
: SPOOL command, B-31
: STARTUP command, B-32
: VARIABLE command, B-36

commands (Server Manager)

: @ command, in a SQL Worksheet, 13-13
: @@ command, 13-13, B-3
: programs, setting characteristics of, B-19

Comments

: in scripts, B-18

commit

: forcing, 10-18

common services

: and agents, 1-7
: Enterprise Manager, 1-6

communication daemon, 6-4

: Enterprise Manager, 1-6
: parameters, 6-7
: populating Navigator, 2-4

composite job, 4-3

concurrency

: instances, multiple, B-34

configure

: mail services, 5-13
: modem, 5-13
: paging services, 5-13, 5-24

CONNECT command

: about, B-7
: INTERNAL option, B-7
: user SYS, B-8

Connect dialog box, 1-17

connecting

: as SYSOPER or SYSDBA, 1-18
: File menu item, 7-8, 13-4
: Navigator menu item, 2-6
: SQL*Net service name, 1-17
: to a database, 1-17
: to a database instance in the Navigator, 2-6
: to a repository, 1-15

connecting to a database, B-7

connections

: changing, in a SQL Worksheet, 13-8
: multiple, 1-18

Console

: about, 15-6
: customize layout, 1-11
: Enterprise Manager, 1-4
: File menu, 1-11
: Help menu, 1-12
: menus, 1-10
: user preferences, 1-19
: using menus, 1-10

context-sensitive menus

: Navigator, 1-11, 2-7
: using, 7-10
: using in the Navigator, 1-11

Copying Tree Objects, 2-10

create

: event set, 5-12
: job, 4-8
: map, 3-6
: or modify a job, 4-9
: or modify an event set, 5-13
: specified object type in the Navigator, 2-6

Create Cluster property sheet, 11-6

Create Datafile

: General Page, 8-11

Create Datafile property sheet

: Auto Extend page, 8-12

Create Index property sheet

: Storage page, 11-14

create like

: profile, 9-21
: role, 9-16
: user, 9-9

Create package body property sheet

: General page, 11-17

Create Procedure property sheet

: General page, 11-22

Create Profile property sheet, 9-19 to 9-20

: profile name, 9-19

Create Redo Log Group property sheet

: about, 12-16

Create Redo Log Member property sheet

: about, 12-17

create refresh group property sheet

: General page, 11-24
: Snapshot page, 11-25

Create Role property sheet

: General page, 9-15

Create Rollback Segment property sheet, 8-14 to 8-15

: about, 8-14

create sequence property sheet

: General page, 11-27

Create Snapshot Log property sheet

: Storage page, 11-30

Create Snapshot property sheet

: Cluster page, 11-33
: General page, 11-32
: Storage page, 11-32

Create Synonym property sheet

: General page, 11-35

Create Table property sheet

: Column Details property sheet, 11-39
: General page, 11-38
: Storage page, 11-37, 11-39

Create Tablespace

: Extents page, 8-6
: General page, 8-5

Create Trigger property sheet

: General page, 11-42
: Timing page, 11-43

Create User property sheet, 9-6

: about, 9-5
: adding quotas, 9-9
: Default Roles page, 9-9
: General page, 9-5
: Privileges page, 9-6
: Roles/Privileges page, 9-6

Create View property sheet

: General page, 11-46

cursors

: disconnect and closing cursors, B-12
: opened at CONNECT, B-8

customize and manage network views

: Map system, 3-6

D

Daemon Manager

: configuration parameters, 6-7
: menu, 6-10

Data Manager

: about, 7-7
: context-sensitive menus, 14-3
: Export wizard, 14-4
: Import wizard, 14-5
: Load wizard, 14-6
: menus, 14-3
: starting, 14-2
: window, 14-2

database

: changing connections, 13-8
: mounting, 10-8, B-33
: opening, 10-8, B-33
: recovering from SQL worksheet, 13-9
: shutting down, 10-7

database administration applications

: DBA, 1-12

Database container

: about, 10-4
: database property sheet, 10-4

database files

: recovering, B-14

Database folder

: mounting a database, 10-8
: opening a database, 10-8
: shutting down a database, 10-7

database instance property sheet

: accessing from a map, 3-5

database link container

: creating a database link, 11-10

Database Links container

: about, 11-9

database name

: at startup, B-32

Database property sheet

: Archive page, 10-6

database tools, 1-8

: application folders, 7-3
: folders, 7-3
: quitting, 7-8

database tools and utilities, 1-8

: about, 7-2
: dialog boxes, 7-12
: property sheets, 7-13

Databases folder

: Navigator tree, 2-2

datafiles

: adding, 8-8
: altering, 8-13
: creating, 8-11
: creating like, 8-13
: multi-column list, 8-10
: renaming, 8-11

Datafiles folder

: about, 8-10
: altering a datafile, 8-13
: create like datafile, 8-13

DATE datatype

: in line mode, B-23, B-27

DBA

: database administration application, 1-8

DBA mode, B-33

DBA privilege, 1-14, B-33

DBA tools

: menus, 7-7

delete

: group, 3-6

Delete option

: Daemon Manager, 6-10
: removing job or event operations, 6-10

DESCRIBE command, B-9

destination

: archive, B-6
: overriding default, B-6

dialog box

: about, 7-12
: command buttons, 7-12

dialog boxes, 7-12

differences

: between SQL*DBA and Server Manager, C-1

Disable Automatic Archiving, 12-9

DISCONNECT command, B-11

disconnecting, B-11

: Navigator menu item, 2-6

discovering services

: communication daemon, 1-6, 2-4
: Navigator, 2-8
: SQL*Net network, 2-4

Discovery

: Navigator menu option, 2-7

discovery cache

: Enterprise Manager, 1-6

distribution host

: and the software distribution process, 15-9
: definition, 15-9

drag and drop, 2-10

: Navigator objects, 2-2

drawers

: opening, 7-14

Drop Log Group, 12-10

Drop Log Member, 12-10

E

Edit menu, 13-5

elapsed timing, B-25, B-28

: configuring, 5-23

EMS

: Event Management system, 5-1

Enable Automatic Archiving, 12-9

End Online Backup, 12-8

Enterprise Manager

: components, 1-3
: database administration, 1-8
: installing, 1-14
: introduction, 1-2
: launch palettes, 1-14
: Oracle releases supported by, 1-2
: privileges needed to use, 1-14
: quitting, 1-11
: repository, 1-14
: starting, 1-15
: starting up, 1-15
: toolbars, 1-13

event

: introduction, 5-1
: parameter settings, 5-16
: process, 5-2
: set, 5-2

Event History page

: Event window, 5-9

Event Management system, 5-1

: categories of events, 5-5
: configuring paging services, 5-24
: configuring the modem, 5-25
: creating an event set, 5-13
: defining administrators, 5-20
: Enterprise Manager, 1-5
: fault management, 5-6
: menu, 5-11
: modifying a registered event set, 5-16
: modifying an event set, 5-13
: performance management, 5-7
: process, 5-2
: registering an event set, 5-16
: resource management, 5-6
: space management, 5-6
: types of events, 5-5
: viewing a registered event set, 5-16
: viewing an event set, 5-10
: window, 5-7

Event Set Library page

: Event window, 5-10
: predefined event sets, 5-10

Event Set Management property sheet

: creating an event, 5-12
: modifying a new event, 5-12

EXCLUSIVE mode, B-34

EXECUTE command, B-12

EXIT command, B-13

exiting an application, 7-8

exiting Enterprise Manager, 1-11

expanding

: container in Navigator, 2-9
: map objects, 3-4
: possible delays with a container, 2-9

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

fetching rows in a query

: setting MAXDATA, B-24

File menu, 13-4

: DBA tools, 7-7

filter

: Navigator, 2-5
: Navigator tree, 2-7

fixit job, 4-3, 5-1

: creating, 4-10
: events, 5-15
: submitting, 5-15
: with events, 5-1

folder pull-down menus

: about, 7-5

folder tabs, 7-14

folders

: opening, 7-4
: pull-down menu, 7-5

Force Checkpoint, 12-10

FORCE option, B-33

forcing the retry of operations

: Daemon Manager, 6-11

Functions container

: creating a function, 11-12

Functions folder

: about, 11-11

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-10
: user-defined, 3-3

Groups folder

: Navigator tree, 2-2

H

Help menu, 7-9

Help system

: using, 1-9, 1-13, 7-9

host

: establishing communication with console, 15-4

Host Folders icon, 15-7

host name, B-7

Hosts folder icon, 15-7

I

illustrations

: console user interface, 15-6
: Oracle Enterprise Manager/Oracle Software Manager network, 15-3 to 15-4
: toolbar icons, 15-6

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 container

: creating an index, 11-14

in-doubt transactions

: forcing a commit, 10-18
: forcing a rollback, 10-18

INIT.ORA file, B-33

Initialization Parameters

: about, 10-8

Initialization parameters

: displaying, B-27

initialization parameters

: editing, 10-10

installing

: Enterprise Manager, 1-14
: intelligent agent, 6-4

Instance Manager

: about, 7-5

instances

: connecting, 1-17, B-7
: default, B-27
: displaying current, B-27
: multiple, sharing a database, B-34
: shutting down, B-30
: starting, B-32

intelligent agent, 1-6, 6-2

: Enterprise Manager, 1-7
: with events, 5-3

J

job

: alter, 4-8
: composite, 4-3
: create, 4-8
: credential preference, 4-3, 4-12
: 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

: Enterprise Manager, 1-5

Job system, 4-1

: and the software distribution process, 15-11
: 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-3
: menu, 4-8
: scheduling jobs, 4-4
: tasks used with Oracle Software Manager, 15-11
: window, 4-4

L

launch palettes, 1-14

launching a database tool, 1-16

: from a map, 3-5
: from the Console, 2-5
: from the Navigator, 1-4
: Navigator, 2-5
: with the right-mouse button, 2-5

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

: 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-9

M

mail

: configuring, 5-23

mail engine

: event system notification, 5-23

Management Information Base (MIB)

: with SNMP, 6-3

manipulation of the objects

: in the Navigator, 2-8

Manually Archive, 12-9

manually archiving redo log files, 12-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-23

menus

: Console, 1-10
: context-sensitive, 7-10
: context-sensitive, using, 7-10
: File menu, 1-11, 7-7
: folder pull-down, about, 7-5
: Help menu, 1-12, 7-9
: Job, 4-8
: Security Manager, 9-3
: View, 1-11
: View menu, 7-8

modem

: changing settings, 5-13
: information, 5-25

modify

: event set, 5-12
: group, 3-6
: map, 3-6
: registered events, 5-12

monitoring

: tools, 1-9
: utilities, 1-9

mounting

: shared databases, B-34

mounting a database, B-33

multiple database connections, 1-18

multiple tasks

: submitting a job, 4-9

N

Name Servers folder

: Navigator tree, 2-2

Navigator, 2-1

: connecting to a database, 2-6
: Enterprise Manager, 1-4
: filtering, 2-5
: manipulating objects, 2-8
: menu, 2-6
: new view, 2-7
: objects, 1-4
: splitting the tree, 2-4, 2-7
: user-defined map groups, 3-3
: window, 2-2

navigator objects

: manipulating, 7-4

Navigator window, 15-6

network, 15-3

: container, 2-2
: encryption, 6-3
: estblishing communication, 15-4
: flow of information, 15-5

new view

: Navigator tree, 2-7

NLS environment, 6-3

Nodes folder

: Navigator tree, 2-2

NORMAL mode, B-31

NUMBER datatype

: in line mode, B-24, B-27

O

object lists

: about, 7-4
: refreshing, 7-8
: selecting from, 7-10
: sorting, 7-11

online help, 1-9, 1-13, 7-9

: accessing, 1-9

online redo log files

: re-archiving, B-6

opening a database, B-33

Operation and Notification Queries folder, 6-6

Oracle Daemon Manager, 6-6

Oracle DB Fault

: event profile, 5-11

Oracle DB Resource

: event profile, 5-11

Oracle DB UpDown

: event profile, 5-11

Oracle Enterprise Manager, job system, 15-11

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

: establishing communication, 15-4
: flow of information, 15-5

Oracle Expert, 1-9

Oracle Host UpDown

: event profile, 5-11

Oracle Intelligent Agent

: establishing communication with console, 15-4

Oracle Listener UpDown

: event profile, 5-11

Oracle Lock Manager, 1-9

Oracle Multi-Protocol Interchange

: and communication daemon, 6-5

Oracle Parallel Servers

: administering, 1-2

Oracle Performance Pack, 1-9

Oracle Remote Operations

: and communication daemon, 6-5

Oracle Secure Network Services (SNS)

: and communication daemon, 6-5

Oracle Server releases

: supported by Enterprise Manager, 1-2

Oracle Software Manager, 15-2

: about console user interface, 15-6
: and Oracle Enterprise Manager, 15-3
: console user interface illustrated, 15-6
: network, 15-3
: toolbar icons illustrated, 15-6

Oracle Tablespace Map, 1-9

Oracle TopSessions, 1-9

Oracle Trace, 1-9

OraTcl

: event scripts, 5-3
: job scripts, 4-2

Output Dialog box

: Job system, 4-14

Outstanding Events page

: Event system, 5-8

P

Package Bodies container

: about, 11-16
: creating a package body, 11-17

Packages container

: about, 11-18
: creating a package, 11-19

page tabs, 7-13

pages, 7-13

Paging Services Configuration

: Event menu, 5-13

Parallel Servers folder

: Navigator tree, 2-2

parameter files (INIT.ORA files)

: specifying alternate, B-33

parameters

: communication daemon, 6-7
: Daemon Manager, 6-7
: events, 5-15
: jobs, 4-12

Parameters Page

: job, 4-12

passwords

: CONNECT command, B-7

Performance Management events, 5-5

performance monitors, 1-10

pinging

: checking node with pending operations, 6-11

Place Tablespace Online, 12-9

platform-specific installation documentation, 6-4

Pre-defined Profiles

: Event system, 5-11

preferred credentials

: connecting in a map, 3-5
: connecting to a database, 2-9
: Console, 1-19

PRINT command, B-13

privileges

: needed to use Enterprise Manager, 1-14
: system, 1-14

Privileges page, 9-6

problem

: job or event operations, 6-10

Procedures container

: about, 11-21
: creating a procedure, 11-21

profile

: create like, 9-21

Profile Container

: about, 9-18

profiles

: altering, 9-21
: assigning to a user, 9-22
: creating, 9-19

Profiles folder

: altering a profile, 9-21
: creating a profile, 9-19
: removing a profile, 9-22

programs

: setting characteristics of, B-19

Progress page

: job, 4-13

Property sheet

: Create Tablespace, 8-5

property sheet

: command buttons, 7-14

property sheet, in-doubt transaction, 10-17

property sheets, 7-13

: about, 7-13
: page tabs, 7-13
: pages, 7-13

Q

Quick Edit Tablespace property sheet

: General page, 8-8

quitting an application, 7-8

quitting Enterprise Manager, 1-11

Quotas page, 9-6

R

RECOVER command, B-14

recovery

: RECOVER command, B-14
: SQL worksheet and, 13-9

redo log files

: archiving, B-4
: listing range of, B-4
: manually archiving, 12-15
: re-archiving, B-6

redo log group

: adding a new, 12-16

redo log group member

: adding to an existing redo log group, 12-17

Redo Log Groups folders

: about, 12-5
: multi-column list, 12-5
: property sheet, 12-6

Redo Log Members folders

: multi-column list, 12-6
: property sheet, 12-7

refresh command

: using, 7-8

Refresh Group container

: creating a refresh group, 11-23

Refresh Groups container

: about, 11-23

registered destination

: map objects, 3-4

registering events

: Event menu, 5-12

Registrations page

: Event window, 5-9

Related publications, viii

release

: and the software distribution process, 15-10
: definition, 15-10

Releases Catalog window, 15-7

REMARK command, B-18

removing

: a split page in the Navigator, 2-7
: job with Remove menu item, 4-8
: problems with a job, 4-8
: problems with an event, 5-12
: registered events, 5-12

removing privileges from a role, 9-18

removing privileges from a user, 9-12 to 9-13

removing roles from a user, 9-12

removing subroles from a role, 9-18

repository

: connecting to, 1-15
: Enterprise Manager, 1-5
: information, 1-6
: tables, 1-5
: unique username, 1-16

resetting defaults, B-24

resetting edits, 10-11

Resource Management events, 5-5

Restrict Sessions, 12-8

right mouse button

: Navigator tree, 2-7, 2-10
: used in the Navigator, 1-11

right-mouse button

: Related Tools menu, 2-5

role

: create like, 9-16

Role Container

: about, 9-14

roles

: altering, 9-16
: creating, 9-15
: DBA and RESOURCE, 9-11
: granting UNLIMITED TABLESPACE, 9-11

Roles folder

: adding privileges or roles to a role, 9-17
: altering a role, 9-16
: creating a role, 9-15
: removing a role, 9-16
: removing privileges or subroles from a role, 9-18

rollback

: forcing, 10-18

Rollback folder

: about, 8-14
: altering a rollback segment, 8-16
: creating a rollback segment, 8-14
: object list, 8-14
: pending offline, 8-18
: placing rollback segment online, 8-17
: removing a rollback segment, 8-16
: taking rollback segment offline, 8-17

rollback segments

: altering, 8-16
: creating, 8-14
: placing online, 8-17
: removing, 8-16
: taking offline, 8-17

rolling forward, B-14

running scripts

: @ command, 13-13, B-3
: @@ command, 13-13, B-3

S

saving

: event history, 5-9
: job history, 4-7
: SQL worksheet, 13-12

schedule

: and manage jobs, 4-3
: execution of a job, 4-12
: job, 4-4

Schema Manager

: about, 7-5

Schema Menus, 11-3

Schema Objects Container

: 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-24

Sequences container

: about, 11-26
: creating a sequence, 11-27

Server Manager Line Mode, 1-9

: platforms, A-1

Server Manager/LineMode

: about, A-1

SERVEROUTPUT

: SET, B-24
: SHOW, B-28

Service Discovery, 1-6

Service Name, 1-19

service name

: in window titles, 1-18
: specifying, 1-17

Service Type, 1-19

services and agents, 6-1

Sessions container

: about, 10-14

Sessions folder

: disconnecting user session, 10-16
: restricting sessions, 10-16

SET command

: about, B-19
: INSTANCE option, B-27
: SERVEROUTPUT, B-24

setting a bitmap background

: Map menu, 3-7 to 3-9, 3-11

setting up the administrators, 5-20

shared disk systems

: mounting shared, B-34

shared mode

: database, B-34

short-cut menu, 1-11

Show Archive Log Info, 12-9

SHOW command, B-25

Show SQL button, 7-14

showing SQL statements, 7-14

shrinking a rollback segment, 8-17

SHUTDOWN command, B-30

Shutdown Database, 12-8

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

signal flag

: on map objects, 3-4

SMTP

: mail engine, 5-23

Snapshot container

: creating a snapshot, 11-32

Snapshot Log container

: creating a snapshot log, 11-30

Snapshot Log property sheet

: General page, 11-30

Snapshot Logs container

: about, 11-29

Snapshots container

: about, 11-31

SNMP

: and agents, 6-3

software distribution process

: about, 15-9
: creating releases, 15-10
: creating software packages, 15-10
: specifying distribution hosts, 15-9
: using the Oracle Enterprise Manager job system, 15-11

software package

: and the software distribution process, 15-10
: definition, 15-10

Software Packages Catalog window, 15-7

Space Management event, 5-5

specifying service names, 1-17, 1-19

split (new) view

: Navigator, 2-7

splitting the Navigator tree, 2-4, 2-7

: new view, 2-7

SPOOL command, B-31

: long lines of text, B-32

spooling multiple log files, B-6

spreadsheets, 7-14

: DBA tools, 7-14

SQL

: showing generated, 7-14

SQL statements

: showing, 7-14

SQL Worksheet

: about, 7-6, 13-2
: connecting from, 13-8
: Edit menu, 13-5
: entering commands, 13-6
: executing commands, 13-8
: executing commands in, 13-6
: File menu, 13-4
: input pane, 13-7
: recovering a database, 13-9, 13-11
: running scripts from, 13-13
: starting, 13-2
: using, 13-2
: Worksheet menu, 13-5

SQL worksheet

: saving work, 13-12

SQL* Net V2.3

: communications, 6-5

SQL*DBA and Server Manager

: differences, C-1

SQL*Net

: specifying service names, 1-17

SQL*Net installation, 1-6

SQL*Net network

: services, 2-4

SQL*Net V1

: communications, 6-5

starting Enterprise Manager, 1-15

starting up a database, 10-7, 12-11

STARTUP command, B-32

Startup Database, 12-8

status

: of a map object, 3-4
: of a registered event set, 5-3

Storage Manager

: about, 7-6

summary of the pending jobs

: Active Jobs page, 4-5

supported Oracle releases, 1-2

Switch Logfile, 12-9

Synonyms container

: about, 11-34
: creating a synonym, 11-35

Synonyms folder, 11-13

SYS username

: CONNECT INTERNAL, B-8

SYSDBA

: role, 3-5

SYSDBA roles

: connect as, 1-18

SYSOPER

: role, 3-5

SYSOPER role

: connect as, 1-18

System Global Area (SGA)

: displaying, B-28

T

tables

: DESCRIBE command, B-10

Tables container, 11-36

: creating a table, 11-37

Tablespace

: menu, 8-3

Tablespace container

: multi-column list, 8-4

Tablespace folder

: about, 8-4

Tablespace folders

: about, 12-3
: multi-column list, 12-4

Tablespaces

: dropping, 8-8

tablespaces

: adding a datafile to, 8-8
: adding rolback segments, 8-9
: backing up, 12-12
: creating, 8-5
: creating a backup script, 8-10
: editiing, 8-7
: making read-only, 8-9
: making writeable, 8-10
: placing online, 8-9
: recovering, B-14
: taking offline, 8-9

Tablespaces folder

: taking tablespace offline, 8-9

Tablespaces folders

: multi-column list, 12-4

Take Tablespace Offline, 12-9

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

third-party applications

: notifications, 6-7

timing

: CPU and elapsed, B-25, B-28

toolbar

: icons, 1-13
: options, 1-13

Tools menu, 1-12

topology file, 1-6

: populating the Navigator, 2-4
: providing network information, 1-6

transactions

: committing at disconnect, B-12

Transactions container

: about, 10-16

Transactions folder

: forcing a commit, 10-18
: forcing a rollback, 10-18
: object list, 10-17

Transparent Network Substrate (TNS)

: and communication daemon, 6-5

Triggers container

: about, 11-41
: creating a trigger, 11-42

troubleshooting

: job and event operations, 6-10

U

User

: create like, 9-9

user preferences

: jobs, 4-3, 4-12
: when running jobs, 4-3, 4-12

user-defined groups

: in the Navigator, 2-5
: job destinations, 4-11
: Navigator tree, 2-3

user-defined map views

: creating, 3-3

Username, 1-19

usernames, B-7

Users

: menu, 9-3

users

: altering, 9-10
: assigning profile to, 9-22
: creating, 9-5

Users container

: creating a user, 9-5

Users Containers

: about, 9-4

Users folder

: adding privileges or roles to a user, 9-11
: altering a user, 9-10
: dropping a user, 9-10
: removing privileges or roles from a user, 9-12 to 9-13

V

VARIABLE command, B-36

View menu, 7-8

Views container

: about, 11-45
: creating a view, 11-45

W

window titles, 1-18

windows

: Catalog, 15-7
: Navigator, 15-6
: Releases Catalog, 15-7
: Software Packages, 15-7

Worksheet menu, 13-5

World folder icon, 15-7

Library

Product

Contents

Index