Skip Headers
Oracle® Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide
10g Release 2 (10.2)

Part Number B14197-02
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
Feedback

Go to previous page
Previous
View PDF

Index

A  B  C  D  E  F  G  H  I  J  L  M  N  O  P  Q  R  S  T  U  V  W  X 

A

adding nodes
quick-start, 10.2, 11.2
Additional Real Application Clusters documentation, 2.1
ADDM
see Automatic Database Diagnostic Monitor
administering
services, 6.7
administering instances
with Server Management, 9.1
administering services
DBCA, 6.8
Enterprise Manager, 6.8
PL/SQL, 6.8
SRVCTL, 6.8
administration
overview, 2.3
tools, 2.3
administrative tools
overview and concepts, 1.9.2
affinity
awareness, 8.5.5
alert administration
Enterprise Manager, 9.4.2
alert blackouts
Enterprise Manager, 9.4.3
alert log
managing, A.3.1
alert logs, A.3.2
alerts
performance monitoring, 13.7.2.2
ALTER SYSTEM ARCHIVE LOG CURRENT statement, 9.5.1
ALTER SYSTEM ARCHIVE LOG statement, 9.5.1
INSTANCE option, 9.5.1
ALTER SYSTEM CHECKPOINT LOCAL statement, 9.5.1
ALTER SYSTEM CHECKPOINT statement
global versus local, 9.5.1
specifying an instance, 9.5.1
ALTER SYSTEM statement
CHECKPOINT clause, 9.5.1
ALTER SYSTEM SWITCH LOGFILE statement, 9.5.1, 9.5.1
architecture
of RAC, 1.3
ARCHIVE LOG command, 9.5.1
archive logs
file format and destination, 7.6
file naming, 7.5
archiver process
monitor, 7.8.1
archiving mode
changing, 7.8
archiving redo log files
identified in control file, 4.1.2
log sequence number, 7.6
ASM
archiving scenario, 7.7.1
installation
Real Application Clusters, introduction to, 2.6
see Automatic Storage Management
asm
as SRVCTL noun, E.7.2
Automatic Database Diagnostic Monitor, 13.6.2, 13.6.3.2, 13.6.5
automatic segment-space management, 2.11.3, 12.2.1
Automatic Storage Management, 2.11.3, 4.1
see ASM
Automatic Storage Management (ASM), 1.3
Automatic Storage Management instance, 4.2.1
automatic undo management, 2.11.3
Automatic Workload Repository, 2.11.4, 6.9, 12.1.3, 12.1.3, 13.5, 13.6.3.2
snapshots, 13.5
AVAILABLE instances
and services, 6.2.1
Average Active Sessions chart
Enterprise Manager, 13.7.4.3
AWR
see Automatic Workload Repository

B

background process
crsd, 1.2.2.1
evmd, 1.2.2.1
ocssd, 1.2.2.1
oprocd, 1.2.2.1
background processes
SMON, 5.2, 8.5.1
background thread trace files, A.3.1.1
BACKGROUND_DUMP_DEST parameter, A.3.1.1, A.3.2
backups
server parameter file, 5.7
bandwidth
interconnect, 13.2
block mode conversions
statistics for, 13.4.1
blocks
associated with instance, 8.5.1
buffer cache, 1.3.1
instance recovery, 8.5.1
buffer sizes
IPC, adjusting for Real Application Clusters, 13.2.1

C

