Skip Headers
Oracle® Database 2 Day + Real Application Clusters Guide
11g Release 2 (11.2)

Part Number E10743-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

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

A

add instance, 9.5.1, 9.5.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.5.3.1, 9.3, 9.5.2
and rconfig, 3.5.3
creating redo log groups, 4.5.3.1
defintion of, 1.2
deleting instances, 9.6.2
affinity, 7.1.7
alert log, 8.5.4
architecture
chip architecture, 1.4.1, 2.1.1, 2.1.4, 9.1.1
determining the chip architecture, 2.1.4
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.4.1.3
archiving
configuring, 6.3.3
enabling, 6.3.3
ASM
See Automatic Storage Management
ASM Configuration Assistant (ASMCA)
description of, 1.5
starting, 3.3.2
ASMCA
See ASM Configuration Assistant (ASMCA)
ASMCMD
description of, 1.5
ASMLib
and device persistency, 2.5.8
configuring, 2.5.7.2
creating 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 (ASM), 2.5.5
and multiple Oracle RAC databases, 4.2
convert to clustered Oracle ASM, 3.5.3
creating disk groups, 3.3.2
file management, 1.3
installing, 3.2.3
managing
mirroring, 1.3
number of instances per node, 1.3
operating system group requirements, 2.2.1.2
rebalancing, 1.3
striping, 1.3
use of, 2.1.1
use with Oracle RAC, 1.3

B

backups
archive logs, 6.3.1, 6.5.1
description of, 6.1
emkey.ora, 3.4.2.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.7.1.2
parallelism, 6.3.2
performing using Enterprise Manager, 6.1, 6.5
privileges, 6.4.1
root.sh script, 3.4.2.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.3
block devices, 2.5.5
configuring partitions, 2.5.6
blocks
cache transfers of, 8.1.3.2
cached, 1.4, 8.2.6
corrupt, 6.1
OCR format, 5.6.1
request latency, 8.1.3.2
undo, 4.5.1
buffer cache, 8.1.3.2

C

Cache Fusion
definition of, 1.4
mechanism, 8.1.3.2
client connections, 2.1.3
client-side load balancing, 7.1.6.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.5.2
and the OCR
and the private interconnect, 2.1.2
archiving, 6.3.3
backing up, 6.1, 6.5
buffer cache, 8.1.3.2
comparison of Oracle RAC to single-instance, 1.4
configuring initialization parameters, 4.4.1
connecting to, 7.1.6
converting to, 3.5
performance, 8
recovery, 6.1, 6.6.4
server parameter files, 4.4.2
starting and stopping, 4.3
topology, 8.3
undo tablespaces, 4.5.1
Cluster Ready Services (CRS), 1.5
checking daemon status, 8.5.1.3
Cluster Ready Services Control (CRSCTL)
checking the Oracle Clusterware status, 5.5.2
description of, 1.5
using to add and remove voting disks, 5.2
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 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.2
description of, 1.5
location of trace files, 8.5.2.6
use by OUI, 3.4.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.4.1.1
CLUSTER_INTERCONNECTS, 4.4.1.2
CLUVFY
See Cluster Verification Utility
COMPATIBLE, 4.4.1.1
configuring ASMLib, 2.5.7.2
connect descriptor, 7.1.6
connection load balancing, 7.1.6
goals, 7.1.6.2
connection pools, 7.1.7
control files
location, 2.1.1
parallelized backups, 6.3.2
CONTROL_FILES, 4.4.1.1
CONTROL_MANAGEMENT_PACK_ACCESS, 4.4.1.3
converting single-instance databases to Oracle RAC, 3.5
prerequisites, 3.5.1
using rconfig, 3.5.3
creating 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.1
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.5, 9.6
description of, 1.5
Database Resource Manager, 7.1.2
terminology, 7.1.2
DB_BLOCK_SIZE, 4.4.1.1
DB_DOMAIN, 4.4.1.1
DB_FILES, 4.4.1.1
DB_NAME, 4.4.1.1
DB_RECOVERY_FILE_DEST, 4.4.1.1
DB_RECOVERY_FILE_DEST_SIZE, 4.4.1.1
DB_UNIQUE_NAME, 4.4.1.1
dba group, 2.2.1.1
delete instance, 9.6.1, 9.6.2
Desktop class, 3.3.3
device path persistency, 2.5.8
diagcollection.pl script, 8.5.1.4
DIAGNOSTIC_DEST, 4.4.1.3
disk groups
creating, 3.3.2
DML_LOCKS, 4.4.1.1
documentation
Real Application Clusters, 1.1.3.1
domain name system, 2.3
DSA keys, 2.2.3

