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

Part Number E16795-08
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, 8.3

A

abnormal instance termination, 3.2.1
ACMS
Atomic Controlfile to Memory Service, 1.3.4
Active Session History, Oracle RAC, 13.8.1
Active Session History, Top Cluster Events, 13.8.2
Active Session History, Top Remote Instance, 13.8.3
active sessions, 13.8.1
ACTIVE_INSTANCE_COUNT initialization parameter, 3.6
adding nodes to an existing cluster, 9.1
adding Oracle RAC to nodes on Linux and UNIX, 10.1
adding Oracle RAC to nodes on Windows, 11.1
ADDM
global monitoring, 13.7
see Automatic Database Diagnostic Monitor
ADDM for Oracle Real Application Clusters mode, 13.7
administering
services, 5.9.1
services with SRVCTL, 5.9.3
administering instances
with Server Management, 3.1
administering Oracle Enterprise Manager jobs, 3.10.3.1
administering services
Oracle Enterprise Manager, 5.9
SRVCTL, 5.9
administrative tools
overview and concepts, 1.6.2
SYSASM privilege, 3.2.3
administrator-managed database instances
adding, 11.1.1
administrator-managed databases, 3.1.1, 5.3.2.6
AVAILABLE instances for services, 5.3.2.6
converting to policy-managed, 3.1.1.2
defined, 1.6.1
PREFERRED instances for services, 5.3.2.6
ADRCI
ADR Command-Line Interpreter, B.2
Advanced Queuing
and FAN, 5.5.1
Advisor Central in Oracle Enterprise Manager, 13.7
aggregates
by instances, 13.1.1.3
by services, 13.1.1.3
by waits, 13.1.1.3
alert administration
Oracle Enterprise Manager, 3.10.3.2
alert blackouts
Oracle Enterprise Manager, 3.10.3.3
alert logs, B.3
managing, B.1
ALTER SYSTEM ARCHIVE LOG CURRENT statement, 3.1.3.2
ALTER SYSTEM ARCHIVE LOG statement, 3.1.3.2
INSTANCE option, 3.1.3.2
ALTER SYSTEM CHECKPOINT LOCAL statement, 3.1.3.2
ALTER SYSTEM CHECKPOINT statement
global versus local, 3.1.3.2
specifying an instance, 3.1.3.2
ALTER SYSTEM KILL SESSION statement
terminating a session on a specific instance, 3.4
ALTER SYSTEM QUIESCE RESTRICTED statement
quiescing a 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, 12.1.3
highly available, 12.1
scalability, 12.1.4
spanning XA transactions across Oracle RAC instances, 5.8.1
using pre-created database sessions, 5.7.5
ARCHIVE LOG command
SQL*Plus, 3.1.3.2
ARCHIVE_LAG_TARGET initialization parameter, 3.6.3
archived redo log files
applying in parallel, 7.5.1
file format and destination, 6.8
file naming, 6.7
log sequence number, 6.8
archiver process
monitor, 6.10
archiving mode
changing, 6.2
ASH reports, 13.8.1
asm
SRVCTL object name, A
ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter, 2.6.4, 3.6
Atomic Controlfile to Memory Service (ACMS), 1.3.4
Automatic Database Diagnostic Monitor, 13.9.2, 13.9.3.2, 13.9.5
Automatic Database Diagnostic Monitor (ADDM), 1.6.3
analyzing AWR data, 13.7
DBMS_ADDM PL/SQL package, 13.7
DBMS_ADVISOR PL/SQL package, 13.7
Global ADDM mode, 13.7
Local ADDM mode, 13.7
Automatic Database Diagnostic Monitoring (ADDM), 13.7
Automatic Diagnostic Repository (ADR), B.2
ADRCI command-line interpreter, B.2
automatic load balancing
configuring RMAN channels for multiple instances, 6.6
AUTOMATIC management policy, 3.2.4
Automatic Performance Diagnostics (AWR)
monitor performance statistics, 13.7
automatic segment space management (ASSM), 12.3.1
tablespace use in Oracle RAC, 12.3.1
automatic undo management
tablespace use in Oracle RAC, 12.3.1
automatic workload management
concepts, 1.4, 5.3.1
description, 5.1
manual rebalancing, 5.2
Automatic Workload Repository, 5.1, 5.2, 5.2, 5.10, 13.9.3.2
Automatic Workload Repository (AWR), 13.7, 13.9
monitoring performance, 5.3.3.3
snapshots, 13.7
AVAILABLE instances
for services, 5.3.2.6
Average Active Sessions chart
performance monitoring, 13.1.1.3
AWR
see Automatic Workload Repository

B

background processes
Oracle RAC, 1.3.4
SMON, 3.2.1, 7.3.1
background thread trace files, B.1
backups
server parameter file, 3.5.3
bandwidth
interconnect, 13.2
best practices
deploying Oracle RAC for high availability, 12.1.2
blackouts
defining, 3.10.3.3
block mode conversions
statistics for, 13.6
blocks
associated with instance, 7.3.1
buffer cache, 1.3.3
instance recovery, 7.3.1
buffer sizes
interprocess communication (IPC)
adjusting for Oracle RAC, 13.3

C

