Index

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

Symbols

$ORACLE_HOME/root.sh script, 6.3.1

A

ACMS

Atomic Controlfile to Memory Service, 1.3.4

Active Session History, Oracle RAC, 11.8.1

Active Session History, Top Cluster Events, 11.8.2

Active Session History, Top Remote Instance, 11.8.3

ACTIVE_INSTANCE_COUNT initialization parameter, 3.6, 3.6.1

adding a new Oracle ASM instance, 9.1.1.1

adding Oracle RAC to nodes, 9.1

ADDM

global monitoring, 11.7

see Automatic Database Diagnostic Monitor

ADDM for Oracle Real Application Clusters mode, 11.7

administering

services, 4.10

services with SRVCTL, 4.11.2

administering instances

with Server Management, 3.1

administering services

Oracle Enterprise Manager, 4.11

SRVCTL, 4.11

administrative tools

overview and concepts, 1.6.2

SYSASM privilege, 3.2.2

administrator-managed databases, 3.1.1, 4.3.1

AVAILABLE instances for services, 4.3.1

converting to policy-managed, 3.1.1

defined, 1.6.1

PREFERRED instances for services, 4.3.1

ADRCI

ADR Command-Line Interpreter, B.2

Advanced Queuing

and FAN, 4.4.1

affinity

awareness, 7.3.5

aggregates

by instances, 11.1.1.3

by services, 11.1.1.3

by waits, 11.1.1.3

alert administration

Oracle Enterprise Manager, 3.10.2.2

alert blackouts

Oracle Enterprise Manager, 3.10.2.3

alert logs, B.3

managing, B.1

ALTER SYSTEM ARCHIVE LOG CURRENT statement, 3.1.3.2

ALTER SYSTEM ARCHIVE LOG statement, 3.1.3.2

INSTANCE option, 3.1.3.2

ALTER SYSTEM CHECKPOINT LOCAL statement, 3.1.3.2

ALTER SYSTEM CHECKPOINT statement

global versus local, 3.1.3.2

specifying an instance, 3.1.3.2

ALTER SYSTEM KILL SESSION statement

terminating a session on a specific instance, 3.4

ALTER SYSTEM QUIESCE RESTRICTED statement

quiescing a single-instance database, 3.7

ALTER SYSTEM statement

CHECKPOINT clause, 3.1.3.2

ALTER SYSTEM SWITCH LOGFILE statement, 3.1.3.2, 3.1.3.2

applications

consolidating multiple in a single database, 10.1.2

highly available, 10.1

scalability, 10.1.3

spanning XA transactions across Oracle RAC instances, 4.8

using pre-created database sessions, 4.6.3

ARCHIVE LOG command

SQL*Plus, 3.1.3.2

ARCHIVE_LAG_TARGET initialization parameter, 3.6.1, 3.6.3

archived redo log files

file format and destination, 5.7

file naming, 5.6

log sequence number, 5.7

archiver process

monitor, 5.10

archiving mode

changing, 5.9

ASH reports, 11.8.1

asm

SRVCTL object name, A

ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter, 2.6.4, 3.6

Atomic Controlfile to Memory Service (ACMS), 1.3.4

Automatic Database Diagnostic Monitor, 11.9.2, 11.9.3.2, 11.9.5

Automatic Database Diagnostic Monitor (ADDM), 1.6.3

analyzing AWR data, 11.7

Automatic Database Diagnostic Monitoring (ADDM), 11.7

Automatic Diagnostic Repository (ADR)

ADRCI command-line interpreter, B.2

automatic load balancing

configuring RMAN channels for multiple instances, 5.5

automatic segment space management (ASSM), 10.3.1

automatic segment-space management

tablespace use in Oracle RAC, 10.3.1

Automatic Storage Management (ASM)

cloning, 6

converting single-instance ASM to clustered ASM, 2.6.5

converting single-instance to a cluster storage manager, 2.6.5

instance creation on newly added nodes, 6

preferred read disks, 3.6

SYSASM privilege, 3.2.2

automatic undo management

tablespace use in Oracle RAC, 10.3.1

automatic workload management

concepts, 1.4, 4.3.1

description, 4.1

manual rebalancing, 4.1

Automatic Workload Repository, 4.1, 4.1, 4.2, 4.12, 11.7, 11.9.3.2

snapshots, 11.7

Automatic Workload Repository (AWR)

monitoring performance, 4.3.1

AVAILABLE instances

for services, 4.3.1

Average Active Sessions chart

performance monitoring, 11.1.1.3

AWR

see Automatic Workload Repository

B

background processes

Oracle RAC, 1.3.4

SMON, 3.2, 7.3.1

background thread trace files, B.1

backups

server parameter file, 3.5.3

bandwidth

interconnect, 11.2

benefits

of cloning Oracle Clusterware, 6.1

best practices

deploying Oracle RAC for high availability, 10.1.1

block mode conversions

statistics for, 11.6

blocks

associated with instance, 7.3.1

buffer cache, 1.3.3

instance recovery, 7.3.1

buffer sizes

IPC, adjusting for Oracle Real Application Clusters, 11.3

C

Cache Fusion, 1.3.3

and e-commerce applications, 10.3.5

overview, 1.6.4

callouts

