Index

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

A

add instance, 9.6.1, 9.6.2
adding OCR locations, 5.5.1
additional Real Application Clusters documentation, 1.1.3
ADDM
See Automatic Database Diagnostic Monitor
administrative tools
overview, 1.5
administrator-managed database
adding instances, 4.6.3.1, 9.4, 9.6.2
and rconfig, 3.6.3
creating redo log groups, 4.6.3.1
definition of, 1.2
deleting instances, 9.7.2
affinity, 7.1.8
alert log, 8.5.4
all node patching, 10.3.2
architecture
chip architecture, 1.4.2, 2.1.2, 2.1.6, 9.2
determining the chip architecture, 2.1.6
enterprise grid computing, 1.4
archive logs, 6.3
backing up, 6.3.2, 6.5.1
deleting after backups, 6.5.1
instance access to, 6.3.1, 6.6.1.1
recovery, 6.6.1, 6.6.2
ARCHIVE_LAG_TARGET, 4.5.1.3
archiving
configuring, 6.3.3
enabling, 6.3.3
ASM. See Oracle ASM
ASMCA. See Oracle ASM Configuration Assistant (ASMCA)
ASMCMD
description of, 1.5
ASMLib
and device persistency, 2.5.8
configuring, 2.5.7.2
creating Oracle ASM disks, 2.5.7.3
installing, 2.5.7.1
Automatic Database Diagnostic Monitor (ADDM)
database findings, 8.1.1
description, 8.1.1
instance findings, 8.1.1
recommendations, 8.1.1
Automatic Storage Management. See Oracle ASM

B

backups
archive logs, 6.3.1, 6.5.1
description of, 6.1
emkey.ora, 3.5.3.2
location of OCR backups, 5.4.2
managing backups, 6.7
manual OCR backups, 5.4.2
Oracle Cluster Registry (OCR), 5.4
Oracle software, 10.2.2
parallelism, 6.3.2
performing using Enterprise Manager, 6.1, 6.5
privileges, 6.4.1
root.sh script, 3.5.3.1
settings, 6.4.2
storing in a fast recovery area, 6.2
viewing backup reports, 6.8
viewing OCR backups, 5.4.1
voting disks, 5.1.3
block devices, 2.5.5
configuring partitions, 2.5.6
blocks
cache transfers of, 8.1.3.1
cached, 1.4, 8.2.6
corrupt, 6.1
OCR format, 5.6.1
request latency, 8.1.3.1
undo, 4.6.1
bonding
interconnect, 2.1.4
buffer cache, 8.1.3.1

C

Cache Fusion
definition of, 1.4
mechanism, 8.1.3.1
certifications, 2.1.1
client connections, 2.1.5
client-side load balancing, 7.1.7.1
cluster database
adding a new node, 9
ADDM findings, 8.1.1
administration, 4
alert log, 8.5.4
alerts, 8.5.3
and Oracle ASM, 4.6.2
and the OCR
and the private interconnect, 2.1.4
archiving, 6.3.3
backing up, 6.1, 6.5
buffer cache, 8.1.3.1
comparison of Oracle RAC to single-instance, 1.4
configuring initialization parameters, 4.5.1
connecting to, 7.1.7
converting to, 3.6
performance, 8
recovery, 6.1, 6.6.4
server parameter files, 4.5.2
starting and stopping, 4.4
topology, 8.3
undo tablespaces, 4.6.1
Cluster Ready Services Control (CRSCTL)
checking the Oracle Clusterware status, 5.5.3
description of, 1.5
using to add and remove voting disks, 5.3.1
using to start Oracle Clusterware processes, 5.4.3.2
using to stop Oracle Clusterware processes, 5.4.3.2
using to troubleshoot Oracle Clusterware issues, 8.5.1.3
Cluster Ready Services (CRS), 1.5
checking daemon status, 8.5.1.3
checking state of all registered resources, 8.5.1.3
Cluster Synchronization Services (CSS), 1.5
checking daemon status, 8.5.1.3
Cluster Time Synchronization Service (CTSS), 2.4.1
Cluster Verification Utility
check postinstallation configuration, 9.3
description of, 1.5
location of trace files, 8.5.2.6
use by OUI, 3.5.1
verify node applications, 8.5.2.1
verifying network connectivity, 8.5.2.5
verifying OCR integrity, 5.4.3.2
CLUSTER_DATABASE, 4.5.1.1
CLUSTER_INTERCONNECTS, 4.5.1.2
CLUVFY
See Cluster Verification Utility
COMPATIBLE, 4.5.1.1
configuring ASMLib, 2.5.7.2
connect descriptor, 7.1.7
connection load balancing, 7.1.7
goals, 7.1.7.2
connection pools, 7.1.8
control files
location, 2.1.3
parallelized backups, 6.3.2
CONTROL_FILES, 4.5.1.1
CONTROL_MANAGEMENT_PACK_ACCESS, 4.5.1.3
converting single-instance databases to Oracle RAC, 3.6
prerequisites, 3.6.1
using rconfig, 3.6.3
creating Oracle ASM disks, 2.5.7.3
CRSCTL
See Cluster Ready Services Control
CSS
See Cluster Synchronization Services
CVU
See Cluster Verification Utility

