Index

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

A

adding nodes

quick-start, 10.2, 11.2

Additional Real Application Clusters documentation, 2.1

ADDM

see Automatic Database Diagnostic Monitor

administering

services, 6.7

services with SRVCTL, 6.8.4

administering instances

with Server Management, 9.1

administering services

DBCA, 6.8

Enterprise Manager, 6.8

PL/SQL, 6.8

SRVCTL, 6.8

administration

overview, 2.3

tools, 2.3

administrative tools

overview and concepts, 1.9.2

Advanced Queuing

and FAN, 6.3.1

affinity

awareness, 8.5.5

alert administration

Enterprise Manager, 9.4.2

alert blackouts

Enterprise Manager, 9.4.3

alert log

managing, A.3.1

alert logs, A.3.2

alerts

performance monitoring, 13.7.2.2

ALTER SYSTEM ARCHIVE LOG CURRENT statement, 9.5.1

ALTER SYSTEM ARCHIVE LOG statement, 9.5.1

INSTANCE option, 9.5.1

ALTER SYSTEM CHECKPOINT LOCAL statement, 9.5.1

ALTER SYSTEM CHECKPOINT statement

global versus local, 9.5.1

specifying an instance, 9.5.1

ALTER SYSTEM statement

CHECKPOINT clause, 9.5.1

ALTER SYSTEM SWITCH LOGFILE statement, 9.5.1, 9.5.1

architecture

of RAC, 1.3

ARCHIVE LOG command, 9.5.1

archive logs

file format and destination, 7.6

file naming, 7.5

archiver process

monitor, 7.8.1

archiving mode

changing, 7.8

archiving redo log files

identified in control file, 4.1.2

log sequence number, 7.6

ASM

archiving scenario, 7.7.1

installation

Real Application Clusters, introduction to, 2.6

see Automatic Storage Management

asm

as SRVCTL noun, E.7.2

Automatic Database Diagnostic Monitor, 13.6.2, 13.6.3.2, 13.6.5

automatic segment-space management, 2.11.3, 12.2.1

Automatic Storage Management, 2.11.3, 4.1

see ASM

Automatic Storage Management (ASM), 1.3

Automatic Storage Management instance, 4.2.1

automatic undo management, 2.11.3

Automatic Workload Repository, 2.11.4, 6.9, 12.1.3, 12.1.3, 13.5, 13.6.3.2

snapshots, 13.5

AVAILABLE instances

for services, 6.2.1

Average Active Sessions chart

Enterprise Manager, 13.7.4.3

AWR

see Automatic Workload Repository

B

background process

crsd, 1.2.2.1

evmd, 1.2.2.1

ocssd, 1.2.2.1

oprocd, 1.2.2.1

background processes

SMON, 5.2, 8.5.1

background thread trace files, A.3.1.1

BACKGROUND_DUMP_DEST parameter, A.3.1.1, A.3.2

backups

server parameter file, 5.7

bandwidth

interconnect, 13.2

block mode conversions

statistics for, 13.4.1

blocks

associated with instance, 8.5.1

buffer cache, 1.3.1

instance recovery, 8.5.1

buffer sizes

IPC, adjusting for Real Application Clusters, 13.2.1

C

Cache Fusion, 1.3.1

and e-commerce applications, 15.2

function, 2.10.1

overview, 1.9.4

callouts

how they are run, 6.3.3

CATCLUST.SQL script

using to create views for Real Application Clusters, 13.3

CLB_GOAL_LONG, 6.2.3

CLB_GOAL_SHORT, 6.2.3

client

application environments and FAN, 6.5

clients

integrated for FAN events, 6.3.1

client-side

load balancing, 6.2.3

client-side load balancing, 6.2.3

cloning, 1.7

CLSD-1009 message

resolving, 3.2.4

CLSD-1011 message

resolving, 3.2.4

cluster

definition of, 1.1

Cluster Database Home Page

Enterprise Manager, 9.3.2

Cluster Database Instance page

Enterprise Manager, 9.3.3

Cluster Database Instance Performance page

Enterprise Manager, 13.7.5

Cluster Database Performance page

Enterprise Manager, 13.7.6

cluster file system