Cache Fusion, 1.3.1
and e-commerce applications, 15.2
function, 2.10.1
overview, 1.9.4
CATCLUST.SQL script
using to create views for Real Application Clusters, 13.3
CLB_GOAL_LONG, 6.2.3
CLB_GOAL_SHORT, 6.2.3
client side
load balancing, 6.2.3
cloning, 1.7
CLSD-1009 message
resolving, 3.2.4
CLSD-1011 message
resolving, 3.2.4
cluster
definition of, 1.1
Cluster Database Home Page
Enterprise Manager, 9.3.2
Cluster Database Instance page
Enterprise Manager, 9.3.3
Cluster Database Instance Performance page
Enterprise Manager, 13.7.5
Cluster Database Performance page
Enterprise Manager, 13.7.6
cluster file system
archiving parameter settings, 7.7.1.2
archiving scenario, 7.7.1
overview, 2.11.2
restore, 8.2.1
storage in Real Application Clusters, 4.1
Cluster Home page
Enterprise Manager, 9.3.5
Cluster Host Load Average chart
Enterprise Manager, 13.7.4.1
Cluster Interconnects page
Enterprise Manager, 13.7.7
Cluster Managed Database Services Detail Page
Enterprise Manager, 6.8.1.3
Cluster Managed Database Services Page
Enterprise Manager, 6.8.1.2
Cluster Manager (CSS)
log files, A.2.9.3
Cluster Ready Services, 2.11.5.1
Cluster Ready Services Control
see CRSCTL
Cluster Synchronization Service (CSS), 1.2.1
Cluster Synchronization Services (CSS)
purpose, 1.2.1
Cluster Verification Utility
cluster integrity verifications, A.4.3.8
connectivity verifications, A.4.3.3
installation requirements, A.4.1
installation verifications, A.4.3.6
known issues, A.4.4
node comparisons and verifications, A.4.3.5
nodelist shortcuts, A.4.2.3
Oracle Clusterware component verifications, A.4.3.7
performing various tests with, A.4.3
see CVU
storage verifications, A.4.3.2
system requirements verifications, A.4.3.1
user and permissions verifications, A.4.3.4
using, A.4
using online help for, A.4.2.1
verbose mode, A.4.2.2
CLUSTER_INTERCONNECTS
parameter, 13.2.1
committed data
instance failure, 8.5.1
communication protocols
verifying settings for, 13.2
configuration problems
reinitializing the OCR, 3.2.5
CONNECT command, 5.1.2, 9.5.1, 9.5.1
CONNECT SYS
example of, 5.2.2
connecting
to instances, 5.1.2
connection load balancing
concepts, 1.5
long method, 6.2.3
short method, 6.2.3
connection pools
and FAN, 6.5
consistent blocks, 1.3.1
control files
MAXLOGHISTORY, 4.1.2
CREATE DATABASE statement
MAXLOGHISTORY clause, 4.1.2
Create Services Page
Enterprise Manager, 6.8.1.4
creating
server parameter files, 5.4, 5.7
crs_getperm, B.2.1
CRS_HOME, 1.6.1
crs_profile, B.2.2
crs_register, B.2.3
crs_relocate, B.2.4
crs_setperm, B.2.5.1
crs_start, B.2.7
crs_stat, B.2.6
crs_stop, B.2.8.1
crs_unregister, B.2.9
CRSCTL
overview and concepts, 1.9.2
crsd, 1.2.2.1
purpose, 1.2.2.1
current blocks, 1.3.1
CVU
concepts, 1.6.1
overview and concepts, 1.9.2

D

data dictionary
querying views, 13.3
Data Guard, 2.11.6.3
data security
wallet, 15.4
data warehouse
deploying applications for in Real Application Clusters, 15.3
database
as SRVCTL noun, E.7.2
creation, 1.6.2
number of archived log files, 4.1.2
quiescing, 9.6
Database Configuration Assistant
Database Storage page, 10.9.2, 11.9.2
Instance Management page, 10.9.2, 11.9.2
List of Cluster Databases page, 10.9.2, 11.9.2
Operations page, 10.9.2, 11.9.2
see DBCA
Summary dialog, 10.9.2, 11.9.2
Welcome page, 10.9.2, 11.9.2
Database Configuration Assistant (DBCA)
creating views for Real Application Clusters, 13.3
Database Locks page
Enterprise Manager, 13.7.4.9
Database Storage page, 10.9.2, 11.9.2
Database Throughput chart
Enterprise Manager, 13.7.4.4
Databases Overview page
Enterprise Manager, 9.3.4
Databases Summary page
Enterprise Manager, 9.3.1
DBCA, 1.6.2
adding and deleting instances in silent mode, 10.9.3, 11.9.3
service administration, 6.8.2
DBMS_SERVICE, 12.1.3
degree of parallelism (DOP), 15.3.2
deleting nodes
quick-start, 10.2, 11.2
design
Real Application Clusters environments, 1.9.1
DISCONNECT command, 5.1.2
disconnecting from instances, 5.1.2
Distributed Transaction Processing, 12.2.4
distributed transactions, 6.6, 12.2.4
documentation
Real Application Clusters, 2.1
DTP, 12.2.4
DTP/XA transactions, 6.6
dynamic performance views
creating, 13.3
for performance monitoring, 13.3
dynamic resource allocation
overview, 1.9.4