how they are run, 4.4.3

capacity

increasing, 10.1.3

catclustdb.sql script, 1.6.3

CATCLUST.SQL script

using to create views for Oracle Real Application Clusters, 11.5

channels

configure one RMAN channel for each Oracle RAC instance, 5.5.2

configuring during crosscheck or restore operations, 5.4

configuring for RMAN, 5.5

chart

Global Cache Block Access Latency, 11.1.1.3

charts

Average Active Sessions, 11.1.1.3

Cluster Host Load Average, 11.1.1.3

Database Throughput, 11.1.1.3

CLB_GOAL_SHORT, 4.4.1

client

application environments and FAN, 4.6

clients

integrated for FAN events, 4.4.1

JDBC thick, 4.6.1.1

JDBC thin, 4.6.1.1

client-side

load balancing, 4.3.3

client-side load balancing, 4.3.3

clone.pl script

cloning parameters, 6.3.1

environment variables, 6.3.1

cloning, 1.5.3, 6, 6.2

benefits, 6.1

deployment phase, 6.3

log files, 6.4

parameters passed to the clone.pl script, 6.3.1

preparation phase, 6.2

running $ORACLE_HOME/root.sh script, 6.3.1

setting ORACLE_BASE, 6.3.1

setting ORACLE_HOME, 6.3.1

setting ORACLE_HOME_NAME, 6.3.1

cluster

definition of, 1.1

Cluster Database Home Page, 11.1.1.1

Cluster Database Performance page

Top Activity drill down menu, 11.1.1.3

cluster file system

archiving parameter settings, 5.8.1.2

archiving scenario, 5.8.1

restore, 7.2.1

storage in Oracle RAC, 2.1

Cluster Host Load Average page

cluster database performance, 11.1.1.3

Cluster Managed Database Services Detail Page, 4.11.1.3

Cluster Managed Database Services Page, 4.11.1.2

CLUSTER NODE NAME parameter

FAN, and matching database signature, 4.4.5

cluster nodes name

in clone.pl script, 6.3.1

Cluster Verification Utility

overview and concepts, 1.6.2

CLUSTER_DATABASE initialization parameter, 3.6, 3.6.1

CLUSTER_DATABASE_INSTANCE initialization parameter, 3.6.1

CLUSTER_DATABASE_INSTANCES initialization parameter, 3.6

CLUSTER_INTERCONNECTS

parameter, 11.3

CLUSTER_INTERCONNECTS parameter

examples, 3.8.2, 3.8.2

recommendations for using, 3.8.1

CLUSTER_NODES parameter

in clone.pl script, 6.3.1

clustered ASM

converting a single-instance ASM, 2.6.5

clusters

consolidating multiple databases in, 10.1.2

clusterware management solution, 1.2

CMAN session pools

and FAN, 4.6

command-line interpreter

ADR Command-Line Interpreter (ADRCI), B.2

committed data

instance failure, 7.3.1

communication protocols

verifying settings for, 11.2

compatibility

Oracle RAC and Oracle Database software, 1.5.1

COMPATIBLE initialization parameter, 3.6.1

configuring channels

during restore or crosscheck operations, 5.4

configuring preferred mirror read disks in extended clusters, 2.6.4

CONNECT command, 3.1.3, 3.1.3.2

SQL*Plus, 3.1.3.2

CONNECT SYS

example of, 3.2.2

connecting

to instances, 1.6.2, 3.1.3

connection failover callback, 4.7

connection load balancing

concepts, 1.4

introduction to, 4.1

long method, 4.3.3

short method, 4.3.3

connection pools

and FAN, 4.6

consistent blocks, 1.3.3

CONTROL_FILES initialization parameter, 3.6.1

converting ASM single-instance to clustered ASM, 2.6.5

CREATE PFILE

FROM MEMORY clause, 3.5

Create Services Page, 4.11.1.4

CREATE SPFILE

FROM MEMORY clause, 3.5

creating

server parameter files, 3.5, 3.5.3

services, 4.10

crosscheck operations

configuring channels during, 5.4

crosschecking on multiple nodes

RMAN backups, 5.4

CRS resources

management of, 1.2

current blocks, 1.3.3

CVU

See Cluster Verification Utility

D

data dictionary

querying views, 11.5

data security

wallet, 10.3.8.1

data warehouse

deploying applications for in Oracle Real Application Clusters, 10.3.7

database

creation, 1.5.2

quiescing, 3.7

services

singleton, 3.1.1

uniform, 3.1.1

SRVCTL object name, A

Database Configuration Assistant (DBCA), 1.5.2

adding and deleting instances in silent mode, 9.1.1.2

cloning Oracle RAC instances, 6.3.1

creating views for Oracle Real Application Clusters, 11.5

Database Storage page, 9.1.1.1

Instance Management page, 9.1.1.1

List of Cluster Databases page, 9.1.1.1

Operations page, 9.1.1.1

running the catclustdb.sql script, 1.6.3

Summary dialog, 9.1.1.1

Welcome page, 9.1.1.1

database instances

administrator-managed

deleting, 9.2.1

database signatures

matching the FAN parameters, 4.4.5

Database Storage page, 9.1.1.1

Database Throughput page

performance monitoring, 11.1.1.3

