Index

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

Symbols

$ORACLE_HOME/root.sh script, 7.3.2

A

ACMS

Atomic Controlfile to Memory Service, 1.3.4

Active Session History, Oracle RAC, 11.8.1

Active Session History, Top Cluster Events, 11.8.2

Active Session History, Top Remote Instance, 11.8.3

ACTIVE_INSTANCE_COUNT initialization parameter, 3.6.1

add node

ASM instances for shared storage, 9.2.3

using NETCA to add a listener, 9.2.4.1

adding a node

root.sh script, 9.2.4.1, 9.2.4.1

ADDM

global monitoring, 11.7

see Automatic Database Diagnostic Monitor

ADDM for Oracle Real Application Clusters mode, 11.7

administering

services, 4.10

services with SRVCTL, 4.11.3

administering instances

with Server Management, 3.1

administering services

DBCA, 4.11

Enterprise Manager, 4.11

PL/SQL, 4.11

SRVCTL, 4.11

administrative tools

overview and concepts, 1.6.2

SYSASM privilege, 3.2.2

ADRCI

ADR Command-Line Interpreter, Preface, B.2

Advanced Queuing

and FAN, 4.4.1

affinity

awareness, 6.3.5

aggregates

by instances, 11.1.1.3

by services, 11.1.1.3

by waits, 11.1.1.3

alert administration

Enterprise Manager, 3.10.2.2

alert blackouts

Enterprise Manager, 3.10.2.3

alert logs, B.3

managing, B.1

ALTER SYSTEM ARCHIVE LOG CURRENT statement, 3.1.2.2

ALTER SYSTEM ARCHIVE LOG statement, 3.1.2.2

INSTANCE option, 3.1.2.2

ALTER SYSTEM CHECKPOINT LOCAL statement, 3.1.2.2

ALTER SYSTEM CHECKPOINT statement

global versus local, 3.1.2.2

specifying an instance, 3.1.2.2

ALTER SYSTEM KILL SESSION statement

terminating a session on a specific instance, 3.4

ALTER SYSTEM QUIESCE RESTRICTED statement

quiescing a single-instance database, 3.7

ALTER SYSTEM statement

CHECKPOINT clause, 3.1.2.2

ALTER SYSTEM SWITCH LOGFILE statement, 3.1.2.2, 3.1.2.2

applications

consolidating multiple in a single database, 10.1.2

highly available, 10.1

scalability, 10.1.3

spanning XA transactions across Oracle RAC instances, 4.8

using pre-created database sessions, 4.6.3

AQ_HA_NOTIFICATIONS parameter

enabling event notification, 4.6.3

ARCHIVE LOG command

SQL*Plus, 3.1.2.2

ARCHIVE_LAG_TARGET initialization parameter, 3.6.1, 3.6.3

archived redo log files

file format and destination, 5.7

file naming, 5.6

log sequence number, 5.7

archiver process

monitor, 5.10

archiving mode

changing, 5.9

ASH reports, 11.8.1

ASM

see Automatic Storage Management (ASM)

asm

SRVCTL object noun name, A.7.2

ASM instances

administering with SRVCTL, 2.6.9

ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter, Preface, 2.6.5, 3.6

Atomic Controlfile to Memory Service (ACMS), 1.3.4

Automatic Database Diagnostic Monitor, 11.9.2, 11.9.3.2, 11.9.5

Automatic Database Diagnostic Monitor (ADDM), 1.6.3

analyzing AWR data, 11.7

Automatic Database Diagnostic Monitoring (ADDM), 11.7

Automatic Diagnostic Repository (ADR)

ADRCI command-line interpreter, Preface, B.2

automatic load balancing

configuring RMAN channels for multiple instances, 5.5

automatic segment space management (ASSM), 10.3.1

automatic segment-space management

tablespace use in Oracle RAC, 10.3.1

Automatic Storage Management (ASM), 2.6.1

archiving scenario, 5.8.1

ASM preferred read failure groups, Preface, 2.6.5

cloning, 7

converting single-instance ASM to clustered ASM, 2.6.6

converting single-instance to a cluster storage manager, 2.6.6

creating instances with DBCA, 7.3.1

installation, 1.5.2

instance creation on newly added nodes, 7, 9.2.3

preferred mirror read disks, 2.6.5

preferred read, Preface

preferred read disks, 3.6

rolling upgrade, Preface, 2.6.4

rolling upgrades, Preface

storage solution, 1.3.1, 2.1

SYSASM privilege, 3.2.2

automatic undo management

tablespace use in Oracle RAC, 10.3.1

automatic workload management

concepts, 1.4, 4.3.1

description, 4.1

manual rebalancing, 4.1

Automatic Workload Repository, 4.1, 4.1, 4.2, 4.12, 11.7, 11.9.3.2

snapshots, 11.7

Automatic Workload Repository (AWR)

monitoring performance, 4.3.1

AVAILABLE instances

for services, 4.3.1

Average Active Sessions chart

performance monitoring, 11.1.1.3

AWR

see Automatic Workload Repository

B

background processes

Oracle RAC, 1.3.4

SMON, 3.2, 6.3.1

background thread trace files, B.1

backups

server parameter file, 3.5.3

bandwidth

interconnect, 11.2

benefits

of cloning Oracle Clusterware, 7.1

best practices

deploying Oracle RAC for high availability, 10.1.1

block mode conversions

statistics for, 11.6

blocks

associated with instance, 6.3.1

