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

A

abnormal instance termination, 3.2.1

ACMS

Atomic Controlfile to Memory Service, 1.3.4

Active Session History, Oracle RAC, 13.8.1

Active Session History, Top Cluster Events, 13.8.2

Active Session History, Top Remote Instance, 13.8.3

active sessions, 13.8.1

ACTIVE_INSTANCE_COUNT initialization parameter, 3.6

adding nodes to an existing cluster, 9.1

adding Oracle RAC to nodes on Linux and UNIX, 10.1

adding Oracle RAC to nodes on Windows, 11.1

ADDM

global monitoring, 13.7

see Automatic Database Diagnostic Monitor

ADDM for Oracle Real Application Clusters mode, 13.7

administering

services, 5.9.1

services with SRVCTL, 5.9.3

administering instances

with Server Management, 3.1

administering Oracle Enterprise Manager jobs, 3.11.3.1

administering services

Oracle Enterprise Manager, 5.9

SRVCTL, 5.9

administrative tools

overview and concepts, 1.6.2

SYSASM privilege, 3.2.3

administrator-managed database instances

adding, 11.1.1

administrator-managed databases, 3.1.1, 5.3.2.6

AVAILABLE instances for services, 5.3.2.6

converting to policy-managed, 3.7

defined, 1.6.1

PREFERRED instances for services, 5.3.2.6

ADRCI

ADR Command-Line Interpreter, B.2

Advanced Queuing

and FAN, 5.5.1

Advisor Central in Oracle Enterprise Manager, 13.7

aggregates

by instances, 13.1.1.3

by services, 13.1.1.3

by waits, 13.1.1.3

alert administration

Oracle Enterprise Manager, 3.11.3.2

alert blackouts

Oracle Enterprise Manager, 3.11.3.3

alert logs, B.3

managing, B.1

ALTER SYSTEM ARCHIVE LOG CURRENT statement, 3.1.3.2

ALTER SYSTEM ARCHIVE LOG statement, 3.1.3.2

INSTANCE option, 3.1.3.2

ALTER SYSTEM CHECKPOINT LOCAL statement, 3.1.3.2

ALTER SYSTEM CHECKPOINT statement

global versus local, 3.1.3.2

specifying an instance, 3.1.3.2

ALTER SYSTEM KILL SESSION statement

terminating a session on a specific instance, 3.4

ALTER SYSTEM QUIESCE RESTRICTED statement

quiescing a noncluster database, 3.8

ALTER SYSTEM statement

CHECKPOINT clause, 3.1.3.2

ALTER SYSTEM SWITCH LOGFILE statement, 3.1.3.2, 3.1.3.2

applications

consolidating multiple in a single database, 12.1.3

highly available, 12.1

scalability, 12.1.4

spanning XA transactions across Oracle RAC instances, 5.8.1

using pre-created database sessions, 5.7.5

ARCHIVE LOG command

SQL*Plus, 3.1.3.2

ARCHIVE_LAG_TARGET initialization parameter, 3.6.3

archived redo log files

applying in parallel, 7.5.1

file format and destination, 6.8

log sequence number, 6.8

archiver process

monitor, 6.10

archiving mode

changing, 6.2

ASH reports, 13.8.1

asm

SRVCTL object name, A

ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter, 2.6.4, 3.6

Atomic Controlfile to Memory Service (ACMS), 1.3.4

Automatic Database Diagnostic Monitor, 13.9.2, 13.9.3.2, 13.9.5

Automatic Database Diagnostic Monitor (ADDM), 1.6.3

analyzing AWR data, 13.7

DBMS_ADDM PL/SQL package, 13.7

DBMS_ADVISOR PL/SQL package, 13.7

Global ADDM mode, 13.7

Local ADDM mode, 13.7

Automatic Database Diagnostic Monitoring (ADDM), 13.7

Automatic Diagnostic Repository (ADR), B.2

ADRCI command-line interpreter, B.2

automatic load balancing

configuring RMAN channels for multiple instances, 6.6

AUTOMATIC management policy, 3.2.4

Automatic Performance Diagnostics (AWR)

monitor performance statistics, 13.7

automatic segment space management (ASSM), 12.3.1

tablespace use in Oracle RAC, 12.3.1

automatic undo management

tablespace use in Oracle RAC, 12.3.1

automatic workload management

concepts, 1.4, 5.3.1

description, 5.1

manual rebalancing, 5.2

Automatic Workload Repository, 5.1, 5.2, 5.2, 5.10, 13.9.3.2

Automatic Workload Repository (AWR), 13.7, 13.9

monitoring performance, 5.3.3.3

snapshots, 13.7

AVAILABLE instances

for services, 5.3.2.6

Average Active Sessions chart

performance monitoring, 13.1.1.3

AWR

see Automatic Workload Repository

B

background processes

Oracle RAC, 1.3.4

SMON, 3.2.1, 7.3.1

background thread trace files, B.1

backups

server parameter file, 3.5.3

bandwidth

interconnect, 13.2

best practices

deploying Oracle RAC for high availability, 12.1.2

blackouts

defining, 3.11.3.3

block mode conversions

statistics for, 13.6

blocks

associated with instance, 7.3.1

buffer cache, 1.3.3

instance recovery, 7.3.1

buffer sizes

interprocess communication (IPC)

adjusting for Oracle RAC, 13.3

C

cache coherency, 13.9.3.1

Cache Fusion, 1.3.3, 12.3.5

and e-commerce applications, 12.3.5

overview, 1.6.4

Cache Fusion performance, 13.2

cache fusion transfers, 13.9.4

callouts

how they are run, 5.5.3

capacity

increasing, 12.1.4

cardinality, 3.1.1

catclustdb.sql script, 1.6.3

CATCLUST.SQL script

using to create views for Oracle RAC, 13.5

changing the configuration of all services, 4.3.1

channels

configure one RMAN channel for each Oracle RAC instance, 6.6.2

