Skip Headers
Oracle® Real Application Clusters Administration and Deployment Guide
11g Release 1 (11.1)

B28254-07
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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

A

ACMS
Atomic Controlfile to Memory Service, 1.3.4
Active Session History, Oracle RAC, 12.8.1
Active Session History, Top Cluster Events, 12.8.2
Active Session History, Top Remote Instance, 12.8.3
ACTIVE_INSTANCE_COUNT initialization parameter, 3.6.1
add node
ASM instances for shared storage, 8.2.3
using NETCA to add a listener, 8.2.4.1
add nodes to a cluster
when the new nodes already have Oracle Clusterware and Oracle Database software installed, 10.5
adding a node
root.sh script, 8.2.4.1
adding nodes
quick-start, 10.2
ADDM
global monitoring, 12.7
see Automatic Database Diagnostic Monitor
ADDM for Oracle Real Application Clusters mode, 12.7
administering
services, 4.10
services with SRVCTL, 4.11.3
administering instances
with Server Management, 3.1
administering services
DBCA, 4.11
Oracle 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
AFFINITY HINT
described, 4.5.1
load balancing FAN event, 4.5.1
aggregates
by instances, 12.1.1.3
by services, 12.1.1.3
by waits, 12.1.1.3
alert administration
Oracle Enterprise Manager, 3.10.2.2
alert blackouts
Oracle 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, 11.1.2
highly available, 11.1
scalability, 11.1.3
spanning XA transactions across Oracle RAC instances, 4.8
using pre-created database sessions, 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, 9.7
file naming, 9.6
log sequence number, 9.7
archiver process
monitor, 9.10
archiving mode
changing, 9.9
ASH reports, 12.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, 12.9.2, 12.9.3.2, 12.9.5
Automatic Database Diagnostic Monitor (ADDM), 1.6.3
analyzing AWR data, 12.7
Automatic Database Diagnostic Monitoring (ADDM), 12.7
Automatic Diagnostic Repository (ADR)
ADRCI command-line interpreter, Preface, B.2
automatic load balancing
configuring RMAN channels for multiple instances, 9.5
automatic segment space management (ASSM), 11.3.1
automatic segment-space management
tablespace use in Oracle RAC, 11.3.1
Automatic Storage Management (ASM), 2.6.1
archiving scenario, 9.8.1
ASM preferred read failure groups, Preface, 2.6.5
cloning, 5
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, 5.3.1
installation, 1.5.2
instance creation on newly added nodes, 5, 8.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, 11.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, 12.7, 12.9.3.2
snapshots, 12.7
Automatic Workload Repository (AWR)
monitoring performance, 4.3.1
AVAILABLE instances
for services, 4.3.1
Average Active Sessions chart
performance monitoring, 12.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, 12.2
benefits
of cloning Oracle Clusterware, 5.1
best practices
deploying Oracle RAC for high availability, 11.1.1
block mode conversions
statistics for, 12.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, 12.3

C

Cache Fusion, 1.3.3
and e-commerce applications, 11.3.5
overview, 1.6.4
callouts
how they are run, 4.4.3
capacity
increasing, 11.1.3
catclustdb.sql script, 1.6.3
CATCLUST.SQL script
using to create views for Oracle Real Application Clusters, 12.5
channels
configure one RMAN channel for each Oracle RAC instance, 9.5.2
configuring during crosscheck or restore operations, 9.4
configuring for RMAN, 9.5
chart
Global Cache Block Access Latency, 12.1.1.3
charts
Average Active Sessions, 12.1.1.3
Cluster Host Load Average, 12.1.1.3
Database Throughput, 12.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, 5.3.1, 5.3.2
environment variables, 5.3.1, 5.3.2
cloning, 1.5.3, 5, 5.2
benefits, 5.1
deployment phase, 5.3
LD_LIBRARY_PATH environment variable, 5.3.2
log files, 5.4
parameters passed to the clone.pl script, 5.3.1, 5.3.2
preparation phase, 5.2
running $ORACLE_HOME/root.sh script, 5.3.2
setting ORACLE_BASE, 5.3.1, 5.3.2
setting ORACLE_HOME, 5.3.1, 5.3.2
setting ORACLE_HOME_NAME, 5.3.1, 5.3.2
cluster
definition of, 1.1
Cluster Database Home Page, 12.1.1.1
Cluster Database Performance page
Top Activity drill down menu, 12.1.1.3
cluster file system
archiving parameter settings, 9.8.1.2
archiving scenario, 9.8.1
restore, 6.2.1
storage in Real Application Clusters, 2.1
Cluster Host Load Average page
cluster database performance, 12.1.1.3
Cluster Managed Database Services Detail Page
Oracle Enterprise Manager, 4.11.1.3
Cluster Managed Database Services Page
Oracle 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, 5.3.1, 5.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, 12.3
CLUSTER_INTERCONNECTS parameter
examples, 3.8.2, 3.8.2
recommendations for using, 3.8.1
CLUSTER_NODES parameter
in clone.pl script, 5.3.1, 5.3.2
clustered ASM
converting a single-instance ASM, 2.6.6
clusters
consolidating multiple databases in, 11.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, 12.2
compatibility
Oracle RAC and Oracle Database software, 1.5.1
COMPATIBLE initialization parameter, 3.6.1
configuring channels
during restore or crosscheck operations, 9.4
configuring preferred mirror read disks in extended clusters, 2.6.5
configuring raw partitions, 10.4.3.1.1
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
Oracle 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, 9.4
crosschecking on multiple nodes
RMAN backups, 9.4
CRS resources
management of, 1.2
current blocks, 1.3.3
CVU
overview and concepts, 1.6.2

