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