archiving parameter settings, 7.7.1.2

archiving scenario, 7.7.1

overview, 2.11.2

restore, 8.2.1

storage in Real Application Clusters, 4.1

Cluster Home page

Enterprise Manager, 9.3.5

Cluster Host Load Average chart

Enterprise Manager, 13.7.4.1

Cluster Interconnects page

Enterprise Manager, 13.7.7

Cluster Managed Database Services Detail Page

Enterprise Manager, 6.8.1.3

Cluster Managed Database Services Page

Enterprise Manager, 6.8.1.2

Cluster Manager (CSS)

log files, A.2.9.3

Cluster Ready Services, 2.11.5.1

Cluster Ready Services Control

see CRSCTL

Cluster Synchronization Service (CSS), 1.2.1

Cluster Synchronization Services (CSS)

purpose, 1.2.1

Cluster Verification Utility

cluster integrity verifications, A.4.3.8

connectivity verifications, A.4.3.3

installation requirements, A.4.1

installation verifications, A.4.3.6

known issues, A.4.4

node comparisons and verifications, A.4.3.5

nodelist shortcuts, A.4.2.3

Oracle Clusterware component verifications, A.4.3.7

performing various tests with, A.4.3

see CVU

storage verifications, A.4.3.2

system requirements verifications, A.4.3.1

user and permissions verifications, A.4.3.4

using, A.4

using online help for, A.4.2.1

verbose mode, A.4.2.2

CLUSTER_INTERCONNECTS

parameter, 13.2.1

CMAN session pools

and FAN, 6.5

committed data

instance failure, 8.5.1

communication protocols

verifying settings for, 13.2

configuration problems

reinitializing the OCR, 3.2.5

CONNECT command, 5.1.2, 9.5.1, 9.5.1

CONNECT SYS

example of, 5.2.2

connecting

to instances, 5.1.2

connection load balancing

concepts, 1.5

introduction to, 6.1

long method, 6.2.3

short method, 6.2.3

connection pools

and FAN, 6.5

consistent blocks, 1.3.1

control files

MAXLOGHISTORY, 4.1.2

CREATE DATABASE statement

MAXLOGHISTORY clause, 4.1.2

Create Services Page

Enterprise Manager, 6.8.1.4

creating

server parameter files, 5.4, 5.7

services, 6.7

crs_getperm, B.2.1

CRS_HOME, 1.6.1

crs_profile, B.2.2

crs_register, B.2.3

crs_relocate, B.2.4

crs_setperm, B.2.5.1

crs_start, B.2.7

crs_stat, B.2.6

crs_stop, B.2.8.1

crs_unregister, B.2.9

CRSCTL

overview and concepts, 1.9.2

crsd, 1.2.2.1

purpose, 1.2.2.1

current blocks, 1.3.1

CVU

concepts, 1.6.1

overview and concepts, 1.9.2

D

data dictionary

querying views, 13.3

Data Guard, 2.11.6.3

data security

wallet, 15.4.1

data warehouse

deploying applications for in Real Application Clusters, 15.3

database

as SRVCTL noun, E.7.2

creation, 1.6.2

number of archived log files, 4.1.2

quiescing, 9.6

Database Configuration Assistant

Database Storage page, 10.9.2, 11.9.2

Instance Management page, 10.9.2, 11.9.2

List of Cluster Databases page, 10.9.2, 11.9.2

Operations page, 10.9.2, 11.9.2

see DBCA

Summary dialog, 10.9.2, 11.9.2

Welcome page, 10.9.2, 11.9.2

Database Configuration Assistant (DBCA)

creating views for Real Application Clusters, 13.3

Database Locks page

Enterprise Manager, 13.7.4.9

Database Storage page, 10.9.2, 11.9.2

Database Throughput chart

Enterprise Manager, 13.7.4.4

Databases Overview page

Enterprise Manager, 9.3.4

Databases Summary page

Enterprise Manager, 9.3.1

DBCA, 1.6.2

adding and deleting instances in silent mode, 10.9.3, 11.9.3

service administration, 6.8.2

DBMS_SERVICE, 12.1.3

degree of parallelism (DOP), 15.3.2

deleting nodes

