23/23

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

---

A

abnormal instance termination, 3.2.2

ACMS

Atomic Controlfile to Memory Service, 1.4.7

Active Session History

Oracle RAC, 13.8.1

Top Cluster Events, 13.8.2

Top Remote Instance, 13.8.3

active sessions, 13.8.1

ACTIVE_INSTANCE_COUNT initialization parameter, 3.7

adding nodes to an existing cluster, 9.1

adding Oracle RAC to nodes on Linux and UNIX, 10.1

adding Oracle RAC to nodes on Windows, 11.1

ADDM

global monitoring, 13.7

see Automatic Database Diagnostic Monitor

ADDM for Oracle Real Application Clusters mode, 13.7

administering

services, 5.13.1

services with SRVCTL, 5.13.3

administering instances

with Server Management, 3.1.1

administering Oracle Enterprise Manager jobs, 3.13.3.1

administering services

Oracle Enterprise Manager, 5.13

SRVCTL, 5.13

administrative tools

overview and concepts, 1.10.2

SYSASM privilege, 3.2.4

administrator-managed database, 1.6, 3.1

administrator-managed database instances

adding, 11.1.1

administrator-managed databases, 5.2.2.5

AVAILABLE instances for services, 5.2.2.5

converting to policy-managed, 3.8

PREFERRED instances for services, 5.2.2.5

ADRCI

ADR Command-Line Interpreter, B.2

Advanced Queuing

and FAN, 5.4.2

Advisor Central in Oracle Enterprise Manager, 13.7

aggregates

by instances, 13.1.1.3

by services, 13.1.1.3

by waits, 13.1.1.3

alert administration

Oracle Enterprise Manager, 3.13.3.2

alert blackouts

Oracle Enterprise Manager, 3.13.3.3

alert logs, B.3

managing, B.1

ALTER SYSTEM ARCHIVE LOG CURRENT statement, 3.1.1.3.1

ALTER SYSTEM ARCHIVE LOG statement, 3.1.1.3.1

INSTANCE option, 3.1.1.3.1

ALTER SYSTEM CHECKPOINT LOCAL statement, 3.1.1.3.1

ALTER SYSTEM CHECKPOINT statement

global versus local, 3.1.1.3.1

specifying an instance, 3.1.1.3.1

ALTER SYSTEM KILL SESSION statement

terminating a session on a specific instance, 3.5

ALTER SYSTEM QUIESCE RESTRICTED statement

quiescing a noncluster database, 3.10

ALTER SYSTEM statement

CHECKPOINT clause, 3.1.1.3.1

ALTER SYSTEM SWITCH LOGFILE statement, 3.1.1.3.1, 3.1.1.3.1

Application Continuity

configuring service attributes, 5.13.3.2

introduction to, 1.5

requests, 5.6.2

applications

consolidating multiple in a single database, 12.1.3

highly available, 12.1

scalability, 12.1.4

spanning XA transactions across Oracle RAC instances, 5.9.1

using pre-created database sessions, 5.8.7

ARCHIVE LOG command

SQL*Plus, 3.1.1.3.1

archive logs

destinations, converting to cluster database, 14.1

ARCHIVE_LAG_TARGET initialization parameter, 3.7.3

archived redo log files

applying in parallel, 7.5.1

file format and destination, 6.8

log sequence number, 6.8

archiver process

monitor, 6.10

archiving mode

changing, 6.2

ASH reports, 13.8.1

asm

SRVCTL object name, A.9

ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter, 2.5.4, 3.7

Atomic Controlfile to Memory Service (ACMS), 1.4.7

Automatic Database Diagnostic Monitor, 13.9.2, 13.9.3.2, 13.9.5

Automatic Database Diagnostic Monitor (ADDM), 1.10.3

analyzing AWR data, 13.7

DBMS_ADDM PL/SQL package, 13.7

DBMS_ADVISOR PL/SQL package, 13.7

Global ADDM mode, 13.7

Local ADDM mode, 13.7

Automatic Database Diagnostic Monitoring (ADDM), 13.7

Automatic Diagnostic Repository (ADR), B.2

ADRCI command-line interpreter, B.2

automatic load balancing

configuring RMAN channels for multiple instances, 6.6

AUTOMATIC management policy, 3.2.1

Automatic Performance Diagnostics (AWR)

monitor performance statistics, 13.7

automatic segment space management (ASSM), 12.3.1

tablespace use in Oracle RAC, 12.3.1

automatic undo management

tablespace use in Oracle RAC, 12.3.1

automatic workload management

concepts, 1.5, 5.1

manual rebalancing, 5.10

Automatic Workload Repository, 1.5, 5.10, 5.10, 5.11, 13.9.3.2

Automatic Workload Repository (AWR), 13.7, 13.9

monitoring performance, 5.2.1.3

snapshots, 13.7

AVAILABLE instances

for services, 5.2.2.5

Average Active Sessions chart

performance monitoring, 13.1.1.3

AWR

see Automatic Workload Repository

---

B

background processes

Oracle RAC, 1.4.7

SMON, 3.2.2, 7.3.1

background thread trace files, B.1

backups

and converting to cluster database, 14.1

server parameter file, 3.6.3

bandwidth

interconnect, 13.2

best practices

deploying Oracle RAC for high availability, 12.1.2

blackouts

defining, 3.13.3.3

block mode conversions

statistics for, 13.6

blocks

associated with instance, 7.3.1

buffer cache, 1.4.6

instance recovery, 7.3.1

buffer sizes

interprocess communication (IPC)

adjusting for Oracle RAC, 13.3

---

C

cache coherency, 13.9.3.1

Cache Fusion, 1.4.6, 12.3.5

and e-commerce applications, 12.3.5

overview, 1.10.4

Cache Fusion performance, 13.2

cache fusion transfers, 13.9.4

callouts

how they are run, 5.4.3

capacity

increasing, 12.1.4

cardinality, 3.1

catclustdb.sql script, 1.10.3

CATCLUST.SQL script

using to create views for Oracle RAC, 13.5

CDBs, 3.3

changing the configuration of all services, 4.2.1

channels

configure one RMAN channel for each Oracle RAC instance, 6.6.2

configuring during crosscheck or restore operations, 6.5

configuring for RMAN, 6.6

chart

Global Cache Block Access Latency, 13.1.1.3

charts

Average Active Sessions, 13.1.1.3

Cluster Host Load Average, 13.1.1.3

Database Throughput, 13.1.1.3

checking the interconnect, B.6

CLB_GOAL_SHORT, 5.4.2

client

application environments and FAN, 5.8

client connections with SCAN, 3.1

client drivers

and FAN, 5.8.1

clients

integrated for FAN events, 5.4.2

JDBC/OCI, 5.8.2.2

JDBC-thin driver, 5.8.2

client-side

load balancing, 5.3

client-side load balancing, 5.3.4

clone.pl, 8.4

clone.pl script

cloning parameters, 8.3

environment variables, 8.3

cloning, 1.7.4, 8, 8.2

deployment phase, 8.3