configuring during crosscheck or restore operations, 6.5

configuring for RMAN, 6.6

chart

Global Cache Block Access Latency, 13.1.1.3

charts

Average Active Sessions, 13.1.1.3

Cluster Host Load Average, 13.1.1.3

Database Throughput, 13.1.1.3

checking the interconnect, B.6

CLB_GOAL_SHORT, 5.5.1

client

application environments and FAN, 5.7

client connections with SCAN, 3.1.1

clients

integrated for FAN events, 5.5.1

JDBC Thin Driver, 5.7.2

JDBC/OCI, 5.7.2.2

client-side

load balancing, 5.4

client-side load balancing, 5.4.1

clone.pl, 8.4

clone.pl script

cloning parameters, 8.3

environment variables, 8.3

cloning, 1.5.3, 8, 8.2

deployment phase, 8.3

log files, 8.4

parameters passed to the clone.pl script, 8.3

preparation phase, 8.2

running $ORACLE_HOME/root.sh script, 8.3

setting ORACLE_BASE, 8.3

setting ORACLE_HOME, 8.3

setting ORACLE_HOME_NAME, 8.3

cloning log files, 8.4

cluster

definition of, 1.1

cluster cache coherency, 13.1.1.2

Cluster Database Performance page

Top Activity drill down menu, 13.1.1.3

cluster file system

archiving parameter settings, 6.9.1.2

archiving scenario, 6.9.1

restore, 7.2.1

storage in Oracle RAC, 2.1

Cluster Host Load Average page

cluster database performance, 13.1.1.3

cluster nodes name

in clone.pl script, 8.3

Cluster Verification Utility

overview and concepts, 1.6.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, 13.3

CLUSTER_INTERCONNECTS initialization parameter, 3.9.1

CLUSTER_INTERCONNECTS parameter

examples, 3.9.2, 3.9.2

CLUSTER_NODE_NAME parameter

FAN, and matching database signature, 5.5.5

CLUSTER_NODES parameter

in clone.pl script, 8.3

clustered Oracle ASM

converting a noncluster Oracle ASM, 2.6.5

clusters

consolidating multiple databases in, 12.1.3

clusterware management solution, 1.2

CMAN session pools

and FAN, 5.7.1

cold backups, 3.8

command-line interpreter

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

committed data

instance failure, 7.3.1

communication protocols

verifying settings for, 13.2

compatibility

Oracle RAC and Oracle Database software, 1.5.1

COMPATIBLE initialization parameter, 3.6.1

configuring channels

during restore or crosscheck operations, 6.5

configuring preferred mirror read disks in extended clusters, 2.6.4

CONNECT command, 3.1.3.2

SQL*Plus, 3.1.3.2

CONNECT SYS

example of, 3.2.3

connecting

to instances, 1.6.2, 3.1.3

connection load balancing

concepts, 1.4

introduction to, 5.1

long method, 5.4.3

short method, 5.4.3

connection pools

and FAN, 5.7.1

consistent blocks, 1.3.3

CONTROL_FILES initialization parameter, 3.6.1

converting a database from Oracle RAC One Node to Oracle RAC, 4.3.2

converting an Oracle RAC database with one instance to Oracle RAC One Node, 4.3.1

corrupted data blocks, B.2

CREATE PFILE

FROM MEMORY clause, 3.5

CREATE PFILE statement, 3.5.3

CREATE SPFILE

FROM MEMORY clause, 3.5

creating

server parameter files, 3.5

services, 5.9.1

SPFILE backups, 3.5.3

crosscheck operations

configuring channels during, 6.5

crosschecking on multiple nodes

RMAN backups, 6.5

CRS Administrator, 3.1.1

CRS resources

management of, 1.2

current blocks, 1.3.3

CVU

See Cluster Verification Utility

D

data dictionary

querying views, 13.5

Data Recovery Advisor, B.2

data security

wallet, 12.3.8.1

data warehouse

deploying applications for in Oracle RAC, 12.3.7

data warehouse systems, 12.3.7

database

creation, 1.5.2

services

singleton, 3.7

uniform, 3.7

SRVCTL object name, A

Database Configuration Assistant (DBCA), 1.5.2

adding and deleting instances in interactive mode

on Windows, 11.1.1.1

adding and deleting instances in silent mode

on Windows, 11.1.1.2

adding instances in interactive mode

on Linux and UNIX, 10.1.2.1

adding instances in silent mode

on Linux and UNIX, 10.1.2.2

cloning Oracle RAC instances, 8.3

creating views for Oracle Real Application Clusters, 13.5

Database Storage page, 10.1.2.1, 11.1.1.1

deleting instances in interactive mode

on Linux and UNIX, 10.2.1.1

on Windows, 11.2.1.1

deleting instances in silent mode

on Linux and UNIX, 10.2.1.2

on Windows, 11.2.1.2

Instance Management page, 10.1.2.1, 11.1.1.1

List of Cluster Databases page, 10.1.2.1, 11.1.1.1

Operations page, 10.1.2.1, 11.1.1.1

running the catclustdb.sql script, 1.6.3

Welcome page, 10.1.2.1, 11.1.1.1

database instances

administrator managed

deleting, 10.2.1, 11.2.1

database resource, 3.1.1

Database Resource Manager, 3.8

database role, 3.2.4

database signatures

matching the FAN parameters, 5.5.5

database state, 3.2

Database Storage page, 10.1.2.1, 11.1.1.1

Database Throughput page

performance monitoring, 13.1.1.3

DATABASE_UNIQUE_NAME parameter

FAN, and matching database signature, 5.5.5

databases

adding

Oracle RAC One Node, 4.2

administrator managed, 3.1.1, 5.3.2.6

consolidating multiple in a cluster, 12.1.3

controlling restarts, 3.10

Oracle RAC One Node

services on, 4.2

policy managed, 3.1.1, 5.3.2.7

scalability, 12.1.4

databases sessions

pre-created, 5.7.5