E

e-commerce
applications in Real Application Clusters, 15.2
Enterprise Manager, 5.1.1, 9.1
administering services, 6.8.1
alert administration, 9.4.2
alert blackouts, 9.4.3
Average Active Sessions chart, 13.7.4.3
Cluster Database Home Page, 9.3.2
Cluster Database Instance page, 9.3.3, 13.7.6
Cluster Database Instance Performance page, 13.7.5
Cluster Home page, 9.3.5
Cluster Host Load Average chart, 13.7.4.1
Cluster Interconnects page, 13.7.7
Database Locks page, 13.7.4.9
Database Throughput chart, 13.7.4.4
Databases Overview page, 9.3.4
Databases Summary page, 9.3.1
Global Cache Block Access Latency chart, 13.7.4.1
Global Cache Coherency chart, 13.7.4.2
Instance Activity page, 13.7.4.7
Instance page, 9.3.3
job administration, 9.4.1
overview, 2.7, 2.9
overview and concepts, 1.9.2
performance monitoring, 13.7.1
services pages, accessing, 6.8.1.5
Top Consumers page, 13.7.4.5
Top Segments page, 13.7.4.8
Top Sessions page, 13.7.4.6
Enterprise Manager Database Control
overview, 2.9
Enterprise Manager Grid Control
instance discovery, 9.2
node discovery, 9.2
overview, 2.9
error messages
for management tools, C, F
PRKA, F.2
PRKC, F.3
PRKD, F.4
PRKE, F.5
PRKH, F.6
PRKI, F.7
PRKN, F.8
PRKO, F.9
PRKP, F.10
PRKR, F.11
PRKS, F.12
PRKU, F.13
PRKV, C.1, F.14
Event Management (EVM), 1.2.1
purpose, 1.2.1
Event Manager (EVM)
log files, A.2.9.4
events
load balancing advisory, 6.3.1
evmd, 1.2.2.1
purpose, 1.2.2.1

F

failover
and Real Application Clusters, 2.11.5.2
failure
instance, 8.5
multiple node, 8.5.2
node, 8.5.1
FAN
callouts, 6.3.6
clients integrated for, 6.5
Fast Application Notification
see FAN
Fast Application Notification (FAN), 6.3
Fast Connection Failover (FCF)
and services, 6.2.1
features
taking advantage of, 2.10
features, new, Preface
files
archiving redo log, 7.6
control file, 4.1.2
redo log, 7.6

G

Global Cache Block Access Latency chart
Enterprise Manager, 13.7.4.1
Global Cache Coherency chart
Enterprise Manager, 13.7.4.2
Global Cache Service (GCS), 1.3.1
Global Cache Service statistics, 13.6.1, 13.6.3.1
GLOBAL clause
forcing a checkpoint, 9.5.1
Global Enqueue Service (GES), 1.3.1
Global Enqueue Service statistics, 13.6.1
Global Resource Directory (GRD), 1.3.1
global service name, 12.1.1
GV$ACTIVE_SERVICES, 12.1.4
GV$SVCMETRIC, 12.1.4

H

H.A.R.D.
implementing for the OCR, 3.2.6
hash partitioning
with Real Application Clusters, 1.9.1
high availability
and Oracle Clusterware, 1.2.1
and Real Application Clusters, 2.11.5.2
high availability framework, 6.1
concepts, 1.5
HOST command, 9.5.1, 9.5.1

