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.2
ACMS
Atomic Controlfile to Memory Service, 1.4.7
Active Session History
Oracle RAC, 13.8.1
Top Cluster Events, 13.8.2
Top Remote Instance, 13.8.3
active sessions, 13.8.1
ACTIVE_INSTANCE_COUNT initialization parameter, 3.7
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.13.1
services with SRVCTL, 5.13.3
administering instances
with Server Management, 3.1.1
administering Oracle Enterprise Manager jobs, 3.13.3.1
administering services
Oracle Enterprise Manager, 5.13
SRVCTL, 5.13
administrative tools
overview and concepts, 1.10.2
SYSASM privilege, 3.2.4
administrator-managed database, 1.6, 3.1
administrator-managed database instances
adding, 11.1.1
administrator-managed databases, 5.2.2.5
AVAILABLE instances for services, 5.2.2.5
converting to policy-managed, 3.8
PREFERRED instances for services, 5.2.2.5
ADRCI
ADR Command-Line Interpreter, B.2
Advanced Queuing
and FAN, 5.4.2
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.13.3.2
alert blackouts
Oracle Enterprise Manager, 3.13.3.3
alert logs, B.3
managing, B.1
ALTER SYSTEM ARCHIVE LOG CURRENT statement, 3.1.1.3.1
ALTER SYSTEM ARCHIVE LOG statement, 3.1.1.3.1
INSTANCE option, 3.1.1.3.1
ALTER SYSTEM CHECKPOINT LOCAL statement, 3.1.1.3.1
ALTER SYSTEM CHECKPOINT statement
global versus local, 3.1.1.3.1
specifying an instance, 3.1.1.3.1
ALTER SYSTEM KILL SESSION statement
terminating a session on a specific instance, 3.5
ALTER SYSTEM QUIESCE RESTRICTED statement
quiescing a noncluster database, 3.10
ALTER SYSTEM statement
CHECKPOINT clause, 3.1.1.3.1
ALTER SYSTEM SWITCH LOGFILE statement, 3.1.1.3.1, 3.1.1.3.1
Application Continuity
configuring service attributes, 5.13.3.2
introduction to, 1.5
requests, 5.6.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.9.1
using pre-created database sessions, 5.8.7
ARCHIVE LOG command
SQL*Plus, 3.1.1.3.1
archive logs
destinations, converting to cluster database, 14.1
ARCHIVE_LAG_TARGET initialization parameter, 3.7.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.9
ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter, 2.5.4, 3.7
Atomic Controlfile to Memory Service (ACMS), 1.4.7
Automatic Database Diagnostic Monitor, 13.9.2, 13.9.3.2, 13.9.5
Automatic Database Diagnostic Monitor (ADDM), 1.10.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.1
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.5, 5.1
manual rebalancing, 5.10
Automatic Workload Repository, 1.5, 5.10, 5.10, 5.11, 13.9.3.2
Automatic Workload Repository (AWR), 13.7, 13.9
monitoring performance, 5.2.1.3
snapshots, 13.7
AVAILABLE instances
for services, 5.2.2.5
Average Active Sessions chart
performance monitoring, 13.1.1.3
AWR
see Automatic Workload Repository

B

background processes
Oracle RAC, 1.4.7
SMON, 3.2.2, 7.3.1
background thread trace files, B.1
backups
and converting to cluster database, 14.1
server parameter file, 3.6.3
bandwidth
interconnect, 13.2
best practices
deploying Oracle RAC for high availability, 12.1.2
blackouts
defining, 3.13.3.3
block mode conversions
statistics for, 13.6
blocks
associated with instance, 7.3.1
buffer cache, 1.4.6
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.4.6, 12.3.5
and e-commerce applications, 12.3.5
overview, 1.10.4
Cache Fusion performance, 13.2
cache fusion transfers, 13.9.4
callouts
how they are run, 5.4.3
capacity
increasing, 12.1.4
cardinality, 3.1
catclustdb.sql script, 1.10.3
CATCLUST.SQL script
using to create views for Oracle RAC, 13.5
CDBs, 3.3
changing the configuration of all services, 4.2.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.4.2
client
application environments and FAN, 5.8
client connections with SCAN, 3.1
client drivers
and FAN, 5.8.1
clients
integrated for FAN events, 5.4.2
JDBC/OCI, 5.8.2.2
JDBC-thin driver, 5.8.2
client-side
load balancing, 5.3
client-side load balancing, 5.3.4
clone.pl, 8.4
clone.pl script
cloning parameters, 8.3
environment variables, 8.3
cloning, 1.7.4, 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 administrator, 3.1
cluster cache coherency, 13.1.1.2
cluster configuration policy, 1.6.4
cluster configuration policy set, 1.6.4
Cluster Database Performance page
Top Activity drill down menu, 13.1.1.3
cluster databases
creating using DBCA, 14.2.3.1.1
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.10.2
CLUSTER_DATABASE initialization parameter, 3.7, 3.7.1
CLUSTER_DATABASE_INSTANCE initialization parameter, 3.7.3
CLUSTER_DATABASE_INSTANCES initialization parameter, 3.7
CLUSTER_INTERCONNECTS
parameter, 13.3
CLUSTER_INTERCONNECTS initialization parameter, 3.7, 3.11.1
CLUSTER_NODE_NAME parameter
FAN, and matching database signature, 5.4.5
CLUSTER_NODES parameter
in clone.pl script, 8.3
clustered Oracle ASM
converting a noncluster Oracle ASM, 2.5.5
clusters
consolidating multiple databases in, 12.1.3
policy-managed, 1.6.4
clusterware management solution, 1.3
cold backups, 3.10
comma-delimited lists with SRVCTL, A.1
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.7.1
COMPATIBLE initialization parameter, 3.7.1
configuring channels
during restore or crosscheck operations, 6.5
configuring preferred mirror read disks in extended clusters, 2.5.4
CONNECT command, 3.1.1.3.1
SQL*Plus, 3.1.1.3.1
CONNECT SYS
example of, 3.2.4
connecting
to instances, 1.10.2
connection load balancing
introduction to, 1.5
long method, 5.3.1
short method, 5.3.1
connection pools
and FAN, 5.8.1
consistent blocks, 1.4.6
CONTROL_FILES initialization parameter, 3.7.1
convert to cluster database
from single-instance to Oracle Real Application Clusters, 14
post-conversion, 14.6
to Oracle RAC from single-instance databases, 14
convert to Oracle RAC database
from non-cluster system, 14.2.1
converting
from single instance to Oracle RAC, 14.3
from single-instance to Oracle Real Application Clusters, 14.3.4
with rconfig, 14.3
converting a database from Oracle RAC One Node to Oracle RAC, 4.2.2
converting an Oracle RAC database with one instance to Oracle RAC One Node, 4.2.1
corrupted data blocks, B.2
CREATE PFILE
FROM MEMORY clause, 3.6
CREATE PFILE statement, 3.6.3
CREATE SPFILE
FROM MEMORY clause, 3.6
creating
server parameter files, 3.6
services, 5.13.1
SPFILE backups, 3.6.3
crosscheck operations
configuring channels during, 6.5
crosschecking on multiple nodes
RMAN backups, 6.5
CRS resources
management of, 1.3
current blocks, 1.4.6
CVU
See Cluster Verification Utility