quick-start, 10.2, 11.2

dependencies

and services, 6.2.1

design

Real Application Clusters environments, 1.9.1

DISCONNECT command, 5.1.2

disconnecting from instances, 5.1.2

Distributed Transaction Processing, 12.2.4

distributed transactions, 12.2.4

and services in RAC, 6.6

documentation

Real Application Clusters, 2.1

DTP, 12.2.4

DTP/XA transactions, 6.6

dynamic performance views

creating, 13.3

for performance monitoring, 13.3

dynamic resource allocation

overview, 1.9.4

E

e-commerce

applications in Real Application Clusters, 15.2

Enterprise Manager, 5.1.1, 9.1

administering services, 6.8.1

alert administration, 9.4.2

alert blackouts, 9.4.3

Average Active Sessions chart, 13.7.4.3

Cluster Database Home Page, 9.3.2

Cluster Database Instance page, 9.3.3, 13.7.6

Cluster Database Instance Performance page, 13.7.5

Cluster Home page, 9.3.5

Cluster Host Load Average chart, 13.7.4.1

Cluster Interconnects page, 13.7.7

Database Locks page, 13.7.4.9

Database Throughput chart, 13.7.4.4

Databases Overview page, 9.3.4

Databases Summary page, 9.3.1

Global Cache Block Access Latency chart, 13.7.4.1

Global Cache Coherency chart, 13.7.4.2

Instance Activity page, 13.7.4.7

Instance page, 9.3.3

job administration, 9.4.1

overview, 2.7, 2.9

overview and concepts, 1.9.2

performance monitoring, 13.7.1

services pages, accessing, 6.8.1.5

Top Consumers page, 13.7.4.5

Top Segments page, 13.7.4.8

Top Sessions page, 13.7.4.6

Enterprise Manager Database Control

overview, 2.9

Enterprise Manager Grid Control

instance discovery, 9.2

node discovery, 9.2

overview, 2.9

error messages

for management tools, C, F

PRKA, F.2

PRKC, F.3

PRKD, F.4

PRKE, F.5

PRKH, F.6

PRKI, F.7

PRKN, F.8

PRKO, F.9

PRKP, F.10

PRKR, F.11

PRKS, F.12

PRKU, F.13

PRKV, C.1, F.14

Event Management (EVM), 1.2.1

purpose, 1.2.1

Event Manager (EVM)

log files, A.2.9.4

evmd, 1.2.2.1

purpose, 1.2.2.1

F

failover

and Real Application Clusters, 2.11.5.2

failure

instance, 8.5

multiple node, 8.5.2

node, 8.5.1

Fast Application Notification, 6.3

and HA events, 6.3.5

callouts, how to use, 6.3.6

callouts,definition of, 6.3.6

events, enabling for JDBC, 6.5.1

events, enabling for OCI, 6.5.2

events, enabling for ODP.NET, 6.5.3

events, enabling ODP.NET clients, 6.5.4

how events are published, 6.3.1

introduction to, 6.1

overview of, 6.3.1

see FAN

uses of, 6.3.1

Fast Connection Failover

introduction to, 6.1

features

taking advantage of, 2.10

features, new, Preface

files

archiving redo log, 7.6

control file, 4.1.2

redo log, 7.6

G

Global Cache Block Access Latency chart

Enterprise Manager, 13.7.4.1

Global Cache Coherency chart

Enterprise Manager, 13.7.4.2

Global Cache Service (GCS), 1.3.1

Global Cache Service statistics, 13.6.1, 13.6.3.1

GLOBAL clause

forcing a checkpoint, 9.5.1

Global Enqueue Service (GES), 1.3.1

Global Enqueue Service statistics, 13.6.1

Global Resource Directory (GRD), 1.3.1

global service name, 12.1.1

goals

and the load balancing advisory, 6.4.1

for load balancing advisory, 6.4.2

GV$ACTIVE_SERVICES, 12.1.4

GV$SVCMETRIC, 12.1.4

H

H.A.R.D.

implementing for the OCR, 3.2.6

hash partitioning

with Real Application Clusters, 1.9.1

high availability

and Oracle Clusterware, 1.2.1