DATABASE UNIQUE NAME parameter

FAN, and matching database signature, 4.4.5

databases

administrator-managed, 3.1.1, 4.3.1

consolidating multiple in a cluster, 10.1.2

controlling restarts, 3.9

policy-managed, 3.1.1, 4.3.1

scalability, 10.1.3

databases sessions

pre-created, 4.6.3

Datagram Protocol (UDP), 1.3.2, B.6

DB_BLOCK_SIZE initialization parameter, 3.6.1

DB_DOMAIN initialization parameter, 3.6.1

DB_FILES initialization parameter, 3.6.1

DB_NAME initialization parameter, 3.6, 3.6.1

DB_RECOVERY_FILE_DEST initialization parameter, 3.6.1

DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 3.6.1

DB_UNIQUE_NAME initialization parameter, 3.6.1

DBCA

see Database Configuration Assistant (DBCA)

default database service, 1.5.2, 3.6, 4.10

degree of parallelism (DOP), 10.3.7.2

deleting administrator-managed database instances, 9.2.1

dependencies

and services, 4.3.1

deploying

Oracle RAC database software, 6.3.1

Oracle Real Application Clusters environments, 1.6.1, 10

design

Oracle Real Application Clusters environments, 1.6.1, 10

diagnosing problems using ADR, B.2

DIAGNOSTIC_DEST parameter, B.1

DISCONNECT command, 3.1.3

disconnecting from instances, 3.1.3

diskgroup

SRVCTL object name, A

DISPATCHERS initialization parameter, 3.6

specifying a service with, 4.10

distributed SQL transactions, 4.8

Distributed Transaction Processing, 4.8, 10.3.4

distributed transactions, 4.8, 10.3.4

directing to a single instance in the cluster, 4.8

services in Oracle RAC, 4.8

XA transactions span instances, 4.8

DML_LOCKS initialization parameter, 3.6.1

DTP, 4.8, 10.3.4

DTP Service., 4.8

DTP/XA transactions, 4.8

dynamic performance views

creating, 11.5

for performance monitoring, 11.4

dynamic resource allocation

overview, 1.6.4

E

e-commerce

applications in Oracle Real Application Clusters, 10.3.5

ENCRYPTION_WALLET_LOCATION parameter, 10.3.8.1

Enterprise Manager

administering services, 4.11.1

Cluster Database page, 11.1.1

overview, 1.2

environment variables

passed to the clone.pl script, 6.3.1

eons

SRVCTL object name, A

event notification

enabling, 4.6.3

examples

setting the CLUSTER_INTERCONNECTS parameter, 3.8.2

extended distance cluster

Oracle ASM preferred mirror read, 2.6.4

extended distance clusters

configuring preferred mirror read disks, 2.6.4

external transaction managers

OraMTS, 4.8

F

failover callback routine, 4.7

failure

instance, 7.3

multiple node, 7.3.2

node, 7.3.1

failure events

calling routines with SQL_ORCLATTR_FAILOVER_CALLBACK, 4.7

identifying with the fo_code parameter, 4.7

FAN events

enabling for JDBC, 4.6.1.1

Fast Application Notification (FAN), 4.4

and high availability events, 4.4.5

callouts definition, 4.4.6

callouts, how to use, 4.4.6

events, enabling for JDBC clients, 4.6.1

events, enabling for ODP.NET, 4.6.4

events, enabling for Oracle Call Interface, 4.6.2

events, enabling ODP.NET clients, 4.6.5

how events are published, 4.4.1

introduction, 4.1

overview, 4.4.1

parameters and matching database signatures, 4.4.5

uses, 4.4.1

Fast Connection Failover

enabling with thin and thick clients, 4.6.1.1

introduction to, 4.1

Fast Connection Failover (FCF)

enabling JDBC clients, 4.6.1

fault diagnosability, B.2

FCF

See Fast Connection Failover (FCF)

features, new, Preface

files

archived redo log files, 5.7

redo log, 5.7

filesystem

SRVCTL object name, A

fo_code parameter

identifying failure events, 4.7

FROM MEMORY clause

on CREATE PFILE or CREATE SPFILE, 3.5

G

GC_SERVER_PROCESSES initialization parameter

specifying the number of LMSn processes, 10.1.2

GCS_SERVER_PROCESSES initialization parameter, 3.6

Generic server pool, 3.1.1

Global ADDM mode, 11.7

Global Cache Block Access Latency

performance monitoring, 11.1.1.3

Global Cache Service (GCS), 1.3.3

Global Cache Service Process (LMS), 1.3.4

Global Cache Service Processes (LMSn)

reducing the number of, 10.1.2, 10.1.2

specifying the number of, 10.1.2

Global Cache Service statistics, 11.9.1, 11.9.3.1

GLOBAL clause

forcing a checkpoint, 3.1.3.2

Global Enqueue Service (GES), 1.3.3

Global Enqueue Service Daemon (LMD), 1.3.4

Global Enqueue Service Monitor (LMON), 1.3.4

Global Enqueue Service statistics, 11.9.1

global performance data

with ADDM, 11.7

Global Resource Directory (GRD), 1.3.3

Global Transaction Process (GTX0-j), 1.3.4

GLOBAL_TXN_PROCESSES initialization parameter, 4.8

