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

Part Number E10718-03
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
View PDF

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

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, 3.6.1
adding a new Oracle ASM instance, 9.1.1.1
adding Oracle RAC to nodes, 9.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.2
administering instances
with Server Management, 3.1
administering services
Oracle Enterprise Manager, 4.11
SRVCTL, 4.11
administrative tools
overview and concepts, 1.6.2
SYSASM privilege, 3.2.2
administrator-managed databases, 3.1.1, 4.3.1
AVAILABLE instances for services, 4.3.1
converting to policy-managed, 3.1.1
defined, 1.6.1
PREFERRED instances for services, 4.3.1
ADRCI
ADR Command-Line Interpreter, B.2
Advanced Queuing
and FAN, 4.4.1
affinity
awareness, 7.3.5
aggregates
by instances, 11.1.1.3
by services, 11.1.1.3
by waits, 11.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.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 single-instance database, 3.7
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, 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
ARCHIVE LOG command
SQL*Plus, 3.1.3.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
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, 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, 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)
cloning, 6
converting single-instance ASM to clustered ASM, 2.6.5
converting single-instance to a cluster storage manager, 2.6.5
instance creation on newly added nodes, 6
preferred read disks, 3.6
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, 7.3.1
background thread trace files, B.1
backups
server parameter file, 3.5.3
bandwidth
interconnect, 11.2
benefits
of cloning Oracle Clusterware, 6.1
best practices
deploying Oracle RAC for high availability, 10.1.1
block mode conversions
statistics for, 11.6
blocks
associated with instance, 7.3.1
buffer cache, 1.3.3
instance recovery, 7.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_SHORT, 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, 6.3.1
environment variables, 6.3.1
cloning, 1.5.3, 6, 6.2
benefits, 6.1
deployment phase, 6.3
log files, 6.4
parameters passed to the clone.pl script, 6.3.1
preparation phase, 6.2
running $ORACLE_HOME/root.sh script, 6.3.1
setting ORACLE_BASE, 6.3.1
setting ORACLE_HOME, 6.3.1
setting ORACLE_HOME_NAME, 6.3.1
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, 7.2.1
storage in Oracle RAC, 2.1
Cluster Host Load Average page
cluster database performance, 11.1.1.3
Cluster Managed Database Services Detail Page, 4.11.1.3
Cluster Managed Database Services Page, 4.11.1.2
CLUSTER NODE NAME parameter
FAN, and matching database signature, 4.4.5
cluster nodes name
in clone.pl script, 6.3.1
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, 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, 6.3.1
clustered ASM
converting a single-instance ASM, 2.6.5
clusters
consolidating multiple databases in, 10.1.2
clusterware management solution, 1.2
CMAN session pools
and FAN, 4.6
command-line interpreter
ADR Command-Line Interpreter (ADRCI), B.2
committed data
instance failure, 7.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.4
CONNECT command, 3.1.3, 3.1.3.2
SQL*Plus, 3.1.3.2
CONNECT SYS
example of, 3.2.2
connecting
to instances, 1.6.2, 3.1.3
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
converting ASM single-instance to clustered ASM, 2.6.5
CREATE PFILE
FROM MEMORY clause, 3.5
Create Services Page, 4.11.1.4
CREATE SPFILE
FROM MEMORY clause, 3.5
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
See Cluster Verification Utility

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
services
singleton, 3.1.1
uniform, 3.1.1
SRVCTL object name, A
Database Configuration Assistant (DBCA), 1.5.2
adding and deleting instances in silent mode, 9.1.1.2
cloning Oracle RAC instances, 6.3.1
creating views for Oracle Real Application Clusters, 11.5
Database Storage page, 9.1.1.1
Instance Management page, 9.1.1.1
List of Cluster Databases page, 9.1.1.1
Operations page, 9.1.1.1
running the catclustdb.sql script, 1.6.3
Summary dialog, 9.1.1.1
Welcome page, 9.1.1.1
database instances
administrator-managed
deleting, 9.2.1
database signatures
matching the FAN parameters, 4.4.5
Database Storage page, 9.1.1.1
Database Throughput page
performance monitoring, 11.1.1.3
DATABASE UNIQUE NAME parameter
FAN, and matching database signature, 4.4.5
databases
administrator-managed, 3.1.1, 4.3.1
consolidating multiple in a cluster, 10.1.2
controlling restarts, 3.9
policy-managed, 3.1.1, 4.3.1
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
see Database Configuration Assistant (DBCA)
default database service, 1.5.2, 3.6, 4.10
degree of parallelism (DOP), 10.3.7.2
deleting administrator-managed database instances, 9.2.1
dependencies
and services, 4.3.1
deploying
Oracle RAC database software, 6.3.1
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.3
disconnecting from instances, 3.1.3
diskgroup
SRVCTL object name, A
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, 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
administering services, 4.11.1
Cluster Database page, 11.1.1
overview, 1.2
environment variables
passed to the clone.pl script, 6.3.1
eons
SRVCTL object name, A
event notification
enabling, 4.6.3
examples
setting the CLUSTER_INTERCONNECTS parameter, 3.8.2
extended distance cluster
Oracle ASM preferred mirror read, 2.6.4
extended distance clusters
configuring preferred mirror read disks, 2.6.4
external transaction managers
OraMTS, 4.8