and Real Application Clusters, 2.11.5.2

high availability framework

concepts, 1.5

introduction to, 6.1

HOST command, 9.5.1, 9.5.1

I

initdb_name.ora file

BACKGROUND_DUMP_DEST parameter, A.3.1.1, A.3.2

USER_DUMP_DEST parameter, A.3.1.2

initialization parameters

cluster database issues regarding, 5.6

CLUSTER_INTERCONNECTS, 13.2.1

RECOVERY_PARALLELISM, 8.7.2.1

that must be identical on all instances, 5.5.1

that must be unique on all instances, 5.5.2

INST_ID column, 13.3

installation

introduction, 1.6

Oracle Clusterware, 1.6.1

Real Application Clusters, 1.6.2

instance

as SRVCTL noun, E.7.2

Instance Activity page

Enterprise Manager, 13.7.4.7

instance addition

quick-start, 10.2, 11.2

instance deletion

quick-start, 10.2, 11.2

instance discovery

Enterprise Manager Grid Control, 9.2

Instance Management page, 10.9.2, 11.9.2

INSTANCE option, 9.5.1

Instance page

Enterprise Manager, 9.3.3

INSTANCE_NUMBER parameter, 5.5.2

instances

failure, 8.5.2

failures, recovery from, 8.5

maximum number for RAC, 1.3

memory structures, 1.3.1

recovery, 5.2, 8.5.1

recovery, abnormal shutdown, 5.2

recovery, multiple failures, 8.5.2

Server Management, 9.1

shutting down, 5.2

verifying, 9.5.2, 9.5.2, 9.5.2

interconnect

and performance, 13.2.1

and the RAC architecture, 1.3

bandwidth, 13.2

protocols for Real Application Clusters, 13.2

verifying settings for, 13.2

IP address

installation requirements, 1.6.1

IPCs

buffer sizes, adjusting, 13.2.1

J

java-based tools

tracing, A.3.3

JDBC

and FAN, 6.5

thick clients, 6.5.1.1

thin clients, 6.5.1.1

job administration

Enterprise Manager, 9.4.1

L

LCK0 Instance Enqueue Process, 1.3.1

List of Cluster Databases page, 10.9.2, 11.9.2

LMD Global Enqueue Service Daemon, 1.3.1

LMOM Global Enqueue Service Monitor, 1.3.1

LMS Global Cache Service Process, 1.3.1

load balancing

by services, 1.3

server-side, 6.2.3

Load Balancing Advisory, 6.7

load balancing advisory

and FAN events, 6.4.3

concepts, 1.5

configuring your environment for using, 6.4.2

description of, 6.4

events and FAN, 6.3.1

introduction to, 6.1

local archiving scenario

RMAN, 7.7.2

Local Area Network (LAN), 1.3

LOCAL clause

forcing a checkpoint, 9.5.1

local file system

archiving parameter settings, 7.7.2.2

restore, 8.2.2

log files

for CSS, A.2.9.3

for EVM, A.2.9.4

for OCR, A.2.9.2

for Oracle Clusterware, A.2.9.1, A.2.9.1

log sequence numbers, 7.6

log switches, 4.1.2

LOG_ARCHIVE_FORMAT parameter, 7.6

M

mass deployment

cloning, 1.7

MAXLOGHISTORY option, 4.1.2

media failures

recovery from, 8.6

membership

and the OCR, 1.4.1

memory structures

in RAC, 1.3.1

message request counters, 13.4.1

messages

errors for management tools, C, F

metrics

performance monitoring, 13.7.2.1

mirroring

Oracle Cluster Registry, 3.2.1

modified data

instance recovery, 8.5.1

monitoring

archiver process, 7.8.1

overview and concepts, 1.9.3

statistics for Real Application Clusters, 13.4

multiple node failures, 8.5.2

multiple nodes

starting from one node, 5.2.2

multiplexed redo log files, 4.1.2

multiplexing

OCR, 1.4.1

N

Net Configuration Assistant

see NETCA

NETCA, 1.6.2

Network Attached Storage (NAS), 1.3.1

network file system, 1.3

network interfaces

defining with OIFCFG, 9.7.1

new features, Preface

node