goals

and the load balancing advisory, 4.5.1

for load balancing advisory, 4.5.2

Grid Naming Service (GNS)

SRVCTL object name, A

GTX0-j

Global Transaction Process, 1.3.4

GV$SESSION dynamic performance view, 3.4

H

hardware-security module (HSM) devices

used by wallets, 10.3.8.1

hash partitioning

with Oracle Real Application Clusters, 10.2

high availability

best practices, 10.1.1

for Oracle RAC Databases, 10.1

high availability framework

concepts, 1.4

introduction to, 4.1

home

SRVCTL object name, A

HOST command, 3.1.3.2

SQL*Plus, 3.1.3.2

I

initdb_name.ora file

DIAGNOSTIC_DEST parameter, B.1

initialization parameters

cluster database issues regarding, 3.6

CLUSTER_INTERCONNECTS, 11.3

RECOVERY_PARALLELISM, 7.5.2.1

settings for instances, 3.5

that must be identical on all instances, 3.6.1

that must be unique on all instances, 3.6.2

INST_ID column, 11.4

installation

introduction, 1.5

Oracle Real Application Clusters, 1.5.2

installations

performing multiple simultaneous cluster, 6

instance

SRVCTL object name, A

instance discovery

Oracle Enterprise Manager Grid Control, 3.10.1

Instance Enqueue Process (LCK0), 1.3.4

Instance Management page, 9.1.1.1

INSTANCE NAME initialization parameter, 3.6

INSTANCE option, 3.1.3.2

INSTANCE parameter

FAN, and matching database signature, 4.4.5

INSTANCE_NAME initialization parameter, 3.6.2

INSTANCE_NUMBER initialization parameter, 3.6.2

INSTANCE_TYPE initialization parameter, 3.6.1

instances

aggregated for service performance, 11.1.1.3

cloning Oracle RAC, 6.3.1

effect of SQL*Plus commands on, 3.1.3.2

failure, 7.3.2

failures, recovery from, 7.3

initialization parameter settings, 3.5

maximum number for Oracle RAC, 1.1

memory structures, 1.3.3

parallel processes, 4.10

private interconnect usage, B.6

recovery, 3.2, 7.3.1

recovery, abnormal shutdown, 3.2

recovery, multiple failures, 7.3.2

Server Management, 3.1

shutting down, 3.2

terminating session on, 3.4

verifying, 3.3, 3.3, 3.3

instead of Statspack, 1.6.3

interconnect

and performance, 11.3

and the Oracle RAC architecture, 1.1

bandwidth, 11.2

protocols for Oracle Real Application Clusters, 11.2

verifying settings for, 11.2

interconnects

alternatives to the private network, 3.8

private, B.6

Interconnects page

monitoring clusterware with Oracle Enterprise Manager, 11.1.1

monitoring Oracle Clusterware, 11.1.1.2

IPCs

buffer sizes, adjusting, 11.3

IPD/OS

See Oracle Instantaneous Problem Detection - OS Tool

J

Java

enabling tools for tracing, B.4

Java Database Connectivity (JDBC) clients

ONS usage, 4.3.1

JDBC

and FAN, 4.6

enabling FAN events for, 4.6.1.1

thick clients, 4.6.1.1, 4.6.1.1

thin clients, 4.6.1.1

JDBC clients

enabling for Fast Connection Failover (FCF), 4.6.1

job administration

Oracle Enterprise Manager, 3.10.2.1

K

KILL SESSION clause

on the ALTER SYSTEM statement, 3.4

L

LCK0 Instance Enqueue Process, 1.3.4

LICENSE_MAX_USERS initialization parameter, 3.6.3

List of Cluster Databases page, 9.1.1.1

listener

SRVCTL object name, A

listeners

command to add to a node, A

command to remove, A

Oracle Net, 1.2

LMD Global Enqueue Service Daemon, 1.3.4

LMON Global Enqueue Service Monitor, 1.3.4

LMS Global Cache Service Process, 1.3.4

LMS processes

reducing the number of, 10.1.2

LMSn processes

reducing the number of, 10.1.2

load balancing

by services, 1.3.2

OCI runtime connection, 4.6.3

server-side, 4.3.3

Load Balancing Advisory, 4.10

load balancing advisory

and FAN events, 4.5.3

concepts, 1.4

configuring your environment for using, 4.5.2

deployment, 4.5.1

description of, 4.5

events and FAN, 4.4.1

introduction to, 4.1

Local ADDM mode, 11.7

local archiving scenario

RMAN, 5.8.2

Local Area Network (LAN), 1.3.2

LOCAL clause

forcing a checkpoint, 3.1.3.2

local file system

archiving parameter settings, 5.8.2.2

restore, 7.2.2

local node name

in clone.pl script, 6.3.1

LOCAL_NODE parameter

in clone.pl script, 6.3.1

location transparency

using service names, 4.10

log files

tracing, B.4

log sequence numbers, 5.7

LOG_ARCHIVE_FORMAT initialization parameter, 3.6.3

LOG_ARCHIVE_FORMAT parameter, 5.7

M

mass deployment

cloning, 1.5.3, 6, 6.2

media failures

recovery from, 7.4

memory structures

in Oracle RAC, 1.3.3