cache coherency, 13.9.3.1
Cache Fusion, 1.3.3, 12.3.5
and e-commerce applications, 12.3.5
overview, 1.6.4
Cache Fusion performance, 13.2
cache fusion transfers, 13.9.4
callouts
how they are run, 5.5.3
capacity
increasing, 12.1.4
catclustdb.sql script, 1.6.3
CATCLUST.SQL script
using to create views for Oracle RAC, 13.5
channels
configure one RMAN channel for each Oracle RAC instance, 6.6.2
configuring during crosscheck or restore operations, 6.5
configuring for RMAN, 6.6
chart
Global Cache Block Access Latency, 13.1.1.3
charts
Average Active Sessions, 13.1.1.3
Cluster Host Load Average, 13.1.1.3
Database Throughput, 13.1.1.3
checking the interconnect, B.6
CLB_GOAL_SHORT, 5.5.1
client
application environments and FAN, 5.7
clients
integrated for FAN events, 5.5.1
JDBC Thin Driver, 5.7.2
JDBC/OCI, 5.7.2.2
client-side
load balancing, 5.4
client-side load balancing, 5.4.1
clone.pl, 8.4
clone.pl script
cloning parameters, 8.3
environment variables, 8.3
cloning, 1.5.3, 8, 8.2
deployment phase, 8.3
log files, 8.4
parameters passed to the clone.pl script, 8.3
preparation phase, 8.2
running $ORACLE_HOME/root.sh script, 8.3
setting ORACLE_BASE, 8.3
setting ORACLE_HOME, 8.3
setting ORACLE_HOME_NAME, 8.3
cloning log files, 8.4
cluster
definition of, 1.1
cluster cache coherency, 13.1.1.2
Cluster Database Performance page
Top Activity drill down menu, 13.1.1.3
cluster file system
archiving parameter settings, 6.9.1.2
archiving scenario, 6.9.1
restore, 7.2.1
storage in Oracle RAC, 2.1
Cluster Host Load Average page
cluster database performance, 13.1.1.3
cluster nodes name
in clone.pl script, 8.3
Cluster Verification Utility
overview and concepts, 1.6.2
CLUSTER_DATABASE initialization parameter, 3.6, 3.6.1
CLUSTER_DATABASE_INSTANCE initialization parameter, 3.6.1
CLUSTER_DATABASE_INSTANCES initialization parameter, 3.6
CLUSTER_INTERCONNECTS
parameter, 13.3
CLUSTER_INTERCONNECTS initialization parameter, 3.8.1
CLUSTER_INTERCONNECTS parameter
examples, 3.8.2, 3.8.2
CLUSTER_NODE_NAME parameter
FAN, and matching database signature, 5.5.5
CLUSTER_NODES parameter
in clone.pl script, 8.3
clustered Oracle ASM
converting a single-instance Oracle ASM, 2.6.5
clusters
consolidating multiple databases in, 12.1.3
clusterware management solution, 1.2
CMAN session pools
and FAN, 5.7.1
cold backups, 3.7
command-line interpreter
ADR Command-Line Interpreter (ADRCI), B.2
committed data
instance failure, 7.3.1
communication protocols
verifying settings for, 13.2
compatibility
Oracle RAC and Oracle Database software, 1.5.1
COMPATIBLE initialization parameter, 3.6.1
configuring channels
during restore or crosscheck operations, 6.5
configuring preferred mirror read disks in extended clusters, 2.6.4
CONNECT command, 3.1.3.2
SQL*Plus, 3.1.3.2
CONNECT SYS
example of, 3.2.3
connecting
to instances, 1.6.2, 3.1.3
connection load balancing
concepts, 1.4
introduction to, 5.1
long method, 5.4.3
short method, 5.4.3
connection pools
and FAN, 5.7.1
consistent blocks, 1.3.3
CONTROL_FILES initialization parameter, 3.6.1
corrupted data blocks, B.2
CREATE PFILE
FROM MEMORY clause, 3.5
CREATE PFILE statement, 3.5.3
CREATE SPFILE
FROM MEMORY clause, 3.5
creating
server parameter files, 3.5
services, 5.9.1
SPFILE backups, 3.5.3
crosscheck operations
configuring channels during, 6.5
crosschecking on multiple nodes
RMAN backups, 6.5
CRS resources
management of, 1.2
current blocks, 1.3.3
CVU
See Cluster Verification Utility

D

data dictionary
querying views, 13.5
Data Recovery Advisor, B.2
data security
wallet, 12.3.8.1
data warehouse
deploying applications for in Oracle RAC, 12.3.7
data warehouse systems, 12.3.7
database
creation, 1.5.2
services
singleton, 3.1.1.2
uniform, 3.1.1.2
SRVCTL object name, A
Database Configuration Assistant (DBCA), 1.5.2
adding and deleting instances in interactive mode
on Windows, 11.1.1.1
adding and deleting instances in silent mode
on Windows, 11.1.1.2
adding instances in interactive mode
on Linux and UNIX, 10.1.1.1
adding instances in silent mode
on Linux and UNIX, 10.1.1.2
cloning Oracle RAC instances, 8.3
creating views for Oracle Real Application Clusters, 13.5
Database Storage page, 10.1.1.1, 11.1.1.1
deleting instances in interactive mode
on Linux and UNIX, 10.2.1.1
on Windows, 11.2.1.1
deleting instances in silent mode
on Linux and UNIX, 10.2.1.2
on Windows, 11.2.1.2
Instance Management page, 10.1.1.1, 11.1.1.1
List of Cluster Databases page, 10.1.1.1, 11.1.1.1
Operations page, 10.1.1.1, 11.1.1.1
running the catclustdb.sql script, 1.6.3
Summary dialog, 10.1.1.1
Welcome page, 10.1.1.1, 11.1.1.1
database instances
administrator managed
deleting, 10.2.1, 11.2.1
Database Resource Manager, 3.7
database role, 3.2.4
database signatures
matching the FAN parameters, 5.5.5
database state, 3.2
Database Storage page, 10.1.1.1, 11.1.1.1
Database Throughput page
performance monitoring, 13.1.1.3
DATABASE_UNIQUE_NAME parameter
FAN, and matching database signature, 5.5.5
databases
adding
Oracle RAC One Node, 4.1
administrator managed, 3.1.1, 5.3.2.6
consolidating multiple in a cluster, 12.1.3
controlling restarts, 3.9
Oracle RAC One Node
services on, 4.1
policy managed, 3.1.1, 5.3.2.7
scalability, 12.1.4
databases sessions
pre-created, 5.7.5
Datagram Protocol (UDP), 1.3.2
DB_BLOCK_SIZE initialization parameter, 3.6.1
DB_DOMAIN initialization parameter, 3.6.1
DB_FILES initialization parameter, 3.6.1
DB_NAME initialization parameter, 3.6, 3.6.1
DB_RECOVERY_FILE_DEST initialization parameter, 3.6.1, 7.6
DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 3.6.1
DB_UNIQUE_NAME initialization parameter, 3.6.1
DBCA
see Database Configuration Assistant (DBCA)
DDL statements, 12.3.2
default database service, 1.5.2, 3.6, 5.9.1
degree of parallelism (DOP), 12.3.7.1
deleting administrator-managed database instances, 10.2.1, 11.2.1
dependencies
and services, 5.3.3.1
deploying
Oracle Real Application Clusters environments, 1.6.1, 12
design
Oracle Real Application Clusters environments, 1.6.1, 12
diagnosing problems for Oracle RAC, B
diagnosing problems using ADR, B.2
DIAGNOSTIC_DEST initialization parameter, B.1, B.3
diskgroup
SRVCTL object name, A
DISPATCHERS initialization parameter, 3.6
specifying a service with, 5.9.1
displaying IP addresses
with ifconfig, 3.8.2
with netstat, 3.8.2
distributed SQL transactions, 5.8.1
Distributed Transaction Processing (DTP), 12.3.4
distributed transactions, 12.3.4
directing to a single instance in the cluster, 5.8.2
services in Oracle RAC, 5.8.1
XA transactions span instances, 5.8.1
DML_LOCKS initialization parameter, 3.6.1
DTP Service., 5.8.2
DTP/XA transactions, 5.8.1
dynamic performance views, 13.9
creating, 13.5
dynamic resource allocation
overview, 1.6.4