F

failover callback routine, 4.7
failure
instance, 7.3
multiple node, 7.3.2
node, 7.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 ODP.NET, 4.6.4
events, enabling for Oracle Call Interface, 4.6.2
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 with thin and thick clients, 4.6.1.1
introduction to, 4.1
Fast Connection Failover (FCF)
enabling JDBC clients, 4.6.1
fault diagnosability, B.2
FCF
See Fast Connection Failover (FCF)
features, new, Preface
files
archived redo log files, 5.7
redo log, 5.7
filesystem
SRVCTL object name, A
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
Generic server pool, 3.1.1
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.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, 11.9.1
global performance data
with ADDM, 11.7
Global Resource Directory (GRD), 1.3.3
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
Grid Naming Service (GNS)
SRVCTL object name, A
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
home
SRVCTL object name, A
HOST command, 3.1.3.2
SQL*Plus, 3.1.3.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, 7.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, 6
instance
SRVCTL object name, A
instance discovery
Oracle Enterprise Manager Grid Control, 3.10.1
Instance Enqueue Process (LCK0), 1.3.4
Instance Management page, 9.1.1.1
INSTANCE NAME initialization parameter, 3.6
INSTANCE option, 3.1.3.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, 6.3.1
effect of SQL*Plus commands on, 3.1.3.2
failure, 7.3.2
failures, recovery from, 7.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, 7.3.1
recovery, abnormal shutdown, 3.2
recovery, multiple failures, 7.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
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
IPD/OS
See Oracle Instantaneous Problem Detection - OS Tool

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 (FCF), 4.6.1
job administration
Oracle Enterprise Manager, 3.10.2.1

K

KILL SESSION clause
on the ALTER SYSTEM statement, 3.4

L

LCK0 Instance Enqueue Process, 1.3.4
LICENSE_MAX_USERS initialization parameter, 3.6.3
List of Cluster Databases page, 9.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, 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
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.3.2
local file system
archiving parameter settings, 5.8.2.2
restore, 7.2.2
local node name
in clone.pl script, 6.3.1
LOCAL_NODE parameter
in clone.pl script, 6.3.1
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, 6, 6.2
media failures
recovery from, 7.4
memory structures
in Oracle RAC, 1.3.3
message request counters, 11.6
migration
application, 10.1.3
mission critical systems
considerations for Oracle RAC, 10.1
modified data
instance recovery, 7.3.1
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, 7.3.2
multiple nodes
starting from one node, 3.2.2
multiplexed redo log files, 2.4

N

Network Attached Storage (NAS), 1.3.2
new features, Preface
NIC bonding, 3.8
node
failure and VIP addresses, 1.3.2
node discovery
Oracle Enterprise Manager Grid Control, 3.10.1
nodeapps
SRVCTL object name, A
nodes
affinity awareness, 7.3.5
failure of, 7.3.1
virtual IP addresses, A, A

O