failure and VIPs, 1.3

node addition

quick-start, 10.2, 11.2

node deletion

quick-start, 10.2, 11.2

node discovery

Enterprise Manager Grid Control, 9.2

nodeapps

as SRVCTL noun, E.7.2

nodes

affinity awareness, 8.5.5

failure of, 8.5.1

O

objects

creation of and effect on performance, 12.2.2

OCI Session Pools

and FAN, 6.5

OCR

installation, 1.6.1

redundancy, 1.6.1

OCR Configuration Tool, D.1

see OCRCONFIG

OCRCHECK

diagnosing OCR problems with, 3.2.3

using, 3.2.3.2

OCRCONFIG

overview and concepts, 1.9.2

ocrconfig command, D.1

ocrconfig -export, D.1

ocrconfig -option, D.1

OCRDUMP

diagnosing OCR problems with, 3.2.3

using, 3.2.3.1

using to view OCR content, A.2.10.1

ocrdump command, A.2.10.1.2, A.2.10.1.2, A.2.10.1.2, A.2.10.1.2

ocssd, 1.2.2.1

purpose, 1.2.2.1

ODP.NET

and FAN, 6.5

and FAN events, 6.5.3

and FCF, 6.5.3

load balancing advisory events, 6.5.4

OIFCFG, 9.7

commands, 9.7.2, 9.7.2

defining network interfaces, 9.7.1

if_name element, 9.7.2

if_type element, 9.7.2

nodename element, 9.7.2

overview and concepts, 1.9.2

subnet element, 9.7.2

syntax, 9.7.2

online recovery, 8.5.1

online transaction processing

applications in Real Application Clusters, 15.2

operating system-specific Oracle documentation

archived redo log name, 7.6

Operations page, 10.9.2, 11.9.2

oprocd, 1.2.2.1

purpose, 1.2.2.1

Oracle Cluster File System (OCFS), 1.3

Oracle Cluster Registry

adding, 3.2.1, 3.2.1.1

contents, 3.2

data loss protection mechanism, overriding, 3.2.4

diagnosing problems with OCRDUMP and OCRCHECK, 3.2.3

downgrading, 3.2.7

exporting, 3.2.5

implementing H.A.R.D., 3.2.6

importing, 3.2.5

importing on UNIX-based systems, 3.2.5.1

importing on Windows-based systems, 3.2.5.2

managing backups, 3.2.2

recovering using OCR backup files, 3.2.2

removing, 3.2.1, 3.2.1.4

repairing, 3.2.1, 3.2.1.3

replacing, 3.2.1, 3.2.1.2

restoring on UNIX-based systems, 3.2.2.1.1

restoring on Windows-based systems, 3.2.2.1.2

restoring using automatically generated OCR backups, 3.2.2.1

see OCR

troubleshooting, A.2.10

upgrading, 3.2.7

Oracle Cluster Registry (OCR), 1.4.1

log files, A.2.9.2

managing, 3.2

purpose, 1.2

Oracle Clusterware

architecture, 1.2

cloning, 1.7

command examples, 14.4

commands, B.2

component processing, 1.2.1

enabling and disabling startup using crsctl commands, A.2.4

event manager alerts, A.2.6

high availability framework, 1.4.2

installation overview, 1.6.1

introduction, 2.7, 14

introduction and concepts of, 1

log files and their locations, A.2.9

overview, 14.2

startup and shutdown using crsctl commands, A.2.3

UNIX processes, 1.2.2.1

working with Oracle Clusterware commands, 14.6

Oracle Clusterware home

adding to a new node, 10.2.1

adding, silent mode, 10.2.1.2

deleting in silent mode, 10.2.4.2

deleting manually, 10.2.4

Oracle Clusterware management

overview and concepts, 1.9.2

Oracle home

adding in silent mode, 10.2.2.2

adding manually, 10.2.2.1

cloning, 1.7

deleting, 10.2.3

deleting manually, 10.2.3.1, 10.2.3.2

Oracle Interface Configuration Tool

see OIFCFG

Oracle Interface Configuration tool

see OIFCFG

Oracle Net Services

and load balancing, 6.5

and services, 6.2.1

Oracle Notification Service (ONS)