Datagram Protocol (UDP), 1.3.2

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

DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 3.6.1

DB_UNIQUE_NAME initialization parameter, 3.6.1

DBCA

see Database Configuration Assistant (DBCA)

DDL statements, 12.3.2

default database service, 1.5.2, 3.6, 5.9.1

degree of parallelism (DOP), 12.3.7.1

deleting administrator-managed database instances, 10.2.1, 11.2.1

dependencies

and services, 5.3.3.1

deploying

Oracle Real Application Clusters environments, 1.6.1, 12

design

Oracle Real Application Clusters environments, 1.6.1, 12

diagnosing problems for Oracle RAC, B

diagnosing problems using ADR, B.2

DIAGNOSTIC_DEST initialization parameter, B.1, B.3

diskgroup

SRVCTL object name, A

DISPATCHERS initialization parameter, 3.6

specifying a service with, 5.9.1

displaying IP addresses

with ifconfig, 3.9.2

with netstat, 3.9.2

distributed SQL transactions, 5.8.1

Distributed Transaction Processing (DTP), 12.3.4

distributed transactions, 12.3.4

directing to a single instance in the cluster, 5.8.2

services in Oracle RAC, 5.8.1

XA transactions span instances, 5.8.1

DML_LOCKS initialization parameter, 3.6.1

DTP Service., 5.8.2

DTP/XA transactions, 5.8.1

dynamic performance views, 13.9

creating, 13.5

GV$, 1.6.3

V$, 1.6.3

dynamic resource allocation

overview, 1.6.4

E

e-commerce

applications in Oracle RAC, 12.3.5

edition

services attribute, 5.3.2.3

ENCRYPTION_WALLET_LOCATION parameter, 12.3.8.1

Enterprise Manager

overview, 1.2

environment variables

passed to the clone.pl script, 8.3

setting with SRVCTL, 3.1.4

evaluating block transfers, 13.6

event notification

enabling, 5.7.5

examples

setting the CLUSTER_INTERCONNECTS parameter, 3.9.2

extended distance cluster, 2.6.4

Oracle ASM preferred mirror read, 2.6.4

extended distance clusters

configuring preferred mirror read disks, 2.6.4

external transaction managers

OraMTS, 5.8.1

F

failure

instance, 7.3

multiple node, 7.3.2

node, 7.3.1

failure groups, 2.6.4

FAN events

enabling for JDBC, 5.7.2.2

Fast Application Notification (FAN), 5.5

and high availability events, 5.5.5

callouts definition, 5.5.6

callouts, how to use, 5.5.6

events, enabling for JDBC clients, 5.7.2

events, enabling for ODP.NET, 5.7.6

events, enabling for Oracle Call Interface, 5.7.4

events, enabling ODP.NET clients, 5.7.7

how events are published, 5.5.1

introduction, 5.1

overview, 5.5.1

parameters and matching database signatures, 5.5.5

uses, 5.5.1

Fast Connection Failover (FCF)

enabling JDBC clients, 5.7.2

enabling with thin and thick clients, 5.7.2.2

introduction to, 5.1

fault diagnosability, B.2

FCF

See Fast Connection Failover (FCF)

features, new, Preface

files

archived redo log files, 6.8

redo log, 6.8

filesystem

SRVCTL object name, A

FROM MEMORY clause

on CREATE PFILE or CREATE SPFILE, 3.5

G

GC_SERVER_PROCESSES initialization parameter

specifying the number of LMSn processes, 12.1.3

GCS protocol, 13.9.3.1

GCS_SERVER_PROCESSES initialization parameter, 3.6

Generic server pool, 3.1.1

GES

See global cache and enqueue service (GES)

global cache and enqueue service (GES), 13.9.1

Global Cache Block Access Latency chart

performance monitoring, 13.1.1.3

Global Cache Service (GCS), 1.3.3, 3.6

Global Cache Service Process (LMS), 1.3.4

Global Cache Service Processes (LMSn)

reducing the number of, 12.1.3

specifying the number of, 12.1.3

Global Cache Service statistics, 13.9.1, 13.9.3.1

GLOBAL clause

forcing a checkpoint, 3.1.3.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, 13.9.1

global performance data

with ADDM, 13.7

Global Resource Directory (GRD), 1.3.3

Global Transaction Process (GTX0-j), 1.3.4

GLOBAL_TXN_PROCESSES initialization parameter, 5.8.1

goals

and the load balancing advisory, 5.6.1

for load balancing advisory, 5.6.2

Grid Naming Service (GNS)

SRVCTL object name, A

GTX0-j

Global Transaction Process, 1.3.4

GV$, 1.6.3

GV$ view, 13.4

GV$SESSION, 3.4, 3.4

H

hash partitioning

with Oracle RAC, 12.2

high availability

best practices, 12.1.2

for Oracle RAC Databases, 12.1

high availability framework

concepts, 1.4

introduction to, 5.1

home

SRVCTL object name, A

HOST command, 3.1.3.2

SQL*Plus, 3.1.3.2

I

idle wait class, 13.8.1

Implicit Connection Cache, 5.7.2

indexes

sequence-based, 12.2

initdb_name.ora file

DIAGNOSTIC_DEST initialization parameter, B.1

initialization parameters

cluster database issues regarding, 3.6

CLUSTER_INTERCONNECTS, 3.9.1, 13.3

recommendations for using, 3.9.1

identical settings for on all instances, 3.6.3

RECOVERY_PARALLELISM, 7.5.2.1

settings for instances, 3.5

specific to Oracle RAC, 3.6

that must be identical on all instances, 3.6.1

that must be unique on all instances, 3.6.2

INST_ID column, 13.4

installation

introduction, 1.5

Oracle Real Application Clusters, 1.5.2

installations

performing multiple simultaneous cluster, 8

instance

SRVCTL object name, A

instance discovery

Oracle Enterprise Manager Grid Control, 3.11.1

Instance Enqueue Process (LCK0), 1.3.4