buffer cache, 1.3.3

instance recovery, 6.3.1

buffer sizes

IPC, adjusting for Oracle Real Application Clusters, 11.3

C

Cache Fusion, 1.3.3

and e-commerce applications, 10.3.5

overview, 1.6.4

callouts

how they are run, 4.4.3

capacity

increasing, 10.1.3

catclustdb.sql script, 1.6.3

CATCLUST.SQL script

using to create views for Oracle Real Application Clusters, 11.5

channels

configure one RMAN channel for each Oracle RAC instance, 5.5.2

configuring during crosscheck or restore operations, 5.4

configuring for RMAN, 5.5

chart

Global Cache Block Access Latency, 11.1.1.3

charts

Average Active Sessions, 11.1.1.3

Cluster Host Load Average, 11.1.1.3

Database Throughput, 11.1.1.3

CLB_GOAL_LONG, 4.3.3

CLB_GOAL_SHORT, 4.3.3, 4.4.1

client

application environments and FAN, 4.6

clients

integrated for FAN events, 4.4.1

JDBC thick, 4.6.1.1

JDBC thin, 4.6.1.1

client-side

load balancing, 4.3.3

client-side load balancing, 4.3.3

clone.pl script

cloning parameters, 7.3.1, 7.3.2

environment variables, 7.3.1, 7.3.2

cloning, 1.5.3, 7, 7.2

benefits, 7.1

deployment phase, 7.3

LD_LIBRARY_PATH environment variable, 7.3.1, 7.3.2

log files, 7.4

parameters passed to the clone.pl script, 7.3.1, 7.3.2

preparation phase, 7.2

running $ORACLE_HOME/root.sh script, 7.3.2

setting ORACLE_BASE, 7.3.1, 7.3.2

setting ORACLE_HOME, 7.3.1, 7.3.2

setting ORACLE_HOME_NAME, 7.3.1, 7.3.2

cluster

definition of, 1.1

Cluster Database Home Page, 11.1.1.1

Cluster Database Performance page

Top Activity drill down menu, 11.1.1.3

cluster file system

archiving parameter settings, 5.8.1.2

archiving scenario, 5.8.1

restore, 6.2.1

storage in Real Application Clusters, 2.1

Cluster Host Load Average page

cluster database performance, 11.1.1.3

Cluster Managed Database Services Detail Page

Enterprise Manager, 4.11.1.3

Cluster Managed Database Services Page

Enterprise Manager, 4.11.1.2

CLUSTER NODE NAME parameter

FAN, and matching database signature, 4.4.5

cluster nodes name

in clone.pl script, 7.3.1, 7.3.2

Cluster Ready Services (CRS)

described, 1.2

CLUSTER_DATABASE initialization parameter, 3.6, 3.6.1

CLUSTER_DATABASE_INSTANCE initialization parameter, 3.6.1

CLUSTER_DATABASE_INSTANCES initialization parameter, 3.6

CLUSTER_INTERCONNECTS

parameter, 11.3

CLUSTER_INTERCONNECTS parameter

examples, 3.8.2, 3.8.2

recommendations for using, 3.8.1

CLUSTER_NODES parameter

in clone.pl script, 7.3.1, 7.3.2

clustered ASM

converting a single-instance ASM, 2.6.6

clusters

cloning

important considerations, 8.1

consolidating multiple databases in, 10.1.2

clusterware management solution, 1.2

CLUSTERWIDE_DISTRIBUTED_TRANSACTIONS initialization parameter

spanning XA transactions across Oracle RAC instances, Preface

CMAN session pools

and FAN, 4.6

command-line interpreter

ADR Command-Line Interpreter (ADRCI), Preface, B.2

committed data

instance failure, 6.3.1

communication protocols

verifying settings for, 11.2

compatibility

Oracle RAC and Oracle Database software, 1.5.1

COMPATIBLE initialization parameter, 3.6.1

configuring channels

during restore or crosscheck operations, 5.4

configuring preferred mirror read disks in extended clusters, 2.6.5

CONNECT command, 3.1.2, 3.1.2.2

SQL*Plus, 3.1.2.2

CONNECT SYS

example of, 3.2.2

connecting

to instances, 1.6.2, 3.1.2

connection failover callback, 4.7

connection load balancing

concepts, 1.4

introduction to, 4.1

long method, 4.3.3

short method, 4.3.3

connection pools

and FAN, 4.6

consistent blocks, 1.3.3

CONTROL_FILES initialization parameter, 3.6.1

CREATE PFILE

FROM MEMORY clause, 3.5

Create Services Page

Enterprise Manager, 4.11.1.4

CREATE SPFILE

FROM MEMORY clause, 3.5

CREATE_SERVICE procedure

DBMS_SERVICE PL/SQL package, 4.11.2

creating

server parameter files, 3.5, 3.5.3

services, 4.10

crosscheck operations

configuring channels during, 5.4

crosschecking on multiple nodes

RMAN backups, 5.4

CRS resources

management of, 1.2

current blocks, 1.3.3

CVU

overview and concepts, 1.6.2

D

data dictionary

querying views, 11.5

data security

wallet, 10.3.8.1

data warehouse

deploying applications for in Oracle Real Application Clusters, 10.3.7

database

creation, 1.5.2

quiescing, 3.7

SRVCTL object noun name, A.7.2

Database Configuration Assistant (DBCA), 1.5.2

adding and deleting instances in silent mode, 9.2.5.2