purpose, 1.2.1

Oracle Notification Services

API, 6.3.1

Oracle Real Application Clusters

overview of administration, 1, 2

Oracle Streams Advanced Queuing

and FAN, 6.3.1

Oracle Universal Installer

see OUI

ORACLE_HOME, 1.6.2

ORACLE_SID parameter, 5.5.2

OracleCRService

purpose, 1.2.2.2

OracleCSService

purpose, 1.2.2.2

OracleEVMService

purpose, 1.2.2.2

OraFenceService

purpose, 1.2.2.2

OUI

database installation, 1.6.2

Oracle Clusterware installation, 1.6.1

Real Application Clusters installation, 1.6.2

outages

planned, 6.3.4

unplanned, 6.3.3

P

parallel instance groups, 15.3.3

parallel recovery, 8.7.2.1

PARALLEL_MAX_SERVERS parameter, 8.7.2.1

parallelism

in Real Application Clusters, 15.3.2

parallel-aware query optimization, 15.3.1

parameter file

overview, 5.4

parameters

that must be identical on all instances, 5.5.1

that must be unique on all instances, 5.5.2

performance

primary components affecting, 13.2

performance evaluation

overview and concepts, 1.9.4

performance monitoring

alerts, 13.7.2.2

Enterprise Manager, 13.7.1

metrics, 13.7.2.1

thresholds, 13.7.2.3

PL/SQL

administering services, 6.8.3

PREFERRED

instances for services, 6.2.1

private interconnect

and Oracle Clusterware, 1.2

PRKA messages, F.2

PRKC messages, F.3

PRKD messages, F.4

PRKE messages, F.5

PRKH messages, F.6

PRKI messages, F.7

PRKN messages, F.8

PRKO messages, F.9

PRKP messages, F.10

PRKR messages, F.11

PRKS messages, F.12

PRKU messages, F.13

PRKV messages, C.1, F.14

Process Monitor Daemon (OPROCD)

purpose, 1.2.1

Q

quiesce database

in Real Application Clusters, 9.6

R

RAC

cloning, 1.7

software components, 1.3.1

RACAD6012|crs_register, B.2.3

RACG

purpose, 1.2.1

raw devices, 1.3

Real Application Clusters

and e-commerce, 15.2

installation overview, 1.6.2

RECOVER command, 9.5.1, 9.5.1

recovery

after SHUTDOWN ABORT, 5.2

from multiple node failure, 8.5.2

from single-node failure, 8.5.1

instance, 5.2

media failures, 8.6

online, 8.5.1

parallel, 8.7.2.1

PARALLEL_MAX_SERVERS parameter, 8.7.2.1

Recovery Manager

see RMAN

RECOVERY_PARALLELISM parameter, 8.7.2.1

redo log files

identified in control file, 4.1.2

instance recovery, 8.5.1

log sequence number, 7.6

using, 4.1.2

redo log groups, 4.1.2

redo logs

format and destination specifications, 7.6

Resource Manager

and services, 6.2.1

resource manager, 12.1.3

resource profiles

and service creation, 6.2.1

attributes, 14.3.1.1

resources

releasing, 8.5.1

restore scenarios

RMAN, 8.2

restore scheme

cluster file system, 8.2.1

local file system, 8.2.2

RMAN

in Real Application Clusters, 2.11.6.2

local archiving scenario, 7.7.2

overview

restore scenarios, 8.2

rolling back

instance recovery, 8.5.1

Runtime Connection Load Balancing, 6.2.1

runtime connection load balancing

introduction to, 6.1

S

scalability

adding nodes and instances, 10.3, 10.4, 11.3, 11.4

adding nodes and instances, quick-start format, 10.2, 11.2

security

wallet, 15.4.1

sequence numbers

with Real Application Clusters, 1.9.1

sequences

log sequence number, 7.6

Server Control

see SRVCTL

Server Control Utility (SRVCTL), 1.4.1

Server Management

administration of instances, 9.1

server parameter file, 2.11.3

backing up, 5.7

setting values in, 5.4.1

server parameter files

creating, 5.4, 5.7

service

as SRVCTL noun, E.7.2

dependencies, 6.2.1