log files, 8.4

parameters passed to the clone.pl script, 8.3

preparation phase, 8.2

running $ORACLE_HOME/root.sh script, 8.3

setting ORACLE_BASE, 8.3

setting ORACLE_HOME, 8.3

setting ORACLE_HOME_NAME, 8.3

cloning log files, 8.4

cluster

definition of, 1.1

cluster administrator, 3.1

cluster cache coherency, 13.1.1.2

cluster configuration policy, 1.6.4

cluster configuration policy set, 1.6.4

Cluster Database Performance page

Top Activity drill down menu, 13.1.1.3

cluster databases

creating using DBCA, 14.2.3.1.1

cluster file system

archiving parameter settings, 6.9.1.2

archiving scenario, 6.9.1

restore, 7.2.1

storage in Oracle RAC, 2.1

Cluster Host Load Average page

cluster database performance, 13.1.1.3

cluster nodes name

in clone.pl script, 8.3

Cluster Verification Utility

overview and concepts, 1.10.2

CLUSTER_DATABASE initialization parameter, 3.7, 3.7.1

CLUSTER_DATABASE_INSTANCE initialization parameter, 3.7.3

CLUSTER_DATABASE_INSTANCES initialization parameter, 3.7

CLUSTER_INTERCONNECTS

parameter, 13.3

CLUSTER_INTERCONNECTS initialization parameter, 3.7, 3.11.1

CLUSTER_NODE_NAME parameter

FAN, and matching database signature, 5.4.5

CLUSTER_NODES parameter

in clone.pl script, 8.3

clustered Oracle ASM

converting a noncluster Oracle ASM, 2.5.5

clusters

consolidating multiple databases in, 12.1.3

policy-managed, 1.6.4

clusterware management solution, 1.3

cold backups, 3.10

comma-delimited lists with SRVCTL, A.1

command-line interpreter

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

committed data

instance failure, 7.3.1

communication protocols

verifying settings for, 13.2

compatibility

Oracle RAC and Oracle Database software, 1.7.1

COMPATIBLE initialization parameter, 3.7.1

configuring channels

during restore or crosscheck operations, 6.5

configuring preferred mirror read disks in extended clusters, 2.5.4

CONNECT command, 3.1.1.3.1

SQL*Plus, 3.1.1.3.1

CONNECT SYS

example of, 3.2.4

connecting

to instances, 1.10.2

connection load balancing

introduction to, 1.5

long method, 5.3.1

short method, 5.3.1

connection pools

and FAN, 5.8.1

consistent blocks, 1.4.6

CONTROL_FILES initialization parameter, 3.7.1

convert to cluster database

from single-instance to Oracle Real Application Clusters, 14

post-conversion, 14.6

to Oracle RAC from single-instance databases, 14

convert to Oracle RAC database

from non-cluster system, 14.2.1

converting

from single instance to Oracle RAC, 14.3

from single-instance to Oracle Real Application Clusters, 14.3.4

with rconfig, 14.3

converting a database from Oracle RAC One Node to Oracle RAC, 4.2.2

converting an Oracle RAC database with one instance to Oracle RAC One Node, 4.2.1

corrupted data blocks, B.2

CREATE PFILE

FROM MEMORY clause, 3.6

CREATE PFILE statement, 3.6.3

CREATE SPFILE

FROM MEMORY clause, 3.6

creating

server parameter files, 3.6

services, 5.13.1

SPFILE backups, 3.6.3

crosscheck operations

configuring channels during, 6.5

crosschecking on multiple nodes

RMAN backups, 6.5

CRS resources

management of, 1.3

current blocks, 1.4.6

CVU

See Cluster Verification Utility

---

D

data dictionary

querying views, 13.5

Data Recovery Advisor, B.2

data security

keystore, 12.3.8.1

data warehouse

deploying applications for in Oracle RAC, 12.3.7

data warehouse systems, 12.3.7

database

services

singleton, 3.8

uniform, 3.8

SRVCTL object name, A.9

database cloud, 12.1.3.3

Database Configuration Assistant (DBCA)

adding and deleting instances in interactive mode

on Windows, 11.1.1.1

adding instances in interactive mode

on Linux and UNIX, 10.1.2.1

cloning Oracle RAC instances, 8.3

creating views for Oracle Real Application Clusters, 13.5

Database Storage page, 10.1.2.1, 11.1.1.1

deleting instances in interactive mode

on Linux and UNIX, 10.2.1.1

on Windows, 11.2.1.1

Instance Management page, 10.1.2.1, 11.1.1.1

List of Cluster Databases page, 10.1.2.1, 11.1.1.1

running the catclustdb.sql script, 1.10.3

Welcome page, 10.1.2.1

database deployment

administrator-managed, 1.6, 3.1

policy-managed, 1.6, 3.1

database instances

administrator managed

deleting, 10.2.1, 11.2.1

connecting to, 3.1.1.3

database pools, 12.1.3.3

database resource, 3.1

Database Resource Manager, 3.10

database role, 3.2.1

database signatures

matching the FAN parameters, 5.4.5

Database Storage page, 10.1.2.1, 11.1.1.1

Database Throughput page

performance monitoring, 13.1.1.3

DATABASE_UNIQUE_NAME parameter

FAN, and matching database signature, 5.4.5

databases

administrator managed, 5.2.2.5

consolidating multiple in a cluster, 12.1.3

controlling restarts, 3.12

creating

Oracle RAC One Node, 4.1

Oracle RAC One Node

services on, 4.1

policy managed, 3.1, 5.2.2.6

scalability, 12.1.4

databases sessions

pre-created, 5.8.7

DB_BLOCK_SIZE initialization parameter, 3.7.1

DB_DOMAIN initialization parameter, 3.7.1

DB_FILES initialization parameter, 3.7.1

DB_NAME initialization parameter, 3.7, 3.7.1

DB_RECOVERY_FILE_DEST initialization parameter, 3.7.1, 7.6

DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 3.7.1

DB_UNIQUE_NAME initialization parameter, 3.7.1

DDL statements, 12.3.2

default database service, 1.7.3, 3.7, 5.13.1

degree of parallelism, 12.3.7.1

deleting administrator-managed database instances, 10.2.1, 11.2.1

dependencies

and services, 5.2.1.1

deploying

Oracle Real Application Clusters environments, 1.10.1, 12

design

Oracle Real Application Clusters environments, 1.10.1, 12

diagnosing problems for Oracle RAC, B

diagnosing problems using ADR, B.2

DIAGNOSTIC_DEST initialization parameter, B.1, B.3

diskgroup

SRVCTL object name, A.9

DISPATCHERS initialization parameter, 3.7

specifying a service with, 5.13.1

Distributed Transaction Processing (DTP), 12.3.4

See DTP

distributed transactions, 12.3.4

directing to a single instance in the cluster, 5.9.2

services in Oracle RAC, 5.9.1

XA transactions span instances, 5.9.1

DML_LOCKS initialization parameter, 3.7.1

DTP, 5.9

services