D

data dictionary
querying views, 13.5
Data Recovery Advisor, B.2
data security
keystore, 12.3.8.1
data warehouse
deploying applications for in Oracle RAC, 12.3.7
data warehouse systems, 12.3.7
database
services
singleton, 3.8
uniform, 3.8
SRVCTL object name, A.9
database cloud, 12.1.3.3
Database Configuration Assistant (DBCA)
adding and deleting instances in interactive mode
on Windows, 11.1.1.1
adding instances in interactive mode
on Linux and UNIX, 10.1.2.1
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
Instance Management page, 10.1.2.1, 11.1.1.1
List of Cluster Databases page, 10.1.2.1, 11.1.1.1
running the catclustdb.sql script, 1.10.3
Welcome page, 10.1.2.1
database deployment
administrator-managed, 1.6, 3.1
policy-managed, 1.6, 3.1
database instances
administrator managed
deleting, 10.2.1, 11.2.1
connecting to, 3.1.1.3
database pools, 12.1.3.3
database resource, 3.1
Database Resource Manager, 3.10
database role, 3.2.1
database signatures
matching the FAN parameters, 5.4.5
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.4.5
databases
administrator managed, 5.2.2.5
consolidating multiple in a cluster, 12.1.3
controlling restarts, 3.12
creating
Oracle RAC One Node, 4.1
Oracle RAC One Node
services on, 4.1
policy managed, 3.1, 5.2.2.6
scalability, 12.1.4
databases sessions
pre-created, 5.8.7
DB_BLOCK_SIZE initialization parameter, 3.7.1
DB_DOMAIN initialization parameter, 3.7.1
DB_FILES initialization parameter, 3.7.1
DB_NAME initialization parameter, 3.7, 3.7.1
DB_RECOVERY_FILE_DEST initialization parameter, 3.7.1, 7.6
DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 3.7.1
DB_UNIQUE_NAME initialization parameter, 3.7.1
DDL statements, 12.3.2
default database service, 1.7.3, 3.7, 5.13.1
degree of parallelism, 12.3.7.1
deleting administrator-managed database instances, 10.2.1, 11.2.1
dependencies
and services, 5.2.1.1
deploying
Oracle Real Application Clusters environments, 1.10.1, 12
design
Oracle Real Application Clusters environments, 1.10.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.9
DISPATCHERS initialization parameter, 3.7
specifying a service with, 5.13.1
Distributed Transaction Processing (DTP), 12.3.4
See DTP
distributed transactions, 12.3.4
directing to a single instance in the cluster, 5.9.2
services in Oracle RAC, 5.9.1
XA transactions span instances, 5.9.1
DML_LOCKS initialization parameter, 3.7.1
DTP, 5.9
services
relocating, 5.9.5
with Oracle RAC, 5.9.3
XA affinity, 5.9.2
XA transactions, 5.9.1
DTP Service., 5.9.2
dynamic database services
description, 1.5
Dynamic Database Services
introduction to, 1.4.3
dynamic performance views, 13.9
creating, 13.5
GV$, 1.10.3
V$, 1.10.3
dynamic resource allocation
overview, 1.10.4

E

e-commerce
applications in Oracle RAC, 12.3.5
edition
services attribute, 5.2.2.2
ENCRYPTION_WALLET_LOCATION parameter, 12.3.8.1
Enterprise Manager
overview, 1.3
environment variables
passed to the clone.pl script, 8.3
setting with SRVCTL, 3.1.1.1
error
recoverable, 5.5.1
evaluating block transfers, 13.6
event notification
enabling, 5.8.7
extended distance cluster, 2.5.4
Oracle ASM preferred mirror read, 2.5.4
extended distance clusters
configuring preferred mirror read disks, 2.5.4
extending Oracle database home
on shared storage
network-attached storage, 10.1, 11.1
Oracle ACFS, 10.1, 11.1
external transaction managers
OraMTS, 5.9.1

F