cloning Oracle RAC instances, 7.3.2

creating views for Oracle Real Application Clusters, 11.5

Database Storage page, 9.2.5.1

Instance Management page, 9.2.5.1

List of Cluster Databases page, 9.2.5.1

Operations page, 9.2.5.1

running the catclustdb.sql script, 1.6.3

Summary dialog, 9.2.5.1

Welcome page, 9.2.5.1

database signatures

matching the FAN parameters, 4.4.5

Database Storage page, 9.2.5.1

Database Throughput page

performance monitoring, 11.1.1.3

DATABASE UNIQUE NAME parameter

FAN, and matching database signature, 4.4.5

databases

consolidating multiple in a cluster, 10.1.2

controlling restarts, 3.9

scalability, 10.1.3

databases sessions

pre-created, 4.6.3

Datagram Protocol (UDP), 1.3.2, B.6

DB_BLOCK_SIZE initialization parameter, 3.6.1

DB_DOMAIN initialization parameter, 3.6.1

DB_FILES initialization parameter, 3.6.1

DB_NAME initialization parameter, 3.6, 3.6.1

DB_RECOVERY_FILE_DEST initialization parameter, 3.6.1

DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 3.6.1

DB_UNIQUE_NAME initialization parameter, 3.6.1

DBCA

creating ASM instances, 7.3.1

see Database Configuration Assistant (DBCA)

DBMS_SERVICE, 4.1

DBMS_SERVICE package

procedures for administering services, 4.11.2

DBMS_SERVICE.GOAL_SERVICE_TIME procedure

service goal, 4.6.3

DBMS_SERVICE.MODIFY_SERVICE procedure

enabling event notification, 4.6.3

default database service, 1.5.2, 3.6, 4.10

degree of parallelism (DOP), 10.3.7.2

DELETE_SERVICE procedure

DBMS_SERVICE PL/SQL package, 4.11.2

dependencies

and services, 4.3.1

deploying

Oracle RAC database software, 7.3.2

Oracle Real Application Clusters environments, 1.6.1, 10

design

Oracle Real Application Clusters environments, 1.6.1, 10

diagnosing problems using ADR, B.2

DIAGNOSTIC_DEST parameter, B.1

DISCONNECT command, 3.1.2

DISCONNECT_SESSION procedure

DBMS_SERVICE PL/SQL package, 4.11.2

disconnecting from instances, 3.1.2

DISPATCHERS initialization parameter, 3.6

specifying a service with, 4.10

distributed SQL transactions, 4.8

Distributed Transaction Processing, 4.8, 10.3.4

distributed transactions, 4.8, 10.3.4

directing to a single instance in the cluster, 4.8

services in Oracle RAC, 4.8

XA transactions span instances, Preface, 4.8

DML_LOCKS initialization parameter, 3.6.1

DTP, 4.8, 10.3.4

DTP Service., 4.8

DTP/XA transactions, 4.8

dynamic performance views

creating, 11.5

for performance monitoring, 11.4

dynamic resource allocation

overview, 1.6.4

E

e-commerce

applications in Oracle Real Application Clusters, 10.3.5

ENCRYPTION_WALLET_LOCATION parameter, 10.3.8.1

Enterprise Manager, 3.1.1

administering services, 4.11.1

alert administration, 3.10.2.2

alert blackouts, 3.10.2.3

Cluster Database page, Preface, 11.1.1

job administration, 3.10.2.1

overview, 1.2

overview and concepts, 1.6.2

services pages, accessing, 4.11.1.5

Enterprise Manager Grid Control

instance discovery, 3.10.1

node discovery, 3.10.1

environment variables

passed to the clone.pl script, 7.3.1, 7.3.2

error messages

for management tools, C

PRKA, C.2

PRKC, C.3

PRKD, C.4

PRKE, C.5

PRKH, C.6

PRKI, C.7

PRKN, C.8

PRKO, C.9

PRKP, C.10

PRKR, C.11

PRKS, C.12

PRKU, C.13

PRKV, C.14

event notification

enabling, 4.6.3

examples

setting the CLUSTER_INTERCONNECTS parameter, 3.8.2

extended distance cluster

ASM preferred mirror read, Preface, 2.6.5

extended distance clusters

configuring preferred mirror read disks, 2.6.5

external transaction managers

OraMTS, 4.8

F

failover callback routine, 4.7

failure

instance, 6.3

multiple node, 6.3.2

node, 6.3.1

failure events

calling routines with SQL_ORCLATTR_FAILOVER_CALLBACK, 4.7

identifying with the fo_code parameter, 4.7

FAN events

enabling for JDBC, 4.6.1.1

Fast Application Notification (FAN), 4.4

and high availability events, 4.4.5

callouts definition, 4.4.6

callouts, how to use, 4.4.6

events, enabling for JDBC clients, 4.6.1

events, enabling for OCI, 4.6.2

events, enabling for ODP.NET, 4.6.4

events, enabling ODP.NET clients, 4.6.5

how events are published, 4.4.1

introduction, 4.1

overview, 4.4.1

parameters and matching database signatures, 4.4.5

uses, 4.4.1

Fast Connection Failover

enabling JDBC clients, 4.6.1

enabling with thin and thick clients, 4.6.1.1

introduction to, 4.1

fault diagnosability, B.2

features, new, Preface

files

archived redo log files, 5.7

redo log, 5.7

fo_code parameter

identifying failure events, 4.7

FROM MEMORY clause

