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 (CRS), 1.5

checking daemon status, 8.5.1.3

checking state of all registered resources, 8.5.1.3

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 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