failure
instance, 7.3
multiple node, 7.3.2
node, 7.3.1
failure groups, 2.5.4
FAN
See Fast Application Notification (FAN)
Fast Application Notification (FAN), 5.4
and high availability events, 5.4.5
callouts
definition, 5.4.7
how to use, 5.4.7
events
enabling for JDBC, 5.8.2.2
enabling for JDBC-thin clients, 5.8.2
enabling for OCI, 5.8.6
enabling for ODP.NET, 5.8.9
enabling ODP.NET clients, 5.8.10
HA events, 5.8.1
how events are published, 5.4.2
introduction, 1.5
overview, 5.4.2
parameters and matching database signatures, 5.4.5
uses, 5.4.2
Fast Connection Failover (FCF)
enabling JDBC-thin clients, 5.8.2
enabling with thin and thick clients, 5.8.2.2
introduction to, 1.5
Fast Recovery
and files managed by Oracle, 14.3.4
fault diagnosability, B.2
FCF
See Fast Connection Failover (FCF)
files
archived redo log files, 6.8
redo log, 6.8
filesystem
SRVCTL object name, A.9
FROM MEMORY clause
on CREATE PFILE or CREATE SPFILE, 3.6

G

GC_SERVER_PROCESSES initialization parameter
specifying the number of LMSn processes, 12.1.3.2
GCS protocol, 13.9.3.1
GCS_SERVER_PROCESSES initialization parameter, 3.7
Generic server pool, 3.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.4.6, 3.7
Global Cache Service Process (LMS), 1.4.7
Global Cache Service Processes (LMSn)
reducing the number of, 12.1.3.2
specifying the number of, 12.1.3.2
Global Cache Service statistics, 13.9.1, 13.9.3.1
GLOBAL clause
forcing a checkpoint, 3.1.1.3.1
Global Data Services listeners
command to add to the cluster, A.9.7.1
Global Enqueue Service (GES), 1.4.6
Global Enqueue Service Daemon (LMD), 1.4.7
Global Enqueue Service Monitor (LMON), 1.4.7
Global Enqueue Service statistics, 13.9.1
global performance data
with ADDM, 13.7
Global Resource Directory (GRD), 1.4.6
global service attributes
GDSCTL, 5.14
global services, 5.14, 12.1.3.3
Global Transaction Process (GTX0-j), 1.4.7
GLOBAL_TXN_PROCESSES initialization parameter, 5.9.1
goals
and the load balancing advisory, 5.7.1
for load balancing advisory, 5.7.2
Grid Naming Service (GNS)
SRVCTL object name, A.9
GTX0-j
Global Transaction Process, 1.4.7
GV$, 1.10.3
GV$ view, 13.4
GV$SESSION, 3.5, 3.5

H

hash partitioning
with Oracle RAC, 12.2
havip
SRVCTL object name, A.9
high availability
best practices, 12.1.2
for Oracle RAC Databases, 12.1
high availability framework
introduction to, 1.5
home
SRVCTL object name, A.9
HOST command, 3.1.1.3.1
SQL*Plus, 3.1.1.3.1

I

idle wait class, 13.8.1
IM column store
See In-Memory Column Store
indexes
sequence-based, 12.2
initdb_name.ora file
DIAGNOSTIC_DEST initialization parameter, B.1
initialization parameters
cluster database issues regarding, 3.7
CLUSTER_INTERCONNECTS, 3.11.1, 13.3
recommendations for using, 3.11.1
identical settings for on all instances, 3.7.3
RECOVERY_PARALLELISM, 7.5.2.1
settings for instances, 3.6
specific to Oracle RAC, 3.7
that must be identical on all instances, 3.7.1
that must be unique on all instances, 3.7.2
In-Memory Column Store
overview, 1.9
INST_ID column, 13.4
installation
introduction, 1.7
installations
performing multiple simultaneous cluster, 8
instance
SRVCTL object name, A.9
instance discovery
Oracle Enterprise Manager Cloud Control, 3.13.1
Instance Enqueue Process (LCK0), 1.4.7
Instance Management page, 10.1.2.1, 11.1.1.1
INSTANCE NAME initialization parameter, 3.7
INSTANCE option, 3.1.1.3.1
INSTANCE parameter
FAN, and matching database signature, 5.4.5
instance recovery, 3.2.2
INSTANCE_NAME initialization parameter, 3.7.2
INSTANCE_NUMBER initialization parameter, 3.7.2
INSTANCE_TYPE initialization parameter, 3.7.1
instances
aggregated for service performance, 13.1.1.3
cloning Oracle RAC, 8.3
effect of SQL*Plus commands on, 3.1.1.3.1
failure, 7.3.2
initialization parameter settings, 3.6
maximum number for Oracle RAC, 1.1
memory structures, 1.4.6
parallel processes, 5.2.1.4
private interconnect usage, B.6
recovery, 3.2.2, 7.3.1
recovery, abnormal shutdown, 3.2.2
recovery, multiple failures, 7.3.2
Server Management, 3.1.1
shutting down, 3.2.2
starting and stopping, 3.2
terminating session on, 3.5
verifying, 3.4, 3.4
verifying running, 3.4.2
instances failure
recovery from, 7.3
instead of Statspack, 1.10.3
interconnect
and performance, 13.3
and the Oracle RAC architecture, 1.1
defined, 1.4.2
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.11
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, 1.5
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
enabling Fast Application Notification events for, 5.8.2.2
JDBC/OCI, 5.8.2.2
JDBC-thin clients
enabling for Fast Connection Failover (FCF), 5.8.2
JDBC-thin driver, 5.8.2
job administration
Oracle Enterprise Manager, 3.13.3.1

K

keystore
data security, 12.3.8.1
KILL SESSION clause
on the ALTER SYSTEM statement, 3.5

L