relocating, 5.9.5

with Oracle RAC, 5.9.3

XA affinity, 5.9.2

XA transactions, 5.9.1

DTP Service., 5.9.2

dynamic database services

description, 1.5

Dynamic Database Services

introduction to, 1.4.3

dynamic performance views, 13.9

creating, 13.5

GV$, 1.10.3

V$, 1.10.3

dynamic resource allocation

overview, 1.10.4

---

E

e-commerce

applications in Oracle RAC, 12.3.5

edition

services attribute, 5.2.2.2

ENCRYPTION_WALLET_LOCATION parameter, 12.3.8.1

Enterprise Manager

overview, 1.3

environment variables

passed to the clone.pl script, 8.3

setting with SRVCTL, 3.1.1.1

error

recoverable, 5.5.1

evaluating block transfers, 13.6

event notification

enabling, 5.8.7

extended distance cluster, 2.5.4

Oracle ASM preferred mirror read, 2.5.4

extended distance clusters

configuring preferred mirror read disks, 2.5.4

extending Oracle database home

on shared storage

network-attached storage, 10.1, 11.1

Oracle ACFS, 10.1, 11.1

external transaction managers

OraMTS, 5.9.1

---

F

failure

instance, 7.3

multiple node, 7.3.2

node, 7.3.1

failure groups, 2.5.4

FAN

See Fast Application Notification (FAN)

Fast Application Notification (FAN), 5.4

and high availability events, 5.4.5

callouts

definition, 5.4.7

how to use, 5.4.7

events

enabling for JDBC, 5.8.2.2

enabling for JDBC-thin clients, 5.8.2

enabling for OCI, 5.8.6

enabling for ODP.NET, 5.8.9

enabling ODP.NET clients, 5.8.10

HA events, 5.8.1

how events are published, 5.4.2

introduction, 1.5

overview, 5.4.2

parameters and matching database signatures, 5.4.5

uses, 5.4.2

Fast Connection Failover (FCF)

enabling JDBC-thin clients, 5.8.2

enabling with thin and thick clients, 5.8.2.2

introduction to, 1.5

Fast Recovery

and files managed by Oracle, 14.3.4

fault diagnosability, B.2

FCF

See Fast Connection Failover (FCF)

files

archived redo log files, 6.8

redo log, 6.8

filesystem

SRVCTL object name, A.9

FROM MEMORY clause

on CREATE PFILE or CREATE SPFILE, 3.6

---

G

GC_SERVER_PROCESSES initialization parameter

specifying the number of LMSn processes, 12.1.3.2

GCS protocol, 13.9.3.1

GCS_SERVER_PROCESSES initialization parameter, 3.7

Generic server pool, 3.1

GES

See global cache and enqueue service (GES)

global cache and enqueue service (GES), 13.9.1

Global Cache Block Access Latency chart

performance monitoring, 13.1.1.3

Global Cache Service (GCS), 1.4.6, 3.7

Global Cache Service Process (LMS), 1.4.7

Global Cache Service Processes (LMSn)

reducing the number of, 12.1.3.2

specifying the number of, 12.1.3.2

Global Cache Service statistics, 13.9.1, 13.9.3.1

GLOBAL clause

forcing a checkpoint, 3.1.1.3.1

Global Data Services listeners

command to add to the cluster, A.9.7.1

Global Enqueue Service (GES), 1.4.6

Global Enqueue Service Daemon (LMD), 1.4.7

Global Enqueue Service Monitor (LMON), 1.4.7

Global Enqueue Service statistics, 13.9.1

global performance data

with ADDM, 13.7

Global Resource Directory (GRD), 1.4.6

global service attributes

GDSCTL, 5.14

global services, 5.14, 12.1.3.3

Global Transaction Process (GTX0-j), 1.4.7

GLOBAL_TXN_PROCESSES initialization parameter, 5.9.1

goals

and the load balancing advisory, 5.7.1

for load balancing advisory, 5.7.2

Grid Naming Service (GNS)

SRVCTL object name, A.9

GTX0-j

Global Transaction Process, 1.4.7

GV$, 1.10.3

GV$ view, 13.4

GV$SESSION, 3.5, 3.5

---

H

hash partitioning

with Oracle RAC, 12.2

havip

SRVCTL object name, A.9

high availability

best practices, 12.1.2

for Oracle RAC Databases, 12.1

high availability framework

introduction to, 1.5

home

SRVCTL object name, A.9

HOST command, 3.1.1.3.1

SQL*Plus, 3.1.1.3.1

---

I

idle wait class, 13.8.1

IM column store

See In-Memory Column Store

indexes

sequence-based, 12.2

initdb_name.ora file

DIAGNOSTIC_DEST initialization parameter, B.1

initialization parameters

cluster database issues regarding, 3.7

CLUSTER_INTERCONNECTS, 3.11.1, 13.3

recommendations for using, 3.11.1

identical settings for on all instances, 3.7.3

RECOVERY_PARALLELISM, 7.5.2.1

settings for instances, 3.6

specific to Oracle RAC, 3.7

that must be identical on all instances, 3.7.1

that must be unique on all instances, 3.7.2

In-Memory Column Store

overview, 1.9

INST_ID column, 13.4

installation

introduction, 1.7

installations

performing multiple simultaneous cluster, 8

instance

SRVCTL object name, A.9

instance discovery

Oracle Enterprise Manager Cloud Control, 3.13.1

Instance Enqueue Process (LCK0), 1.4.7

Instance Management page, 10.1.2.1, 11.1.1.1

INSTANCE NAME initialization parameter, 3.7

INSTANCE option, 3.1.1.3.1

INSTANCE parameter

FAN, and matching database signature, 5.4.5

instance recovery, 3.2.2

INSTANCE_NAME initialization parameter, 3.7.2

INSTANCE_NUMBER initialization parameter, 3.7.2

INSTANCE_TYPE initialization parameter, 3.7.1

instances

aggregated for service performance, 13.1.1.3

cloning Oracle RAC, 8.3

effect of SQL*Plus commands on, 3.1.1.3.1

failure, 7.3.2

initialization parameter settings, 3.6

maximum number for Oracle RAC, 1.1

memory structures, 1.4.6

parallel processes, 5.2.1.4

private interconnect usage, B.6

recovery, 3.2.2, 7.3.1

recovery, abnormal shutdown, 3.2.2

recovery, multiple failures, 7.3.2

Server Management, 3.1.1

shutting down, 3.2.2

starting and stopping, 3.2

terminating session on, 3.5

verifying, 3.4, 3.4

verifying running, 3.4.2

instances failure

recovery from, 7.3

instead of Statspack, 1.10.3

interconnect

and performance, 13.3

and the Oracle RAC architecture, 1.1

defined, 1.4.2

protocols for Oracle Real Application Clusters, 13.2

verifying settings for, 13.2

interconnect bandwidth, 13.2

latency, 13.2

interconnect block transfer rates, 13.6

interconnect settings

verifying, 13.2

interconnects

alternatives to the private network, 3.11