on CREATE PFILE or CREATE SPFILE, 3.5

G

GC_SERVER_PROCESSES initialization parameter

specifying the number of LMSn processes, 10.1.2

GCS_SERVER_PROCESSES initialization parameter, 3.6

Global ADDM mode, 11.7

Global Cache Block Access Latency

performance monitoring, 11.1.1.3

Global Cache Service (GCS), 1.3.3

Global Cache Service Process (LMS), 1.3.4

Global Cache Service Processes (LMSn)

reducing the number of, 10.1.2, 10.1.2

specifying the number of, 10.1.2

Global Cache Service statistics, 11.9.1, 11.9.3.1

GLOBAL clause

forcing a checkpoint, 3.1.2.2

Global Enqueue Service (GES), 1.3.3

Global Enqueue Service Daemon (LMD), 1.3.4

Global Enqueue Service Monitor (LMON), 1.3.4

Global Enqueue Service statistics, 11.9.1

global performance data

with ADDM, 11.7

Global Resource Directory (GRD), 1.3.3

Global Services Daemon (GSD), 1.2

Global Transaction Process (GTX0-j), 1.3.4

GLOBAL_TXN_PROCESSES initialization parameter, 4.8

goals

and the load balancing advisory, 4.5.1

for load balancing advisory, 4.5.2

GTX0-j

Global Transaction Process, 1.3.4

GV$SESSION dynamic performance view, 3.4

H

hardware-security module (HSM) devices

used by wallets, 10.3.8.1

hash partitioning

with Oracle Real Application Clusters, 10.2

high availability

best practices, 10.1.1

for Oracle RAC Databases, 10.1

high availability framework

concepts, 1.4

introduction to, 4.1

HOST command, 3.1.2.2

SQL*Plus, 3.1.2.2

I

initdb_name.ora file

DIAGNOSTIC_DEST parameter, B.1

initialization parameters

cluster database issues regarding, 3.6

CLUSTER_INTERCONNECTS, 11.3

RECOVERY_PARALLELISM, 6.5.2.1

settings for instances, 3.5

that must be identical on all instances, 3.6.1

that must be unique on all instances, 3.6.2

INST_ID column, 11.4

installation

introduction, 1.5

Oracle Real Application Clusters, 1.5.2

installations

performing multiple simultaneous cluster, 7

instance

SRVCTL object noun name, A.7.2

instance discovery

Enterprise Manager Grid Control, 3.10.1

Instance Enqueue Process (LCK0), 1.3.4

Instance Management page, 9.2.5.1

INSTANCE NAME initialization parameter, 3.6

INSTANCE option, 3.1.2.2

INSTANCE parameter

FAN, and matching database signature, 4.4.5

INSTANCE_NAME initialization parameter, 3.6.2

INSTANCE_NUMBER initialization parameter, 3.6.2

INSTANCE_TYPE initialization parameter, 3.6.1

instances

aggregated for service performance, 11.1.1.3

cloning Oracle RAC, 7.3.2

effect of SQL*Plus commands on, 3.1.2.2

failure, 6.3.2

failures, recovery from, 6.3

initialization parameter settings, 3.5

maximum number for Oracle RAC, 1.1

memory structures, 1.3.3

parallel processes, 4.10

private interconnect usage, B.6

recovery, 3.2, 6.3.1

recovery, abnormal shutdown, 3.2

recovery, multiple failures, 6.3.2

Server Management, 3.1

shutting down, 3.2

terminating session on, 3.4

verifying, 3.3, 3.3, 3.3

instead of Statspack, 1.6.3

interconnect

and performance, 11.3

and the Oracle RAC architecture, 1.1, 1.3.1

bandwidth, 11.2

protocols for Oracle Real Application Clusters, 11.2

verifying settings for, 11.2

interconnects

alternatives to the private network, 3.8

private, B.6

Interconnects page

monitoring clusterware with Oracle Enterprise Manager, 11.1.1

monitoring Oracle Clusterware, 11.1.1.2

IPCs

buffer sizes, adjusting, 11.3

J

Java

enabling tools for tracing, B.4

Java Database Connectivity (JDBC) clients

ONS usage, 4.3.1

JDBC

and FAN, 4.6

enabling FAN events for, 4.6.1.1

thick clients, 4.6.1.1, 4.6.1.1

thin clients, 4.6.1.1

JDBC clients

enabling for Fast Connection Failover, 4.6.1

job administration

Enterprise Manager, 3.10.2.1

job scheduling

with Oracle Scheduler, Preface

K

KILL SESSION clause

on the ALTER SYSTEM statement, 3.4

L

LCK0 Instance Enqueue Process, 1.3.4

LD_LIBRARY_PATH environment variable

setting during cloning, 7.3.1, 7.3.2

LICENSE_MAX_USERS initialization parameter, 3.6.3

List of Cluster Databases page, 9.2.5.1

listener object

SRVCTL object noun name, A.7.2

listeners

adding during add node, 9.2.4.1

creating during cloning, 7.3.1

Oracle Net, 1.2

removing with srvctl remove listener command, A.7.14.6

LMD Global Enqueue Service Daemon, 1.3.4

LMON Global Enqueue Service Monitor, 1.3.4

LMS Global Cache Service Process, 1.3.4

LMS processes

reducing the number of, 10.1.2

LMSn processes

reducing the number of, 10.1.2

load balancing

by services, 1.3.2

OCI runtime connection, 4.6.3