Instance Management page, 10.1.2.1, 11.1.1.1

INSTANCE NAME initialization parameter, 3.6

INSTANCE option, 3.1.3.2

INSTANCE parameter

FAN, and matching database signature, 5.5.5

instance recovery, 3.2.1

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

cloning Oracle RAC, 8.3

effect of SQL*Plus commands on, 3.1.3.2

failure, 7.3.2

initialization parameter settings, 3.5

maximum number for Oracle RAC, 1.1

memory structures, 1.3.3

parallel processes, 5.3.3.4

private interconnect usage, B.6

recovery, 3.2.1, 7.3.1

recovery, abnormal shutdown, 3.2.1

recovery, multiple failures, 7.3.2

Server Management, 3.1

shutting down, 3.2.1

starting and stopping, 3.2

terminating session on, 3.4

verifying, 3.3, 3.3

verifying running, 3.3

instances failure

recovery from, 7.3

instead of Statspack, 1.6.3

interconnect

and performance, 13.3

and the Oracle RAC architecture, 1.1

protocols for Oracle Real Application Clusters, 13.2

verifying settings for, 13.2

interconnect bandwidth, 13.2

latency, 13.2

interconnect block transfer rates, 13.6

interconnect settings

verifying, 13.2

interconnects

alternatives to the private network, 3.9

private, B.6

Interconnects page

monitoring clusterware with Oracle Enterprise Manager, 13.1.1

monitoring Oracle Clusterware, 13.1.1.2

interprocess communication (IPC)

buffer sizes

adjusting, 13.3

IPC protocol, 13.2, 13.9.3.1

J

Java Database Connectivity (JDBC) clients

Oracle Notification Service usage, 5.1

Java-based tools and utilities

CVU, B.4

DBCA, B.4

DBUA, B.4

enabling tools for tracing, B.4

GSD, B.4

NETCA, B.4

SRVCTL, B.4

JDBC

and FAN, 5.7.1

enabling FAN events for, 5.7.2.2

JDBC clients

enabling for Fast Connection Failover (FCF), 5.7.2

JDBC Thin Driver, 5.7.2

JDBC/OCI, 5.7.2.2

job administration

Oracle Enterprise Manager, 3.11.3.1

K

KILL SESSION clause

on the ALTER SYSTEM statement, 3.4

L

LCK0

Instance Enqueue Process, 1.3.4

level thresholds

services, 5.11

LICENSE_MAX_USERS initialization parameter, 3.6.3

List of Cluster Databases page, 10.1.2.1, 11.1.1.1

listener

SRVCTL object name, A

listeners

command to add to a node, A

command to remove, A

Oracle Net, 1.2

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

LMSn processes

reducing the number of, 12.1.3

load balancing, 12.3.5

by services, 1.3.2

OCI runtime connection, 5.7.5

server-side, 5.4

Load Balancing Advisory, 5.3.2.8

load balancing advisory

and FAN events, 5.6.3

concepts, 1.4

configuring your environment for using, 5.6.2

deployment, 5.6.1

description of, 5.6

events and FAN, 5.5.1

introduction to, 5.1

local archiving scenario

RMAN, 6.9.2

Local Area Network (LAN), 1.3.2

LOCAL clause

forcing a checkpoint, 3.1.3.2

local file system

archiving parameter settings, 6.9.2.2

restore, 7.2.2

local instance

shutting down, 3.2.3

starting, 3.2.3

local node name

in clone.pl script, 8.3

LOCAL_NODE parameter

in clone.pl script, 8.3

locally managed tablespaces, 12.3.1

log files

tracing, B.4

log sequence numbers, 6.8

LOG_ARCHIVE_FORMAT initialization parameter, 3.6.3

LOG_ARCHIVE_FORMAT parameter, 6.8

M

mass deployment

cloning, 1.5.3, 8, 8.2

media failures

recovery from, 7.4

memory structures

in Oracle RAC, 1.3.3

message request counters, 13.6

migration

application, 12.1.4

missing files, B.2

mission critical systems

considerations for Oracle RAC, 12.1.1

modified data

instance recovery, 7.3.1

monitoring

archiver process, 6.10

overview and concepts, 1.6.3

performance of global cache block access, 13.1.1.3

monitoring host load average, 13.1.1.3

mount all non-running instances of an Oracle RAC database, 3.2.4

multiple cluster interconnects, 3.9

multiple databases in a cluster, 3.9.1

multiple instances

starting from a single SQL*Plus session, 3.2.3

starting from one node, 3.2.3

multiple node failures, 7.3.2

multiple public networks, 1.3.2

multiplexed redo log files, 2.4

N

net service name, 3.1.3

network

SRVCTL object name, A

Network Attached Storage (NAS), 1.3.2

network resources, 1.3.2

NIC bonding, 3.9

node

failure and VIP addresses, 1.3.2

node affinity awareness, 7.3.4

node discovery

Oracle Enterprise Manager Grid Control, 3.11.1

node evictions, 13.1.1.1

nodeapps

SRVCTL object name, A

nodes

affinity awareness, 7.3.4

failure of, 7.3.1

virtual IP addresses, A, A

noncluster databases

quiescing, 3.8

noncluster Oracle ASM

converting to clustered Oracle ASM, 2.6.5

O

object creation and deletion, 12.3.2

objects

creation of and effect on performance, 12.3.2

srvctl object names and abbreviations, A

OC4J

SRVCTL object name, A

OCFS2, 1.3.1

OCI session pooling, 5.7.5

OCI Session Pools

and FAN, 5.7.1

OCI session pools

optimizing, 5.7.5

runtime connection load balancing, 5.7.5

service metrics, 5.7.5

OCI_EVENTS mode

setup for runtime connection load balancing, 5.7.5

OCI_THREADED mode

setup for runtime connection load balancing, 5.7.5

OCRDUMP utility, 13.3

ODP.NET

and FAN, 5.7.1

and Fast Connection Failover, 5.7.6