objects
creation of and effect on performance, 10.3.2
srvctl object names and abbreviations, A
OC4J
SRVCTL object name, A
OCFS2, 1.3.1
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
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 Fast Connection Failover, 4.6.4
load balancing advisory events, 4.6.5
online recovery, 7.3.1
online transaction processing
applications in Oracle Real Application Clusters, 10.3.5
ons
SRVCTL object name, A
Operations page, 9.1.1.1
Oracle ASM
see Oracle Automatic Storage Management (Oracle ASM)
Oracle ASM instances
administering with SRVCTL, 2.6.6
Oracle Automatic Storage Management (Oracle ASM)
adding a new instance, 9.1.1.1
archiving scenario, 5.8.1
installation, 1.5.2
Oracle ASM preferred read failure groups, 2.6.4
preferred mirror read disks, 2.6.4
SRVCTL object name, A
storage solution, 2.1
Oracle Call Interface (OCI)
runtime connection load balancing, 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, 1.2
introduction, 1.2
introduction and concepts of, 1
managing Oracle processes, 1.2
Oracle Dynamic Volume Manager
described, Preface
Oracle Enterprise Manager, 3.1.2
adding database instances to nodes, 9.1.1
alert administration, 3.10.2.2
alert blackouts, 3.10.2.3
Automatic Database Diagnostic Monitoring (ADDM), 11.7
Cluster Database Performance page
Cluster Database Performance page, 11.1.1.3
Cluster Managed Database Services Detail Page, 4.11.1.3
Cluster Managed Database Services Page, 4.11.1.2
Create Services Page, 4.11.1.4
deleting database instances from nodes, 9.2.1
Interconnects page, 11.1.1.2
job administration, 3.10.2.1
overview and concepts, 1.6.2
services pages, accessing, 4.11.1.5
using the Interconnects page to monitor Oracle Clusterware, 11.1.1
Oracle Enterprise Manager Grid Control
instance discovery, 3.10.1
node discovery, 3.10.1
Oracle home
cloning, 1.5.3
Oracle Instantaneous Problem Detection - OS Tool (IPD/OS), 1.6.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
SRVCTL object name, A
used by FAN, 4.3.1
Oracle Notification Services
API, 4.4.1
Oracle processes
managed by Oracle Clusterware, 1.2
Oracle RAC
adding to nodes in a cluster, 9.1
cloning, 1.5.3, 6
removing, 9.2.2
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), 1.3.1
volume manager, 1.3.1
Oracle RAC Management Processes (RMSn), 1.3.4
Oracle RAC One Node, Preface
Oracle Real Application Clusters
and e-commerce, 10.3.5
installation overview, 1.5.2
overview of administration, 1
Oracle Real Application Clusters One Node, Preface
Oracle Streams Advanced Queuing
and FAN, 4.4.1
ORACLE_BASE environment variable, 6.3.1
ORACLE_HOME, 1.5.2
ORACLE_HOME environment variable, 6.3.1
ORACLE_HOME_NAME environment variable, 6.3.1
ORACLE_SID parameter, 3.6.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, 7.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, 7.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, 6.3
cloning preparation, 6.2
policy-managed databases, 3.1.1, 4.3.1
defined, 1.6.1
deleting, 9.2.1
PREFERRED instances
for services, 4.3.1
preferred read disks
Oracle ASM in an Oracle RAC extended distance cluster, 2.6.4
private interconnect
determining usage, B.6
private network
alternative interconnect, 3.8
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