OCI runtime connection load balancing, Preface

server-side, 4.3.3

Load Balancing Advisory, 4.10

load balancing advisory

and FAN events, 4.5.3

concepts, 1.4

configuring your environment for using, 4.5.2

deployment, 4.5.1

description of, 4.5

events and FAN, 4.4.1

introduction to, 4.1

Local ADDM mode, 11.7

local archiving scenario

RMAN, 5.8.2

Local Area Network (LAN), 1.3.2

LOCAL clause

forcing a checkpoint, 3.1.2.2

local file system

archiving parameter settings, 5.8.2.2

restore, 6.2.2

local node name

in clone.pl script, 7.3.1, 7.3.2

LOCAL_NODE parameter

in clone.pl script, 7.3.1, 7.3.2

location transparency

using service names, 4.10

log files

tracing, B.4

log sequence numbers, 5.7

LOG_ARCHIVE_FORMAT initialization parameter, 3.6.3

LOG_ARCHIVE_FORMAT parameter, 5.7

M

mass deployment

cloning, 1.5.3, 7, 7.2

media failures

recovery from, 6.4

memory structures

in Oracle RAC, 1.3.3

message request counters, 11.6

messages

errors for management tools, C

migration

application, 10.1.3

mission critical systems

considerations for Oracle RAC, 10.1

modified data

instance recovery, 6.3.1

MODIFY_SERVICE procedure

DBMS_SERVICE PL/SQL package, 4.11.2

monitoring

archiver process, 5.10

overview and concepts, 1.6.3

performance of global cache block access, 11.1.1.3

statistics for Oracle Real Application Clusters, 11.6

monitoring host load average, 11.1.1.3

multiple node failures, 6.3.2

multiple nodes

starting from one node, 3.2.2

multiplexed redo log files, 2.4

N

Net Configuration Assistant

see NETCA

Net Configuration Assistant (NETCA)

adding a listener, 9.2.4.1

NETCA, 1.5.2

creating listeners during cloning, 7.3.1

Network Attached Storage (NAS), 1.3.2

network file system, 1.3.1

new features, Preface

NIC bonding, 3.8

node

failure and VIP addresses, 1.3.2

node discovery

Enterprise Manager Grid Control, 3.10.1

nodeapps

SRVCTL object noun name, A.7.2

nodes

affinity awareness, 6.3.5

failure of, 6.3.1

virtual IP addresses, A.5

nosharedhome argument, 9.3.2

O

objects

creation of and effect on performance, 10.3.2

srvctl nouns and abbreviations, A.7.2

OCI environment

to receive service metrics, 4.6.3

OCI session pooling, 4.6.3

OCI Session Pools

and FAN, 4.6

OCI session pools

optimizing, 4.6.3

runtime connection load balancing, 4.6.3

service metrics, 4.6.3

OCI_EVENTS mode

setup for runtime connection load balancing, 4.6.3

OCI_SPC_NO_RLB mode parameter

setting for runtime connection load balancing, 4.6.3

OCI_THREADED mode

setup for runtime connection load balancing, 4.6.3

OCISessionPoolCreate()

setting OCI_SPC_NO_RLB mode parameter, 4.6.3

ocr.loc file

on a shared file system, 9.3.2

ODBC applications

calling SQL_ORCLATTR_FAILOVER_HANDLE attribute, 4.7

ODBC_FO_ABORT failure event, 4.7

ODBC_FO_BEGIN failure event, 4.7

ODBC_FO_END failure event, 4.7

ODBC_FO_ERROR failure event, 4.7

ODBC_FO_REAUTH failure event, 4.7

ODP.NET

and FAN, 4.6

and FAN events, 4.6.4

and Fast Connection Failover, 4.6.4

load balancing advisory events, 4.6.5

OIFCFG command-line interface

run during add node, 9.2.4.1, 9.2.4.1

online recovery, 6.3.1

online transaction processing

applications in Oracle Real Application Clusters, 10.3.5

Operations page, 9.2.5.1

Oracle Call Interface (OCI)

runtime connection load balancing, Preface, 4.6.3

Oracle Cluster File System (OCFS), 1.3.1

configuring when extending Oracle RAC, 9.2.3

Oracle Clusterware

cloning, 1.5.3

controlling database restarts, 3.9

described, 1.2

introduction, 1.2

introduction and concepts of, 1

managing Oracle processes, 1.2

Oracle Enterprise Manager

adding database instances to nodes, 9.2.5

Automatic Database Diagnostic Monitoring (ADDM), 11.7

Cluster Database Performance page

Cluster Database Performance page, Preface, 11.1.1.3

deleting database instances from nodes, 9.3.1

Interconnects page, 11.1.1.2

using the Interconnects page to monitor Oracle Clusterware, 11.1.1

Oracle home

adding in silent mode, 9.2.4.2

cloning, 1.5.3

Oracle Maximum Availability Architecture (MAA), 10.1

Oracle Net

listeners, 1.2

Oracle Net Services

and load balancing, 4.6

and services, 4.3.1

Oracle Notification Service (ONS), 1.2

used by FAN, 4.3.1

Oracle Notification Services

API, 4.4.1

Oracle processes

managed by Oracle Clusterware, 1.2

Oracle RAC

cloning, 1.5.3, 7

software components, 1.3.3

Oracle RAC Management Processes (RMSn), 1.3.4

Oracle Real Application Clusters

and e-commerce, 10.3.5

installation overview, 1.5.2