D

data dictionary
querying views, 12.5
data security
wallet, 11.3.8.1
data warehouse
deploying applications for in Oracle Real Application Clusters, 11.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, 8.2.5.2, 10.4.5.2
cloning Oracle RAC instances, 5.3.2
creating views for Oracle Real Application Clusters, 12.5
Database Storage page, 8.2.5.1, 10.4.5.1
Instance Management page, 8.2.5.1, 10.4.5.1
List of Cluster Databases page, 8.2.5.1, 10.4.5.1
Operations page, 8.2.5.1, 10.4.5.1
running the catclustdb.sql script, 1.6.3
Summary dialog, 8.2.5.1, 10.4.5.1
Welcome page, 8.2.5.1, 10.4.5.1
database signatures
matching the FAN parameters, 4.4.5
Database Storage page, 8.2.5.1, 10.4.5.1
Database Throughput page
performance monitoring, 12.1.1.3
DATABASE UNIQUE NAME parameter
FAN, and matching database signature, 4.4.5
databases
consolidating multiple in a cluster, 11.1.2
controlling restarts, 3.9
scalability, 11.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, 5.3.1
see Database Configuration Assistant (DBCA)
DBCA_RAW_CONFIG environment variable, 10.4.3.1
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
default database service, 1.5.2, 3.6, 4.10
degree of parallelism (DOP), 11.3.7.2
DELETE_SERVICE procedure
DBMS_SERVICE PL/SQL package, 4.11.2
deleting nodes
quick-start, 10.2
dependencies
and services, 4.3.1
deploying
Oracle RAC database software, 5.3.2
Oracle Real Application Clusters environments, 1.6.1, 11
design
Oracle Real Application Clusters environments, 1.6.1, 11
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, 11.3.4
distributed transactions, 4.8, 11.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, 11.3.4
DTP Service., 4.8
DTP/XA transactions, 4.8
dynamic performance views
creating, 12.5
for performance monitoring, 12.4
dynamic resource allocation
overview, 1.6.4

E