load balancing advisory events, 5.7.7

OLTP environments, 12.2

online database relocation

relocation utility, 4.4

online recovery, 7.3.1

online transaction processing (OLTP)

applications in Oracle RAC, 12.3.5

ONS

See Oracle Notification Service

ons

SRVCTL object name, A

Operations page, 10.1.2.1, 11.1.1.1

optimal execution plans, 12.3.7.1

Oracle ASM

see Oracle Automatic Storage Management (Oracle ASM)

Oracle Automatic Storage Management (Oracle ASM)

archiving scenario, 6.9.1

converting noncluster Oracle ASM to clustered Oracle ASM, 2.6.5

installation, 1.5.2

instances

administering with SRVCTL, 2.6.6

Oracle ASM preferred read failure groups, 2.6.4

preferred mirror read disks, 2.6.4

preferred read disks, 3.6

SRVCTL object name, A

storage solution, 2.1

SYSASM privilege, 3.2.3

Oracle Call Interface (OCI)

runtime connection load balancing, 5.7.5

Oracle Call Interface environment

to receive service metrics, 5.7.5

Oracle Cluster File System (OCFS for Windows), 1.3.1

Oracle Cluster Registry (OCR), 3.1.4, 13.3

Oracle Clusterware

cloning, 1.5.3

control policies

AUTOMATIC, 3.10

MANUAL, 3.10

using SRVCTL to display and change, 3.10

controlling database restarts, 3.10

described, 1.2, 1.2

introduction, 1.2

introduction and concepts of, 1

managing Oracle processes, 1.2

Oracle Database

session activity, 13.8.1

Oracle Dynamic Volume Manager

described, Preface

Oracle Enterprise Manager

adding database instances to nodes

on Linux and UNIX, 10.1.2

on Windows, 11.1.1

alert administration, 3.11.3.2

alert blackouts, 3.11.3.3

Automatic Database Diagnostic Monitoring (ADDM), 13.7

Average Active Sessions chart, 13.1.1.3

Cluster Database Home page, 13.1.1.1

Cluster Database page, 13.1.1

Cluster Database Performance page

performance statistics for an Oracle RAC database, 13.1.1.3

configuring to recognize changes in database management, 3.7

Database Throughput charts, 13.1.1.3

deleting database instances from nodes, 10.2.1, 11.2.1

Global Cache Block Access Latency chart, 13.1.1.3

Interconnects page, 13.1.1.2

job administration, 3.11.3.1

monitoring load values for available nodes, 13.1.1.3

overview and concepts, 1.6.2

Top Activity drill down menu, 13.1.1.3

using the Interconnects page to monitor Oracle Clusterware, 13.1.1

using to administer Oracle RAC, 3.1.2

using to administer services, 5.9.2

using to back up the server parameter file, 3.5.3

using to create DTP services, 5.8.4

using to monitor Oracle Clusterware, 13.1.1

using to monitor Oracle RAC, 13.1.1

using to monitor Oracle RAC environments, 1.6.3

using to restore SPFILE, 7.2.3

using to schedule Automatic Workload Repository actions, 5.11

using to set up a fast recovery area, 7.6

using to start or stop a database, 3.2.2

using with RMAN, 6.4

Oracle Enterprise Manager Database Control

using emca to reconfigure, 3.7

Oracle Enterprise Manager Grid Control

instance discovery, 3.11.1

node discovery, 3.11.1

Oracle home

cloning, 1.5.3

defined, 1.5.2

Oracle Interface Configuration (OIFCFG), 13.3

Oracle Managed Files, 3.1.1

Oracle Maximum Availability Architecture (MAA), 12.1.1

Oracle Net

listeners, 1.2

Oracle Net Services

and load balancing, 5.7.1

and services, 5.3.2.9

Oracle Notification Service, 1.2

SRVCTL object name, A

used by FAN, 5.1

Oracle Notification Services

API, 5.5.1

Oracle processes

managed by Oracle Clusterware, 1.2

Oracle RAC

adding administrator-managed database instances, 10.1.2.1, 11.1.1

adding policy-managed database instances, 10.1, 11.1

adding to nodes in a cluster on Linux and UNIX, 10.1

adding to nodes in a cluster on Windows, 11.1

background processes

ACMS, 1.3.4

GTX0-j, 1.3.4

LCK0, 1.3.4

LMD, 1.3.4

LMON, 1.3.4

LMS, 1.3.4

RSMN, 1.3.4

benefits of cloning, 8.1

cloning, 1.5.3, 8

size of the binaries, 8.1

converting database from, 4.3

converting database to, 4.3

converting single instance to Oracle RAC One Node, 4.3.1

copying the Oracle RAC home, 8.2

databases

quiescing, 3.8

deploying clone, 8.3

diagnosing performance problems, 13.8.1

diagnosing problems for, B

removing on Windows, 11.2.2

removing the software from Linux and UNIX, 10.2.2

security considerations, 12.3.8

shutting down instances, 3.2.1

software components, 1.3.3

storage options

network file system (NFS), 1.3.1

Oracle Automatic Storage Management (Oracle ASM), 1.3.1

Oracle Cluster File System (OCFS for Windows), 1.3.1

volume manager, 1.3.1

using a fast recovery area in, 7.6

Oracle RAC background processes

(RMSn), 1.3.4

Oracle RAC One Node, Preface, 4

adding databases, 4.2

converting database from, 4.3

converting database to, 4.3

converting to Oracle RAC, 4.3.2

online database relocation, 4.4

relocating to another node, 4.4

Oracle RAC One Node database

services on, 4.2

Oracle Real Application Clusters

and e-commerce, 12.3.5

installation overview, 1.5.2

overview of administration, 1

Oracle Real Application Clusters One Node, 4

See Oracle RAC One Node

Oracle Streams, 5.3.3.5

Oracle Streams Advanced Queuing

and FAN, 5.5.1

Oracle Universal Installer

database installation, 1.5.2