overview of administration, 1

Oracle Scheduler

advanced job scheduling, Preface

Oracle Streams Advanced Queuing

and FAN, 4.4.1

ORACLE_BASE environment variable, 7.3.1, 7.3.2

ORACLE_HOME, 1.5.2

ORACLE_HOME environment variable, 7.3.1, 7.3.2

ORACLE_HOME_NAME environment variable, 7.3.1, 7.3.2

ORACLE_SID parameter, 3.6.2

OracleCRService resource

after cluster node restart, 3.2

OracleDBConsolesid

restarting after a cluster node restart, 3.2

OraMTS

external transaction manager, 4.8

OUI

database installation, 1.5.2

Oracle Real Application Clusters installation, 1.5.2

outages

planned, 4.4.4

unplanned, 4.4.3

P

parallel instance groups, 4.10

parallel processes, 4.10

parallel recovery, 6.5.2.1

PARALLEL_INSTANCE_GROUPS initialization parameter

parallel processes, 4.10, 4.10

PARALLEL_MAX_SERVERS initialization parameter, 3.6.1

PARALLEL_MAX_SERVERS parameter, 6.5.2.1

parallelism

in Oracle Real Application Clusters, 10.3.7.2

parallel-aware query optimization, 10.3.7.1

parameter file

overview, 3.5

parameters

that must be identical on all instances, 3.6.1

that must be unique on all instances, 3.6.2

Partial ADDM mode, 11.7

performance, 11.1.1.3

aggregates by services, 11.1.1.3

comprehensive global data, 11.7

monitoring activity by wait events, services, and instances, 11.1.1.3

monitoring database throughput, 11.1.1.3

monitoring global cache block access, 11.1.1.3

monitoring potential problems in the database, 11.1.1.3

primary components affecting, 11.2

service aggregates by instances, 11.1.1.3

service aggregates by waits, 11.1.1.3

using ADDM, 1.6.3

performance evaluation

overview and concepts, 1.6.4

phases

cloning deployment, 7.3

cloning preparation, 7.2

PL/SQL

administering services, 4.11.2

PREFERRED instances

for services, 4.3.1

preferred read disks

ASM in an Oracle RAC extended distance cluster, Preface, 2.6.5

private interconnect

determining usage, B.6

private network

alternative interconnect, 3.8

PRKA messages, C.2

PRKC messages, C.3

PRKD messages, C.4

PRKE messages, C.5

PRKH messages, C.6

PRKI messages, C.7

PRKN messages, C.8

PRKO messages, C.9

PRKP messages, C.10

PRKR messages, C.11

PRKS messages, C.12

PRKU messages, C.13

PRKV messages, C.14

processes

managed by Oracle Clusterware, 1.2

parallel, 4.10

Q

queue

access using service names, 4.10

quiesce database

in Oracle Real Application Clusters, 3.7

quiescing

single-instance database, 3.7

R

raw device storage

configuring when extending Oracle RAC, 9.2.3

raw devices, 1.3.1

rconfig command

converting ASM single-instance, 2.6.6

rebalancing

workloads, 4.1

RECOVER command, 3.1.2.2

SQL*Plus, 3.1.2.2

recovery

after SHUTDOWN ABORT, 3.2

from multiple node failure, 6.3.2

from single-node failure, 6.3.1

instance, 3.2

media failures, 6.4

online, 6.3.1

parallel, 6.5.2.1

PARALLEL_MAX_SERVERS initialization parameter, 6.5.2.1

RECOVERY_PARALLELISM parameter, 6.5.2.1

redo log files

instance recovery, 6.3.1

log sequence number, 5.7

using, 2.4

redo log groups, 2.4

redo logs

format and destination specifications, 5.7

REMOTE_LOGIN_PASSWORD_FILE initialization parameter, 3.6.1

Resource Manager

and services, 4.3.1

resource manager, 4.1

resource profiles

and service creation, 4.3.1

resources

releasing, 6.3.1

response file

cloning, 7.3.1

restore scenarios

RMAN, 6.2

restore scheme

cluster file system, 6.2.1

local file system, 6.2.2

RESULT_CACHE_MAX_SIZE initialization parameter, 3.6, 3.6.1

RMAN

configuring channels, 5.4

configuring channels to use automatic load balancing, 5.5

configuring one channel for each instance, 5.5.2

crosschecking on multiple nodes, 5.4

local archiving scenario, 5.8.2

restore scenarios, 6.2

RMSn Oracle RAC Management Processes, 1.3.4

rolling back

instance recovery, 6.3.1

rolling upgrades

ASM, Preface

ASM software, Preface, 2.6.4

root.sh script

$ORACLE_HOME, 7.3.2

issues the oifcfg command during add node, 9.2.4.1, 9.2.4.1

RSMN background process, 1.3.4

Runtime Connection Load Balancing, 4.3.1

runtime connection load balancing

defined, 4.6.3

disabling, 4.6.3

in OCI session pools, 4.6.3

introduction to, 4.1

S

scalability

adding nodes and instances, 9.2

Oracle RAC, 10.1.3

scheduler

jobs, Preface

scripts

$ORACLE_HOME/root.sh, 7.3.2

security

wallet, 10.3.8.1

sequence numbers

with Oracle Real Application Clusters, 10.2

sequences

log sequence number, 5.7

Server Control

see SRVCTL

Server Management

administration of instances, 3.1

server parameter file

backing up, 3.5.3