private, B.6

Interconnects page

monitoring clusterware with Oracle Enterprise Manager, 13.1.1

monitoring Oracle Clusterware, 13.1.1.2

interprocess communication (IPC)

buffer sizes

adjusting, 13.3

IPC protocol, 13.2, 13.9.3.1

---

J

Java Database Connectivity (JDBC) clients

Oracle Notification Service usage, 1.5

Java-based tools and utilities

CVU, B.4

DBCA, B.4

DBUA, B.4

enabling tools for tracing, B.4

GSD, B.4

NETCA, B.4

SRVCTL, B.4

JDBC

enabling Fast Application Notification events for, 5.8.2.2

JDBC/OCI, 5.8.2.2

JDBC-thin clients

enabling for Fast Connection Failover (FCF), 5.8.2

JDBC-thin driver, 5.8.2

job administration

Oracle Enterprise Manager, 3.13.3.1

---

K

keystore

data security, 12.3.8.1

KILL SESSION clause

on the ALTER SYSTEM statement, 3.5

---

L

LCK0

Instance Enqueue Process, 1.4.7

level thresholds

services, 5.12

LICENSE_MAX_USERS initialization parameter, 3.7.3

List of Cluster Databases page, 10.1.2.1, 11.1.1.1

listener

SRVCTL object name, A.9

listeners

command to add to a node, A.9.6.1

command to remove, A.9.126.1

Oracle Net, 1.3

LMD

Global Enqueue Service Daemon, 1.4.7

LMON Global Enqueue Service Monitor, 1.4.7

LMS

Global Cache Service Process, 1.4.7

LMS processes

reducing the number of, 12.1.3.2

LMSn processes

reducing the number of, 12.1.3.2

load balancing, 12.3.5

OCI runtime connection, 5.8.7

server-side, 5.3

load balancing advisory

and FAN events, 5.7.3

configuring your environment for using, 5.7.2

deployment, 5.7.1

description of, 5.7

events and FAN, 5.4.2

introduction to, 1.5

Load Balancing Advisory, 5.2.2.7

local archiving scenario

RMAN, 6.9.2

Local Area Network (LAN), 1.4.2

LOCAL clause

forcing a checkpoint, 3.1.1.3.1

local file system

archiving parameter settings, 6.9.2.2

restore, 7.2.2

local instance

shutting down, 3.2.4

starting, 3.2.4

local node name

in clone.pl script, 8.3

LOCAL_NODE parameter

in clone.pl script, 8.3

locally managed tablespaces, 12.3.1

log files

tracing, B.4

log sequence numbers, 6.8

LOG_ARCHIVE_FORMAT initialization parameter, 3.7.3

LOG_ARCHIVE_FORMAT parameter, 6.8

---

M

management database

SRVCTL object name, A.9

management listener

SRVCTL object name, A.9

mass deployment

cloning, 8, 8.2

media failures

recovery from, 7.4

Memory Guard, 3.9

memory structures

in Oracle RAC, 1.4.6

message request counters, 13.6

migration

application, 12.1.4

from single-instance, 14.2

missing files, B.2

mission critical systems

considerations for Oracle RAC, 12.1.1

modified data

instance recovery, 7.3.1

monitoring

archiver process, 6.10

overview and concepts, 1.10.3

performance of global cache block access, 13.1.1.3

monitoring host load average, 13.1.1.3

mount all non-running instances of an Oracle RAC database, 3.2.1

multiple cluster interconnects, 3.11

multiple databases in a cluster, 3.11.1

multiple instances

starting from a single SQL*Plus session, 3.2.4

starting from one node, 3.2.4

multiple node failures, 7.3.2

multiple public networks, 1.4.4

multiplexed redo log files, 2.3

multitenant container database

See CDBs

mutables

rules for grants, 5.6.1.1

---

N

net service name, 3.1.1.3

network

restricting service registration, 1.4.5, 5.2.4

SRVCTL object name, A.9

Network Attached Storage (NAS), 1.4.2

network resources, 1.4.4

node

failure and VIP addresses, 1.4.4

node affinity awareness, 7.3.4

node discovery

Oracle Enterprise Manager Cloud Control, 3.13.1

node evictions, 13.1.1.1

node VIPs, 1.4.4

nodeapps

SRVCTL object name, A.9

nodes

affinity awareness, 7.3.4

failure of, 7.3.1

virtual IP addresses, A.4, A.4

noncluster databases

quiescing, 3.10

noncluster Oracle ASM

converting to clustered Oracle ASM, 2.5.5

---

O

object creation and deletion, 12.3.2

objects

creation of and effect on performance, 12.3.2

srvctl object names and abbreviations, A.9

OC4J

SRVCTL object name, A.9

OCI

runtime connection load balancing, 5.8.7

session pooling, 5.8.7

session pools

optimizing, 5.8.7

runtime connection load balancing, 5.8.7

service metrics, 5.8.7

OCRDUMP utility, 13.3

ODP.NET

and Fast Connection Failover, 5.8.9

load balancing advisory events, 5.8.10

OLTP environments, 12.2

online database relocation

relocation feature, 4.3

online recovery, 7.3.1

online transaction processing (OLTP)

applications in Oracle RAC, 12.3.5

ons

SRVCTL object name, A.9

ONS

See Oracle Notification Service

optimal execution plans, 12.3.7.1

Oracle ACFS, 1.4.1

Oracle ASM

see Oracle Automatic Storage Management (Oracle ASM)

Oracle Automatic Storage Management (Oracle ASM)

archiving scenario, 6.9.1

converting noncluster Oracle ASM to clustered Oracle ASM, 2.5.5

installation, 1.7.3

instances

administering with SRVCTL, 2.5.6

Oracle ASM preferred read failure groups, 2.5.4

preferred mirror read disks, 2.5.4

preferred read disks, 3.7

SRVCTL object name, A.9

storage solution, 2.1

SYSASM privilege, 3.2.4

Oracle Call Interface

See OCI

Oracle Cluster Registry (OCR), 3.1.1.1, 13.3

Oracle Clusterware

cloning, 1.7.4

control policies

AUTOMATIC, 3.12

MANUAL, 3.12

using SRVCTL to display and change, 3.12

controlling database restarts, 3.12

described, 1.3, 1.3

introduction, 1.3

introduction and concepts of, 1

managing Oracle processes, 1.3

Oracle Database

session activity, 13.8.1

Oracle Database Upgrade Assistant, 14

Oracle Enterprise Manager

adding database instances to nodes

on Linux and UNIX, 10.1.2

on Windows, 11.1.1

alert administration, 3.13.3.2

alert blackouts, 3.13.3.3

Automatic Database Diagnostic Monitoring (ADDM), 13.7

Average Active Sessions chart, 13.1.1.3

Cluster Database Home page, 13.1.1.1

Cluster Database page, 13.1.1

Cluster Database Performance page

performance statistics for an Oracle RAC database, 13.1.1.3

configuring to recognize changes in database management, 3.8

Database Throughput charts, 13.1.1.3