message request counters, 11.6

migration

application, 10.1.3

mission critical systems

considerations for Oracle RAC, 10.1

modified data

instance recovery, 7.3.1

monitoring

archiver process, 5.10

overview and concepts, 1.6.3

performance of global cache block access, 11.1.1.3

statistics for Oracle Real Application Clusters, 11.6

monitoring host load average, 11.1.1.3

multiple node failures, 7.3.2

multiple nodes

starting from one node, 3.2.2

multiplexed redo log files, 2.4

N

Network Attached Storage (NAS), 1.3.2

new features, Preface

NIC bonding, 3.8

node

failure and VIP addresses, 1.3.2

node discovery

Oracle Enterprise Manager Grid Control, 3.10.1

nodeapps

SRVCTL object name, A

nodes

affinity awareness, 7.3.5

failure of, 7.3.1

virtual IP addresses, A, A

O

objects

creation of and effect on performance, 10.3.2

srvctl object names and abbreviations, A

OC4J

SRVCTL object name, A

OCFS2, 1.3.1

OCI session pooling, 4.6.3

OCI Session Pools

and FAN, 4.6

OCI session pools

optimizing, 4.6.3

runtime connection load balancing, 4.6.3

service metrics, 4.6.3

OCI_EVENTS mode

setup for runtime connection load balancing, 4.6.3

OCI_SPC_NO_RLB mode parameter

setting for runtime connection load balancing, 4.6.3

OCI_THREADED mode

setup for runtime connection load balancing, 4.6.3

OCISessionPoolCreate()

setting OCI_SPC_NO_RLB mode parameter, 4.6.3

ODBC applications

calling SQL_ORCLATTR_FAILOVER_HANDLE attribute, 4.7

ODBC_FO_ABORT failure event, 4.7

ODBC_FO_BEGIN failure event, 4.7

ODBC_FO_END failure event, 4.7

ODBC_FO_ERROR failure event, 4.7

ODBC_FO_REAUTH failure event, 4.7

ODP.NET

and FAN, 4.6

and Fast Connection Failover, 4.6.4

load balancing advisory events, 4.6.5

online recovery, 7.3.1

online transaction processing

applications in Oracle Real Application Clusters, 10.3.5

ons

SRVCTL object name, A

Operations page, 9.1.1.1

Oracle ASM

see Oracle Automatic Storage Management (Oracle ASM)

Oracle ASM instances

administering with SRVCTL, 2.6.6

Oracle Automatic Storage Management (Oracle ASM)

adding a new instance, 9.1.1.1

archiving scenario, 5.8.1

installation, 1.5.2

Oracle ASM preferred read failure groups, 2.6.4

preferred mirror read disks, 2.6.4

SRVCTL object name, A

storage solution, 2.1

Oracle Call Interface (OCI)

runtime connection load balancing, 4.6.3

Oracle Call Interface environment

to receive service metrics, 4.6.3

Oracle Cluster File System (OCFS), 1.3.1

Oracle Clusterware

cloning, 1.5.3

controlling database restarts, 3.9

described, 1.2, 1.2

introduction, 1.2

introduction and concepts of, 1

managing Oracle processes, 1.2

Oracle Dynamic Volume Manager

described, Preface

Oracle Enterprise Manager, 3.1.2

adding database instances to nodes, 9.1.1

alert administration, 3.10.2.2

alert blackouts, 3.10.2.3

Automatic Database Diagnostic Monitoring (ADDM), 11.7

Cluster Database Performance page

Cluster Database Performance page, 11.1.1.3

Cluster Managed Database Services Detail Page, 4.11.1.3

Cluster Managed Database Services Page, 4.11.1.2

Create Services Page, 4.11.1.4

deleting database instances from nodes, 9.2.1

Interconnects page, 11.1.1.2

job administration, 3.10.2.1

overview and concepts, 1.6.2

services pages, accessing, 4.11.1.5

using the Interconnects page to monitor Oracle Clusterware, 11.1.1

Oracle Enterprise Manager Grid Control

instance discovery, 3.10.1

node discovery, 3.10.1

Oracle home

cloning, 1.5.3

Oracle Instantaneous Problem Detection - OS Tool (IPD/OS), 1.6.3

Oracle Maximum Availability Architecture (MAA), 10.1

Oracle Net

listeners, 1.2

Oracle Net Services

and load balancing, 4.6

and services, 4.3.1

Oracle Notification Service (ONS), 1.2

SRVCTL object name, A

used by FAN, 4.3.1

Oracle Notification Services

API, 4.4.1

Oracle processes

managed by Oracle Clusterware, 1.2

Oracle RAC

adding to nodes in a cluster, 9.1

cloning, 1.5.3, 6

removing, 9.2.2

software components, 1.3.3

storage options

network file system (NFS), 1.3.1

Oracle Automatic Storage Management (Oracle ASM), 1.3.1

Oracle Cluster File System (OCFS), 1.3.1

volume manager, 1.3.1

Oracle RAC Management Processes (RMSn), 1.3.4

Oracle RAC One Node, Preface

Oracle Real Application Clusters

and e-commerce, 10.3.5

installation overview, 1.5.2

overview of administration, 1

Oracle Real Application Clusters One Node, Preface