setting values in, 3.5.1

server parameter files

creating, 3.5, 3.5.3

servers

scalability, 10.1.3

service

dependencies, 4.3.1

levels, 4.13

SRVCTL object noun name, A.7.2

service level objective

defining for Oracle RAC, 10.1

service metrics

OCI runtime connection load balancing, Preface, 4.6.3

runtime connection load balancing, 4.6.3

SERVICE parameter

FAN, and matching database signature, 4.4.5

SERVICE TIME

load balancing advisory goal, 4.5.2

SERVICE_NAMES initialization parameter, 3.6

setting for services, 3.6, 4.10

services

access to a queue, 4.10

activity levels aggregated by instances, 11.1.1.3

activity levels aggregated by services, 11.1.1.3

activity levels aggregated by waits, 11.1.1.3

administering, 4.10

administering with DBCA, 4.11

administering with Enterprise Manager, 4.11

administering with PL/SQL, 4.11

administering with PL/SQL DBMS_SERVICE package, 4.11.2

administering with SRVCTL, 4.11, 4.11.3

basic concepts about, 4.3.1

concepts, 1.4

configuring automatic workload management characteristics, 4.10

default, 4.3.2

introduction to, 1.3.2, 4.1

performance monitored by AWR, 4.3.1

SERVICE_NAMES parameter, 3.6, 4.10

specifying a service, 4.10

using, 4.3.1

sessions

multiple, 3.1.2

terminating on a specific instance, 3.4

SESSIONS_PER_USER initialization parameter, 3.6

setting attributes for SQLSetConnectAttr function, 4.7

setting instances, 1.6.2, 3.1.2

shared everything, 1.3.1

shared storage

configuring when extending Oracle RAC, 9.2.3

sharedhome argument, 9.3.2

SHOW INSTANCE command, 3.1.2.2

SQL*Plus, 3.1.2.2

SHOW PARAMETER command

SQL*Plus, 3.1.2.2

SHOW PARAMETERS command, 3.1.2.2

SHOW SGA command, 3.1.2.2

SQL*Plus, 3.1.2.2

SHUTDOWN ABORT command, 3.2

SHUTDOWN command

ABORT option, 3.2

SQL*Plus, 3.1.2.2

SHUTDOWN TRANSACTIONAL, 3.2

shutting down

instances, 3.2

shutting down an instance

abnormal shutdown, 3.2

shutting down instances, 3.2

sidalrt.log file, B.3

single system image, 1.3.3

single-instance ASM

converting to clustered ASM, 2.6.6

single-instance databases

quiescing, 3.7

SMON process

instance recovery, 6.3.1, 6.3.2

recovery after SHUTDOWN ABORT, 3.2

snapshot control file, 5.2

SPFILE

restore with Enterprise Manager, 6.2.3

restore with RMAN, 6.2.3

SPFILE initialization parameter, 3.6, 3.6.3

SQL statements

executing in parallel, 4.10

instance-specific, 3.1.2.2

SQL*Plus, 3.1.2

changing the prompt, 3.1.2.1

SQL*Plus commands

effect on instances, 3.1.2.2

SQL_ORCLATTR_FAILOVER_CALLBACK attribute

of the SQLSetConnectAttr function, 4.7

SQL_ORCLATTR_FAILOVER_HANDLE attribute

of the SQLSetConnectAttr function, 4.7

SQLSetConnectAttr function

setting attributes in the sqora.h file, 4.7

SQL_ORCLATTR_FAILOVER_CALLBACK attribute, 4.7

SQL_ORCLATTR_FAILOVER_HANDLE attribute, 4.7

sqora.h file, 4.7

SRVCTL

add asm command, A.7.3.5.1

add database command, A.7.3.1.1

add instance command, A.7.3.2.1

add listener command

listeners, A.7.3.5.2, A.7.3.6.2

add nodeapps command, A.7.3.4.1

add service command, A.7.3.3.2

add, usage description, A.7.3

administering ASM instances, 2.6.9

administering services with, 4.11.3

cluster database configuration tasks, A.3

cluster database tasks, A.4

concurrent commands, A.1.1

config asm command, A.7.4.4.1, A.7.4.5.1

config database command, A.7.4.1.1

config nodeapps command, A.7.4.3.1

config service command, A.7.4.2.1

config, usage description, A.7.4

disable asm command, A.7.6.4.1

disable database command, A.7.6.1.1

disable instance command, A.7.6.2.1

disable service command, 4.11.3.3, A.7.6.3.1

disable, usage description, A.7.6

enable asm command, A.7.5.4.1

enable database command, A.7.5.1.1

enable instance command, A.7.5.2.1

enable service command, 4.11.3.3, A.7.5.3.1

enable, usage description, A.7.5

getenv database command, A.7.12.1.2

getenv instance command, A.7.12.2.1

getenv nodeapps command, A.7.12.4.1

getenv service command, A.7.12.3.1

getenv, usage description, A.7.12

modify database command, A.7.9.1.1

modify instance command, A.7.9.2.1

modify listener command, A.7.9.5.1

modify nodeapps command, A.7.9.4.1

modify service command, A.7.9.3.1

modify, usage description, A.7.9

node-level tasks, A.5

object noun names, A.7.2

overview, 3.1.3

overview and concepts, 1.6.2

relocate service command, A.7.10.1.1

relocate, usage description, A.7.10

remove asm command, A.7.14.5.1

remove database command, A.7.14.1.1