I

initdb_name.ora file
BACKGROUND_DUMP_DEST parameter, A.3.1.1, A.3.2
USER_DUMP_DEST parameter, A.3.1.2
initialization parameters
cluster database issues regarding, 5.6
CLUSTER_INTERCONNECTS, 13.2.1
RECOVERY_PARALLELISM, 8.7.2.1
that must be identical on all instances, 5.5.1
that must be unique on all instances, 5.5.2
INST_ID column, 13.3
installation
introduction, 1.6
Oracle Clusterware, 1.6.1
Real Application Clusters, 1.6.2
instance
as SRVCTL noun, E.7.2
Instance Activity page
Enterprise Manager, 13.7.4.7
instance addition
quick-start, 10.2, 11.2
instance deletion
quick-start, 10.2, 11.2
instance discovery
Enterprise Manager Grid Control, 9.2
Instance Management page, 10.9.2, 11.9.2
INSTANCE option, 9.5.1
Instance page
Enterprise Manager, 9.3.3
INSTANCE_NUMBER parameter, 5.5.2
instances
failure, 8.5.2
failures, recovery from, 8.5
maximum number for RAC, 1.3
memory structures, 1.3.1
recovery, 5.2, 8.5.1
recovery, abnormal shutdown, 5.2
recovery, multiple failures, 8.5.2
Server Management, 9.1
shutting down, 5.2
verifying, 9.5.2, 9.5.2, 9.5.2
interconnect
and performance, 13.2.1
and the RAC architecture, 1.3
bandwidth, 13.2
protocols for Real Application Clusters, 13.2
verifying settings for, 13.2
IP address
installation requirements, 1.6.1
IPCs
buffer sizes, adjusting, 13.2.1

J

java-based tools
tracing, A.3.3
JDBC
and services, 6.2.1
clients, 6.5.2.1
job administration
Enterprise Manager, 9.4.1

L

LCK0 Instance Enqueue Process, 1.3.1
List of Cluster Databases page, 10.9.2, 11.9.2
LMD Global Enqueue Service Daemon, 1.3.1
LMOM Global Enqueue Service Monitor, 1.3.1
LMS Global Cache Service Process, 1.3.1
load balancing
by services, 1.3
server side, 6.2.3
Load Balancing Advisory, 6.7
load balancing advisory, 6.1, 6.4
concepts, 1.5
configuring, 6.4.2
events, 6.3.1
FAN events, 6.4.3
local archiving scenario
RMAN, 7.7.2
Local Area Network (LAN), 1.3
LOCAL clause
forcing a checkpoint, 9.5.1
local file system
archiving parameter settings, 7.7.2.2
restore, 8.2.2
log files
for CSS, A.2.9.3
for EVM, A.2.9.4
for OCR, A.2.9.2
for Oracle Clusterware, A.2.9.1, A.2.9.1
log sequence numbers, 7.6
log switches, 4.1.2
LOG_ARCHIVE_FORMAT parameter, 7.6

M

mass deployment
cloning, 1.7
MAXLOGHISTORY option, 4.1.2
media failures
recovery from, 8.6
membership
and the OCR, 1.4.1
memory structures
in RAC, 1.3.1
message request counters, 13.4.1
messages
errors for management tools, C, F
metrics
performance monitoring, 13.7.2.1
mirroring
Oracle Cluster Registry, 3.2.1
modified data
instance recovery, 8.5.1
monitoring
archiver process, 7.8.1
overview and concepts, 1.9.3
statistics for Real Application Clusters, 13.4
multiple node failures, 8.5.2
multiple nodes
starting from one node, 5.2.2
multiplexed redo log files, 4.1.2
multiplexing
OCR, 1.4.1

N

Net Configuration Assistant
see NETCA
NETCA, 1.6.2
Network Attached Storage (NAS), 1.3.1
network file system, 1.3
network interfaces
defining with OIFCFG, 9.7.1
new features, Preface
node
failure and VIPs, 1.3
node addition
quick-start, 10.2, 11.2
node deletion
quick-start, 10.2, 11.2
node discovery
Enterprise Manager Grid Control, 9.2
nodeapps
as SRVCTL noun, E.7.2
nodes
affinity awareness, 8.5.5
failure of, 8.5.1