E

e-commerce
applications in Oracle RAC, 12.3.5
edition
services attribute, 5.3.2.3
ENCRYPTION_WALLET_LOCATION parameter, 12.3.8.1
Enterprise Manager
administering services, 5.9.2
Cluster Database page, 13.1.1
overview, 1.2
environment variables
passed to the clone.pl script, 8.3
setting with SRVCTL, 3.1.4
evaluating block transfers, 13.6
event notification
enabling, 5.7.5
examples
setting the CLUSTER_INTERCONNECTS parameter, 3.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, 5.8.1

F

failure
instance, 7.3
multiple node, 7.3.2
node, 7.3.1
FAN events
enabling for JDBC, 5.7.2.2
Fast Application Notification (FAN), 5.5
and high availability events, 5.5.5
callouts definition, 5.5.6
callouts, how to use, 5.5.6
events, enabling for JDBC clients, 5.7.2
events, enabling for ODP.NET, 5.7.6
events, enabling for Oracle Call Interface, 5.7.4
events, enabling ODP.NET clients, 5.7.7
how events are published, 5.5.1
introduction, 5.1
overview, 5.5.1
parameters and matching database signatures, 5.5.5
uses, 5.5.1
Fast Connection Failover (FCF)
enabling JDBC clients, 5.7.2
enabling with thin and thick clients, 5.7.2.2
introduction to, 5.1
fault diagnosability, B.2
FCF
See Fast Connection Failover (FCF)
features, new, Preface
files
archived redo log files, 6.8
redo log, 6.8
filesystem
SRVCTL object name, A
FROM MEMORY clause
on CREATE PFILE or CREATE SPFILE, 3.5

G

GC_SERVER_PROCESSES initialization parameter
specifying the number of LMSn processes, 12.1.3
GCS protocol, 13.9.3.1
GCS_SERVER_PROCESSES initialization parameter, 3.6
Generic server pool, 3.1.1
GES
See global cache and enqueue service (GES)
global cache and enqueue service (GES), 13.9.1
Global Cache Block Access Latency chart
performance monitoring, 13.1.1.3
Global Cache Service (GCS), 1.3.3, 3.6
Global Cache Service Process (LMS), 1.3.4
Global Cache Service Processes (LMSn)
reducing the number of, 12.1.3
specifying the number of, 12.1.3
Global Cache Service statistics, 13.9.1, 13.9.3.1
GLOBAL clause
forcing a checkpoint, 3.1.3.2
Global Enqueue Service (GES), 1.3.3
Global Enqueue Service Daemon (LMD), 1.3.4
Global Enqueue Service Monitor (LMON), 1.3.4
Global Enqueue Service statistics, 13.9.1
global performance data
with ADDM, 13.7
Global Resource Directory (GRD), 1.3.3
Global Transaction Process (GTX0-j), 1.3.4
GLOBAL_TXN_PROCESSES initialization parameter, 5.8.1
goals
and the load balancing advisory, 5.6.1
for load balancing advisory, 5.6.2
Grid Naming Service (GNS)
SRVCTL object name, A
GTX0-j
Global Transaction Process, 1.3.4
GV$ view, 13.4
GV$SESSION, 3.4, 3.4

H

hash partitioning
with Oracle RAC, 12.2
high availability
best practices, 12.1.2
for Oracle RAC Databases, 12.1
high availability framework
concepts, 1.4
introduction to, 5.1
home
SRVCTL object name, A
HOST command, 3.1.3.2
SQL*Plus, 3.1.3.2

I