DTP property, 6.6

levels, 6.9.1

SERVICE TIME

load balancing advisory goal, 6.4.2

SERVICE_NAMES

parameter, 6.8.2.2

services, 2.11.4, 12.1.1

administering, 6.7

administering with DBCA, 6.8

administering with Enterprise Manager, 6.8

administering with PL/SQL, 6.8

administering with SRVCTL, 6.8, 6.8.4

and distributed transactions, 6.6

basic concepts about, 6.2.1

concepts, 1.5

configurations for, 12.1.2

configuring workload management characteristics, 6.7

default, 6.2.2

introduction to, 1.3, 6.1

names, limitations for, 6.8.2.2

using, 6.2.1

sessions

multiple, 5.1.2

setting instances, 5.1.2

shared everything, 1.3

SHOW INSTANCE command, 9.5.1, 9.5.1

SHOW PARAMETER command, 9.5.1

SHOW PARAMETERS command, 9.5.1

SHOW SGA command, 9.5.1, 9.5.1

SHUTDOWN ABORT command, 5.2

SHUTDOWN command, 9.5.1

ABORT option, 5.2

SHUTDOWN TRANSACTIONAL, 5.2

shutting down

instances, 5.2

shutting down an instance

abnormal shutdown, 5.2

shutting down instances, 5.2

sidalrt.log file, A.3.2

siddbwr.trc file, A.3.1.1

sidsmon.trc file, A.3.1.1

single system image, 1.3.1

single-instance Oracle databases

how they differ from RAC, 1.3

singleton services, 6.6

SMON process

instance recovery, 8.5.1, 8.5.2

recovery after SHUTDOWN ABORT, 5.2

snapshot control file, 7.2

SPFILE

restore with Enterprise Manager, 8.2.3

restore with RMAN, 8.2.3

split brain syndrome, 1.2

SQL statements

instance-specific, 9.5.1

SQL*Plus, 5.1.2, 9.5

SRVCTL

add asm command, E.7.3.5.1

add database command, E.7.3.1.1

add instance command, E.7.3.2.1

add nodeapps command, E.7.3.4.1

add service command, E.7.3.3.2

add, usage description, E.7.3

administering services with, 6.8.4

cluster database configuration tasks, E.3

cluster database tasks, E.4

concurrent commands, E.1.1

config asm command, E.7.4.4.1, E.7.4.5.1

config database command, E.7.4.1.1

config nodeapps command, E.7.4.3.1

config service command, E.7.4.2.1

config, usage description, E.7.4

disable asm command, E.7.6.4.1

disable database command, E.7.6.1.1

disable instance command, E.7.6.2.1

disable service command, 6.8.4.3, E.7.6.3.1

disable, usage description, E.7.6

enable asm command, E.7.5.4.1

enable database command, E.7.5.1.1

enable instance command, E.7.5.2.1

enable service command, 6.8.4.3, E.7.5.3.1

enable, usage description, E.7.5

getenv database command, E.7.12.1.2

getenv instance command, E.7.12.2.1

getenv nodeapps command, E.7.12.4.1

getenv service command, E.7.12.3.1

getenv, usage description, E.7.12

modify database command, E.7.9.1.1

modify instance command, E.7.9.2.1

modify nodeapps command, E.7.9.4.1

modify service command, E.7.9.3.1

modify, usage description, E.7.9

node-level tasks, E.5

overview, 5.1.3

overview and concepts, 1.9.2

relocate service command, E.7.10.1.1

relocate, usage description, E.7.10

remove asm command, E.7.14.5.1

remove database command, E.7.14.1.1

remove instance command, E.7.14.2.1

remove nodeapps command, E.7.14.4.1

remove service command, E.7.14.3.1

remove, usage description, E.7.14

setenv database command, E.7.13.1.2

setenv instance command, E.7.13.2.1

setenv nodeapps command, E.7.13.4.2

setenv service command, E.7.13.3.1

setenv, usage description, E.7.13

start asm command, E.7.7.5.1

start database command, 5.2.3, E.7.7.1.1

start instance command, 5.2.3, E.7.7.2.1

start listener command, E.7.7.6.1

start nodeapps command, E.7.7.4.1