deleting database instances from nodes, 10.2.1, 11.2.1

Global Cache Block Access Latency chart, 13.1.1.3

Interconnects page, 13.1.1.2

job administration, 3.13.3.1

monitoring load values for available nodes, 13.1.1.3

overview and concepts, 1.10.2

Top Activity drill down menu, 13.1.1.3

using the Interconnects page to monitor Oracle Clusterware, 13.1.1

using to administer Oracle RAC, 3.1.1.2

using to administer services, 5.13.2

using to back up the server parameter file, 3.6.3

using to convert single-instance databases to Oracle Real Application Clusters, 14.3.4

using to create DTP services, 5.9.4

using to monitor Oracle Clusterware, 13.1.1

using to monitor Oracle RAC, 13.1.1

using to monitor Oracle RAC environments, 1.10.3

using to restore SPFILE, 7.2.3

using to schedule Automatic Workload Repository actions, 5.12

using to set up a fast recovery area, 7.6

using to start or stop a database, 3.2

using with RMAN, 6.4

Oracle Enterprise Manager Cloud Control

instance discovery, 3.13.1

node discovery, 3.13.1

Oracle Grid Infrastructure, 1.1

Oracle home

defined, 1.7.2

Oracle Interface Configuration (OIFCFG), 13.3

Oracle Managed Files, 3.1

Oracle Maximum Availability Architecture (MAA), 12.1.1

Oracle Multitenant, 1.8

Oracle Net

listeners, 1.3

Oracle Net connection failover, 5.3.2

Oracle Net Services

and load balancing, 5.8.1

and services, 5.2.2.8

Oracle Notification Service, 1.3

SRVCTL object name, A.9

used by FAN, 1.5

Oracle Notification Services

API, 5.4.2

Oracle processes

managed by Oracle Clusterware, 1.3

Oracle RAC

adding administrator-managed database instances, 10.1.2.1, 11.1.1

adding policy-managed database instances, 10.1, 11.1

adding to nodes in a cluster on Linux and UNIX, 10.1

adding to nodes in a cluster on Windows, 11.1

and e-commerce, 12.3.5

background processes

ACMS, 1.4.7

GTX0-j, 1.4.7

LCK0, 1.4.7

LMD, 1.4.7

LMON, 1.4.7

LMS, 1.4.7

RMSn, 1.4.7

RSMN, 1.4.7

benefits of cloning, 8.1

cloning, 8

size of the binaries, 8.1

converting database from, 4.2

converting database to, 4.2

converting from non-cluster system, 14.2.1

converting single instance to Oracle RAC One Node, 4.2.1

copying the Oracle RAC home, 8.2

databases

converting from single-instance Oracle databases, 14

quiescing, 3.10

deploying clone, 8.3

diagnosing performance problems, 13.8.1

diagnosing problems for, B

overview of administration, 1

removing on Windows, 11.2.2

removing the software from Linux and UNIX, 10.2.2

security considerations, 12.3.8

shutting down instances, 3.2.2

software components, 1.4.6

storage options

IBM GPFS, 1.4.1

network file system (NFS), 1.4.1

Oracle Automatic Storage Management (Oracle ASM), 1.4.1

Oracle Automatic Storage Management Cluster File System (Oracle ACFS), 1.4.1

Oracle OCFS2, 1.4.1

volume manager, 1.4.1

using a fast recovery area in, 7.6

Oracle RAC One Node, 4

converting database from, 4.2

converting database to, 4.2

converting to Oracle RAC, 4.2.2

creating databases, 4.1

database

services on, 4.1

online database relocation, 4.3

relocating to another node, 4.3

Oracle Real Application Clusters

See Oracle RAC

Oracle Real Application Clusters One Node

See Oracle RAC One Node

Oracle Resource Manager

and services, 5.2.1.2

Oracle Services

using, 5.13

Oracle Services for Microsoft Transaction Server

creating the OraMTS service, 11.1.1.1

Oracle Streams, 5.2.1.5

Oracle Streams Advanced Queuing

and FAN, 5.4.2

Oracle Universal Installer

database installation, 1.7.2

Oracle Real Application Clusters installation, 1.7.2

Oracle XA, 5.2.2.9

ORACLE_BASE environment variable, 8.3

ORACLE_HOME environment variable, 8.3

ORACLE_HOME_NAME environment variable, 8.3

ORACLE_SID parameter, 3.7.2

oradebug ipc command, B.6

OraMTS

external transaction manager, 5.9.1

See Oracle Services for Microsoft Transaction Server

orapwd file, 3.8

outages

planned, 5.4.4

unplanned, 5.4.3

---

P

parallel execution, 12.3.7.2

parallel processes, 5.2.1.4

parallel recovery, 7.5.2.1

disabling, 7.5.2

PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 3.7.1

PARALLEL_FORCE_LOCAL initialization parameter, 5.2.1.4

PARALLEL_INSTANCE_GROUPS initialization parameter, 5.2.1.4

parallelism

in Oracle RAC, 12.3.7.2

parallel-aware query optimization, 12.3.7.1

parameter file

overview, 3.6

parameter file search order, 3.6.2

parameters

DB_RECOVERY_FILE_DEST, 7.6

that must be identical on all instances, 3.7.1

that must be unique on all instances, 3.7.2

password file-based authentication, 4.3

PDBs, 3.3

managing, 3.3

performance, 13.1.1.3

aggregates by services, 13.1.1.3

comprehensive global data, 13.7

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

monitoring database throughput, 13.1.1.3

monitoring global cache block access, 13.1.1.3

monitoring potential problems in the database, 13.1.1.3

primary components affecting, 13.2

service aggregates by instances, 13.1.1.3

service aggregates by waits, 13.1.1.3

using ADDM, 1.10.3

performance evaluation

overview and concepts, 1.10.4

performance statistics, 13.9.5

PFILE

using with Oracle RAC, 3.6

phases

cloning deployment, 8.3

cloning preparation, 8.2

pluggable database

See PDBs

PMON background process, 3.5

policy set, 1.6.4

policy-managed clusters, 1.6.4

policy-managed database, 1.6, 3.1

policy-managed database instances

adding, 11.1

policy-managed databases, 3.1, 3.7.2, 5.2.2.6

deleting on Linux and UNIX, 10.2.1

deleting on Windows, 11.2.1

deploying, 1.6.2

managing, 1.6.3

PREFERRED instances

for services, 5.2.2.5

preferred read disks

Oracle ASM in an Oracle RAC extended distance cluster, 2.5.4

private clouds, 12.1.3.3

private interconnect, B.6

determining usage, B.6

private network

alternative interconnect, 3.11

private network IP address, 13.3

processes

managed by Oracle Clusterware, 1.3

parallel, 5.2.1.4

public and private interfaces

shown in Oracle Enterprise Manager, 13.1.1.2

public network

defined, 1.4.2

---

Q

query optimizer, 12.3.7.1

default cost model for, 12.3.7.1

queue tables, 5.2.1.5

quiesce database