LCK0
Instance Enqueue Process, 1.4.7
level thresholds
services, 5.12
LICENSE_MAX_USERS initialization parameter, 3.7.3
List of Cluster Databases page, 10.1.2.1, 11.1.1.1
listener
SRVCTL object name, A.9
listeners
command to add to a node, A.9.6.1
command to remove, A.9.126.1
Oracle Net, 1.3
LMD
Global Enqueue Service Daemon, 1.4.7
LMON Global Enqueue Service Monitor, 1.4.7
LMS
Global Cache Service Process, 1.4.7
LMS processes
reducing the number of, 12.1.3.2
LMSn processes
reducing the number of, 12.1.3.2
load balancing, 12.3.5
OCI runtime connection, 5.8.7
server-side, 5.3
load balancing advisory
and FAN events, 5.7.3
configuring your environment for using, 5.7.2
deployment, 5.7.1
description of, 5.7
events and FAN, 5.4.2
introduction to, 1.5
Load Balancing Advisory, 5.2.2.7
local archiving scenario
RMAN, 6.9.2
Local Area Network (LAN), 1.4.2
LOCAL clause
forcing a checkpoint, 3.1.1.3.1
local file system
archiving parameter settings, 6.9.2.2
restore, 7.2.2
local instance
shutting down, 3.2.4
starting, 3.2.4
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.7.3
LOG_ARCHIVE_FORMAT parameter, 6.8

M

management database
SRVCTL object name, A.9
management listener
SRVCTL object name, A.9
mass deployment
cloning, 8, 8.2
media failures
recovery from, 7.4
Memory Guard, 3.9
memory structures
in Oracle RAC, 1.4.6
message request counters, 13.6
migration
application, 12.1.4
from single-instance, 14.2
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.10.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.1
multiple cluster interconnects, 3.11
multiple databases in a cluster, 3.11.1
multiple instances
starting from a single SQL*Plus session, 3.2.4
starting from one node, 3.2.4
multiple node failures, 7.3.2
multiple public networks, 1.4.4
multiplexed redo log files, 2.3
multitenant container database
See CDBs
mutables
rules for grants, 5.6.1.1

N

net service name, 3.1.1.3
network
restricting service registration, 1.4.5, 5.2.4
SRVCTL object name, A.9
Network Attached Storage (NAS), 1.4.2
network resources, 1.4.4
node
failure and VIP addresses, 1.4.4
node affinity awareness, 7.3.4
node discovery
Oracle Enterprise Manager Cloud Control, 3.13.1
node evictions, 13.1.1.1
node VIPs, 1.4.4
nodeapps
SRVCTL object name, A.9
nodes
affinity awareness, 7.3.4
failure of, 7.3.1
virtual IP addresses, A.4, A.4
noncluster databases
quiescing, 3.10
noncluster Oracle ASM
converting to clustered Oracle ASM, 2.5.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.9
OC4J
SRVCTL object name, A.9
OCI
runtime connection load balancing, 5.8.7
session pooling, 5.8.7
session pools
optimizing, 5.8.7
runtime connection load balancing, 5.8.7
service metrics, 5.8.7
OCRDUMP utility, 13.3
ODP.NET
and Fast Connection Failover, 5.8.9
load balancing advisory events, 5.8.10
OLTP environments, 12.2
online database relocation
relocation feature, 4.3
online recovery, 7.3.1
online transaction processing (OLTP)
applications in Oracle RAC, 12.3.5
ons
SRVCTL object name, A.9
ONS
See Oracle Notification Service
optimal execution plans, 12.3.7.1
Oracle ACFS, 1.4.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.5.5
installation, 1.7.3
instances
administering with SRVCTL, 2.5.6
Oracle ASM preferred read failure groups, 2.5.4
preferred mirror read disks, 2.5.4
preferred read disks, 3.7
SRVCTL object name, A.9
storage solution, 2.1
SYSASM privilege, 3.2.4
Oracle Call Interface
See OCI
Oracle Cluster Registry (OCR), 3.1.1.1, 13.3
Oracle Clusterware
cloning, 1.7.4
control policies
AUTOMATIC, 3.12
MANUAL, 3.12
using SRVCTL to display and change, 3.12
controlling database restarts, 3.12
described, 1.3, 1.3
introduction, 1.3
introduction and concepts of, 1
managing Oracle processes, 1.3
Oracle Database
session activity, 13.8.1
Oracle Database Upgrade Assistant, 14
Oracle Enterprise Manager
adding database instances to nodes
on Linux and UNIX, 10.1.2
on Windows, 11.1.1
alert administration, 3.13.3.2
alert blackouts, 3.13.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.8
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.13.3.1
monitoring load values for available nodes, 13.1.1.3
overview and concepts, 1.10.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.1.2
using to administer services, 5.13.2
using to back up the server parameter file, 3.6.3
using to convert single-instance databases to Oracle Real Application Clusters, 14.3.4
using to create DTP services, 5.9.4
using to monitor Oracle Clusterware, 13.1.1
using to monitor Oracle RAC, 13.1.1
using to monitor Oracle RAC environments, 1.10.3
using to restore SPFILE, 7.2.3
using to schedule Automatic Workload Repository actions, 5.12
using to set up a fast recovery area, 7.6
using to start or stop a database, 3.2
using with RMAN, 6.4
Oracle Enterprise Manager Cloud Control
instance discovery, 3.13.1
node discovery, 3.13.1
Oracle Grid Infrastructure, 1.1
Oracle home
defined, 1.7.2
Oracle Interface Configuration (OIFCFG), 13.3
Oracle Managed Files, 3.1
Oracle Maximum Availability Architecture (MAA), 12.1.1
Oracle Multitenant, 1.8
Oracle Net
listeners, 1.3
Oracle Net connection failover, 5.3.2
Oracle Net Services
and load balancing, 5.8.1
and services, 5.2.2.8
Oracle Notification Service, 1.3
SRVCTL object name, A.9
used by FAN, 1.5
Oracle Notification Services
API, 5.4.2
Oracle processes
managed by Oracle Clusterware, 1.3
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
and e-commerce, 12.3.5
background processes
ACMS, 1.4.7
GTX0-j, 1.4.7
LCK0, 1.4.7
LMD, 1.4.7
LMON, 1.4.7
LMS, 1.4.7
RMSn, 1.4.7
RSMN, 1.4.7
benefits of cloning, 8.1
cloning, 8
size of the binaries, 8.1
converting database from, 4.2
converting database to, 4.2
converting from non-cluster system, 14.2.1
converting single instance to Oracle RAC One Node, 4.2.1
copying the Oracle RAC home, 8.2
databases
converting from single-instance Oracle databases, 14
quiescing, 3.10
deploying clone, 8.3
diagnosing performance problems, 13.8.1
diagnosing problems for, B
overview of administration, 1
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.2
software components, 1.4.6
storage options
IBM GPFS, 1.4.1
network file system (NFS), 1.4.1
Oracle Automatic Storage Management (Oracle ASM), 1.4.1
Oracle Automatic Storage Management Cluster File System (Oracle ACFS), 1.4.1
Oracle OCFS2, 1.4.1
volume manager, 1.4.1
using a fast recovery area in, 7.6
Oracle RAC One Node, 4
converting database from, 4.2
converting database to, 4.2
converting to Oracle RAC, 4.2.2
creating databases, 4.1
database
services on, 4.1
online database relocation, 4.3
relocating to another node, 4.3
Oracle Real Application Clusters
See Oracle RAC
Oracle Real Application Clusters One Node
See Oracle RAC One Node
Oracle Resource Manager
and services, 5.2.1.2
Oracle Services
using, 5.13
Oracle Services for Microsoft Transaction Server
creating the OraMTS service, 11.1.1.1
Oracle Streams, 5.2.1.5
Oracle Streams Advanced Queuing
and FAN, 5.4.2
Oracle Universal Installer
database installation, 1.7.2
Oracle Real Application Clusters installation, 1.7.2
Oracle XA, 5.2.2.9
ORACLE_BASE environment variable, 8.3
ORACLE_HOME environment variable, 8.3
ORACLE_HOME_NAME environment variable, 8.3
ORACLE_SID parameter, 3.7.2
oradebug ipc command, B.6
OraMTS
external transaction manager, 5.9.1
See Oracle Services for Microsoft Transaction Server
orapwd file, 3.8
outages
planned, 5.4.4
unplanned, 5.4.3