rebalancing
workloads, 4.1
RECOVER command, 3.1.3.2
SQL*Plus, 3.1.3.2
recovery
after SHUTDOWN ABORT, 3.2
from multiple node failure, 7.3.2
from single-node failure, 7.3.1
instance, 3.2
media failures, 7.4
online, 7.3.1
parallel, 7.5.2.1
PARALLEL_MAX_SERVERS initialization parameter, 7.5.2.1
RECOVERY_PARALLELISM parameter, 7.5.2.1
redo log files
instance recovery, 7.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_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, 7.3.1
restore scenarios
RMAN, 7.2
restore scheme
cluster file system, 7.2.1
local file system, 7.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, 7.2
RMSn Oracle RAC Management Processes, 1.3.4
rolling back
instance recovery, 7.3.1
root.sh script
$ORACLE_HOME, 6.3.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
Oracle RAC, 10.1.3
SCAN, 1.2
defined, 1.4
scan
SRVCTL object name, A
scan_listener
SRVCTL object name, A
scripts
$ORACLE_HOME/root.sh, 6.3.1
security
wallet, 10.3.8.1
sequence numbers
with Oracle Real Application Clusters, 10.2
sequences
log sequence number, 5.7
Server Control Utility
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
server pool
SRVCTL object name, A
server pools
concepts, 1.4
servers
scalability, 10.1.3
service
dependencies, 4.3.1
levels, 4.13
SRVCTL object name, A
service level objective
defining for Oracle RAC, 10.1
service metrics
OCI runtime connection load balancing, 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 Oracle Enterprise Manager, 4.11
administering with SRVCTL, 4.11, 4.11.2
basic concepts about, 4.3.1
concepts, 1.4
configuring automatic workload management characteristics, 4.10
default, 4.3.2
enabling event notification, 4.6.3
introduction to, 1.3.2, 4.1
management policy
automatic, 4.3.1
manual, 4.3.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.3
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.3
shared everything, 1.3.1
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 command, 3.2
SHUTDOWN command
ABORT option, 3.2
SQL*Plus, 3.1.3.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 client access name
See SCAN
single client access name (SCAN)
SRVCTL object name, A
single system image, 1.3.3
single-instance ASM
converting to clustered ASM, 2.6.5
single-instance databases
quiescing, 3.7
SMON process
instance recovery, 7.3.1, 7.3.2
recovery after SHUTDOWN ABORT, 3.2
snapshot control file, 5.2
SPFILE
restore with Oracle Enterprise Manager, 7.2.3
restore with RMAN, 7.2.3
SPFILE initialization parameter, 3.6, 3.6.3
SQL statements
executing in parallel, 4.10
instance-specific, 3.1.3.2
SQL*Plus, 3.1.3
changing the prompt, 3.1.3.1
SQL*Plus commands
effect on instances, 3.1.3.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, usage description, A
administering Oracle ASM instances, 2.6.6
administering services with, 4.11.2
cluster database configuration tasks, A
cluster database tasks, A
command syntax, A
commands
add asm, A
add database, A
add eons, A
add filesystem, A
add gns, A
add instance, A
add listener, A
add nodeapps, A
add ons, A
add scan, A
add scan_listener, A
add service, A, A, A
add srvpool, A
add vip, A
config asm, A, A
config database, A
config eons, 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
disable asm, A
disable database, A
disable diskgroup, A
disable eons, 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, 4.11.2.3, A
disable vip, A
enable asm, A
enable database, A
enable diskgroup, A, A
enable eons, 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, 4.11.2.3, A
enable vip, A
getenv asm, A
getenv database, A
getenv listener, A
getenv nodeapps, A, A
help, A
modify asm, A
modify database, A
modify eons, A, A
modify filesystem, A
modify instance, A
modify listener, A
modify nodeapps, A
modify oc4j, A
modify ons, A
modify scan, A
modify scan_listener, A
modify service, A
modify srvpool, A
relocate gns, A
relocate oc4j, A
relocate scan, A
relocate scan_listener, A
relocate server, A
relocate service, A
remove asm, A
remove database, A
remove diskgroup, A
remove eons, 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
start asm, A
start database, A
start diskgroup, A
start eons, A, A
start gns, A
start home, A
start instance, 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 database, A
status diskgroup, A
status eons, 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 database, A
stop diskgroup, A
stop eons, A
stop filesystem, A
stop gns, A
stop home, A
stop instance, 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
concurrent commands, A
config, usage description, A
deprecated commands and options, A
disable, usage description, A
enable, usage description, A
getenv, usage description, A
modify, usage description, A
node-level tasks, A
object name
database, A
diskgroup, A
eons, A
filesystem, A
Grid Naming Service (GNS), A
home, A
instance, A
listener, A
node applications (nodeapps), A
oc4j, A
Oracle Automatic Storage Management (Oracle ASM), A
Oracle Notification Service (ONS), 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 database command, 3.2.3
start instance command, 3.2.3
start service command, 4.11.2.2, 4.11.2.2
start, usage description, A
status service command, 4.11.2.5
status, usage description, A
stop database command, 3.2.3
stop instance command, 3.2.3
stop, usage description, A
unsetenv, usage description, A
srvctl
enabling event notification, 4.6.3
SRVM_TRACE environment variable, B.4
Standard Edition
installing ASM, 1.5.2
STARTUP command
SQL*Plus, 3.1.3.2
statistics
contents of, 11.6
monitoring for Oracle Real Application Clusters, 11.6
Statspack, 11.9, 11.9.1
usage, 1.6.3
storage
cluster file system, 2.1
Oracle Automatic Storage Management (Oracle ASM), 2.6.1
subnet
configuring for virtual IP address, A, A
Summary dialog, 9.1.1.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.3
SYSOPER privilege
for connecting, 3.1.3
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, 7.3.1
rolling back, 7.3.1
waiting for recovery, 7.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
Universal Connection Pool
benefits, Preface

V

V$ACTIVE_INSTANCES, 3.3, 3.3
vendor clusterware, 1.1
verification
data files, 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
SRVCTL object name, A
Virtual Internet Protocol (VIP) address, 1.2
virtual IP address
requirements, A, A

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.1.1.1
workload management
See automatic workload management
workloads
and services, 4.3.1
See Also automatic workload management

X

XA transactions, 4.8, 10.3.4
spanning Oracle RAC instances, 4.8