O

objects
creation of and effect on performance, 12.2.2
OCI
and services, 6.2.1
OCR
installation, 1.6.1
redundancy, 1.6.1
OCR Configuration Tool, D.1
see OCRCONFIG
OCRCHECK
diagnosing OCR problems with, 3.2.3
using, 3.2.3.2
OCRCONFIG
overview and concepts, 1.9.2
ocrconfig command, D.1
ocrconfig -export, D.1
ocrconfig -option, D.1
OCRDUMP
diagnosing OCR problems with, 3.2.3
using, 3.2.3.1
using to view OCR content, A.2.10.1
ocrdump command, A.2.10.1.2, A.2.10.1.2, A.2.10.1.2, A.2.10.1.2
ocssd, 1.2.2.1
purpose, 1.2.2.1
ODP.NET
and FAN events, 6.5.3
and FCF, 6.5.3
and services, 6.2.1
load balancing advisory events, 6.5.4
OIFCFG, 9.7
commands, 9.7.2, 9.7.2
defining network interfaces, 9.7.1
if_name element, 9.7.2
if_type element, 9.7.2
nodename element, 9.7.2
overview and concepts, 1.9.2
subnet element, 9.7.2
syntax, 9.7.2
online recovery, 8.5.1
online transaction processing
applications in Real Application Clusters, 15.2
operating system-specific Oracle documentation
archived redo log name, 7.6
Operations page, 10.9.2, 11.9.2
oprocd, 1.2.2.1
purpose, 1.2.2.1
Oracle Cluster File System (OCFS), 1.3
Oracle Cluster Registry
adding, 3.2.1, 3.2.1.1
contents, 3.2
data loss protection mechanism, overriding, 3.2.4
diagnosing problems with OCRDUMP and OCRCHECK, 3.2.3
downgrading, 3.2.7
exporting, 3.2.5
implementing H.A.R.D., 3.2.6
importing, 3.2.5
importing on UNIX-based systems, 3.2.5.1
importing on Windows-based systems, 3.2.5.2
managing backups, 3.2.2
recovering using OCR backup files, 3.2.2
removing, 3.2.1, 3.2.1.4
repairing, 3.2.1, 3.2.1.3
replacing, 3.2.1, 3.2.1.2
restoring on UNIX-based systems, 3.2.2.1.1
restoring on Windows-based systems, 3.2.2.1.2
restoring using automatically generated OCR backups, 3.2.2.1
see OCR
troubleshooting, A.2.10
upgrading, 3.2.7
Oracle Cluster Registry (OCR), 1.4.1
log files, A.2.9.2
managing, 3.2
purpose, 1.2
Oracle Clusterware
architecture, 1.2
cloning, 1.7
command examples, 14.4
commands, B.2
component processing, 1.2.1
enabling and disabling startup using crsctl commands, A.2.4
event manager alerts, A.2.6
high availability framework, 1.4.2
installation overview, 1.6.1
introduction, 2.7, 14
introduction and concepts of, 1
log files and their locations, A.2.9
overview, 14.2
startup and shutdown using crsctl commands, A.2.3
UNIX processes, 1.2.2.1
working with Oracle Clusterware commands, 14.6
Oracle Clusterware home
adding to a new node, 10.2.1
adding, silent mode, 10.2.1.2
deleting in silent mode, 10.2.4.2
deleting manually, 10.2.4
Oracle Clusterware management
overview and concepts, 1.9.2
Oracle home
adding in silent mode, 10.2.2.2
adding manually, 10.2.2.1
cloning, 1.7
deleting, 10.2.3
deleting manually, 10.2.3.1, 10.2.3.2
Oracle Interface Configuration Tool
see OIFCFG
Oracle Interface Configuration tool
see OIFCFG
Oracle Net Services
and services, 6.2.1
Oracle Notification Service (ONS)
purpose, 1.2.1
Oracle Real Application Clusters
overview of administration, 1, 2
Oracle Universal Installer
see OUI
ORACLE_HOME, 1.6.2
ORACLE_SID parameter, 5.5.2
OracleCRService
purpose, 1.2.2.2
OracleCSService
purpose, 1.2.2.2
OracleEVMService
purpose, 1.2.2.2
OraFenceService
purpose, 1.2.2.2
OUI
database installation, 1.6.2
Oracle Clusterware installation, 1.6.1
Real Application Clusters installation, 1.6.2
outages
planned, 6.3.4
unplanned, 6.3.3