Oracle Real Application Clusters installation, 1.5.2

ORACLE_BASE environment variable, 8.3

ORACLE_HOME environment variable, 8.3

ORACLE_HOME_NAME environment variable, 8.3

ORACLE_SID parameter, 3.6.2

oradebug ipc command, B.6

OraMTS

external transaction manager, 5.8.1

orapwd file, 3.7

outages

planned, 5.5.4

unplanned, 5.5.3

P

parallel execution, 12.3.7.2

parallel processes, 5.3.3.4

parallel recovery, 7.5.2.1

disabling, 7.5.2

PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 3.6.1

PARALLEL_FORCE_LOCAL initialization parameter, 5.3.3.4

PARALLEL_INSTANCE_GROUPS initialization parameter, 5.3.3.4

parallelism

in Oracle RAC, 12.3.7.2

parallel-aware query optimization, 12.3.7.1

parameter file

overview, 3.5

parameter file search order, 3.5.2

parameters

DB_RECOVERY_FILE_DEST, 7.6

that must be identical on all instances, 3.6.1

that must be unique on all instances, 3.6.2

password file-based authentication, 4.4

performance, 13.1.1.3

aggregates by services, 13.1.1.3

comprehensive global data, 13.7

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

monitoring database throughput, 13.1.1.3

monitoring global cache block access, 13.1.1.3

monitoring potential problems in the database, 13.1.1.3

primary components affecting, 13.2

service aggregates by instances, 13.1.1.3

service aggregates by waits, 13.1.1.3

using ADDM, 1.6.3

performance evaluation

overview and concepts, 1.6.4

performance statistics, 13.9.5

PFILE

using with Oracle RAC, 3.5

phases

cloning deployment, 8.3

cloning preparation, 8.2

PMON background process, 3.4

policy-managed database instances

adding, 11.1

policy-managed databases, 3.1.1, 3.6.2, 5.3.2.7

defined, 1.6.1

deleting on Linux and UNIX, 10.2.1

deleting on Windows, 11.2.1

PREFERRED instances

for services, 5.3.2.6

preferred read disks

Oracle ASM in an Oracle RAC extended distance cluster, 2.6.4

private interconnect, B.6

determining usage, B.6

private network

alternative interconnect, 3.9

private network IP address, 13.3

processes

managed by Oracle Clusterware, 1.2

parallel, 5.3.3.4

public and private interfaces

shown in Oracle Enterprise Manager, 13.1.1.2

Q

query optimizer, 12.3.7.1

default cost model for, 12.3.7.1

queue tables, 5.3.3.5

quiesce database

in Oracle Real Application Clusters, 3.8

quiesced databases, 3.8

quiescing

noncluster database, 3.8

R

rebalancing

workloads, 5.2

RECOVER command, 3.1.3.2

SQL*Plus, 3.1.3.2

recovery

after SHUTDOWN ABORT, 3.2.1

from multiple node failure, 7.3.2

from single-node failure, 7.3.1

instance, 3.2.1

media failures, 7.4

online, 7.3.1

parallel, 7.5.2.1

RECOVERY_PARALLELISM parameter, 7.5.2.1

redo log files

instance recovery, 7.3.1

log sequence number, 6.8

using, 2.4

redo log groups, 2.4

redo logs

format and destination specifications, 6.8

redo thread, 3.1.1

reducing contention, 12.2

remote Oracle Notification Service subscription, 5.7.2.1

Remote Slave Monitor (RSMN), 1.3.4

REMOTE_LISTENER database parameter, 5.4.1

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 3.6.1

resource contention, 13.1.1.3

Resource Manager

and services, 5.3.3.2

resource manager, 5.2

resource profiles

and service creation, 5.3.3.1

resources

releasing, 7.3.1

resources held by the session, 3.4

restore scenarios

RMAN, 7.2

restore scheme

cluster file system, 7.2.1

local file system, 7.2.2

result cache, 3.6

disabling, 3.6

enabling, 3.6

RESULT_CACHE_MAX_SIZE initialization parameter, 3.6, 3.6.1

RMAN

CONFIGURE command, 6.3

configuring channels, 6.5

configuring channels to use automatic load balancing, 6.6

configuring one channel for each instance, 6.6.2

configuring snapshot control file locations, 6.3

crosschecking on multiple nodes, 6.5

DUPLICATE command, 6.3

local archiving scenario, 6.9.2

restore scenarios, 7.2

using to create SPFILE backups, 3.5.3

RMSn

Oracle RAC Management Processes, 1.3.4

rolling back

instance recovery, 7.3.1

root.sh script

$ORACLE_HOME, 8.3

RSMN

Remote Slave Monitor, 1.3.4

Runtime Connection Load Balancing, 5.3.2.8

runtime connection load balancing

defined, 5.7.5

in OCI session pools, 5.7.5

introduction to, 5.1

S

scalability, 12.3.5

Oracle RAC, 12.1.4

SCAN, 1.2

defined, 1.4

scan

SRVCTL object name, A

scan_listener

SRVCTL object name, A

scripts

$ORACLE_HOME/root.sh, 8.3

security

wallet, 12.3.8.1

sequence-based indexes, 12.2

sequences

log sequence number, 6.8

Server Control Utility

see SRVCTL

Server Management

administration of instances, 3.1

server parameter file

backing up, 3.5.3

server parameter files

creating, 3.5

server pool, 3.1.1

concepts, 1.4

creating for a policy-managed database, 3.7

Generic, 3.1.1

SRVCTL object name, A

servers

relocating from another server pool, 3.7

scalability, 12.1.4

service

SRVCTL object name, A

service level objective

defining for Oracle RAC, 12.1.1

service levels, 12.3.6

service metrics

OCI runtime connection load balancing, 5.7.5

runtime connection load balancing, 5.7.5

SERVICE parameter

FAN, and matching database signature, 5.5.5

SERVICE TIME

load balancing advisory goal, 5.6.2