D

data files
location, 2.1.3
parallelized backups, 6.3.2
database
administrator-managed, 1.2
findings in ADDM analysis, 8.1.1
policy-managed, 1.2
See cluster database
Database Configuration Assistant (DBCA)
deleting an instance, 9.6, 9.7
description of, 1.5
database name
limitations, 3.4.3
Database Resource Manager, 7.1.2
terminology, 7.1.2
Database Upgrade Assistant (DBUA), 10.6
DB_BLOCK_SIZE, 4.5.1.1
DB_DOMAIN, 4.5.1.1
DB_FILES, 4.5.1.1
DB_NAME, 4.5.1.1
DB_RECOVERY_FILE_DEST, 4.5.1.1
DB_RECOVERY_FILE_DEST_SIZE, 4.5.1.1
DB_UNIQUE_NAME, 4.5.1.1
dba group, 2.2.1.1
DBUA. See Database Upgrade Assistant (DBUA)
delete instance, 9.7.1, 9.7.2
Desktop class, 3.4.3
device path persistency, 2.5.8
diagcollection.pl script, 8.5.1.4
DIAGNOSTIC_DEST, 4.5.1.3
disk groups
creating, 3.4.2
DML_LOCKS, 4.5.1.1
documentation
Real Application Clusters, 1.1.3.1, 1.1.3.2
domain name system, 2.3
DSA keys, 2.2.3

E

Enterprise Manager
alerts, 8.5.3
Average Active Sessions chart, 8.1.3.4
backup and recovery, 6.1
backup reports, 6.8
Cluster Cache Coherency page, 8.2.1
Cluster Database page, 8.1
Cluster Database Performance page, 8.1.3
Cluster Host Load Average chart, 8.1.3.3
Cluster Managed Database Services page, 7.3.2
Database Locks page, 8.2.7
Database Throughput charts, 8.1.3.5
description of, 1.5
encryption key, 3.5.3.2
Global Cache Block Access Latency chart, 8.1.3.1
Instance Activity page, 8.2.5
Instances charts, 8.1.3.7
performing recovery, 6.6.4
Recovery wizard, 6.1, 6.6
Services charts, 8.1.3.6
Top Consumers page, 8.2.2
Top Segments page, 8.2.6
Top Sessions page, 8.2.3
errata level, 2.1.6
erratum kernel
See errata level
event
FAN load balancing, 7.1.6
UP and DOWN, 7.1.4
use by FAN callouts, 7.1.5
Event Manager (EVM), 1.5
checking daemon status, 8.5.1.3
EVM
See Event Manager

F

FAN
See Fast Application Notification
Fast Application Notification, 7.1.4
callouts, 7.1.5
events, 7.1.4
fast recovery area, 6.2
configuring, 6.2
creating disk group for, 3.4.2
fixup scripts, 3.3.2

G

General Parallel File System (GPFS), 2.5.5
Global Services Daemon (GSD), 1.5
GNS
See Grid Naming Service
Grid home
patching, 10.3.1
unlocking, 10.3.1
Grid Naming Service (GNS), 2.1.5
Grid Plug and Play, 4.5.1.2
grid user, 2.2.1.1
Grid_home
choosing, 2.5.2
definition of, 3.1
disk space requirements, 2.5.2
GSD
See Global Services Daemon

H

hardware
checking certifications, 2.1.1
hardware requirements, 2.2
high availability framework, 5.1