Oracle Streams Advanced Queuing

and FAN, 4.4.1

ORACLE_BASE environment variable, 6.3.1

ORACLE_HOME, 1.5.2

ORACLE_HOME environment variable, 6.3.1

ORACLE_HOME_NAME environment variable, 6.3.1

ORACLE_SID parameter, 3.6.2

OraMTS

external transaction manager, 4.8

OUI

database installation, 1.5.2

Oracle Real Application Clusters installation, 1.5.2

outages

planned, 4.4.4

unplanned, 4.4.3

P

parallel instance groups, 4.10

parallel processes, 4.10

parallel recovery, 7.5.2.1

PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 3.6.1

PARALLEL_INSTANCE_GROUP initialization parameter

parallel processes, 4.10

PARALLEL_INSTANCE_GROUPS initialization parameter

parallel processes, 4.10

PARALLEL_MAX_SERVERS parameter, 7.5.2.1

parallelism

in Oracle Real Application Clusters, 10.3.7.2

parallel-aware query optimization, 10.3.7.1

parameter file

overview, 3.5

parameters

that must be identical on all instances, 3.6.1

that must be unique on all instances, 3.6.2

Partial ADDM mode, 11.7

performance, 11.1.1.3

aggregates by services, 11.1.1.3

comprehensive global data, 11.7

monitoring activity by wait events, services, and instances, 11.1.1.3

monitoring database throughput, 11.1.1.3

monitoring global cache block access, 11.1.1.3

monitoring potential problems in the database, 11.1.1.3

primary components affecting, 11.2

service aggregates by instances, 11.1.1.3

service aggregates by waits, 11.1.1.3

using ADDM, 1.6.3

performance evaluation

overview and concepts, 1.6.4

phases

cloning deployment, 6.3

cloning preparation, 6.2

policy-managed databases, 3.1.1, 4.3.1

defined, 1.6.1

deleting, 9.2.1

PREFERRED instances

for services, 4.3.1

preferred read disks

Oracle ASM in an Oracle RAC extended distance cluster, 2.6.4

private interconnect

determining usage, B.6

private network

alternative interconnect, 3.8

processes

managed by Oracle Clusterware, 1.2

parallel, 4.10

Q

queue

access using service names, 4.10

quiesce database

in Oracle Real Application Clusters, 3.7

quiescing

single-instance database, 3.7

R

rebalancing

workloads, 4.1

RECOVER command, 3.1.3.2

SQL*Plus, 3.1.3.2

recovery

after SHUTDOWN ABORT, 3.2

from multiple node failure, 7.3.2

from single-node failure, 7.3.1

instance, 3.2

media failures, 7.4

online, 7.3.1

parallel, 7.5.2.1

PARALLEL_MAX_SERVERS initialization parameter, 7.5.2.1

RECOVERY_PARALLELISM parameter, 7.5.2.1

redo log files

instance recovery, 7.3.1

log sequence number, 5.7

using, 2.4

redo log groups, 2.4

redo logs

format and destination specifications, 5.7

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 3.6.1

Resource Manager

and services, 4.3.1

resource manager, 4.1

resource profiles

and service creation, 4.3.1

resources

releasing, 7.3.1

restore scenarios

RMAN, 7.2

restore scheme

cluster file system, 7.2.1

local file system, 7.2.2

RESULT_CACHE_MAX_SIZE initialization parameter, 3.6, 3.6.1

RMAN

configuring channels, 5.4

configuring channels to use automatic load balancing, 5.5

configuring one channel for each instance, 5.5.2

crosschecking on multiple nodes, 5.4

local archiving scenario, 5.8.2

restore scenarios, 7.2

RMSn Oracle RAC Management Processes, 1.3.4

rolling back

instance recovery, 7.3.1

root.sh script

$ORACLE_HOME, 6.3.1

RSMN background process, 1.3.4

Runtime Connection Load Balancing, 4.3.1

runtime connection load balancing

defined, 4.6.3

disabling, 4.6.3

in OCI session pools, 4.6.3

introduction to, 4.1

S

scalability

Oracle RAC, 10.1.3

SCAN, 1.2

defined, 1.4

scan

SRVCTL object name, A

scan_listener

SRVCTL object name, A

scripts

$ORACLE_HOME/root.sh, 6.3.1

security

wallet, 10.3.8.1

sequence numbers

with Oracle Real Application Clusters, 10.2

sequences

log sequence number, 5.7

Server Control Utility

see SRVCTL

Server Management

administration of instances, 3.1

server parameter file

backing up, 3.5.3

setting values in, 3.5.1

server parameter files

creating, 3.5, 3.5.3

server pool

SRVCTL object name, A

server pools

concepts, 1.4

servers

scalability, 10.1.3

service

dependencies, 4.3.1

levels, 4.13

SRVCTL object name, A

service level objective

defining for Oracle RAC, 10.1

service metrics

OCI runtime connection load balancing, 4.6.3

runtime connection load balancing, 4.6.3

SERVICE parameter

FAN, and matching database signature, 4.4.5

SERVICE TIME

load balancing advisory goal, 4.5.2

SERVICE_NAMES initialization parameter, 3.6

setting for services, 3.6, 4.10

services

access to a queue, 4.10

activity levels aggregated by instances, 11.1.1.3