P

parallel instance groups, 15.3.3
parallel recovery, 8.7.2.1
PARALLEL_MAX_SERVERS parameter, 8.7.2.1
parallelism
in Real Application Clusters, 15.3.2
parallel-aware query optimization, 15.3.1
parameter file
overview, 5.4
parameters
that must be identical on all instances, 5.5.1
that must be unique on all instances, 5.5.2
performance
primary components affecting, 13.2
performance evaluation
overview and concepts, 1.9.4
performance monitoring
alerts, 13.7.2.2
Enterprise Manager, 13.7.1
metrics, 13.7.2.1
thresholds, 13.7.2.3
PL/SQL
administering services, 6.8.3
PREFERRED
instances and services, 6.2.1
private interconnect
and Oracle Clusterware, 1.2
PRKA messages, F.2
PRKC messages, F.3
PRKD messages, F.4
PRKE messages, F.5
PRKH messages, F.6
PRKI messages, F.7
PRKN messages, F.8
PRKO messages, F.9
PRKP messages, F.10
PRKR messages, F.11
PRKS messages, F.12
PRKU messages, F.13
PRKV messages, C.1, F.14
Process Monitor Daemon (OPROCD)
purpose, 1.2.1

Q

quiesce database
in Real Application Clusters, 9.6

R

RAC
cloning, 1.7
software components, 1.3.1
RACAD6012|crs_register, B.2.3
RACG
purpose, 1.2.1
raw devices, 1.3
Real Application Clusters
and e-commerce, 15.2
installation overview, 1.6.2
RECOVER command, 9.5.1, 9.5.1
recovery
after SHUTDOWN ABORT, 5.2
from multiple node failure, 8.5.2
from single-node failure, 8.5.1
instance, 5.2
media failures, 8.6
online, 8.5.1
parallel, 8.7.2.1
PARALLEL_MAX_SERVERS parameter, 8.7.2.1
Recovery Manager
see RMAN
RECOVERY_PARALLELISM parameter, 8.7.2.1
redo log files
identified in control file, 4.1.2
instance recovery, 8.5.1
log sequence number, 7.6
using, 4.1.2
redo log groups, 4.1.2
redo logs
format and destination specifications, 7.6
Resource Manager
and services, 6.2.1
resource manager, 12.1.3
resource profiles
attributes, 14.3.1.1
resources
releasing, 8.5.1
restore scenarios
RMAN, 8.2
restore scheme
cluster file system, 8.2.1
local file system, 8.2.2
RMAN
in Real Application Clusters, 2.11.6.2
local archiving scenario, 7.7.2
overview
restore scenarios, 8.2
rolling back
instance recovery, 8.5.1
runtime connection load balancing, 6.2.1

S