E

Enterprise Manager
alerts, 8.5.3
and My Oracle Support, 10.1
Average Active Sessions chart, 8.1.3.3
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.1
Cluster Managed Database Services page, 7.3.2
Database Locks page, 8.2.7
Database Throughput charts, 8.1.3.4
description of, 1.5
encryption key, 3.4.2.2
Global Cache Block Access Latency chart, 8.1.3.2
Instance Activity page, 8.2.5
Instances charts, 8.1.3.6
performing recovery, 6.6.4
Recovery wizard, 6.1, 6.6
Services charts, 8.1.3.5
Top Consumers page, 8.2.2
Top Segments page, 8.2.6
Top Sessions page, 8.2.3
errata level, 2.1.4
erratum kernel
See errata level
event
FAN load balancing, 7.1.5
UP and DOWN, 7.1.4
use by FAN callouts, 7.1.4.1
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.4.1
events, 7.1.4
fast recovery area, 6.2
configuring, 6.2
creating disk group for, 3.3.2

G

General Parallel File System (GPFS), 2.5.5
Global Services Daemon (GSD), 1.5
GNS
See Grid Naming Service
Grid Naming Service (GNS), 2.1.3
Grid Plug and Play, 4.4.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 requirements, 2.2
high availability framework, 5.1

I

initialization parameters
ARCHIVE_LAG_TARGET, 4.4.1.3
CLUSTER_DATABASE, 4.4.1.1
CLUSTER_INTERCONNECTS, 4.4.1.2
COMPATIBLE, 4.4.1.1
CONTROL_FILES, 4.4.1.1
CONTROL_MANAGEMENT_PACK_ACCESS, 4.4.1.3
DB_BLOCK_SIZE, 4.4.1.1
DB_DOMAIN, 4.4.1.1
DB_FILES, 4.4.1.1
DB_NAME, 4.4.1.1
DB_RECOVERY_FILE_DEST, 4.4.1.1
DB_RECOVERY_FILE_DEST_SIZE, 4.4.1.1
DB_UNIQUE_NAME, 4.4.1.1
DIAGNOSTIC_DEST, 4.4.1.3
DML_LOCKS, 4.4.1.1
INSTANCE_NAME, 4.4.1.2
INSTANCE_NUMBER, 4.4.1.2
INSTANCE_TYPE, 4.4.1.1
LICENSE_MAX_SESSIONS, 4.4.1.3
LICENSE_MAX_USERS, 4.4.1.3
LOG_ARCHIVE_FORMAT, 4.4.1.3
modifying for the current instance, 4.4.3.1
modifying for the SPFILE, 4.4.3.2
PARALLEL_EXECUTION_MESSAGE_SIZE, 4.4.1.1
REDO_TRANSPORT_USER, 4.4.1.3
REMOTE_LOGIN_PASSWORDFILE, 4.4.1.1
RESULT_CACHE_MAX_SIZE, 4.4.1.1
ROLLBACK_SEGMENTS, 4.4.1.2
SERVICE_NAMES, 4.4.1.4
SPFILE, 4.4.1.3
that must be different on each instance, 4.4.1.2
that must be identical on all instances, 4.4.1.1
that should be the same on each instance, 4.4.1.3
TRACE_ENABLED, 4.4.1.3
UNDO_MANAGEMENT, 4.4.1.1, 4.4.1.2
UNDO_RETENTION, 4.4.1.3
UNDO_TABLESPACE, 4.4.1.2
installing ASMLib, 2.5.7.1
installing RPMs, 2.1.4
instance
adding, 9.5.1, 9.5.2
deleting, 9.6.1, 9.6.2
findings in ADDM analysis, 8.1.1
Oracle ASM instances for multiple Oracle RAC databases, 4.2
Oracle ASM instances in Enterprise Manager, 4.2
setting initialization parameters, 4.4
starting for the database, 4.3
stopping for the database, 4.3
instance management, 4.1
INSTANCE_NAME, 4.4.1.2
INSTANCE_NUMBER, 4.4.1.2
INSTANCE_TYPE, 4.4.1.1
integrated clients, 7.1.5
interconnect
definition of, 1.4, 2.1.2