activity levels aggregated by services, 11.1.1.3

activity levels aggregated by waits, 11.1.1.3

administering, 4.10

administering with Oracle Enterprise Manager, 4.11

administering with SRVCTL, 4.11, 4.11.2

basic concepts about, 4.3.1

concepts, 1.4

configuring automatic workload management characteristics, 4.10

default, 4.3.2

enabling event notification, 4.6.3

introduction to, 1.3.2, 4.1

management policy

automatic, 4.3.1

manual, 4.3.1

performance monitored by AWR, 4.3.1

SERVICE_NAMES parameter, 3.6, 4.10

specifying a service, 4.10

using, 4.3.1

sessions

multiple, 3.1.3

terminating on a specific instance, 3.4

SESSIONS_PER_USER initialization parameter, 3.6

setting attributes for SQLSetConnectAttr function, 4.7

setting instances, 1.6.2, 3.1.3

shared everything, 1.3.1

SHOW INSTANCE command, 3.1.3.2

SQL*Plus, 3.1.3.2

SHOW PARAMETER command

SQL*Plus, 3.1.3.2

SHOW PARAMETERS command, 3.1.3.2

SHOW SGA command, 3.1.3.2

SQL*Plus, 3.1.3.2

SHUTDOWN ABORT command, 3.2

SHUTDOWN command

ABORT option, 3.2

SQL*Plus, 3.1.3.2

SHUTDOWN TRANSACTIONAL, 3.2

shutting down

instances, 3.2

shutting down an instance

abnormal shutdown, 3.2

shutting down instances, 3.2

sidalrt.log file, B.3

single client access name

See SCAN

single client access name (SCAN)

SRVCTL object name, A

single system image, 1.3.3

single-instance ASM

converting to clustered ASM, 2.6.5

single-instance databases

quiescing, 3.7

SMON process

instance recovery, 7.3.1, 7.3.2

recovery after SHUTDOWN ABORT, 3.2

snapshot control file, 5.2

SPFILE

restore with Oracle Enterprise Manager, 7.2.3

restore with RMAN, 7.2.3

SPFILE initialization parameter, 3.6, 3.6.3

SQL statements

executing in parallel, 4.10

instance-specific, 3.1.3.2

SQL*Plus, 3.1.3

changing the prompt, 3.1.3.1

SQL*Plus commands

effect on instances, 3.1.3.2

SQL_ORCLATTR_FAILOVER_CALLBACK attribute

of the SQLSetConnectAttr function, 4.7

SQL_ORCLATTR_FAILOVER_HANDLE attribute

of the SQLSetConnectAttr function, 4.7

SQLSetConnectAttr function

setting attributes in the sqora.h file, 4.7

SQL_ORCLATTR_FAILOVER_CALLBACK attribute, 4.7

SQL_ORCLATTR_FAILOVER_HANDLE attribute, 4.7

sqora.h file, 4.7

SRVCTL

add, usage description, A

administering Oracle ASM instances, 2.6.6

administering services with, 4.11.2

cluster database configuration tasks, A

cluster database tasks, A

command syntax, A

commands

add asm, A

add database, A

add eons, A

add filesystem, A

add gns, A

add instance, A

add listener, A

add nodeapps, A

add ons, A

add scan, A

add scan_listener, A

add service, A, A, A

add srvpool, A

add vip, A

config asm, A, A

config database, A

config eons, A

config filesystem, A

config gns, A

config nodeapps, A

config oc4j, A

config ons, A

config scan, A

config scan_listener, A

config service, A

config srvpool, A

config vip, A

disable asm, A

disable database, A

disable diskgroup, A

disable eons, A

disable filesystem, A

disable gns, A

disable instance, A

disable listener, A

disable nodeapps, A

disable oc4j, A

disable ons, A

disable scan, A

disable scan_listener, A

disable service, 4.11.2.3, A

disable vip, A

enable asm, A

enable database, A

enable diskgroup, A, A

enable eons, A

enable filesystem, A

enable instance, A

enable listener, A

enable nodeapps, A

enable oc4j, A

enable ons, A

enable scan, A

enable scan_listener, A

enable service, 4.11.2.3, A

enable vip, A

getenv asm, A

getenv database, A

getenv listener, A

getenv nodeapps, A, A

help, A

modify asm, A

modify database, A

modify eons, A, A

modify filesystem, A

modify instance, A

modify listener, A

modify nodeapps, A

modify oc4j, A

modify ons, A

modify scan, A

modify scan_listener, A

modify service, A

modify srvpool, A

relocate gns, A

relocate oc4j, A

relocate scan, A

relocate scan_listener, A

relocate server, A

relocate service, A

remove asm, A

remove database, A

remove diskgroup, A

remove eons, A

remove filesystem, A

remove gns, A

remove instance, A

remove listener, A

remove nodeapps, A

remove oc4j, A

remove ons, A

remove scan, A

remove scan_listener, A

remove service, A

remove srvpool, A

remove vip, A

setenv asm, A

setenv database, A, A

setenv listener, A

setenv nodeapps, A

start asm, A

start database, A

start diskgroup, A

start eons, A, A

start gns, A

start home, A

start instance, A

start listener, A

start nodeapps, A