scalability
adding nodes and instances, 10.3, 10.4, 11.3, 11.4
adding nodes and instances, quick-start format, 10.2, 11.2
security
wallet, 15.4
sequence numbers
with Real Application Clusters, 1.9.1
sequences
log sequence number, 7.6
Server Control
see SRVCTL
Server Control Utility (SRVCTL), 1.4.1
Server Management
administration of instances, 9.1
server parameter file, 2.11.3
backing up, 5.7
setting values in, 5.4.1
server parameter files
creating, 5.4, 5.7
service
as SRVCTL noun, E.7.2
DTP property, 6.6
levels, 6.9.1
SERVICE TIME, 6.4.2
SERVICE_NAMES
parameter, 6.8.2.2
services, 2.11.4, 6.1, 12.1.1
administering, 6.7
administering with DBCA, 6.8
administering with Enterprise Manager, 6.8
administering with PL/SQL, 6.8
administering with SRVCTL, 6.8
and distributed transactions, 6.6
basic concepts about, 6.2.1
concepts, 1.5
configurations for, 12.1.2
default, 6.2.2
introduction to, 1.3
names, limitations for, 6.8.2.2
using, 6.2.1
sessions
multiple, 5.1.2
setting instances, 5.1.2
shared everything, 1.3
SHOW INSTANCE command, 9.5.1, 9.5.1
SHOW PARAMETER command, 9.5.1
SHOW PARAMETERS command, 9.5.1
SHOW SGA command, 9.5.1, 9.5.1
SHUTDOWN ABORT command, 5.2
SHUTDOWN command, 9.5.1
ABORT option, 5.2
SHUTDOWN TRANSACTIONAL, 5.2
shutting down
instances, 5.2
shutting down an instance
abnormal shutdown, 5.2
shutting down instances, 5.2
sidalrt.log file, A.3.2
siddbwr.trc file, A.3.1.1
sidsmon.trc file, A.3.1.1
single system image, 1.3.1
single-instance Oracle databases
how they differ from RAC, 1.3
singleton services, 6.6
SMON process
instance recovery, 8.5.1, 8.5.2
recovery after SHUTDOWN ABORT, 5.2
snapshot control file, 7.2
SPFILE
restore with Enterprise Manager, 8.2.3
restore with RMAN, 8.2.3
split brain syndrome, 1.2
SQL statements
instance-specific, 9.5.1
SQL*Plus, 5.1.2, 9.5
SRVCTL
add asm command, E.7.3.5.1
add database command, E.7.3.1.1
add instance command, E.7.3.2.1
add nodeapps command, E.7.3.4.1
add service command, E.7.3.3.2
add, usage description, E.7.3
cluster database configuration tasks, E.3
cluster database tasks, E.4
concurrent commands, E.1.1
config asm command, E.7.4.4.1, E.7.4.5.1
config database command, E.7.4.1.1
config nodeapps command, E.7.4.3.1
config service command, E.7.4.2.1
config, usage description, E.7.4
disable asm command, E.7.6.4.1
disable database command, E.7.6.1.1
disable instance command, E.7.6.2.1
disable service command, 6.8.4.3, E.7.6.3.1
disable, usage description, E.7.6
enable asm command, E.7.5.4.1
enable database command, E.7.5.1.1
enable instance command, E.7.5.2.1
enable service command, 6.8.4.3, E.7.5.3.1
enable, usage description, E.7.5
getenv database command, E.7.12.1.2
getenv instance command, E.7.12.2.1
getenv nodeapps command, E.7.12.4.1
getenv service command, E.7.12.3.1
getenv, usage description, E.7.12
modify database command, E.7.9.1.1
modify instance command, E.7.9.2.1
modify nodeapps command, E.7.9.4.1
modify service command, E.7.9.3.1
modify, usage description, E.7.9
node-level tasks, E.5
overview, 5.1.3
overview and concepts, 1.9.2
relocate service command, E.7.10.1.1
relocate, usage description, E.7.10
remove asm command, E.7.14.5.1
remove database command, E.7.14.1.1
remove instance command, E.7.14.2.1
remove nodeapps command, E.7.14.4.1
remove service command, E.7.14.3.1
remove, usage description, E.7.14
setenv database command, E.7.13.1.2
setenv instance command, E.7.13.2.1
setenv nodeapps command, E.7.13.4.2
setenv service command, E.7.13.3.1
setenv, usage description, E.7.13
start asm command, E.7.7.5.1
start database command, 5.2.3, E.7.7.1.1
start instance command, 5.2.3, E.7.7.2.1
start listener command, E.7.7.6.1
start nodeapps command, E.7.7.4.1
start service command, 6.8.4.2, 6.8.4.2, E.7.7.3.1
start, usage description, E.7.7
status asm command, E.7.11.5.1
status database command, E.7.11.1.1
status instance command, E.7.11.2.1
status nodeapps command, E.7.11.4.1
status service command, 6.8.4.5, E.7.11.3.1
status, usage description, E.7.11
stop asm command, E.7.8.5.1
stop database command, 5.2.3, E.7.8.1.1
stop instance command, 5.2.3, E.7.8.2.1
stop listener command, E.7.8.6.1
stop nodeapps command, E.7.8.4.1
stop service command, E.7.8.3.1
stop, usage description, E.7.8
unsetenv database command, E.7.13.5.2
unsetenv instance command, E.7.13.6.1
unsetenv nodeapps command, E.7.13.8.1
unsetenv service command, E.7.13.7.2
unsetenv, usage description, E.7.13
Standard Edition
ASM
standby databases, 2.11.6.3
STARTUP command, 9.5.1
statistics
contents of, 13.4.1
monitoring for Real Application Clusters, 13.4
Statspack, 13.6, 13.6.1
storage, 2.11.3
basic RAC requirements for, 1.3
cluster file system, 4.1
Real Application Clusters, introduction to, 2.6
Summary dialog, 10.9.2, 11.9.2
SYSAUX tablespace, 12.2.3
SYSDBA
privilege for connecting, 5.1.2
SYSOPER privilege
for connecting, 5.1.2
system change, 7.6
System Global Area (SGA), 1.3.1
size requirements, 1.3.1