K

kernel parameters
configuring on Linux x86 operating system, 2.4.2

L

LICENSE_MAX_SESSIONS, 4.4.1.3
LICENSE_MAX_USERS, 4.4.1.3
Linux x86 operating system
configuring kernel parameters, 2.4.2
listener
and client-side load balancing, 7.1.6.1
and server-side load balancing, 7.1.6.2
checking status of, 7.2.1
description of, 7.1.6
service registration, 4.4.1.4
load balancing
client-side, 7.1.6.1
connection goals, 7.1.6.2
definition of, 7.1.6
runtime connection, 7.1.7
server-side, 7.1.6.2
Load Balancing Advisory, 7.1.5, 7.1.7
LOG_ARCHIVE_FORMAT, 4.4.1.3

M

membership
and the OCR, 2.1.1
memory requirements, 2.2
minimum downtime patching, 10.7.2

N

NAS devices
configuring for ASM, 2.5.6
network adapters, 2.1.2
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 Time Protocol (NTP), 2.4.1
NFS
See network file system
nodeapps
definition of, 1.5
nodes
definition of, 1.2
eviction, 5.3.1

O

OCFS, 2.5.5
OCFS2, 2.5.5
OCR
See Oracle Cluster Registry
OCRCHECK
check status of OLR, 5.4.4
description of, 5.6.1
using to verify status of the OCR, 5.4.3.1
OCRCONFIG
administering OLR, 5.4.4, 5.4.4
OCRDUMP
dump content of OLR, 5.4.4
oinstall group, 2.2.1.1
OLR
See Oracle Local Registry
ONS
See Oracle Notification Service
OPatch
"Not a valid patch area" error, 10.8.3
partially installed patch, 10.8.4
preparing to use, 10.7.1
updating the cluster node list, 10.8.1
viewing log and trace files, 10.8.2
Optimal Flexible Architecture (OFA), 2.5.3
Oracle ASM Cluster File System (Oracle ACFS), 1.3, 2.5.4
Oracle Automatic Storage Management (Oracle ASM)
See Automatic Storage Management
Oracle base directory, 2.5.3
Oracle Cluster Registry (OCR)
backing up, 5.4
changing the location of, 5.5.2
definition of, 2.1.1
location of OCR backups, 5.4.2
manual backups, 5.4.2
mirroring the OCR, 5.5.1
multiplexing, 2.1.1
recovering, 5.4.3
removing a mirror, 5.5.3
repairing, 5.5.4
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 (OCM), 3.3.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)
administering, 5.4.4, 5.4.4
check status of, 5.4.4
defined, 5.1
dump content of, 5.4.4
Oracle Net
configuration, 7.1.6
Oracle Notification Service (ONS), 1.5, 7.1.4
Oracle Real Application Clusters
high availability framework, 7.1.3
installation on different platforms, 1.4.1
overview of administration, 1, 3
patching, 3.4.4
Oracle software owner, 2.2.1.1
Oracle Universal Installer (OUI)
description of, 1.5
grid infrastructure installation, 3.2.3
Oracle Real Application Clusters installation, 3.1
preparing for installation, 3.1
starting, 3.2.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.7.1.2
when to set the environment variable, 1.5
oracleasm
configure, 2.5.7.2
drivers, 2.5.7.1
packages, 2.5.7.1
OSASM group, 2.2.1.2
OSDBA group, 2.2.1.1
OSOPER group, 2.2.1.2
OUI
See Oracle Universal Installer