start oc4j, A

start ons, A

start scan, A

start scan_listener, A

start service, A

start vip, A

status asm, A

status database, A

status diskgroup, A

status eons, A

status filesystem, A

status gns, A

status home, A

status instance, A

status listener, A

status nodeapps, A

status oc4j, A

status ons, A

status scan, A

status scan_listener, A

status server, A

status service, A

status srvpool, A

status vip, A

stop asm, A

stop database, A

stop diskgroup, A

stop eons, A

stop filesystem, A

stop gns, A

stop home, A

stop instance, A

stop listener, A

stop nodeapps, A

stop oc4j, A

stop ons, A

stop scan, A

stop scan_listener, A

stop service, A

stop vip, A

unsetenv asm, A

unsetenv database, A, A

unsetenv listener, A

unsetenv nodeapps, A

concurrent commands, A

config, usage description, A

deprecated commands and options, A

disable, usage description, A

enable, usage description, A

getenv, usage description, A

modify, usage description, A

node-level tasks, A

object name

database, A

diskgroup, A

eons, A

filesystem, A

Grid Naming Service (GNS), A

home, A

instance, A

listener, A

node applications (nodeapps), A

oc4j, A

Oracle Automatic Storage Management (Oracle ASM), A

Oracle Notification Service (ONS), A

scan, A

scan_listener, A

server pool (srvpool), A

service, A

vip, A

object names, A

overview, 3.1.4

overview and concepts, 1.6.2

relocate, usage description, A

remove, usage description, A

setenv, usage description, A

start database command, 3.2.3

start instance command, 3.2.3

start service command, 4.11.2.2, 4.11.2.2

start, usage description, A

status service command, 4.11.2.5

status, usage description, A

stop database command, 3.2.3

stop instance command, 3.2.3

stop, usage description, A

unsetenv, usage description, A

srvctl

enabling event notification, 4.6.3

SRVM_TRACE environment variable, B.4

Standard Edition

installing ASM, 1.5.2

STARTUP command

SQL*Plus, 3.1.3.2

statistics

contents of, 11.6

monitoring for Oracle Real Application Clusters, 11.6

Statspack, 11.9, 11.9.1

usage, 1.6.3

storage

cluster file system, 2.1

Oracle Automatic Storage Management (Oracle ASM), 2.6.1

subnet

configuring for virtual IP address, A, A

Summary dialog, 9.1.1.1

SYS$BACKGROUND service, 4.3.2

SYS$USERS service, 4.3.2

SYSASM privilege, 3.2.2

SYSAUX tablespace, 10.3.3

SYSDBA

privilege for connecting, 3.1.3

SYSOPER privilege

for connecting, 3.1.3

system change, 5.7

System Global Area (SGA), 1.3.3

size requirements, 1.3.3

T

tablespaces

automatic segment-space management in Oracle RAC, 10.3.1

automatic undo management in Oracle RAC, 10.3.1

use in Oracle RAC, 10.3.1

TCP/IP, 1.3.2

THREAD initialization parameter, 3.6

threads

multiple application, 4.6.3

thresholds

services, 4.13

THROUGHPUT

load balancing advisory goal, 4.5.2

timed statistics, 11.6

timeout

messages, avoiding, 1.3.2

Top Activity drill down menu

on the Cluster Database Performance page, 11.1.1.3

Top Cluster Events, ASH report, 11.8.2

Top Remote Instance, ASH report, 11.8.3

trace files, B.1

managing, B.1

sidalrt.log, B.3

TRACE_ENABLED initialization parameter, 3.6.3

tracing

enabling Java tools, B.4

SRVM_TRACE environment variable, B.4

writing to log files, B.4

transactions

instance failure, 7.3.1

rolling back, 7.3.1

waiting for recovery, 7.3.1

Transparent Application Failover

and services, 4.3.3

Transparent Data Encryption, 10.3.8.1

specifying the ENCRYPTION_WALLET_LOCATION parameter, 10.3.8.1

specifying the WALLET_LOCATION parameter, 10.3.8.1

Transparent Database Encryption, 10.3.8.1

tuning

overview, 1.6.4

using ADDM, 1.6.3

U

UNDO_MANAGEMENT initialization parameter, 3.6.1

UNDO_RETENTION initialization parameter, 3.6.3

UNDO_TABLESPACE parameter, 3.6.2

Universal Connection Pool

benefits, Preface

V

V$ACTIVE_INSTANCES, 3.3, 3.3

vendor clusterware, 1.1

verification

data files, online files, 2.3

versions

compatibility for Oracle RAC and Oracle Database software, 1.5.1

views

creating for Oracle Real Application Clusters, 11.5

for performance monitoring, 11.4

VIP

SRVCTL object name, A

Virtual Internet Protocol (VIP) address, 1.2

virtual IP address

requirements, A, A

W

wait events, 11.9.1

aggregated for service performance, 11.1.1.3

wallet

data security, 10.3.8.1

WALLET_LOCATION parameter, 10.3.8.1

wallets

for Transparent Data Encryption, 10.3.8.1

Welcome page, 9.1.1.1

workload management

See automatic workload management

workloads

and services, 4.3.1

X

XA transactions, 4.8, 10.3.4

spanning Oracle RAC instances, 4.8