P

parallel execution, 12.3.7.2
parallel processes, 5.2.1.4
parallel recovery, 7.5.2.1
disabling, 7.5.2
PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 3.7.1
PARALLEL_FORCE_LOCAL initialization parameter, 5.2.1.4
PARALLEL_INSTANCE_GROUPS initialization parameter, 5.2.1.4
parallelism
in Oracle RAC, 12.3.7.2
parallel-aware query optimization, 12.3.7.1
parameter file
overview, 3.6
parameter file search order, 3.6.2
parameters
DB_RECOVERY_FILE_DEST, 7.6
that must be identical on all instances, 3.7.1
that must be unique on all instances, 3.7.2
password file-based authentication, 4.3
PDBs, 3.3
managing, 3.3
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.10.3
performance evaluation
overview and concepts, 1.10.4
performance statistics, 13.9.5
PFILE
using with Oracle RAC, 3.6
phases
cloning deployment, 8.3
cloning preparation, 8.2
pluggable database
See PDBs
PMON background process, 3.5
policy set, 1.6.4
policy-managed clusters, 1.6.4
policy-managed database, 1.6, 3.1
policy-managed database instances
adding, 11.1
policy-managed databases, 3.1, 3.7.2, 5.2.2.6
deleting on Linux and UNIX, 10.2.1
deleting on Windows, 11.2.1
deploying, 1.6.2
managing, 1.6.3
PREFERRED instances
for services, 5.2.2.5
preferred read disks
Oracle ASM in an Oracle RAC extended distance cluster, 2.5.4
private clouds, 12.1.3.3
private interconnect, B.6
determining usage, B.6
private network
alternative interconnect, 3.11
private network IP address, 13.3
processes
managed by Oracle Clusterware, 1.3
parallel, 5.2.1.4
public and private interfaces
shown in Oracle Enterprise Manager, 13.1.1.2
public network
defined, 1.4.2

Q

query optimizer, 12.3.7.1
default cost model for, 12.3.7.1
queue tables, 5.2.1.5
quiesce database
in Oracle Real Application Clusters, 3.10
quiesced databases, 3.10
quiescing
noncluster database, 3.10

R

rconfig, 14.3
rebalancing
workloads, 5.10
RECOVER command, 3.1.1.3.1
SQL*Plus, 3.1.1.3.1
recoverable error, 5.5.1
recovery
after SHUTDOWN ABORT, 3.2.2
from multiple node failure, 7.3.2
from single-node failure, 7.3.1
instance, 3.2.2
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.3
redo log groups, 2.3
redo logs
format and destination specifications, 6.8
redo thread, 3.1
reducing contention, 12.2
regions, 12.1.3.3
remote Oracle Notification Service subscription, 5.8.2.1
Remote Slave Monitor (RSMN), 1.4.7
REMOTE_LOGIN_PASSWORDFILE initialization parameter, 3.7.1
replicated databases
and global services, 5.14
resource contention, 13.1.1.3
resource manager, 5.10
resource profiles
and service creation, 5.2.1.1
resources
releasing, 7.3.1
resources held by the session, 3.5
restore scenarios
RMAN, 7.2
restore scheme
cluster file system, 7.2.1
local file system, 7.2.2
result cache, 3.7
disabling, 3.7
enabling, 3.7
RESULT_CACHE_MAX_SIZE initialization parameter, 3.7, 3.7.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
local archiving scenario, 6.9.2
restore scenarios, 7.2
using to create SPFILE backups, 3.6.3
RMSn
Oracle RAC management processes, 1.4.7
rolling back
instance recovery, 7.3.1
root.sh script
$ORACLE_HOME, 8.3
RSMN
Remote Slave Monitor, 1.4.7
runtime connection load balancing
defined, 5.8.7
in OCI session pools, 5.8.7
introduction to, 1.5
Runtime Connection Load Balancing, 5.2.2.7