e-commerce
applications in Oracle Real Application Clusters, 11.3.5
encryption key
rekeying master key, 11.3.8.1
ENCRYPTION_WALLET_LOCATION parameter, 11.3.8.1
environment variables
passed to the clone.pl script, 5.3.1, 5.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
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, 9.7
redo log, 9.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, 11.1.2
GCS_SERVER_PROCESSES initialization parameter, 3.6
Global ADDM mode, 12.7
Global Cache Block Access Latency
performance monitoring, 12.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, 11.1.2, 11.1.2
specifying the number of, 11.1.2
Global Cache Service statistics, 12.9.1, 12.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, 12.9.1
global performance data
with ADDM, 12.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, 11.3.8.1
hash partitioning
with Oracle Real Application Clusters, 11.2
high availability
best practices, 11.1.1
for Oracle RAC Databases, 11.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, 12.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, 12.4
installation
introduction, 1.5
Oracle Real Application Clusters, 1.5.2
installations
performing multiple simultaneous cluster, 5
instance
SRVCTL object noun name, A.7.2
instance addition
quick-start, 10.2
instance deletion
quick-start, 10.2
instance discovery
Oracle Enterprise Manager Grid Control, 3.10.1
Instance Enqueue Process (LCK0), 1.3.4
Instance Management page, 8.2.5.1, 10.4.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, 12.1.1.3
cloning Oracle RAC, 5.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, 12.3
and the Oracle RAC architecture, 1.1, 1.3.1
bandwidth, 12.2
protocols for Oracle Real Application Clusters, 12.2
verifying settings for, 12.2
interconnects
alternatives to the private network, 3.8
private, B.6
Interconnects page
monitoring clusterware with Oracle Enterprise Manager, 12.1.1
monitoring Oracle Clusterware, 12.1.1.2
IPCs
buffer sizes, adjusting, 12.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
Oracle 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, 5.3.2
LICENSE_MAX_USERS initialization parameter, 3.6.3
List of Cluster Databases page, 8.2.5.1, 10.4.5.1
listener object
SRVCTL object noun name, A.7.2
listeners
adding during add node, 8.2.4.1
creating during cloning, 5.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, 11.1.2
LMSn processes
reducing the number of, 11.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
described, 4.5
events and FAN, 4.4.1
introduction to, 4.1
Local ADDM mode, 12.7
local archiving scenario
RMAN, 9.8.2
Local Area Network (LAN), 1.3.2
LOCAL clause
forcing a checkpoint, 3.1.2.2
local file system
archiving parameter settings, 9.8.2.2
restore, 6.2.2
local node name
in clone.pl script, 5.3.1, 5.3.2
LOCAL_NODE parameter
in clone.pl script, 5.3.1, 5.3.2
location transparency
using service names, 4.10
log files
tracing, B.4
log sequence numbers, 9.7
LOG_ARCHIVE_FORMAT initialization parameter, 3.6.3
LOG_ARCHIVE_FORMAT parameter, 9.7

M

mass deployment
cloning, 1.5.3, 5, 5.2
master key
rekeying, 11.3.8.1
media failures
recovery from, 6.4
memory structures
in Oracle RAC, 1.3.3
message request counters, 12.6
messages
errors for management tools, C
migration
application, 11.1.3
mission critical systems
considerations for Oracle RAC, 11.1
modified data
instance recovery, 6.3.1
MODIFY_SERVICE procedure
DBMS_SERVICE PL/SQL package, 4.11.2
monitoring
archiver process, 9.10
overview and concepts, 1.6.3
performance of global cache block access, 12.1.1.3
statistics for Oracle Real Application Clusters, 12.6
monitoring host load average, 12.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, 8.2.4.1
NETCA, 1.5.2
creating listeners during cloning, 5.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 addition
quick-start, 10.2
node deletion
quick-start, 10.2
node discovery
Oracle 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, 8.3.2

O