I

initialization parameters
ARCHIVE_LAG_TARGET, 4.5.1.3
CLUSTER_DATABASE, 4.5.1.1
CLUSTER_INTERCONNECTS, 4.5.1.2
COMPATIBLE, 4.5.1.1
CONTROL_FILES, 4.5.1.1
CONTROL_MANAGEMENT_PACK_ACCESS, 4.5.1.3
DB_BLOCK_SIZE, 4.5.1.1
DB_DOMAIN, 4.5.1.1
DB_FILES, 4.5.1.1
DB_NAME, 4.5.1.1
DB_RECOVERY_FILE_DEST, 4.5.1.1
DB_RECOVERY_FILE_DEST_SIZE, 4.5.1.1
DB_UNIQUE_NAME, 4.5.1.1
DIAGNOSTIC_DEST, 4.5.1.3
DML_LOCKS, 4.5.1.1
INSTANCE_NAME, 4.5.1.2
INSTANCE_NUMBER, 4.5.1.2
INSTANCE_TYPE, 4.5.1.1
LICENSE_MAX_SESSIONS, 4.5.1.3
LICENSE_MAX_USERS, 4.5.1.3
LOG_ARCHIVE_FORMAT, 4.5.1.3
modifying for the current instance, 4.5.3.1
modifying for the SPFILE, 4.5.3.2
PARALLEL_EXECUTION_MESSAGE_SIZE, 4.5.1.1
REDO_TRANSPORT_USER, 4.5.1.3
REMOTE_LOGIN_PASSWORDFILE, 4.5.1.1
RESULT_CACHE_MAX_SIZE, 4.5.1.1
ROLLBACK_SEGMENTS, 4.5.1.2
SERVICE_NAMES, 4.5.1.4
SPFILE, 4.5.1.3
that must be different on each instance, 4.5.1.2
that must be identical on all instances, 4.5.1.1
that should be the same on each instance, 4.5.1.3
TRACE_ENABLED, 4.5.1.3
UNDO_MANAGEMENT, 4.5.1.1, 4.5.1.2
UNDO_RETENTION, 4.5.1.3
UNDO_TABLESPACE, 4.5.1.2
installing ASMLib, 2.5.7.1
installing RPMs, 2.1.6
instance
adding, 9.6.1, 9.6.2
deleting, 9.7.1, 9.7.2
findings in ADDM analysis, 8.1.1
Oracle ASM instances for multiple Oracle RAC databases, 4.3
Oracle ASM instances in Enterprise Manager, 4.3
setting initialization parameters, 4.5
starting for the database, 4.4
stopping for the database, 4.4
instance management, 4.1
INSTANCE_NAME, 4.5.1.2
INSTANCE_NUMBER, 4.5.1.2
INSTANCE_TYPE, 4.5.1.1
integrated clients, 7.1.6
interconnect
definition of, 1.4, 2.1.4

K

kernel parameters
configuring on Linux x86 operating system, 2.4.2

L

LICENSE_MAX_SESSIONS, 4.5.1.3
LICENSE_MAX_USERS, 4.5.1.3
Linux x86 operating system
configuring kernel parameters, 2.4.2
listener
and client-side load balancing, 7.1.7.1
and server-side load balancing, 7.1.7.2
checking status of, 7.3.3
description of, 7.1.7
service registration, 4.5.1.4
load balancing
client-side, 7.1.7.1
connection goals, 7.1.7.2
definition of, 7.1.7
run-time connection, 7.1.8
server-side, 7.1.7.2
Load Balancing Advisory, 7.1.6, 7.1.8
LOG_ARCHIVE_FORMAT, 4.5.1.3

M

membership
and the OCR, 2.1.3
memory requirements, 2.2
migrating the OCR to Oracle ASM, 5.5.2
migrating voting disks to Oracle ASM, 5.3.3
minimum downtime patching, 10.3.4
multipath devices, 2.5

N

NAS devices
configuring for Oracle ASM, 2.5.6
network adapters, 2.1.4
network file system (NFS)
configuring for use with Oracle ASM, 2.5.6
support for, 2.5.5
using for shared storage, 2.5.5
network interface names, 2.1.4
Network Time Protocol (NTP), 2.4.1
NFS
See network file system
NIC bonding, 2.1.4
nodeapps
definition of, 1.5
nodes
definition of, 1.2
eviction, 5.1.1