start service command, 6.8.4.2, 6.8.4.2, E.7.7.3.1

start, usage description, E.7.7

status asm command, E.7.11.5.1

status database command, E.7.11.1.1

status instance command, E.7.11.2.1

status nodeapps command, E.7.11.4.1

status service command, 6.8.4.5, E.7.11.3.1

status, usage description, E.7.11

stop asm command, E.7.8.5.1

stop database command, 5.2.3, E.7.8.1.1

stop instance command, 5.2.3, E.7.8.2.1

stop listener command, E.7.8.6.1

stop nodeapps command, E.7.8.4.1

stop service command, E.7.8.3.1

stop, usage description, E.7.8

unsetenv database command, E.7.13.5.2

unsetenv instance command, E.7.13.6.1

unsetenv nodeapps command, E.7.13.8.1

unsetenv service command, E.7.13.7.2

unsetenv, usage description, E.7.13

Standard Edition

ASM

standby databases, 2.11.6.3

STARTUP command, 9.5.1

statistics

contents of, 13.4.1

monitoring for Real Application Clusters, 13.4

Statspack, 13.6, 13.6.1

storage, 2.11.3

basic RAC requirements for, 1.3

cluster file system, 4.1

Real Application Clusters, introduction to, 2.6

Summary dialog, 10.9.2, 11.9.2

SYSAUX tablespace, 12.2.3

SYSDBA

privilege for connecting, 5.1.2

SYSOPER privilege

for connecting, 5.1.2

system change, 7.6

System Global Area (SGA), 1.3.1

size requirements, 1.3.1

T

TCP/IP, 1.3

THREAD parameter, 5.6

thresholds

performance monitoring, 13.7.2.3

services, 6.9.1

THROUGHPUT

load balancing advisory goal, 6.4.2

timed statistics, 13.4.1

timeout

messages, avoiding, 1.3

Top Consumers page

Enterprise Manager, 13.7.4.5

Top Segments page

Enterprise Manager, 13.7.4.8

Top Sessions page

Enterprise Manager, 13.7.4.6

trace files, A.3.1.1

background thread trace files, A.3.1.1

managing, A.3.1

sidalrt.log, A.3.2

siddbwr.trc file, A.3.1.1

sidsmon.trc file, A.3.1.1

tracing

enabling for RAC high availability, A.2.11

java-based tools, A.3.3

transactions

instance failure, 8.5.1

rolling back, 8.5.1

waiting for recovery, 8.5.1

Transparent Application Failover

and services, 6.2.3

Transparent Database Encryption, 15.4.1

troubleshooting, A.3.1

tuning

overview, 1.9.4

U

UNDO_TABLESPACE parameter, 5.5.2

unified log directory structure, A.2.9

User Datagram Protocol (UDP)

and the private interconnect, 1.2

user trace files, A.3.1.2

USER_DUMP_DEST parameter, A.3.1.2

V

V$ACTIVE_INSTANCES, 9.5.2, 9.5.2

V$ACTIVE_SERVICES, 12.1.4

V$SERVICEMETRIC_HISTORY, 12.1.4

V$SESSION, 12.1.4

V$SQL, 12.1.4

vendor clusterware, 1.1

verification

datafiles, online files, 4.1.1

views

creating for Real Application Clusters, 13.3

for performance monitoring, 13.3

VIP addresses, 1.3

configuring, 1.3

virtual host name, 1.3

virtual IP address, 1.6.1

volume manager

alternate storage method for RAC, 1.3

Voting Disk, 1.4.1

voting disk

administering, 3.1

backing up, 3.1.1

dynamically adding, 3.1.3

installation, 1.6.1

purpose, 1.2

recovering, 3.1.2

redundancy, 1.6.1

voting disks

multiple, 1.4.1

redundancy, 1.4.1

W

wait events, 13.6.1

wallet

data security, 15.4.1

Welcome page, 10.9.2, 11.9.2

Workload Management

concepts, 1.5

workload management, 12.1.1

basic concepts about, 6.2.1

introduction to, 6.1

manual re-balancing, 12.1.3

workloads

and services, 6.2.1

X

XA transactions, 12.2.4