Object Link Manager (OLM)
starting, 10.4.3.1.1
objects
creation of and effect on performance, 11.3.2
srvctl nouns and abbreviations, A.7.2
OCFS2, 1.3.1
configuring when extending Oracle RAC, 8.2.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, 8.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, 8.2.4.1
online recovery, 6.3.1
online transaction processing
applications in Oracle Real Application Clusters, 11.3.5
Operations page, 8.2.5.1, 10.4.5.1
Oracle Call Interface (OCI)
runtime connection load balancing, Preface, 4.6.3
Oracle Call Interface environment
to receive service metrics, 4.6.3
Oracle Cluster File System (OCFS), 1.3.1
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, 3.1.1
adding database instances to nodes, 8.2.5
administering services, 4.11.1
alert administration, 3.10.2.2
alert blackouts, 3.10.2.3
Automatic Database Diagnostic Monitoring (ADDM), 12.7
Cluster Database page, Preface, 12.1.1
Cluster Database Performance page
Cluster Database Performance page, Preface, 12.1.1.3
deleting database instances from nodes, 8.3.1, 10.4.5, 10.6.1
Interconnects page, 12.1.1.2
job administration, 3.10.2.1
overview, 1.2
overview and concepts, 1.6.2
services pages, accessing, 4.11.1.5
using the Interconnects page to monitor Oracle Clusterware, 12.1.1
Oracle Enterprise Manager Grid Control
instance discovery, 3.10.1
node discovery, 3.10.1
Oracle home
adding in silent mode, 8.2.4.2
cloning, 1.5.3
Oracle Maximum Availability Architecture (MAA), 11.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, 5
software components, 1.3.3
Oracle RAC Management Processes (RMSn), 1.3.4
Oracle Real Application Clusters
and e-commerce, 11.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, 5.3.1, 5.3.2
ORACLE_HOME, 1.5.2
ORACLE_HOME environment variable, 5.3.1, 5.3.2
ORACLE_HOME_NAME environment variable, 5.3.1, 5.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_EXECUTION_MESSAGE_SIZE initialization parameter, 3.6.1
PARALLEL_INSTANCE_GROUP initialization parameter
parallel processes, 4.10
PARALLEL_INSTANCE_GROUPS initialization parameter
parallel processes, 4.10
PARALLEL_MAX_SERVERS parameter, 6.5.2.1
parallelism
in Oracle Real Application Clusters, 11.3.7.2
parallel-aware query optimization, 11.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, 12.7
performance, 12.1.1.3
aggregates by services, 12.1.1.3
comprehensive global data, 12.7
monitoring activity by wait events, services, and instances, 12.1.1.3
monitoring database throughput, 12.1.1.3
monitoring global cache block access, 12.1.1.3
monitoring potential problems in the database, 12.1.1.3
primary components affecting, 12.2
service aggregates by instances, 12.1.1.3
service aggregates by waits, 12.1.1.3
using ADDM, 1.6.3
performance evaluation
overview and concepts, 1.6.4
phases
cloning deployment, 5.3
cloning preparation, 5.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, 8.2.3
raw devices, 1.3.1
raw partitions
configuring, 10.4.3.1.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, 9.7
using, 2.4
redo log groups, 2.4
redo logs
format and destination specifications, 9.7
rekeying the master key, 11.3.8.1
REMOTE_LOGIN_PASSWORDFILE 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, 5.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, 9.4
configuring channels to use automatic load balancing, 9.5
configuring one channel for each instance, 9.5.2
crosschecking on multiple nodes, 9.4
local archiving scenario, 9.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, 5.3.2
issues the oifcfg command during add node, 8.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, 8.2, 10.3, 10.4
adding nodes and instances, quick-start format, 10.2
Oracle RAC, 11.1.3
scheduler
jobs, Preface
scripts
$ORACLE_HOME/root.sh, 5.3.2
security
wallet, 11.3.8.1
sequence numbers
with Oracle Real Application Clusters, 11.2
sequences
log sequence number, 9.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, 11.1.3
service
dependencies, 4.3.1
levels, 4.13
SRVCTL object noun name, A.7.2
service level objective
defining for Oracle RAC, 11.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, 12.1.1.3
activity levels aggregated by services, 12.1.1.3
activity levels aggregated by waits, 12.1.1.3
administering, 4.10
administering with DBCA, 4.11
administering with Oracle 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
setting up the wallet, 11.3.8.1
shared everything, 1.3.1
shared storage
configuring when extending Oracle RAC, 8.2.3
sharedhome argument, 8.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, 9.2
SPFILE
restore with Oracle 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.6.1
modify nodeapps command, A.7.9.5.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, 12.6
monitoring for Oracle Real Application Clusters, 12.6
Statspack, 12.9, 12.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, 8.2.3
subnet
configuring for virtual IP address, A.5
Summary dialog, 8.2.5.1, 10.4.5.1
SYS$BACKGROUND service, 4.3.2
SYS$USERS service, 4.3.2
SYSASM privilege, 3.2.2
SYSAUX tablespace, 11.3.3
SYSDBA
privilege for connecting, 3.1.2
SYSOPER privilege
for connecting, 3.1.2
system change, 9.7
System Global Area (SGA), 1.3.3
size requirements, 1.3.3

T

tablespaces
automatic segment-space management in Oracle RAC, 11.3.1
automatic undo management in Oracle RAC, 11.3.1
use in Oracle RAC, 11.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, 12.6
timeout
messages, avoiding, 1.3.2
Top Activity drill down menu
on the Cluster Database Performance page, 12.1.1.3
Top Cluster Events, ASH report, 12.8.2
Top Remote Instance, ASH report, 12.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, 11.3.8.1
specifying the ENCRYPTION_WALLET_LOCATION parameter, 11.3.8.1
specifying the WALLET_LOCATION parameter, 11.3.8.1
Transparent Database Encryption, 11.3.8.1
tuning
overview, 1.6.4
using ADDM, 1.6.3

U

UCP (Universal Connection Pool)
described, 4.5.1
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, 8.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, 12.5
for performance monitoring, 12.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, 12.9.1
aggregated for service performance, 12.1.1.3
wallet
data security, 11.3.8.1
setup, 11.3.8.1
WALLET_LOCATION parameter, 11.3.8.1
wallets
for Transparent Data Encryption, 11.3.8.1
Welcome page, 8.2.5.1, 10.4.5.1
workload
balancing with Oracle Scheduler, Preface
workload management
See automatic workload management
workloads
and services, 4.3.1
See Also automatic workload management

X

XA transactions, 4.8, 11.3.4
spanning Oracle RAC instances, Preface, 4.8