in Oracle Real Application Clusters, 3.10

quiesced databases, 3.10

quiescing

noncluster database, 3.10

---

R

rconfig, 14.3

rebalancing

workloads, 5.10

RECOVER command, 3.1.1.3.1

SQL*Plus, 3.1.1.3.1

recoverable error, 5.5.1

recovery

after SHUTDOWN ABORT, 3.2.2

from multiple node failure, 7.3.2

from single-node failure, 7.3.1

instance, 3.2.2

media failures, 7.4

online, 7.3.1

parallel, 7.5.2.1

RECOVERY_PARALLELISM parameter, 7.5.2.1

redo log files

instance recovery, 7.3.1

log sequence number, 6.8

using, 2.3

redo log groups, 2.3

redo logs

format and destination specifications, 6.8

redo thread, 3.1

reducing contention, 12.2

regions, 12.1.3.3

remote Oracle Notification Service subscription, 5.8.2.1

Remote Slave Monitor (RSMN), 1.4.7

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 3.7.1

replicated databases

and global services, 5.14

resource contention, 13.1.1.3

resource manager, 5.10

resource profiles

and service creation, 5.2.1.1

resources

releasing, 7.3.1

resources held by the session, 3.5

restore scenarios

RMAN, 7.2

restore scheme

cluster file system, 7.2.1

local file system, 7.2.2

result cache, 3.7

disabling, 3.7

enabling, 3.7

RESULT_CACHE_MAX_SIZE initialization parameter, 3.7, 3.7.1

RMAN

CONFIGURE command, 6.3

configuring channels, 6.5

configuring channels to use automatic load balancing, 6.6

configuring one channel for each instance, 6.6.2

configuring snapshot control file locations, 6.3

crosschecking on multiple nodes, 6.5

local archiving scenario, 6.9.2

restore scenarios, 7.2

using to create SPFILE backups, 3.6.3

RMSn

Oracle RAC management processes, 1.4.7

rolling back

instance recovery, 7.3.1

root.sh script

$ORACLE_HOME, 8.3

RSMN

Remote Slave Monitor, 1.4.7

runtime connection load balancing

defined, 5.8.7

in OCI session pools, 5.8.7

introduction to, 1.5

Runtime Connection Load Balancing, 5.2.2.7

---

S

scalability, 12.3.5

Oracle RAC, 12.1.4

scan

SRVCTL object name, A.9

SCAN, 1.3

SCAN listener

and restricting service registration, 1.4.5, 5.2.4

scan_listener

SRVCTL object name, A.9

scripts

$ORACLE_HOME/root.sh, 8.3

security

keystore, 12.3.8.1

sequence-based indexes, 12.2

sequences

log sequence number, 6.8

server

SRVCTL object name, A.9

Server Control Utility

see SRVCTL

Server Management

administration of instances, 3.1.1

server parameter file

backing up, 3.6.3

server parameter files

creating, 3.6

server pool, 3.1

SRVCTL object name, A.9

server pools, 1.6.1

creating for a policy-managed database, 3.8

Generic, 3.1

XML conversion files for, 14.5

servers

relocating from another server pool, 3.8

scalability, 12.1.4

service

SRVCTL object name, A.9

service level objective

defining for Oracle RAC, 12.1.1

service levels, 12.3.6

service metrics

OCI runtime connection load balancing, 5.8.7

runtime connection load balancing, 5.8.7

SERVICE parameter

FAN, and matching database signature, 5.4.5

SERVICE TIME

load balancing advisory goal, 5.7.2

SERVICE_NAMES initialization parameter, 3.7

setting for services, 3.7, 5.13.1

service-level agreements, 3.5

services, 3.7

activity levels aggregated by instances, 13.1.1.3

activity levels aggregated by services, 13.1.1.3

activity levels aggregated by waits, 13.1.1.3

administering, 5.13.1

administering with Oracle Enterprise Manager, 5.13

administering with SRVCTL, 5.13, 5.13.3

attributes

edition, 5.2.2.2

basic concepts about, 5.1

configuring automatic workload management characteristics, 5.2.2

default, 5.2.3

dependencies, 5.2.1.1

enabling event notification, 5.8.7

global, 5.14

introduction to, 1.5

level thresholds, 5.12

management policy

automatic, 5.2.2.3

manual, 5.2.2.3

performance monitored by AWR, 5.2.1.3

restricting registration with listeners, 1.4.5, 5.2.4

SERVICE_NAMES parameter, 3.7, 5.13.1

specifying a service, 5.13.1

using, 5.1

services for administrator-managed databases, 3.8

sessions

terminating on a specific instance, 3.5

setting instances, 1.10.2, 3.1.1.3

shared everything, 1.4.1

shared server configuration, 3.7

SHOW INSTANCE command, 3.1.1.3.1

SQL*Plus, 3.1.1.3.1

SHOW PARAMETER command

SQL*Plus, 3.1.1.3.1

SHOW PARAMETERS command, 3.1.1.3.1

SHOW SGA command, 3.1.1.3.1

SQL*Plus, 3.1.1.3.1

SHUTDOWN ABORT, 3.2.2, B.5

SHUTDOWN command

ABORT option, 3.2.2

SQL*Plus, 3.1.1.3.1

SHUTDOWN IMMEDIATE, B.5

SHUTDOWN TRANSACTIONAL, 3.2.2

shutting down

instances, 3.2.2

shutting down an instance

abnormal shutdown, 3.2.2

shutting down instances, 3.2.2

sidalrt.log file, B.3

single client access name

See SCAN

Single Client Access Name (SCAN)

SRVCTL object name, A.9

single system image, 1.4.6

single-instance database

convert to Oracle RAC database

administrative considerations, 14.1

single-instance databases

converting, 14.3.4

converting to Oracle RAC database, 14

SMON process

instance recovery, 7.3.1, 7.3.2

recovery after SHUTDOWN ABORT, 3.2.2

snapshot control file, 6.3

configuring locations, 6.3

speed-up for data warehouse systems, 12.3.7.1

SPFILE

backing up, 3.6.3

backups

creating, 3.6.3

changing parameter settings, 3.6

corrupted, 3.6.1

default names, 3.6.2

location, 3.6

naming convention for, 3.6.2

recovering, 3.6.3

restore with Oracle Enterprise Manager, 7.2.3

restore with RMAN, 7.2.3

setting values in, 3.6.1

SPFILE initialization parameter, 3.7, 3.7.3

SQL statements

executing in parallel, 5.2.1.4

instance-specific, 3.1.1.3.1

SQL*Plus, 3.1.1.3, 3.1.1.3

commands

CONNECT, 3.1.1.3

effect on instances, 3.1.1.3.1

SRVCTL

add, usage description, A.9.1

administering Oracle ASM instances, 2.5.6

administering services with, 5.13.3

cluster database configuration tasks, A.4

cluster database tasks, A.4

command feedback, A.1

command syntax, A.9

commands

add cvu, A.9.2.1, A.9.119.1

add database, A.9.3.1

add havip, A.9.4.1