idle wait class, 13.8.1
Implicit Connection Cache, 5.7.2
indexes
sequence-based, 12.2
initdb_name.ora file
DIAGNOSTIC_DEST initialization parameter, B.1
initialization parameters
cluster database issues regarding, 3.6
CLUSTER_INTERCONNECTS, 3.8.1, 13.3
recommendations for using, 3.8.1
identical settings for on all instances, 3.6.3
RECOVERY_PARALLELISM, 7.5.2.1
settings for instances, 3.5
specific to Oracle RAC, 3.6
that must be identical on all instances, 3.6.1
that must be unique on all instances, 3.6.2
INST_ID column, 13.4
installation
introduction, 1.5
Oracle Real Application Clusters, 1.5.2
installations
performing multiple simultaneous cluster, 8
instance
SRVCTL object name, A
instance discovery
Oracle Enterprise Manager Grid Control, 3.10.1
Instance Enqueue Process (LCK0), 1.3.4
Instance Management page, 10.1.1.1, 11.1.1.1
INSTANCE NAME initialization parameter, 3.6
INSTANCE option, 3.1.3.2
INSTANCE parameter
FAN, and matching database signature, 5.5.5
instance recovery, 3.2.1
INSTANCE_NAME initialization parameter, 3.6.2
INSTANCE_NUMBER initialization parameter, 3.6.2
INSTANCE_TYPE initialization parameter, 3.6.1
instances
aggregated for service performance, 13.1.1.3
cloning Oracle RAC, 8.3
effect of SQL*Plus commands on, 3.1.3.2
failure, 7.3.2
initialization parameter settings, 3.5
maximum number for Oracle RAC, 1.1
memory structures, 1.3.3
parallel processes, 5.3.3.4
private interconnect usage, B.6
recovery, 3.2.1, 7.3.1
recovery, abnormal shutdown, 3.2.1
recovery, multiple failures, 7.3.2
Server Management, 3.1
shutting down, 3.2.1
starting and stopping, 3.2
terminating session on, 3.4
verifying, 3.3, 3.3
verifying running, 3.3
instances failure
recovery from, 7.3
instead of Statspack, 1.6.3
interconnect
and performance, 13.3
and the Oracle RAC architecture, 1.1
protocols for Oracle Real Application Clusters, 13.2
verifying settings for, 13.2
interconnect bandwidth, 13.2
latency, 13.2
interconnect block transfer rates, 13.6
interconnect settings
verifying, 13.2
interconnects
alternatives to the private network, 3.8
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
ONS usage, 5.1
Java-based tools and utilities
CVU, B.4
DBCA, B.4
DBUA, B.4
enabling tools for tracing, B.4
GSD, B.4
NETCA, B.4
SRVCTL, B.4
JDBC
and FAN, 5.7.1
enabling FAN events for, 5.7.2.2
JDBC clients
enabling for Fast Connection Failover (FCF), 5.7.2
JDBC Thin Driver, 5.7.2
JDBC/OCI, 5.7.2.2
job administration
Oracle Enterprise Manager, 3.10.3.1

K

KILL SESSION clause
on the ALTER SYSTEM statement, 3.4

L

LCK0
Instance Enqueue Process, 1.3.4
level thresholds
services, 5.11
LICENSE_MAX_USERS initialization parameter, 3.6.3
List of Cluster Databases page, 10.1.1.1, 11.1.1.1
listener
SRVCTL object name, A
listeners
command to add to a node, A
command to remove, A
Oracle Net, 1.2
LMD
Global Enqueue Service Daemon, 1.3.4
LMON Global Enqueue Service Monitor, 1.3.4
LMS
Global Cache Service Process, 1.3.4
LMS processes
reducing the number of, 12.1.3
LMSn processes
reducing the number of, 12.1.3
load balancing, 12.3.5
by services, 1.3.2
OCI runtime connection, 5.7.5
server-side, 5.4
Load Balancing Advisory, 5.3.2.8
load balancing advisory
and FAN events, 5.6.3
concepts, 1.4
configuring your environment for using, 5.6.2
deployment, 5.6.1
description of, 5.6
events and FAN, 5.5.1
introduction to, 5.1
local archiving scenario
RMAN, 6.9.2
Local Area Network (LAN), 1.3.2
LOCAL clause
forcing a checkpoint, 3.1.3.2
local file system
archiving parameter settings, 6.9.2.2
restore, 7.2.2
local instance
shutting down, 3.2.3
starting, 3.2.3
local node name
in clone.pl script, 8.3
LOCAL_NODE parameter
in clone.pl script, 8.3
locally managed tablespaces, 12.3.1
log files
tracing, B.4
log sequence numbers, 6.8
LOG_ARCHIVE_FORMAT initialization parameter, 3.6.3
LOG_ARCHIVE_FORMAT parameter, 6.8

M

mass deployment
cloning, 1.5.3, 8, 8.2
media failures
recovery from, 7.4
memory structures
in Oracle RAC, 1.3.3
message request counters, 13.6
migration
application, 12.1.4
missing files, B.2
mission critical systems
considerations for Oracle RAC, 12.1.1
modified data
instance recovery, 7.3.1
monitoring
archiver process, 6.10
overview and concepts, 1.6.3
performance of global cache block access, 13.1.1.3
monitoring host load average, 13.1.1.3
mount all non-running instances of an Oracle RAC database, 3.2.4
multiple cluster interconnects, 3.8
multiple databases in a cluster, 3.8.1
multiple instances
starting from a single SQL*Plus session, 3.2.3
starting from one node, 3.2.3
multiple node failures, 7.3.2
multiple public networks, 1.3.2
multiplexed redo log files, 2.4

N

net service name, 3.1.3
network
SRVCTL object name, A
Network Attached Storage (NAS), 1.3.2
NIC bonding, 3.8
node
failure and VIP addresses, 1.3.2
node affinity awareness, 7.3.4
node discovery
Oracle Enterprise Manager Grid Control, 3.10.1
node evictions, 13.1.1.1
nodeapps
SRVCTL object name, A
nodes
affinity awareness, 7.3.4
failure of, 7.3.1
virtual IP addresses, A, A