T

TAF
and services, 6.2.1
TCP/IP, 1.3
THREAD parameter, 5.6
thresholds
performance monitoring, 13.7.2.3
services, 6.9.1
THROUGHPUT, 6.4.2
timed statistics, 13.4.1
timeout
messages, avoiding, 1.3
Top Consumers page
Enterprise Manager, 13.7.4.5
Top Segments page
Enterprise Manager, 13.7.4.8
Top Sessions page
Enterprise Manager, 13.7.4.6
trace files, A.3.1.1
background thread trace files, A.3.1.1
managing, A.3.1
sidalrt.log, A.3.2
siddbwr.trc file, A.3.1.1
sidsmon.trc file, A.3.1.1
tracing
enabling for RAC high availability, A.2.11
java-based tools, A.3.3
transactions
instance failure, 8.5.1
rolling back, 8.5.1
waiting for recovery, 8.5.1
Transparent Database Encryption, 15.4
troubleshooting, A.3.1
tuning
overview, 1.9.4

U

UNDO_TABLESPACE parameter, 5.5.2
unified log directory structure, A.2.9
User Datagram Protocol (UDP)
and the private interconnect, 1.2
user trace files, A.3.1.2
USER_DUMP_DEST parameter, A.3.1.2

V

V$ACTIVE_INSTANCES, 9.5.2, 9.5.2
V$ACTIVE_SERVICES, 12.1.4
V$SERVICEMETRIC_HISTORY, 12.1.4
V$SESSION, 12.1.4
V$SQL, 12.1.4
vendor clusterware, 1.1
verification
datafiles, online files, 4.1.1
views
creating for Real Application Clusters, 13.3
for performance monitoring, 13.3
VIP addresses, 1.3
configuring, 1.3
virtual host name, 1.3
virtual IP address, 1.6.1
volume manager
alternate storage method for RAC, 1.3
Voting Disk, 1.4.1
voting disk
administering, 3.1
backing up, 3.1.1
dynamically adding, 3.1.3
installation, 1.6.1
purpose, 1.2
recovering, 3.1.2
redundancy, 1.6.1
voting disks
multiple, 1.4.1
redundancy, 1.4.1

W

wait events, 13.6.1
wallet
data security, 15.4
Welcome page, 10.9.2, 11.9.2
Workload Management
concepts, 1.5
workload management, 12.1.1
basic concepts about, 6.2.1
manual rebalancing, 12.1.3
workloads
and services, 6.2.1

X

XA transactions, 12.2.4