add instance, A.9.5.1

add listener, A.9.6.1

add mgmtlsnr, A.9.7.1

add network, A.9.8.1

add nodeapps, A.9.9.1

add ons, A.9.11.1

add scan, A.9.12.1

add scan_listener, A.9.13.1

add service, A.9.14.1

add srvpool, A.9.15.1

add vip, A.9.16.1

config cvu, A.9.18.1

config database, A.9.19.1

config havip, A.9.20.1

config listener, A.9.21.1

config network, A.9.22.1

config nodeapps, A.9.23.1

config oc4j, A.9.24

config ons, A.9.25

config scan, A.9.26.1

config scan_listener, A.9.27.1

config service, A.9.28.1

config srvpool, A.9.29.1

config vip, A.9.30.1

config volume, A.9.31.1

convert database, A.9.32.1

disable cvu, A.9.34.1

disable database, A.9.35.1

disable diskgroup, A.9.36.1

disable filesystem, A.9.37.1

disable gns, A.9.38.1

disable havip, A.9.39.1

disable instance, A.9.40.1

disable listener, A.9.41.1

disable mgmtdb, A.9.42.1

disable mgmtlsnr, A.9.43.1

disable nodeapps, A.9.44.1

disable oc4j, A.9.45.1

disable ons, A.9.46

disable scan, A.9.47.1

disable scan_listener, A.9.48.1

disable service, A.9.49.1

disable vip, A.9.50.1

disable volume, A.9.51.1

downgrade database, A.9.52

enable asm, A.9.54.1

enable cvu, A.9.55.1

enable database, A.9.56.1

enable diskgroup, A.9.57.1

enable filesystem, A.9.58.1

enable gns, A.9.59.1

enable havip, A.9.60.1

enable instance, A.9.61.1

enable listener, A.9.62.1

enable mgmtdb, A.9.63.1

enable mgmtlsnr, A.9.64.1

enable nodeapps, A.9.65.1

enable oc4j, A.9.66.1

enable ons, A.9.67.1

enable scan, A.9.68.1

enable scan_listener, A.9.69.1

enable service, A.9.70.1

enable vip, A.9.71.1

enable volume, A.9.72.1

-eval parameter, A.1

export gns, A.9.73.1

getenv asm, A.9.75.1

getenv database, A.9.76.1

getenv listener, A.9.77.1

getenv mgmtdb, A.9.78.1

getenv mgmtlsnr, A.9.79.1

getenv nodeapps, A.9.80.1, A.9.81.1

help, A.5

import gns, A.9.82.1

modify asm, A.9.84.1

modify cvu, A.9.85.1

modify database, A.9.86.1

modify filesystem, A.9.87.1

modify gns, A.9.88.1

modify havip, A.9.89.1

modify instance, A.9.90.1

modify listener, A.9.91.1

modify mgmtdb, A.9.92.1

modify mgmtlsnr, A.9.93.1

modify network, A.9.94.1

modify nodeapps, A.9.95.1

modify oc4j, A.9.96.1

modify ons, A.9.97.1

modify scan, A.9.98.1

modify scan_listener, A.9.99.1

modify service, A.9.100

modify srvpool, A.9.101.1

modify vip, A.9.102.1

predict asm, A.9.103.1.1

predict database, A.9.103.2

predict diskgroup, A.9.103.3.1

predict filesystem, A.9.103.4.1

predict listener, A.9.103.5.1

predict network, A.9.103.6.1

predict oc4j, A.9.103.7.1

predict scan, A.9.103.8.1

predict scan_listener, A.9.103.9.1

predict service, A.9.103.10.1

predict vip, A.9.103.11.1

relocate asm, A.9.105.1

relocate cvu, A.9.106.1

relocate database, A.9.107.1

relocate gns, A.9.108.1

relocate havip, A.9.109.1

relocate mgmtdb, A.9.110.1

relocate oc4j, A.9.111.1

relocate scan, A.9.112.1

relocate scan_listener, A.9.113.1

relocate server, A.9.114.1

relocate service, A.9.115.1

relocate vip, A.9.116.1

remove asm, A.9.118.1

remove database, A.9.120.1

remove diskgroup, A.9.121.1

remove filesystem, A.9.122.1

remove gns, A.9.123.1

remove havip, A.9.124.1

remove instance, A.9.125.1

remove listener, A.9.126.1

remove mgmtdb, A.9.127.1

remove mgmtlsnr, A.9.128.1

remove network, A.9.129.1

remove nodeapps, A.9.130.1

remove oc4j, A.9.131.1

remove ons, A.9.132.1

remove scan, A.9.133.1

remove scan_listener, A.9.134.1

remove service, A.9.135.1

remove srvpool, A.9.136.1

remove vip, A.9.137.1

remove volume, A.9.138.1

setenv asm, A.9.140.1

setenv database, A.9.141.1, A.9.146.1

setenv listener, A.9.142.1

setenv mgmtdb, A.9.143.1

setenv mgmtlsnr, A.9.144.1

setenv nodeapps, A.9.145.1

srvctl setenv, 3.1.1.1

start asm, A.9.148.1

start cvu, A.9.149.1

start database, 3.2.1, A.9.150.1

start diskgroup, A.9.151.1

start filesystem, A.9.152.1

start gns, A.9.153.1

start havip, A.9.154.1

start instance, 3.2.1, A.9.156.1

start listener, A.9.157.1

start mgmtdb, A.9.158.1, A.9.159.1

start nodeapps, A.9.160.1

start oc4j, A.9.161.1

start ons, A.9.162.1

start scan, A.9.163.1

start scan_listener, A.9.164.1

start service, A.9.165.1

start vip, A.9.166.1

start volume, A.9.167.1

status asm, A.9.169.1

status cvu, A.9.170.1

status database, A.9.171.1

status diskgroup, A.9.172.1

status filesystem, A.9.173.1

status gns, A.9.174.1

status havip, A.9.175.1

status home, A.9.176.1

status instance, A.9.177.1

status listener, A.9.178.1

status mgmtdb, A.9.179.1

status mgmtlsnr, A.9.180.1

status nodeapps, A.9.181.1

status oc4j, A.9.182.1

status ons, A.9.183.1

status scan, A.9.184.1

status scan_listener, A.9.185.1

status server, A.9.186.1

status service, A.9.187.1

status srvpool, A.9.188.1

status vip, A.9.189.1

status volume, A.9.190.1

stop asm, A.9.192.1

stop cvu, A.9.193.1

stop database, 3.2.1, A.9.194.1, A.9.202.1

stop diskgroup, A.9.195.1

stop filesystem, A.9.196.1

stop gns, A.9.197.1

stop havip, A.9.198.1

stop home, A.9.199.1

stop instance, 3.2.1, A.9.200.1

stop listener, A.9.201.1

stop mgmtlsnr, A.9.203.1

stop nodeapps, A.9.204.1

stop oc4j, A.9.205.1

stop ons, A.9.206.1

stop scan, A.9.207.1