O

object creation and deletion, 12.3.2
objects
creation of and effect on performance, 12.3.2
srvctl object names and abbreviations, A
OC4J
SRVCTL object name, A
OCFS2, 1.3.1
OCI session pooling, 5.7.5
OCI Session Pools
and FAN, 5.7.1
OCI session pools
optimizing, 5.7.5
runtime connection load balancing, 5.7.5
service metrics, 5.7.5
OCI_EVENTS mode
setup for runtime connection load balancing, 5.7.5
OCI_THREADED mode
setup for runtime connection load balancing, 5.7.5
OCRDUMP utility, 13.3
ODP.NET
and FAN, 5.7.1
and Fast Connection Failover, 5.7.6
load balancing advisory events, 5.7.7
OLTP environments, 12.2
online database relocation
relocation utility, 4.3
online recovery, 7.3.1
online transaction processing (OLTP)
applications in Oracle RAC, 12.3.5
ons
SRVCTL object name, A
Operations page, 10.1.1.1, 11.1.1.1
optimal execution plans, 12.3.7.1
Oracle ASM
see Oracle Automatic Storage Management (Oracle ASM)
Oracle Automatic Storage Management (Oracle ASM)
archiving scenario, 6.9.1
converting single-instance Oracle ASM to clustered Oracle ASM, 2.6.5
installation, 1.5.2
instances
administering with SRVCTL, 2.6.6
Oracle ASM preferred read failure groups, 2.6.4
preferred mirror read disks, 2.6.4
preferred read disks, 3.6
SRVCTL object name, A
storage solution, 2.1
SYSASM privilege, 3.2.3
Oracle Call Interface (OCI)
runtime connection load balancing, 5.7.5
Oracle Call Interface environment
to receive service metrics, 5.7.5
Oracle Cluster File System (OCFS for Windows), 1.3.1
Oracle Cluster Registry (OCR), 3.1.4, 13.3
Oracle Clusterware
cloning, 1.5.3
control policies
AUTOMATIC, 3.9
MANUAL, 3.9
using SRVCTL to display and change, 3.9
controlling database restarts, 3.9
described, 1.2, 1.2
introduction, 1.2
introduction and concepts of, 1
managing Oracle processes, 1.2
Oracle configuration files
troubleshooting Windows Firewall exceptions, 12.3.8.2.3
Oracle Database
session activity, 13.8.1
Oracle Dynamic Volume Manager
described, Preface
Oracle Enterprise Manager, 3.1.2
adding database instances to nodes
on Linux and UNIX, 10.1.1
on Windows, 11.1.1
alert administration, 3.10.3.2
alert blackouts, 3.10.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 Performance page
performance statistics for an Oracle RAC database, 13.1.1.3
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.10.3.1
monitoring load values for available nodes, 13.1.1.3
overview and concepts, 1.6.2
Top Activity drill down menu, 13.1.1.3
using the Interconnects page to monitor Oracle Clusterware, 13.1.1
Oracle Enterprise Manager Grid Control
instance discovery, 3.10.1
node discovery, 3.10.1
Oracle home
cloning, 1.5.3
defined, 1.5.2
Oracle Interface Configuration (OIFCFG), 13.3
Oracle Maximum Availability Architecture (MAA), 12.1.1
Oracle Net
listeners, 1.2
Oracle Net Services
and load balancing, 5.7.1
and services, 5.3.2.9
Oracle Notification Service (ONS), 1.2
SRVCTL object name, A
used by FAN, 5.1
Oracle Notification Services
API, 5.5.1
Oracle processes
managed by Oracle Clusterware, 1.2
Oracle RAC
adding administrator-managed database instances, 10.1.1.1, 11.1.1
adding policy-managed database instances, 10.1, 11.1
adding to nodes in a cluster on Linux and UNIX, 10.1
adding to nodes in a cluster on Windows, 11.1
background processes
ACMS, 1.3.4
GTX0-j, 1.3.4
LCK0, 1.3.4
LMD, 1.3.4
LMON, 1.3.4
LMS, 1.3.4
RSMN, 1.3.4
benefits of cloning, 8.1
cloning, 1.5.3, 8
size of the binaries, 8.1
converting database from, 4.2
converting database to, 4.2
copying the Oracle RAC home, 8.2
databases
quiescing, 3.7
deploying clone, 8.3
diagnosing performance problems, 13.8.1
diagnosing problems for, B
removing on Windows, 11.2.2
removing the software from Linux and UNIX, 10.2.2
security considerations, 12.3.8
shutting down instances, 3.2.1
software components, 1.3.3
storage options
network file system (NFS), 1.3.1
Oracle Automatic Storage Management (Oracle ASM), 1.3.1
Oracle Cluster File System (OCFS for Windows), 1.3.1
volume manager, 1.3.1
using a fast recovery area in, 7.6
Oracle RAC background processes
(RMSn), 1.3.4
Oracle RAC One Node, Preface, 4
adding databases, 4.1
converting database from, 4.2
converting database to, 4.2
online database relocation, 4.3
Oracle RAC One Node database
services on, 4.1
Oracle Real Application Clusters
and e-commerce, 12.3.5
installation overview, 1.5.2
overview of administration, 1
Oracle Real Application Clusters One Node, 4
See Oracle RAC One Node
Oracle Streams, 5.3.3.5
Oracle Streams Advanced Queuing
and FAN, 5.5.1
Oracle Universal Installer
database installation, 1.5.2
Oracle Real Application Clusters installation, 1.5.2
ORACLE_BASE environment variable, 8.3
ORACLE_HOME environment variable, 8.3
ORACLE_HOME_NAME environment variable, 8.3
ORACLE_SID parameter, 3.6.2
oradebug ipc command, B.6
OraMTS
external transaction manager, 5.8.1
outages
planned, 5.5.4
unplanned, 5.5.3