O

OCFS, 2.5.5
OCFS2, 2.5.5
OCR
migrate to Oracle ASM, 5.5.2
See Oracle Cluster Registry
OCRCHECK
description of, 5.6.1
using to verify status of the OCR, 5.4.3.1
oinstall group, 2.2.1.1
OLR
See Oracle Local Registry
ONS
See Oracle Notification Service
OPatch
"Not a valid patch area" error, 10.5.3
partially installed patch, 10.5.4
preparing to use, 10.2
updating the cluster node list, 10.5.1
viewing log and trace files, 10.5.2
operating system
checking certifications, 2.1.1
Optimal Flexible Architecture (OFA), 2.5.3
Oracle ASM, 2.5.5
and multiple Oracle RAC databases, 4.3
convert to clustered Oracle ASM, 3.6.3
creating disk groups, 3.4.2
creating voting disks, 5.3.3
file management, 1.3
installing, 3.3.3
managing
mirroring, 1.3
number of instances per node, 1.3
operating system group requirements, 2.2.1.3
rebalancing, 1.3
shut down instances, 5.2.2
storing the OCR, 5.5.2
striping, 1.3
use of, 2.1.3
use with Oracle RAC, 1.3
Oracle ASM Cluster File System (Oracle ACFS), 1.3, 2.5.4
Oracle ASM Configuration Assistant (ASMCA)
description of, 1.5
starting, 3.4.2
Oracle Automatic Storage Management (Oracle ASM). See Oracle ASM
Oracle base directory, 2.5.3
Oracle Cluster Registry (OCR)
backing up, 5.4
changing the location of, 5.5.3
definition of, 2.1.3
location of OCR backups, 5.4.2
manual backups, 5.4.2
mirroring the OCR, 5.5.1
multiplexing, 2.1.3
recovering, 5.4.3
removing a mirror, 5.5.4
repairing, 5.5.5
restoring from backup, 5.4.3.2
status, 5.4.3.1
troubleshooting, 5.6
usage in Oracle RAC, 7.1.3
viewing backups of, 5.4.1
Oracle Clusterware, 1.2
and process control, 5.1
monitoring using Enterprise Manager, 8.4.1
use of, 5.1
Oracle Configuration Manager
installation, 3.2
Oracle Configuration Manager (OCM), 3.4.3
Oracle Flashback, 6.1
Oracle Grid Infrastructure, 1.2
software owner, 2.2.1.1
Oracle home directory
creating, 2.5.4
definition of, 3.1
Oracle Inventory
group, 2.2.1.1
Oracle Local Registry (OLR)
defined, 5.1.2
Oracle Net
configuration, 7.1.7
Oracle Notification Service (ONS), 1.5, 7.1.4
Oracle RAC
creating a database, 3.4
Oracle RAC One Node
administration, 4.2
creating a database, 3.4
Oracle Real Application Clusters
high availability framework, 7.1.3
installation on different platforms, 1.4.2
overview of administration, 1, 3
patching, 3.5.5
Oracle software owner, 2.2.1.1
Oracle Support
checking certifications, 2.1.1
Oracle Universal Installer (OUI)
description of, 1.5
Oracle Grid Infrastructure installation, 3.3.3
Oracle Real Application Clusters installation, 3.1
preparing for installation, 3.1
starting, 3.3.3
oracle user, 2.2.1.1
creating, 2.2.2
modifying environment of, 2.2.4
ORACLE_BASE, 2.5.3
ORACLE_HOME, 3.1
backing up, 10.2.2
when to set the environment variable, 1.5
ORACLE_SID
limitations, 3.4.3
oracleasm
configure, 2.5.7.2
drivers, 2.5.7.1
packages, 2.5.7.1
OSASM group, 2.2.1.3
OSDBA group, 2.2.1.1
OSOPER group, 2.2.1.3
OUI
See Oracle Universal Installer
out-of-place upgrade, 10.6

P