S

scalability, 12.3.5
Oracle RAC, 12.1.4
scan
SRVCTL object name, A.9
SCAN, 1.3
SCAN listener
and restricting service registration, 1.4.5, 5.2.4
scan_listener
SRVCTL object name, A.9
scripts
$ORACLE_HOME/root.sh, 8.3
security
keystore, 12.3.8.1
sequence-based indexes, 12.2
sequences
log sequence number, 6.8
server
SRVCTL object name, A.9
Server Control Utility
see SRVCTL
Server Management
administration of instances, 3.1.1
server parameter file
backing up, 3.6.3
server parameter files
creating, 3.6
server pool, 3.1
SRVCTL object name, A.9
server pools, 1.6.1
creating for a policy-managed database, 3.8
Generic, 3.1
XML conversion files for, 14.5
servers
relocating from another server pool, 3.8
scalability, 12.1.4
service
SRVCTL object name, A.9
service level objective
defining for Oracle RAC, 12.1.1
service levels, 12.3.6
service metrics
OCI runtime connection load balancing, 5.8.7
runtime connection load balancing, 5.8.7
SERVICE parameter
FAN, and matching database signature, 5.4.5
SERVICE TIME
load balancing advisory goal, 5.7.2
SERVICE_NAMES initialization parameter, 3.7
setting for services, 3.7, 5.13.1
service-level agreements, 3.5
services, 3.7
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.13.1
administering with Oracle Enterprise Manager, 5.13
administering with SRVCTL, 5.13, 5.13.3
attributes
edition, 5.2.2.2
basic concepts about, 5.1
configuring automatic workload management characteristics, 5.2.2
default, 5.2.3
dependencies, 5.2.1.1
enabling event notification, 5.8.7
global, 5.14
introduction to, 1.5
level thresholds, 5.12
management policy
automatic, 5.2.2.3
manual, 5.2.2.3
performance monitored by AWR, 5.2.1.3
restricting registration with listeners, 1.4.5, 5.2.4
SERVICE_NAMES parameter, 3.7, 5.13.1
specifying a service, 5.13.1
using, 5.1
services for administrator-managed databases, 3.8
sessions
terminating on a specific instance, 3.5
setting instances, 1.10.2, 3.1.1.3
shared everything, 1.4.1
shared server configuration, 3.7
SHOW INSTANCE command, 3.1.1.3.1
SQL*Plus, 3.1.1.3.1
SHOW PARAMETER command
SQL*Plus, 3.1.1.3.1
SHOW PARAMETERS command, 3.1.1.3.1
SHOW SGA command, 3.1.1.3.1
SQL*Plus, 3.1.1.3.1
SHUTDOWN ABORT, 3.2.2, B.5
SHUTDOWN command
ABORT option, 3.2.2
SQL*Plus, 3.1.1.3.1
SHUTDOWN IMMEDIATE, B.5
SHUTDOWN TRANSACTIONAL, 3.2.2
shutting down
instances, 3.2.2
shutting down an instance
abnormal shutdown, 3.2.2
shutting down instances, 3.2.2
sidalrt.log file, B.3
single client access name
See SCAN
Single Client Access Name (SCAN)
SRVCTL object name, A.9
single system image, 1.4.6
single-instance database
convert to Oracle RAC database
administrative considerations, 14.1
single-instance databases
converting, 14.3.4
converting to Oracle RAC database, 14
SMON process
instance recovery, 7.3.1, 7.3.2
recovery after SHUTDOWN ABORT, 3.2.2
snapshot control file, 6.3
configuring locations, 6.3
speed-up for data warehouse systems, 12.3.7.1
SPFILE
backing up, 3.6.3
backups
creating, 3.6.3
changing parameter settings, 3.6
corrupted, 3.6.1
default names, 3.6.2
location, 3.6
naming convention for, 3.6.2
recovering, 3.6.3
restore with Oracle Enterprise Manager, 7.2.3
restore with RMAN, 7.2.3
setting values in, 3.6.1
SPFILE initialization parameter, 3.7, 3.7.3
SQL statements
executing in parallel, 5.2.1.4
instance-specific, 3.1.1.3.1
SQL*Plus, 3.1.1.3, 3.1.1.3
commands
CONNECT, 3.1.1.3
effect on instances, 3.1.1.3.1
SRVCTL
add, usage description, A.9.1
administering Oracle ASM instances, 2.5.6
administering services with, 5.13.3
cluster database configuration tasks, A.4
cluster database tasks, A.4
command feedback, A.1
command syntax, A.9
commands
add cvu, A.9.2.1, A.9.119.1
add database, A.9.3.1
add havip, A.9.4.1
add instance, A.9.5.1
add listener, A.9.6.1
add mgmtlsnr, A.9.7.1
add network, A.9.8.1
add nodeapps, A.9.9.1
add ons, A.9.11.1
add scan, A.9.12.1
add scan_listener, A.9.13.1
add service, A.9.14.1
add srvpool, A.9.15.1
add vip, A.9.16.1
config cvu, A.9.18.1
config database, A.9.19.1
config havip, A.9.20.1
config listener, A.9.21.1
config network, A.9.22.1
config nodeapps, A.9.23.1
config oc4j, A.9.24
config ons, A.9.25
config scan, A.9.26.1
config scan_listener, A.9.27.1
config service, A.9.28.1
config srvpool, A.9.29.1
config vip, A.9.30.1
config volume, A.9.31.1
convert database, A.9.32.1
disable cvu, A.9.34.1
disable database, A.9.35.1
disable diskgroup, A.9.36.1
disable filesystem, A.9.37.1
disable gns, A.9.38.1
disable havip, A.9.39.1
disable instance, A.9.40.1
disable listener, A.9.41.1
disable mgmtdb, A.9.42.1
disable mgmtlsnr, A.9.43.1
disable nodeapps, A.9.44.1
disable oc4j, A.9.45.1
disable ons, A.9.46
disable scan, A.9.47.1
disable scan_listener, A.9.48.1
disable service, A.9.49.1
disable vip, A.9.50.1
disable volume, A.9.51.1
downgrade database, A.9.52
enable asm, A.9.54.1
enable cvu, A.9.55.1
enable database, A.9.56.1
enable diskgroup, A.9.57.1
enable filesystem, A.9.58.1
enable gns, A.9.59.1
enable havip, A.9.60.1
enable instance, A.9.61.1
enable listener, A.9.62.1
enable mgmtdb, A.9.63.1
enable mgmtlsnr, A.9.64.1
enable nodeapps, A.9.65.1
enable oc4j, A.9.66.1
enable ons, A.9.67.1
enable scan, A.9.68.1
enable scan_listener, A.9.69.1
enable service, A.9.70.1
enable vip, A.9.71.1
enable volume, A.9.72.1
-eval parameter, A.1
export gns, A.9.73.1
getenv asm, A.9.75.1
getenv database, A.9.76.1
getenv listener, A.9.77.1
getenv mgmtdb, A.9.78.1
getenv mgmtlsnr, A.9.79.1
getenv nodeapps, A.9.80.1, A.9.81.1
help, A.5
import gns, A.9.82.1
modify asm, A.9.84.1
modify cvu, A.9.85.1
modify database, A.9.86.1
modify filesystem, A.9.87.1
modify gns, A.9.88.1
modify havip, A.9.89.1
modify instance, A.9.90.1
modify listener, A.9.91.1
modify mgmtdb, A.9.92.1
modify mgmtlsnr, A.9.93.1
modify network, A.9.94.1
modify nodeapps, A.9.95.1
modify oc4j, A.9.96.1
modify ons, A.9.97.1
modify scan, A.9.98.1
modify scan_listener, A.9.99.1
modify service, A.9.100
modify srvpool, A.9.101.1
modify vip, A.9.102.1
predict asm, A.9.103.1.1
predict database, A.9.103.2
predict diskgroup, A.9.103.3.1
predict filesystem, A.9.103.4.1
predict listener, A.9.103.5.1
predict network, A.9.103.6.1
predict oc4j, A.9.103.7.1
predict scan, A.9.103.8.1
predict scan_listener, A.9.103.9.1
predict service, A.9.103.10.1
predict vip, A.9.103.11.1
relocate asm, A.9.105.1
relocate cvu, A.9.106.1
relocate database, A.9.107.1
relocate gns, A.9.108.1
relocate havip, A.9.109.1
relocate mgmtdb, A.9.110.1
relocate oc4j, A.9.111.1
relocate scan, A.9.112.1
relocate scan_listener, A.9.113.1
relocate server, A.9.114.1
relocate service, A.9.115.1
relocate vip, A.9.116.1
remove asm, A.9.118.1
remove database, A.9.120.1
remove diskgroup, A.9.121.1
remove filesystem, A.9.122.1
remove gns, A.9.123.1
remove havip, A.9.124.1
remove instance, A.9.125.1
remove listener, A.9.126.1
remove mgmtdb, A.9.127.1
remove mgmtlsnr, A.9.128.1
remove network, A.9.129.1
remove nodeapps, A.9.130.1
remove oc4j, A.9.131.1
remove ons, A.9.132.1
remove scan, A.9.133.1
remove scan_listener, A.9.134.1
remove service, A.9.135.1
remove srvpool, A.9.136.1
remove vip, A.9.137.1
remove volume, A.9.138.1
setenv asm, A.9.140.1
setenv database, A.9.141.1, A.9.146.1
setenv listener, A.9.142.1
setenv mgmtdb, A.9.143.1
setenv mgmtlsnr, A.9.144.1
setenv nodeapps, A.9.145.1
srvctl setenv, 3.1.1.1
start asm, A.9.148.1
start cvu, A.9.149.1
start database, 3.2.1, A.9.150.1
start diskgroup, A.9.151.1
start filesystem, A.9.152.1
start gns, A.9.153.1
start havip, A.9.154.1
start instance, 3.2.1, A.9.156.1
start listener, A.9.157.1
start mgmtdb, A.9.158.1, A.9.159.1
start nodeapps, A.9.160.1
start oc4j, A.9.161.1
start ons, A.9.162.1
start scan, A.9.163.1
start scan_listener, A.9.164.1
start service, A.9.165.1
start vip, A.9.166.1
start volume, A.9.167.1
status asm, A.9.169.1
status cvu, A.9.170.1
status database, A.9.171.1
status diskgroup, A.9.172.1
status filesystem, A.9.173.1
status gns, A.9.174.1
status havip, A.9.175.1
status home, A.9.176.1
status instance, A.9.177.1
status listener, A.9.178.1
status mgmtdb, A.9.179.1
status mgmtlsnr, A.9.180.1
status nodeapps, A.9.181.1
status oc4j, A.9.182.1
status ons, A.9.183.1
status scan, A.9.184.1
status scan_listener, A.9.185.1
status server, A.9.186.1
status service, A.9.187.1
status srvpool, A.9.188.1
status vip, A.9.189.1
status volume, A.9.190.1
stop asm, A.9.192.1
stop cvu, A.9.193.1
stop database, 3.2.1, A.9.194.1, A.9.202.1
stop diskgroup, A.9.195.1
stop filesystem, A.9.196.1
stop gns, A.9.197.1
stop havip, A.9.198.1
stop home, A.9.199.1
stop instance, 3.2.1, A.9.200.1
stop listener, A.9.201.1
stop mgmtlsnr, A.9.203.1
stop nodeapps, A.9.204.1
stop oc4j, A.9.205.1
stop ons, A.9.206.1
stop scan, A.9.207.1
stop scan_listener, A.9.208.1
stop service, A.9.209.1
stop vip, A.9.210.1
stop volume, A.9.211.1
unsetenv asm, A.9.213.1
unsetenv database, A.9.214.1, A.9.219.1
unsetenv listener, A.9.215.1
unsetenv mgmtdb, A.9.216.1
unsetenv mgmtlsnr, A.9.217.1
unsetenv nodeapps, A.9.218.1
update database, A.9.221
update gns, A.9.222
update listener, A.9.223
update scan_listener, A.9.224
upgrade database, A.9.225
concurrent commands, A.1
config, usage description, A.9.17
deprecated commands and options, A.8
difference between SRVCTL and CRSCTL, A.7
disable, usage description, A.9.33
enable, usage description, A.9.53
enabling event notification, 5.8.7
getenv, usage description, A.9.74
modify, usage description, A.9.83
node-level tasks, A.4
object name
database, A.9
diskgroup, A.9
filesystem, A.9
Grid Naming Service (GNS), A.9
havip, A.9
home, A.9
instance, A.9
listener, A.9
mgmtdb, A.9
mgmtlsnr, A.9
network, A.9
node applications (nodeapps), A.9
oc4j, A.9
Oracle Automatic Storage Management (Oracle ASM), A.9
Oracle Notification Service, A.9
scan, A.9
scan_listener, A.9
server, A.9
server pool (srvpool), A.9
service, A.9
vip, A.9
volume, A.9
object names, A.9
overview, 3.1.1.1
overview and concepts, 1.10.2
predict, usage description, A.9.103
relocate, usage description, A.9.104
remove, usage description, A.9.117
setenv, usage description, A.9.139
specifying a continuation of command line entries, A.1
specifying command parameters in a file, A.2.1
start, usage description, A.9.147
status, usage description, A.9.168
stop or start cluster database, 3.2.1
stop, usage description, A.9.191
stopping active commands, A.7
unsetenv, usage description, A.9.212
using comma-delimited lists, A.1
SRVM_TRACE environment variable, B.4
Standard Edition
installing Oracle ASM, 1.7.3
starting administrator-managed databases, 3.2.1
starting policy-managed databases, 3.2.1
STARTUP command
SQL*Plus, 3.1.1.3.1
statistics
contents of, 13.6
Statspack, 13.9, 13.9.1
usage, 1.10.3
stop database instances, 3.2.1
storage
cluster file system, 2.1
Oracle Automatic Storage Management (Oracle ASM), 2.5.1
subnet
configuring for virtual IP address, A.4, A.4
subnets, 1.4.4
SYS$BACKGROUND service, 5.2.3
SYS$USERS service, 5.2.3
SYSASM privilege, 3.1.1.3, 3.2.4
SYSAUX tablespace
increasing size when adding nodes, 12.3.3
reducing size when removing nodes, 12.3.3
SYSDBA, 3.1.1.3
privilege for connecting, 3.1.1.3
SYSDBA connections to an Oracle ASM instance, 3.1.1.3
SYSOPER, 3.1.1.3
SYSOPER privilege
for connecting, 3.1.1.3
system change, 6.8
System Global Area (SGA), 1.4.6, 13.8.1
size requirements, 1.4.6

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.4.3
terminating a session on a specific instance, 3.5
THREAD initialization parameter, 3.7
threads
multiple application, 5.8.7
THROUGHPUT
load balancing advisory goal, 5.7.2
timed statistics, 13.6
tnsnames.ora file, 3.7
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.7.3
tracing
enabling Java-based tools and utilities, B.4
SRVM_TRACE environment variable, B.4
writing to log files, B.4
transaction failover, 5.5.1
Transaction Guard, 5.5.1
configuring JDBC-thin clients, 5.8.4, 5.8.5
configuring OCI clients, 5.8.8
configuring service attributes, 5.13.3.2
configuring services for, 5.5.3
introduction to, 1.5
transactional TAF, 5.8.8
transactions
distributed SQL, 5.9.1
DTP/XA, 5.9.1
instance failure, 7.3.1
rolling back, 3.5, 7.3.1
waiting for recovery, 7.3.1
Transparent Application Failover
and services, 5.6.3
Transparent Data Encryption
specifying the ENCRYPTION_WALLET_LOCATION parameter, 12.3.8.1
with encrypted keystores and obfuscated keystores, 12.3.8.1
tuning
overview, 1.10.4
using ADDM, 1.10.3