stop scan_listener, A.9.208.1

stop service, A.9.209.1

stop vip, A.9.210.1

stop volume, A.9.211.1

unsetenv asm, A.9.213.1

unsetenv database, A.9.214.1, A.9.219.1

unsetenv listener, A.9.215.1

unsetenv mgmtdb, A.9.216.1

unsetenv mgmtlsnr, A.9.217.1

unsetenv nodeapps, A.9.218.1

update database, A.9.221

update gns, A.9.222

update listener, A.9.223

update scan_listener, A.9.224

upgrade database, A.9.225

concurrent commands, A.1

config, usage description, A.9.17

deprecated commands and options, A.8

difference between SRVCTL and CRSCTL, A.7

disable, usage description, A.9.33

enable, usage description, A.9.53

enabling event notification, 5.8.7

getenv, usage description, A.9.74

modify, usage description, A.9.83

node-level tasks, A.4

object name

database, A.9

diskgroup, A.9

filesystem, A.9

Grid Naming Service (GNS), A.9

havip, A.9

home, A.9

instance, A.9

listener, A.9

mgmtdb, A.9

mgmtlsnr, A.9

network, A.9

node applications (nodeapps), A.9

oc4j, A.9

Oracle Automatic Storage Management (Oracle ASM), A.9

Oracle Notification Service, A.9

scan, A.9

scan_listener, A.9

server, A.9

server pool (srvpool), A.9

service, A.9

vip, A.9

volume, A.9

object names, A.9

overview, 3.1.1.1

overview and concepts, 1.10.2

predict, usage description, A.9.103

relocate, usage description, A.9.104

remove, usage description, A.9.117

setenv, usage description, A.9.139

specifying a continuation of command line entries, A.1

specifying command parameters in a file, A.2.1

start, usage description, A.9.147

status, usage description, A.9.168

stop or start cluster database, 3.2.1

stop, usage description, A.9.191

stopping active commands, A.7

unsetenv, usage description, A.9.212

using comma-delimited lists, A.1

SRVM_TRACE environment variable, B.4

Standard Edition

installing Oracle ASM, 1.7.3

starting administrator-managed databases, 3.2.1

starting policy-managed databases, 3.2.1

STARTUP command

SQL*Plus, 3.1.1.3.1

statistics

contents of, 13.6

Statspack, 13.9, 13.9.1

usage, 1.10.3

stop database instances, 3.2.1

storage

cluster file system, 2.1

Oracle Automatic Storage Management (Oracle ASM), 2.5.1

subnet

configuring for virtual IP address, A.4, A.4

subnets, 1.4.4

SYS$BACKGROUND service, 5.2.3

SYS$USERS service, 5.2.3

SYSASM privilege, 3.1.1.3, 3.2.4

SYSAUX tablespace

increasing size when adding nodes, 12.3.3

reducing size when removing nodes, 12.3.3

SYSDBA, 3.1.1.3

privilege for connecting, 3.1.1.3

SYSDBA connections to an Oracle ASM instance, 3.1.1.3

SYSOPER, 3.1.1.3

SYSOPER privilege

for connecting, 3.1.1.3

system change, 6.8

System Global Area (SGA), 1.4.6, 13.8.1

size requirements, 1.4.6

---

T

tablespaces

automatic segment space management (ASSM) in Oracle RAC, 12.3.1

automatic undo management in Oracle RAC, 12.3.1

locally managed, 12.3.1

use in Oracle RAC, 12.3.1

TCP network ports

Windows Firewall considerations, 12.3.8.2

TCP/IP, 1.4.3

terminating a session on a specific instance, 3.5

THREAD initialization parameter, 3.7

threads

multiple application, 5.8.7

THROUGHPUT

load balancing advisory goal, 5.7.2

timed statistics, 13.6

tnsnames.ora file, 3.7

Top Activity drill down menu

on the Cluster Database Performance page, 13.1.1.3

Top Cluster Events, 13.8.2

Top Cluster Events, ASH report, 13.8.2

Top Remote Instance, 13.8.3

Top Remote Instance, ASH report, 13.8.3

trace files, B.1

managing, B.1

sidalrt.log, B.3

trace files for background processes, B.1

TRACE_ENABLED initialization parameter, 3.7.3

tracing

enabling Java-based tools and utilities, B.4

SRVM_TRACE environment variable, B.4

writing to log files, B.4

transaction failover, 5.5.1

Transaction Guard, 5.5.1

configuring JDBC-thin clients, 5.8.4, 5.8.5

configuring OCI clients, 5.8.8

configuring service attributes, 5.13.3.2

configuring services for, 5.5.3

introduction to, 1.5

transactional TAF, 5.8.8

transactions

distributed SQL, 5.9.1

DTP/XA, 5.9.1

instance failure, 7.3.1

rolling back, 3.5, 7.3.1

waiting for recovery, 7.3.1

Transparent Application Failover

and services, 5.6.3

Transparent Data Encryption

specifying the ENCRYPTION_WALLET_LOCATION parameter, 12.3.8.1

with encrypted keystores and obfuscated keystores, 12.3.8.1

tuning

overview, 1.10.4

using ADDM, 1.10.3

---

U

undo tablespace, 3.1

UNDO_MANAGEMENT initialization parameter, 3.7.1

UNDO_RETENTION initialization parameter, 3.7.3

UNDO_TABLESPACE parameter, 3.7.2

User Datagram Protocol (UDP), B.6

user process trace files, B.1

---

V

V$, 1.10.3

V$ view, 13.4

V$ACTIVE_INSTANCES, 3.4.2, 3.4.2

V$CLUSTER_INTERCONNECTS, 13.2, B.6

V$CONFIGURED_INTERCONNECTS, 13.2

valid node checking, 1.4.5, 5.2.4

vendor clusterware, 1.1

verification

data files, online files, 2.2

verifying interconnect settings, 13.2

versions

compatibility for Oracle RAC and Oracle Database software, 1.7.1

views

creating for Oracle Real Application Clusters, 13.5

dynamic performance

for performance monitoring, 13.4

GV$, 13.4

for performance monitoring, 13.4

GV$SESSION, 3.5, 3.5

instance-specific, 13.4

V$ views, 13.4

VIP

SRVCTL object name, A.9

VIPs

node, 1.4.4

Virtual Internet Protocol (VIP) address, 1.1

virtual IP address

requirements, A.4, A.4

VNCR

See valid node checking, 1.4.5, 5.2.4

volume

SRVCTL object name, A.9

---

W

wait events, 13.9, 13.9.1

aggregated for service performance, 13.1.1.3

block-related, 13.9.5.1

contention-related, 13.9.5.3

load-related, 13.9.5.4

message-related, 13.9.5.2

Welcome page, 10.1.2.1

Windows Firewall, 12.3.8.2

workload management

See automatic workload management

workloads

and services, 5.1

See Also automatic workload management

---

X

XA affinity, 5.9.2

XA transactions, 5.9.1

spanning Oracle RAC instances, 5.9.1

XA Transactions, 12.3.4