packages, 2.1.6
parallel recovery, 6.6.3
PARALLEL_EXECUTION_MESSAGE_SIZE, 4.5.1.1
parameters
See initialization parameters
patch plan, 10.1
patch sets, 10.6
applying, 10.4
definition of, 10
patches
all node patching method, 10.3.2
applying, 10.3
applying previously downloaded patches during installation, 3.2
definition of, 10
locating, 10.1
minimum downtime patching, 10.3.4
rolling patching, 10.3.3
permissions file for udev, 2.5.8
physical RAM requirements, 2.2
policy-managed database
definition of, 1.2
private interconnect
and Oracle Clusterware, 2.1.4
private interface name, 2.1.4
public interface name, 2.1.4

R

RAM requirements, 2.2
rconfig, 3.6
recovery
archive logs, 6.6.1, 6.6.2
database, 6.6.4
description of, 6.1
enabling archiving, 6.3.3
instance state during, 6.6.1.2
Oracle Cluster Registry (OCR), 5.4.3
parallelism, 6.6.3
privileges, 6.4.1
restoring the OCR from backup, 5.4.3.2
server parameter file, 6.6.5
voting disks, 5.3.2.2
with Enterprise Manager, 6.1
Recovery Manager (RMAN)
channels, 6.3.2
parallelism and backups, 6.3.2
redo logs
location, 2.1.3
REDO_TRANSPORT_USER, 4.5.1.3
redundancy
normal, 5.1.3
redundant interconnect usage, 2.1.4
REMOTE_LOGIN_PASSWORDFILE, 4.5.1.1
removing temporary files, 3.3.3
requirements
hardware, 2.2
network, 2.1.4
software, 2.1.6
storage, 2.1.3
resource manager
See Database Resource Manager
RESULT_CACHE_MAX_SIZE, 4.5.1.1
ROLLBACK_SEGMENTS, 4.5.1.2
rolling patch method, 10.3.3
root.sh, 3.5.3.1
RPMs
ASMLib, 2.5.7.1
RSA keys, 2.2.3
rules files for udev, 2.5.8
Run-time connection load balancing, 7.1.8

S

scripts
fixup, 3.3.2
secure shell
configuring, 2.2.3
Server class, 3.4.3
Server Control (SRVCTL)
description of, 1.5
server parameter file, 4.5.2
description of, 4.5.1
recovery, 6.6.5
server pools, 1.2, 1.2
server-side load balancing, 7.1.7.2
SERVICE_NAMES, 4.5.1.4
services
administration, 7.3
available instance, 7.1.1
creating, 7.2
definition of, 7.1.1
failover, 7.1.1.1, 7.1.1.2
preferred instance, 7.1.1
use with workload management, 7.1.1
using for database connections, 7.1.7
shared Oracle home directory, 2.5.4
shared storage
supported types, 2.5.5
single-instance database, 3.4.3
software requirements
checking software requirements, 2.1.6
SPFILE, 4.5.1.3
See server parameter file
SQL*Plus
description of, 1.5
SSH
See secure shell
swap space
requirements, 2.2
SYSOPER privilege, 2.2.1.3
System Global Area (SGA), 8.1.3.1

T

tablespaces
undo, 4.6.1
temporary disk space
requirements, 2.2
temporary files
removing, 3.3.3
time synchronization, 2.4.1
tnsnames.ora file, 7.1.7, 7.1.7.1, 7.3.3
topology, 8.3
TRACE_ENABLED, 4.5.1.3
Troubleshooting
alert log messages, 8.5.4
interconnect settings, 8.5.2.5
Using Cluster Ready Services Control (CRSCTL), 8.5.1, 8.5.1.3
Using Cluster Verification Utility (cluvfy), 8.5.2
viewing cluster database alerts, 8.5.3

U

udev, 2.5.8
undo segments, 4.6.1
UNDO_MANAGEMENT, 4.5.1.1, 4.5.1.2
UNDO_RETENTION, 4.5.1.3
UNDO_TABLESPACE, 4.5.1.2
Universal Connection Pool (UCP), 7.1.8
unlock Grid home, 10.3.1
up2date, 2.1.6
upgrades
out-of-place, 10.6
user equivalence, 2.2.3, 10.2.5

V

VIP
See Virtual IP
Virtual IP (VIP), 1.5
voting disks
adding and removing, 5.3.1
backing up, 5.1.3
definition of, 2.1.3
migrate to Oracle ASM, 5.3.3
multiple, 2.1.3
recovering, 5.3.2.2

W

workload management, 7.1

Y

YUM, 2.1.6