remove instance command, A.7.14.2.1

remove nodeapps command, A.7.14.4.1

remove service command, A.7.14.3.1

remove, usage description, A.7.14

setenv database command, A.7.13.1.2

setenv instance command, A.7.13.2.1

setenv nodeapps command, A.7.13.4.2

setenv service command, A.7.13.3.1

setenv, usage description, A.7.13

start asm command, A.7.7.5.1

start database command, 3.2.3, A.7.7.1.1

start instance command, 3.2.3, A.7.7.2.1

start listener command, A.7.7.6.1

start nodeapps command, A.7.7.4.1

start service command, 4.11.3.2, 4.11.3.2, A.7.7.3.1

start, usage description, A.7.7

status asm command, A.7.11.5.1

status database command, A.7.11.1.1

status instance command, A.7.11.2.1

status nodeapps command, A.7.11.4.1

status service command, 4.11.3.5, A.7.11.3.1

status, usage description, A.7.11

stop asm command, A.7.8.5.1

stop database command, 3.2.3, A.7.8.1.1

stop instance command, 3.2.3, A.7.8.2.1

stop listener command, A.7.8.6.1

stop nodeapps command, A.7.8.4.1

stop service command, A.7.8.3.1

stop, usage description, A.7.8

unsetenv database command, A.7.13.5.2

unsetenv instance command, A.7.13.6.1

unsetenv nodeapps command, A.7.13.8.1

unsetenv service command, A.7.13.7.2

unsetenv, usage description, A.7.13

srvctl remove listener command, A.7.14.6

SRVM_TRACE environment variable, B.4

Standard Edition

installing ASM, 1.5.2

START_SERVICE procedure

DBMS_SERVICE PL/SQL package, 4.11.2

STARTUP command

SQL*Plus, 3.1.2.2

statistics

contents of, 11.6

monitoring for Oracle Real Application Clusters, 11.6

Statspack, 11.9, 11.9.1

usage, 1.6.3

STOP_SERVICE procedure

DBMS_SERVICE PL/SQL package, 4.11.2

storage

cluster file system, 2.1

Oracle Real Application Clusters introduction, 2.6.1

storage devices

configuring when extending Oracle RAC, 9.2.3

subnet

configuring for virtual IP address, A.5

Summary dialog, 9.2.5.1

SYS$BACKGROUND service, 4.3.2

SYS$USERS service, 4.3.2

SYSASM privilege, 3.2.2

SYSAUX tablespace, 10.3.3

SYSDBA

privilege for connecting, 3.1.2

SYSOPER privilege

for connecting, 3.1.2

system change, 5.7

System Global Area (SGA), 1.3.3

size requirements, 1.3.3

T

tablespaces

automatic segment-space management in Oracle RAC, 10.3.1

automatic undo management in Oracle RAC, 10.3.1

use in Oracle RAC, 10.3.1

TCP/IP, 1.3.2

THREAD initialization parameter, 3.6

threads

multiple application, 4.6.3

thresholds

services, 4.13

THROUGHPUT

load balancing advisory goal, 4.5.2

timed statistics, 11.6

timeout

messages, avoiding, 1.3.2

Top Activity drill down menu

on the Cluster Database Performance page, 11.1.1.3

Top Cluster Events, ASH report, 11.8.2

Top Remote Instance, ASH report, 11.8.3

trace files, B.1

managing, B.1

sidalrt.log, B.3

TRACE_ENABLED initialization parameter, 3.6.3

tracing

enabling Java tools, B.4

SRVM_TRACE environment variable, B.4

writing to log files, B.4

transactions

instance failure, 6.3.1

rolling back, 6.3.1

waiting for recovery, 6.3.1

Transparent Application Failover

and services, 4.3.3

Transparent Data Encryption, 10.3.8.1

specifying the ENCRYPTION_WALLET_LOCATION parameter, 10.3.8.1

specifying the WALLET_LOCATION parameter, 10.3.8.1

Transparent Database Encryption, 10.3.8.1

tuning

overview, 1.6.4

using ADDM, 1.6.3

U

UNDO_MANAGEMENT initialization parameter, 3.6.1

UNDO_RETENTION initialization parameter, 3.6.3

UNDO_TABLESPACE parameter, 3.6.2

upgrades

ASM rolling upgrades, Preface, 2.6.4

V

V$ACTIVE_INSTANCES, 3.3, 3.3

vendor cluster file systems

configuring when extending Oracle RAC, 9.2.3

vendor clusterware, 1.1

verification

datafiles, online files, 2.3

versions

compatibility for Oracle RAC and Oracle Database software, 1.5.1

views

creating for Oracle Real Application Clusters, 11.5

for performance monitoring, 11.4

VIP addresses, 1.3.2

configuring, 1.3.2

virtual host name, 1.3.2

Virtual Internet Protocol (VIP) address, 1.2

virtual IP address

requirements, A.5

volume manager

alternate storage method for Oracle RAC, 1.3.1

W

wait events, 11.9.1

aggregated for service performance, 11.1.1.3

wallet

data security, 10.3.8.1

WALLET_LOCATION parameter, 10.3.8.1

wallets

for Transparent Data Encryption, 10.3.8.1

Welcome page, 9.2.5.1

workload

balancing with Oracle Scheduler, Preface

workload management

See automatic workload management

workloads

and services, 4.3.1

X

XA transactions, 4.8, 10.3.4

spanning Oracle RAC instances, Preface, 4.8