SERVICE_NAMES initialization parameter, 3.6

setting for services, 3.6, 5.9.1

service-level agreements, 3.4

services, 3.6

activity levels aggregated by instances, 13.1.1.3

activity levels aggregated by services, 13.1.1.3

activity levels aggregated by waits, 13.1.1.3

administering, 5.9.1

administering with Oracle Enterprise Manager, 5.9

administering with SRVCTL, 5.9, 5.9.3

attributes

edition, 5.3.2.3

basic concepts about, 5.3.1

concepts, 1.4

configuring automatic workload management characteristics, 5.3.2

default, 5.3.4

dependencies, 5.3.3.1

enabling event notification, 5.7.5

introduction to, 1.3.2, 5.1

level thresholds, 5.11

management policy

automatic, 5.3.2.4

manual, 5.3.2.4

performance monitored by AWR, 5.3.3.3

SERVICE_NAMES parameter, 3.6, 5.9.1

specifying a service, 5.9.1

using, 5.3.1

services for administrator-managed databases, 3.7

sessions

terminating on a specific instance, 3.4

setting instances, 1.6.2, 3.1.3

shared everything, 1.3.1

shared server configuration, 3.6

SHOW INSTANCE command, 3.1.3.2

SQL*Plus, 3.1.3.2

SHOW PARAMETER command

SQL*Plus, 3.1.3.2

SHOW PARAMETERS command, 3.1.3.2

SHOW SGA command, 3.1.3.2

SQL*Plus, 3.1.3.2

SHUTDOWN ABORT, 3.2.1, B.5

SHUTDOWN command

ABORT option, 3.2.1

SQL*Plus, 3.1.3.2

SHUTDOWN IMMEDIATE, B.5

SHUTDOWN TRANSACTIONAL, 3.2.1

shutting down

instances, 3.2.1

shutting down an instance

abnormal shutdown, 3.2.1

shutting down instances, 3.2.1

sidalrt.log file, B.3

single client access name

See SCAN

single client access name (SCAN)

SRVCTL object name, A

single system image, 1.3.3

SMON process

instance recovery, 7.3.1, 7.3.2

recovery after SHUTDOWN ABORT, 3.2.1

snapshot control file, 6.3

configuring locations, 6.3

speed-up for data warehouse systems, 12.3.7.1

SPFILE

backing up, 3.5.3

backups

creating, 3.5.3

changing parameter settings, 3.5

corrupted, 3.5.1

default names, 3.5.2

location, 3.5

naming convention for, 3.5.2

recovering, 3.5.3

restore with Oracle Enterprise Manager, 7.2.3

restore with RMAN, 7.2.3

setting values in, 3.5.1

SPFILE initialization parameter, 3.6, 3.6.3

SQL statements

executing in parallel, 5.3.3.4

instance-specific, 3.1.3.2

SQL*Plus, 3.1.3

changing the prompt, 3.1.3.1, 3.1.3.1

commands

CONNECT, 3.1.3

effect on instances, 3.1.3.2

SRVCTL

add, usage description, A

administering Oracle ASM instances, 2.6.6

administering services with, 5.9.3

cluster database configuration tasks, A

cluster database tasks, A

command syntax, A

commands

add asm, A

add cvu, A, A

add database, A

add filesystem, A

add gns, A

add instance, A

add listener, A

add network, A

add nodeapps, A

add ons, A

add scan, A

add scan_listener, A

add service, A

add srvpool, A

add vip, A

config asm, A, A

config cvu, A

config database, A

config filesystem, A

config gns, A

config nodeapps, A

config oc4j, A

config ons, A

config scan, A

config scan_listener, A

config service, A

config srvpool, A

config vip, A

convert database, A

disable asm, A

disable cvu, A

disable database, A

disable diskgroup, A

disable filesystem, A

disable gns, A

disable instance, A

disable listener, A

disable nodeapps, A

disable oc4j, A

disable ons, A

disable scan, A

disable scan_listener, A

disable service, 5.9.3.3, A

disable vip, A

downgrade database, A

enable asm, A

enable cvu, A

enable database, A

enable diskgroup, A, A

enable filesystem, A

enable instance, A

enable listener, A

enable nodeapps, A

enable oc4j, A

enable ons, A

enable scan, A

enable scan_listener, A

enable service, 5.9.3.3, A

enable vip, A

getenv asm, A

getenv database, A

getenv listener, A

getenv nodeapps, A, A

help, A

modify asm, A

modify cvu, A

modify database, A

modify filesystem, A

modify gns, A

modify instance, A

modify listener, A

modify network, A

modify nodeapps, A

modify oc4j, A

modify ons, A

modify scan, A

modify scan_listener, A

modify service, A

modify srvpool, A

relocate cvu, A

relocate database, A

relocate gns, A

relocate oc4j, A

relocate scan, A

relocate scan_listener, A

relocate server, A

relocate service, A

relocate vip, A

remove asm, A

remove database, A

remove diskgroup, A

remove filesystem, A

remove gns, A

remove instance, A

remove listener, A

remove nodeapps, A

remove oc4j, A

remove ons, A

remove scan, A

remove scan_listener, A

remove service, A

remove srvpool, A

remove vip, A

setenv asm, A

setenv database, A, A

setenv listener, A

setenv nodeapps, A

srvctl setenv, 3.1.4

start asm, A

start cvu, A

start database, 3.2.4, A

start diskgroup, A

start filesystem, A

start gns, A

start home, A

start instance, 3.2.4, A

start listener, A

start nodeapps, A

start oc4j, A

start ons, A

start scan, A

start scan_listener, A

start service, A

start vip, A

status asm, A

status cvu, A

status database, A

status diskgroup, A

status filesystem, A

status gns, A

status home, A

status instance, A

status listener, A

status nodeapps, A

status oc4j, A

status ons, A

status scan, A

status scan_listener, A

status server, A

status service, A

status srvpool, A

status vip, A

stop asm, A

stop cvu, A