U

undo tablespace, 3.1
UNDO_MANAGEMENT initialization parameter, 3.7.1
UNDO_RETENTION initialization parameter, 3.7.3
UNDO_TABLESPACE parameter, 3.7.2
User Datagram Protocol (UDP), B.6
user process trace files, B.1

V

V$, 1.10.3
V$ view, 13.4
V$ACTIVE_INSTANCES, 3.4.2, 3.4.2
V$CLUSTER_INTERCONNECTS, 13.2, B.6
V$CONFIGURED_INTERCONNECTS, 13.2
valid node checking, 1.4.5, 5.2.4
vendor clusterware, 1.1
verification
data files, online files, 2.2
verifying interconnect settings, 13.2
versions
compatibility for Oracle RAC and Oracle Database software, 1.7.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.5, 3.5
instance-specific, 13.4
V$ views, 13.4
VIP
SRVCTL object name, A.9
VIPs
node, 1.4.4
Virtual Internet Protocol (VIP) address, 1.1
virtual IP address
requirements, A.4, A.4
VNCR
See valid node checking, 1.4.5, 5.2.4
volume
SRVCTL object name, A.9

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
Welcome page, 10.1.2.1
Windows Firewall, 12.3.8.2
workload management
See automatic workload management
workloads
and services, 5.1
See Also automatic workload management

X

XA affinity, 5.9.2
XA transactions, 5.9.1
spanning Oracle RAC instances, 5.9.1
XA Transactions, 12.3.4