P

parallel execution, 12.3.7.2
parallel processes, 5.3.3.4
parallel recovery, 7.5.2.1
disabling, 7.5.2
PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 3.6.1
PARALLEL_FORCE_LOCAL initialization parameter, 5.3.3.4
PARALLEL_INSTANCE_GROUPS initialization parameter, 5.3.3.4
parallelism
in Oracle RAC, 12.3.7.2
parallel-aware query optimization, 12.3.7.1
parameter file
overview, 3.5
parameter file search order, 3.5.2
parameters
DB_RECOVERY_FILE_DEST, 7.6
that must be identical on all instances, 3.6.1
that must be unique on all instances, 3.6.2
performance, 13.1.1.3
aggregates by services, 13.1.1.3
comprehensive global data, 13.7
monitoring activity by wait events, services, and instances, 13.1.1.3
monitoring database throughput, 13.1.1.3
monitoring global cache block access, 13.1.1.3
monitoring potential problems in the database, 13.1.1.3
primary components affecting, 13.2
service aggregates by instances, 13.1.1.3
service aggregates by waits, 13.1.1.3
using ADDM, 1.6.3
performance evaluation
overview and concepts, 1.6.4
performance statistics, 13.9.5
PFILE
using with Oracle RAC, 3.5
phases
cloning deployment, 8.3
cloning preparation, 8.2
PMON background process, 3.4
policy-managed database instances
adding, 11.1
policy-managed databases, 3.1.1, 3.6.2, 5.3.2.7
defined, 1.6.1
deleting on Linux and UNIX, 10.2.1
deleting on Windows, 11.2.1
PREFERRED instances
for services, 5.3.2.6
preferred read disks
Oracle ASM in an Oracle RAC extended distance cluster, 2.6.4
private interconnect, B.6
determining usage, B.6
private network
alternative interconnect, 3.8
private network IP address, 13.3
processes
managed by Oracle Clusterware, 1.2
parallel, 5.3.3.4
public and private interfaces
shown in Oracle Enterprise Manager, 13.1.1.2

Q

query optimizer, 12.3.7.1
default cost model for, 12.3.7.1
queue tables, 5.3.3.5
quiesce database
in Oracle Real Application Clusters, 3.7
quiesced databases, 3.7
quiescing
single-instance database, 3.7

R

rebalancing
workloads, 5.2
RECOVER command, 3.1.3.2
SQL*Plus, 3.1.3.2
recovery
after SHUTDOWN ABORT, 3.2.1
from multiple node failure, 7.3.2
from single-node failure, 7.3.1
instance, 3.2.1
media failures, 7.4
online, 7.3.1
parallel, 7.5.2.1
RECOVERY_PARALLELISM parameter, 7.5.2.1
redo log files
instance recovery, 7.3.1
log sequence number, 6.8
using, 2.4
redo log groups, 2.4
redo logs
format and destination specifications, 6.8
reducing contention, 12.2
remote ONS subscription, 5.7.2.1
Remote Slave Monitor (RSMN), 1.3.4
REMOTE_LOGIN_PASSWORDFILE initialization parameter, 3.6.1
resource contention, 13.1.1.3
Resource Manager
and services, 5.3.3.2
resource manager, 5.2
resource profiles
and service creation, 5.3.3.1
resources
releasing, 7.3.1
resources held by the session, 3.4
restore scenarios
RMAN, 7.2
restore scheme
cluster file system, 7.2.1
local file system, 7.2.2
result cache, 3.6
disabling, 3.6
enabling, 3.6
RESULT_CACHE_MAX_SIZE initialization parameter, 3.6, 3.6.1
RMAN
CONFIGURE command, 6.3
configuring channels, 6.5
configuring channels to use automatic load balancing, 6.6
configuring one channel for each instance, 6.6.2
configuring snapshot control file locations, 6.3
crosschecking on multiple nodes, 6.5
DUPLICATE command, 6.3
local archiving scenario, 6.9.2
restore scenarios, 7.2
using to create SPFILE backups, 3.5.3
RMI daemon executable, 12.3.8.2.1
RMI registry application, 12.3.8.2.1
RMSn
Oracle RAC Management Processes, 1.3.4
rolling back
instance recovery, 7.3.1
root.sh script
$ORACLE_HOME, 8.3
RSMN
Remote Slave Monitor, 1.3.4
Runtime Connection Load Balancing, 5.3.2.8
runtime connection load balancing
defined, 5.7.5
in OCI session pools, 5.7.5
introduction to, 5.1

S