stop database, 3.2.4, A

stop diskgroup, A

stop filesystem, A

stop gns, A

stop home, A

stop instance, 3.2.4, A

stop listener, A

stop nodeapps, A

stop oc4j, A

stop ons, A

stop scan, A

stop scan_listener, A

stop service, A

stop vip, A

unsetenv asm, A

unsetenv database, A, A

unsetenv listener, A

unsetenv nodeapps, A

upgrade database, A

concurrent commands, A

config, usage description, A

convert, usage description, A

deprecated commands and options, A

disable, usage description, A

downgrade, usage description, A

enable, usage description, A

enabling event notification, 5.7.5

getenv, usage description, A

modify, usage description, A

node-level tasks, A

object name

database, A

diskgroup, A

filesystem, A

Grid Naming Service (GNS), A

home, A

instance, A

listener, A

network, A

node applications (nodeapps), A

oc4j, A

Oracle Automatic Storage Management (Oracle ASM), A

Oracle Notification Service, A

scan, A

scan_listener, A

server pool (srvpool), A

service, A

vip, A

object names, A

overview, 3.1.4

overview and concepts, 1.6.2

relocate, usage description, A

remove, usage description, A

setenv, usage description, A

start service command, 5.9.3.2, 5.9.3.2

start, usage description, A

status service command, 5.9.3.5

status, usage description, A

stop or start cluster database, 3.2.4

stop, usage description, A

unsetenv, usage description, A

upgrade, usage description, A

SRVM_TRACE environment variable, B.4

Standard Edition

installing Oracle ASM, 1.5.2

starting administrator-managed databases, 3.2.4

starting policy-managed databases, 3.2.4

STARTUP command

SQL*Plus, 3.1.3.2

statistics

contents of, 13.6

Statspack, 13.9, 13.9.1

usage, 1.6.3

stop database instances, 3.2.4

storage

cluster file system, 2.1

Oracle Automatic Storage Management (Oracle ASM), 2.6.1

subnet

configuring for virtual IP address, A, A

subnets, 1.3.2

SYS$BACKGROUND service, 5.3.4

SYS$USERS service, 5.3.4

SYSASM privilege, 3.1.3, 3.2.3

SYSAUX tablespace

increasing size when adding nodes, 12.3.3

reducing size when removing nodes, 12.3.3

SYSDBA, 3.1.3

privilege for connecting, 3.1.3

SYSDBA connections to an Oracle ASM instance, 3.1.3

SYSOPER, 3.1.3

SYSOPER privilege

for connecting, 3.1.3

system change, 6.8

System Global Area (SGA), 1.3.3, 13.8.1

size requirements, 1.3.3

T

tablespaces

automatic segment space management (ASSM) in Oracle RAC, 12.3.1

automatic undo management in Oracle RAC, 12.3.1

locally managed, 12.3.1

use in Oracle RAC, 12.3.1

TCP network ports

Windows Firewall considerations, 12.3.8.2

TCP/IP, 1.3.2

terminating a session on a specific instance, 3.4

THREAD initialization parameter, 3.6

threads

multiple application, 5.7.5

THROUGHPUT

load balancing advisory goal, 5.6.2

timed statistics, 13.6

timeout

messages, avoiding, 1.3.2

tnsnames.ora file, 3.6

Top Activity drill down menu

on the Cluster Database Performance page, 13.1.1.3

Top Cluster Events, 13.8.2

Top Cluster Events, ASH report, 13.8.2

Top Remote Instance, 13.8.3

Top Remote Instance, ASH report, 13.8.3

trace files, B.1

managing, B.1

sidalrt.log, B.3

trace files for background processes, B.1

TRACE_ENABLED initialization parameter, 3.6.3

tracing

enabling Java-based tools and utilities, B.4

SRVM_TRACE environment variable, B.4

writing to log files, B.4

transactions

instance failure, 7.3.1

rolling back, 3.4, 7.3.1

waiting for recovery, 7.3.1

Transparent Application Failover

and services, 5.3.2.12

Transparent Data Encryption

specifying the ENCRYPTION_WALLET_LOCATION parameter, 12.3.8.1

with encrypted wallets and obfuscated wallets, 12.3.8.1

tuning

overview, 1.6.4

using ADDM, 1.6.3

U

undo tablespace, 3.1.1

UNDO_MANAGEMENT initialization parameter, 3.6.1

UNDO_RETENTION initialization parameter, 3.6.3

UNDO_TABLESPACE parameter, 3.6.2

Universal Connection Pool

benefits, Preface

User Datagram Protocol (UDP), B.6

user process trace files, B.1

V

V$, 1.6.3

V$ view, 13.4

V$ACTIVE_INSTANCES, 3.3, 3.3

V$CLUSTER_INTERCONNECTS, 13.2, B.6

V$CONFIGURED_INTERCONNECTS, 13.2

vendor clusterware, 1.1

verification

data files, online files, 2.3

verifying interconnect settings, 13.2

versions

compatibility for Oracle RAC and Oracle Database software, 1.5.1

views

creating for Oracle Real Application Clusters, 13.5

dynamic performance

for performance monitoring, 13.4

GV$, 13.4

for performance monitoring, 13.4

GV$SESSION, 3.4, 3.4

instance-specific, 13.4

V$ views, 13.4

VIP

SRVCTL object name, A

Virtual Internet Protocol (VIP) address, 1.2

virtual IP address

requirements, A, A

W

wait events, 13.9, 13.9.1

aggregated for service performance, 13.1.1.3

block-related, 13.9.5.1

contention-related, 13.9.5.3

load-related, 13.9.5.4

message-related, 13.9.5.2

wallet

data security, 12.3.8.1

Welcome page, 10.1.2.1, 11.1.1.1

Windows Firewall, 12.3.8.2

workload management

See automatic workload management

workloads

and services, 5.3.1

X

XA Transactions, 12.3.4

XA transactions

spanning Oracle RAC instances, 5.8.1