P

packages, 2.1.4
parallel recovery, 6.6.3
PARALLEL_EXECUTION_MESSAGE_SIZE, 4.4.1.1
parameters
See initialization parameters
patch sets
applying, 10.6
definition of, 10
patches
applying, 10.4
definition of, 10
minimum downtime patching, 10.7.2
obtaining, 10.2
rolling patching, 10.4.1
staging, 10.7.1.3
uploading to the Patch Cache, 10.3
uploading to the Software Library, 10.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.2

R

RAM requirements, 2.2
rconfig, 3.5
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.3
with Enterprise Manager, 6.1
Recovery Manager (RMAN)
channels, 6.3.2
parallelism and backups, 6.3.2
redo logs
location, 2.1.1
REDO_TRANSPORT_USER, 4.4.1.3
redundancy
normal, 5.1
REMOTE_LOGIN_PASSWORDFILE, 4.4.1.1
removing temporary files, 3.2.3
requirements
hardware, 2.2
network, 2.1.2
software, 2.1.4
storage, 2.1.1
resource manager
See Database Resource Manager
RESULT_CACHE_MAX_SIZE, 4.4.1.1
ROLLBACK_SEGMENTS, 4.4.1.2
rolling patch method, 10.4.1
root.sh, 3.4.2.1
RPMs
ASMLib, 2.5.7.1
RSA keys, 2.2.3
rules files for udev, 2.5.8
Runtime connection load balancing, 7.1.7

S

secure shell
configuring, 2.2.3
Server class, 3.3.3
Server Control (SRVCTL)
description of, 1.5
server parameter file, 4.4.2
description of, 4.4.1
recovery, 6.6.5
server pools, 1.2, 1.2
server-side load balancing, 7.1.6.2
SERVICE_NAMES, 4.4.1.4
services
administration, 7.3
available instance, 7.1.1.1
creating, 7.2
definition of, 7.1.1
failover, 7.1.1.1
preferred instance, 7.1.1.1
use with workload management, 7.1.1
using for database connections, 7.1.6
shared Oracle home directory, 2.5.4
shared storage
supported types, 2.5.5
single-instance database, 3.3.3
Software Library
configuring, 10.1.1
software requirements
checking software requirements, 2.1.4
SPFILE, 4.4.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.2
System Global Area (SGA), 8.1.3.2

T

tablespaces
undo, 4.5.1
temporary disk space
requirements, 2.2
temporary files
removing, 3.2.3
time synchronization, 2.4.1
tnsnames.ora file, 7.1.6, 7.1.6.1, 7.2.1
topology, 8.3
TRACE_ENABLED, 4.4.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.5.1
UNDO_MANAGEMENT, 4.4.1.1, 4.4.1.2
UNDO_RETENTION, 4.4.1.3
UNDO_TABLESPACE, 4.4.1.2
Universal Connection Pool (UCP), 7.1.7
up2date, 2.1.4
user equivalence, 2.2.3, 10.7.1.5

V

VIP
See Virtual IP
Virtual IP (VIP), 1.5
voting disks
adding and removing, 5.2
backing up, 5.3
definition of, 2.1.1
multiple, 2.1.1
recovering, 5.3.3

W

workload management, 7.1

Y

YUM, 2.1.4