scalability, 12.3.5
Oracle RAC, 12.1.4
SCAN, 1.2
defined, 1.4
scan
SRVCTL object name, A
scan_listener
SRVCTL object name, A
scripts
$ORACLE_HOME/root.sh, 8.3
security
wallet, 12.3.8.1
sequence-based indexes, 12.2
sequences
log sequence number, 6.8
Server Control Utility
see SRVCTL
Server Management
administration of instances, 3.1
server parameter file
backing up, 3.5.3
server parameter files
creating, 3.5
server pool
SRVCTL object name, A
server pools
concepts, 1.4
servers
scalability, 12.1.4
service
SRVCTL object name, A
service level objective
defining for Oracle RAC, 12.1.1
service levels, 12.3.6
service metrics
OCI runtime connection load balancing, 5.7.5
runtime connection load balancing, 5.7.5
SERVICE parameter
FAN, and matching database signature, 5.5.5
SERVICE TIME
load balancing advisory goal, 5.6.2
SERVICE_NAMES initialization parameter, 3.6
setting for services, 3.6, 5.9.1
service-level agreements, 3.4
services, 3.6
activity levels aggregated by instances, 13.1.1.3
activity levels aggregated by services, 13.1.1.3
activity levels aggregated by waits, 13.1.1.3
administering, 5.9.1
administering with Oracle Enterprise Manager, 5.9
administering with SRVCTL, 5.9, 5.9.3
attributes
edition, 5.3.2.3
basic concepts about, 5.3.1
concepts, 1.4
configuring automatic workload management characteristics, 5.3.2
default, 5.3.4
dependencies, 5.3.3.1
enabling event notification, 5.7.5
introduction to, 1.3.2, 5.1
level thresholds, 5.11
management policy
automatic, 5.3.2.4
manual, 5.3.2.4
performance monitored by AWR, 5.3.3.3
SERVICE_NAMES parameter, 3.6, 5.9.1
specifying a service, 5.9.1
using, 5.3.1
services for administrator-managed databases, 3.1.1.2
sessions
terminating on a specific instance, 3.4
setting instances, 1.6.2, 3.1.3
shared everything, 1.3.1
shared server configuration, 3.6
SHOW INSTANCE command, 3.1.3.2
SQL*Plus, 3.1.3.2
SHOW PARAMETER command
SQL*Plus, 3.1.3.2
SHOW PARAMETERS command, 3.1.3.2
SHOW SGA command, 3.1.3.2
SQL*Plus, 3.1.3.2
SHUTDOWN ABORT, 3.2.1, B.5
SHUTDOWN command
ABORT option, 3.2.1
SQL*Plus, 3.1.3.2
SHUTDOWN IMMEDIATE, B.5
SHUTDOWN TRANSACTIONAL, 3.2.1
shutting down
instances, 3.2.1
shutting down an instance
abnormal shutdown, 3.2.1
shutting down instances, 3.2.1
sidalrt.log file, B.3
single client access name
See SCAN
single client access name (SCAN)
SRVCTL object name, A
single system image, 1.3.3
single-instance databases
quiescing, 3.7
single-instance Oracle ASM
converting to clustered Oracle ASM, 2.6.5
SMON process
instance recovery, 7.3.1, 7.3.2
recovery after SHUTDOWN ABORT, 3.2.1
snapshot control file, 6.3
configuring locations, 6.3
speed-up for data warehouse systems, 12.3.7.1
SPFILE
backing up, 3.5.3
backups
creating, 3.5.3
changing parameter settings, 3.5
corrupted, 3.5.1
default names, 3.5.2
location, 3.5
naming convention for, 3.5.2
recovering, 3.5.3
restore with Oracle Enterprise Manager, 7.2.3
restore with RMAN, 7.2.3
setting values in, 3.5.1
SPFILE initialization parameter, 3.6, 3.6.3
SQL statements
executing in parallel, 5.3.3.4
instance-specific, 3.1.3.2
SQL*Plus, 3.1.3
changing the prompt, 3.1.3.1, 3.1.3.1
commands
CONNECT, 3.1.3
effect on instances, 3.1.3.2
SRVCTL
add, usage description, A
administering Oracle ASM instances, 2.6.6
administering services with, 5.9.3
cluster database configuration tasks, A
cluster database tasks, A
command syntax, A
commands
add asm, A
add cvu, A, A
add database, A
add filesystem, A
add gns, A
add instance, A
add listener, A
add network, A
add nodeapps, A
add ons, A
add scan, A
add scan_listener, A
add service, A
add srvpool, A
add vip, A
config asm, A, A
config cvu, A
config database, A
config filesystem, A
config gns, A
config nodeapps, A
config oc4j, A
config ons, A
config scan, A
config scan_listener, A
config service, A
config srvpool, A
config vip, A
convert database, A
disable asm, A
disable cvu, A
disable database, A
disable diskgroup, A
disable filesystem, A
disable gns, A
disable instance, A
disable listener, A
disable nodeapps, A
disable oc4j, A
disable ons, A
disable scan, A
disable scan_listener, A
disable service, 5.9.3.3, A
disable vip, A
downgrade database, A
enable asm, A
enable cvu, A
enable database, A
enable diskgroup, A, A
enable filesystem, A
enable instance, A
enable listener, A
enable nodeapps, A
enable oc4j, A
enable ons, A
enable scan, A
enable scan_listener, A
enable service, 5.9.3.3, A
enable vip, A
getenv asm, A
getenv database, A
getenv listener, A
getenv nodeapps, A, A
help, A
modify asm, A
modify cvu, A
modify database, A
modify filesystem, A
modify gns, A
modify instance, A
modify listener, A
modify network, A
modify nodeapps, A
modify oc4j, A
modify ons, A
modify scan, A
modify scan_listener, A
modify service, A
modify srvpool, A
relocate cvu, A
relocate database, A
relocate gns, A
relocate oc4j, A
relocate scan, A
relocate scan_listener, A
relocate server, A
relocate service, A
remove asm, A
remove database, A
remove diskgroup, A
remove filesystem, A
remove gns, A
remove instance, A
remove listener, A
remove nodeapps, A
remove oc4j, A
remove ons, A
remove scan, A
remove scan_listener, A
remove service, A
remove srvpool, A
remove vip, A
setenv asm, A
setenv database, A, A
setenv listener, A
setenv nodeapps, A
srvctl setenv, 3.1.4
start asm, A
start cvu, A
start database, 3.2.4, A
start diskgroup, A
start filesystem, A
start gns, A
start home, A
start instance, 3.2.4, A
start listener, A
start nodeapps, A
start oc4j, A
start ons, A
start scan, A
start scan_listener, A
start service, A
start vip, A
status asm, A
status cvu, A
status database, A
status diskgroup, A
status filesystem, A
status gns, A
status home, A
status instance, A
status listener, A
status nodeapps, A
status oc4j, A
status ons, A
status scan, A
status scan_listener, A
status server, A
status service, A
status srvpool, A
status vip, A
stop asm, A
stop cvu, A
stop database, 3.2.4, A
stop diskgroup, A
stop filesystem, A
stop gns, A
stop home, A
stop instance, 3.2.4, A
stop listener, A
stop nodeapps, A
stop oc4j, A
stop ons, A
stop scan, A
stop scan_listener, A
stop service, A
stop vip, A
unsetenv asm, A
unsetenv database, A, A
unsetenv listener, A
unsetenv nodeapps, A
upgrade database, A
concurrent commands, A
config, usage description, A
convert, usage description, A
deprecated commands and options, A
disable, usage description, A
downgrade, usage description, A
enable, usage description, A
enabling event notification, 5.7.5
getenv, usage description, A
modify, usage description, A
node-level tasks, A
object name
database, A
diskgroup, A
filesystem, A
Grid Naming Service (GNS), A
home, A
instance, A
listener, A
network, A
node applications (nodeapps), A
oc4j, A
Oracle Automatic Storage Management (Oracle ASM), A
Oracle Notification Service (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 service command, 5.9.3.2, 5.9.3.2
start, usage description, A
status service command, 5.9.3.5
status, usage description, A
stop or start cluster database, 3.2.4
stop, usage description, A
unsetenv, usage description, A
upgrade, usage description, A
SRVM_TRACE environment variable, B.4
Standard Edition
installing Oracle ASM, 1.5.2
starting administrator-managed databases, 3.2.4
starting policy-managed databases, 3.2.4
STARTUP command
SQL*Plus, 3.1.3.2
statistics
contents of, 13.6
Statspack, 13.9, 13.9.1
usage, 1.6.3
stop database instances, 3.2.4
storage
cluster file system, 2.1
Oracle Automatic Storage Management (Oracle ASM), 2.6.1
subnet
configuring for virtual IP address, A, A
subnets, 1.3.2
Summary dialog, 10.1.1.1
SYS$BACKGROUND service, 5.3.4
SYS$USERS service, 5.3.4
SYSASM privilege, 3.1.3, 3.2.3
SYSAUX tablespace
increasing size when adding nodes, 12.3.3
reducing size when removing nodes, 12.3.3
SYSDBA, 3.1.3
privilege for connecting, 3.1.3
SYSDBA connections to an Oracle ASM instance, 3.1.3
SYSOPER, 3.1.3
SYSOPER privilege
for connecting, 3.1.3
system change, 6.8
System Global Area (SGA), 1.3.3, 13.8.1
size requirements, 1.3.3

T

tablespaces
automatic segment space management (ASSM) in Oracle RAC, 12.3.1
automatic undo management in Oracle RAC, 12.3.1
locally managed, 12.3.1
use in Oracle RAC, 12.3.1
TCP network ports
Windows Firewall considerations, 12.3.8.2
TCP/IP, 1.3.2
terminating a session on a specific instance, 3.4
THREAD initialization parameter, 3.6
threads
multiple application, 5.7.5
THROUGHPUT
load balancing advisory goal, 5.6.2
timed statistics, 13.6
timeout
messages, avoiding, 1.3.2
tnsnames.ora file, 3.6
Top Activity drill down menu
on the Cluster Database Performance page, 13.1.1.3
Top Cluster Events, 13.8.2
Top Cluster Events, ASH report, 13.8.2
Top Remote Instance, 13.8.3
Top Remote Instance, ASH report, 13.8.3
trace files, B.1
managing, B.1
sidalrt.log, B.3
trace files for background processes, B.1
TRACE_ENABLED initialization parameter, 3.6.3
tracing
enabling Java-based tools and utilities, B.4
SRVM_TRACE environment variable, B.4
writing to log files, B.4
transactions
instance failure, 7.3.1
rolling back, 3.4, 7.3.1
waiting for recovery, 7.3.1
Transparent Application Failover
and services, 5.3.2.12
Transparent Data Encryption
specifying the ENCRYPTION_WALLET_LOCATION parameter, 12.3.8.1
with encrypted wallets and obfuscated wallets, 12.3.8.1
troubleshooting Windows Firewall exceptions
examining Oracle trace files and log files, 12.3.8.2.3
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
User Datagram Protocol (UDP), B.6
user process trace files, B.1

V

V$ view, 13.4
V$ACTIVE_INSTANCES, 3.3, 3.3
V$CLUSTER_INTERCONNECTS, 13.2, B.6
V$CONFIGURED_INTERCONNECTS, 13.2
vendor clusterware, 1.1
verification
data files, online files, 2.3
verifying interconnect settings, 13.2
versions
compatibility for Oracle RAC and Oracle Database software, 1.5.1
views
creating for Oracle Real Application Clusters, 13.5
dynamic performance
for performance monitoring, 13.4
GV$, 13.4
for performance monitoring, 13.4
GV$SESSION, 3.4, 3.4
instance-specific, 13.4
V$ views, 13.4
VIP
SRVCTL object name, A
Virtual Internet Protocol (VIP) address, 1.2
virtual IP address
requirements, A, A

W

wait events, 13.9, 13.9.1
aggregated for service performance, 13.1.1.3
block-related, 13.9.5.1
contention-related, 13.9.5.3
load-related, 13.9.5.4
message-related, 13.9.5.2
wallet
data security, 12.3.8.1
Welcome page, 10.1.1.1, 11.1.1.1
Windows Firewall, 12.3.8.2
Windows Firewall exceptions list, 12.3.8.2.1
Windows Firewall log file, 12.3.8.2.3
Windows registry
the Oracle key in, 12.3.8.2.3
workload management
See automatic workload management
workloads
and services, 5.3.1
See Also automatic workload management

X

XA Transactions, 12.3.4
XA transactions
spanning Oracle RAC instances, 5.8.1