Index

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

---

A

access to resources, 2.2.1

accounts

adding to database password file, 7.5.1

privileges and permissions, 4.3

to manage a single-instance Oracle Database, 7.5

active/active configurations, 3.1.2

active/passive configurations, 3.1.1

Add Resource to Group Wizard

Oracle single-instance databases, 7.3.3

adding a single-instance Oracle Database to a group, 7.3

authentication information, 7.3.3.5

network names, 7.3.3.3

Oracle Net listener, 7.4.1

possible owner nodes, 7.3.3.2

prerequisites, 7.3.1

steps, 7.3.2

tnsnames.ora file, 7.3.2

Administrator privileges

logging in to a cluster, 4.3.2

alert files, A.5

allocating IP addresses for a cluster, 2.4

application log

troubleshooting startup problems, 6.3

application software

rolling upgrade of, 1.2.2

applications

automatic reconnection after failover, 1.2.4

failover, 1.2.4, 2.7.2

mission-critical, 3.1.2

archived files, 7.10.7.3

authentication

checking preferences in Oracle Enterprise Manager, 7.10.8

log on as batch user access rights, 7.10.8

permissions and privileges required, 4.3

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 7.5

SYSDBA role, 7.5.1

SYSOPER privileges, 7.5.1

troubleshooting DBA authentication, 7.10.6

using SYS for databases, 7.5.1

availability

RAID technology, 2.1.1

---

B

bandwidth

increasing with multiple network names, 2.3

benefits

of Oracle Fail Safe, 1.2

---

C

checkpoints

prior to database failover, 2.6.2

client connections

to single-instance Oracle Databases, 7.4.1

clients

access to resources, 2.3

accessing groups with multiple network names, 4.7

cluster connections, 2.7.2

connecting to resources using multiple virtual addresses, 4.7

reconnecting to a single-instance database after failover, 7.9

cluster alias

definition, 2.5

Oracle Fail Safe Manager and, 2.5

use of, 2.5

cluster disks

Oracle single-instance databases and, 7.3.1

RAID hardware and, 1.3

redundancy and, 2.1.1

See also disks

Cluster Group, 2.5

cluster alias network name, 2.5

resources in, 2.5

cluster nodes, 2.1

adding to an existing cluster, 4.8

defined, 1.1

shared servers configuration and, 7.4.4

cluster registry

run Validate group to correct, 7.7

cluster resources

defined, 2.2.1

clusters, 1.1

adding a new node to, 4.8

cluster alias, 2.5

configuration, 2.1

connecting to, 2.5

definition, 2

different configurations, 2.1.2

disk configurations, 2.1.3

disks

See cluster disks

introduction, 2.1

members of, 2.1

nodes, 1.2.1, 2.1

synchronizing password files on, 7.5.1

typical configuration, 1.3

verifying the configuration, 6.1.1

clusterwide operations

Verify Group operation, 6.1.2

communications

lost when a system fails, 7.10.9

managing with Oracle Intelligent Agent, 2.2.2

configurations, 3.1

active/active, 3.1.2

active/passive, 3.1.1

customizing, 3.1, 3.1

disk-level, 2.1.3

multiple virtual addresses in, 4.7

shared-nothing, 2.1.3

system-level, 2.1.2

typical, 1.3

using wizard input, 4.2, 4.2

verifying, 6.1.2, 6.1.3

connect to cluster

domain user account, 4.3.2

corruption

tnsnames.ora and listener.ora files, 7.10.7.1

custom resource types, 2.2.4

customer support

calling, A.1

customizing configurations, 3.1

---

D

data files

adding new, 7.7

database account

SYS, 7.5, 7.10.8

database administrator

changing the password, 7.10.6

connecting as internal, 7.10.6

DBA_AUTHORIZATION parameter, 7.5

database password file

adding accounts to for a database, 7.5.1

database recovery

optimization for single-instance databases, 7.6

databases

adding a new data file, 7.7

backup operations on, 7.7

changing DBA passwords, 7.10.6

checkpointing and, 2.6.2

clients lose single-instance database connection, 7.10.9

configuration data, 7.3.3

configuring database resource to use shared servers, 7.4.4

configuring using wizard input, 4.2

EXCLUSIVE access, 7.5

group resource, 2.2.2

identity, 7.3.3.4

Is Alive polling, 7.10.6

LOCAL_LISTENER parameter in the initialization file, 7.4.4.1

network names, 7.3.3.3

Oracle8i or later using shared servers, 7.4.4.1

resolving an unstable state, 7.10.4

security, 7.5

SHARED access, 7.5

shared servers and Windows Failover Cluster nodes, 7.4.4

steps for configuring, 7.3.2, 7.3.2

synchronizing password files, 7.5.1

taking offline, 7.7

due to change in password, 7.10.6

for cold backup operation, 7.7

Pending Timeout, 7.10.4

problems, 7.10.6

testing shutdown on the secondary node, 4.2

upgrading with Oracle Database Upgrade Assistant, 7.5.3

using shared servers, 7.4.4

using SQL*Plus for cold backup operations, 7.7

verifying, 6.1.2, 6.1.3

See also resources

DBA_AUTHORIZATION parameter, 7.5

dependencies

among resources, 2.2.3, 2.2.3

DISABLEISALIVE parameter, 7.10.5

discovering

resources, 4.4

standalone single-instance databases, 7.1

disk devices

detecting changes with Verify Group, 7.10.2

resources in a group, 2.2.2

verification after adding more, 7.10.2

disks

configuration, 2.1.3

resource type, 2.2.4

See also cluster disks

DISPATCHERS parameter

specifying full listener information in, 7.4.4.1

specifying information in, 7.4.4.1

domain account

for Oracle Fail Safe, 4.3

for Oracle Fail Safe Manager, 4.3

dynamic-link libraries (DLLs)

custom, 2.2.4

FsResOdbs.dll, 2.2.4

generic services, 2.2.4, 2.2.4

IP addresses, 2.2.4

managing resources, 2.2.4

physical disks, 2.2.4

---

E

ENABLEISALIVE parameter, 7.10.5

error handling

scripts and, 7.10.1

errors

FS-10066, 7.10.7.1

FS-10070, 7.10.7.1

FS-10101, 7.10.8

ORA-01031, 7.10.8

reporting, A.1

returned for insufficient privileges, 7.10.8

tracking information in a trace file, A.4

user authentication, 7.10.8

written to the Oracle Net listener log, 7.10.4

---

F

failback

effect of preferred owner nodes list on, 2.7.1, 2.7.1

move group operation effect on, 2.7.1

failback policy

dumping information about, 6.2

specifying, 2.7

verifying with Validate group action, 6.1.2

verifying with Verify Group operation, 7.10.2

failover period, 2.6.8

failover policy

for groups, 2.6.8

failover threshold, 2.6.8

failovers, 2.6

applications, 1.2.4

automatic application reconnection, 1.2.4

checking with the Verify command, 4.2

client applications and, 2.7.2

database checkpointing and, 2.6.2

definition, 2.1

disabling during backup operations, 7.7

due to resource failure, 2.6.1.1

dumping information about policies, 6.2

effect of possible owner nodes list on, 2.6.11

effect of preferred owner nodes list on, 2.6.11

effect of resource restart policy on, 2.6.9

fastest, 3.1.1

for load-balancing, 2.6

groups and, 2.2.2

in an active/active configuration, 3.1.2

limiting repeated, 2.6.8

node failures and, 2.6.1.2

node to which group moves during, 2.6.11

planned, 2.6, 2.6.2

replaying transactions and, 1.2.4

troubleshooting, 7.10.5

unit of, 2.2.2

unplanned, 2.6

verifying with Validate group action, 6.1.2

verifying with Verify Group operation, 7.10.2

failures

unplanned, 2.6.1

verifying resources to prevent, 6.1.2, 6.1.3

Fibre Channel

shared storage interconnect, 1.3

file corruption

in tnsnames.ora and listener.ora files, 7.10.7.1

files

alert, A.5

archived, 7.10.7.3

trace, A.5

flags

tracing Oracle Fail Safe errors, A.4

FSCMD command, 1.2.2

DISABLEISALIVE parameter, 7.10.5

ENABLEISALIVE parameter, 7.10.5

FsDbError.bat script, 7.10.1

FSR_TRACE_OUTPUT value, A.4

FsResOdbs.dll file

functions, 2.2.4

FSS_TRACE_OUTPUT value, A.4

---

G

generic services

defined, 2.2.4

for Windows services, 2.2.4

resource type, 2.2.4

GR_VERIFY string, A.4

groups

added bandwidth for, 2.3

adding a single-instance database to, 7.3.2

adding network names to, 2.3

correcting the network name, 7.10.7.1

DBA password mismatches, 7.10.6

definition of, 2.2.2

dumping information about, 6.2

examples of resources, 2.2.2

failover, 2.2.2

failover period, 2.6.8

failover policy, 2.6.8

failover threshold, 2.6.8

multiple virtual addresses in, 4.7

network names and, 7.3.3

Oracle homes, 4.6

ownership of, 2.2.2

populating, 4.2

preferred owner nodes list, 2.6.10

privileges for adding a single-instance database, 7.10.8

resource dependencies, 2.2.3

verifying resources in, 6.1.2

with multiple virtual addresses, 4.7

---

H

hardware

configuration, 1.3

RAID, 1.3

heartbeat connection, 2.1

definition of, 1.3

---

I

initialization parameter file

deleting the LOCAL_LISTENER parameter, 7.4.4.1

exporting SPFILE and, 7.3.3.4

location of, 7.3.3.4

PFILE and, 7.3.3.4

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 7.5, 7.10.6

restrictions on specifying SPFILE and, 7.3.3.4

installation

interactive, 1.2.2

of Oracle Fail Safe, 1.2.2

silent mode, 1.2.2

using a response file with, 1.2.2

insufficient privileges, 7.10.8, 7.10.8

interconnects

private internode connection, 2.1

shared storage, 2.1

intracluster communications, 1.3

IP addresses

allocating for a cluster, 2.4

determining number needed, 2.4

resource type, 2.2.4

Is Alive polling

disabling, 7.10.5

DLL file function, 2.2.4

effect during backup operations, 7.7

enabling, 7.10.5

---

J

jobs

troubleshooting access problems, 7.10.8

---

L

Listener Control Utility (LSNRCTL)

creating listeners, 7.10.7.2

listener.ora files, 4.2

archived, 7.10.7.3

checking configuration data, 7.10.4

example, 7.10.7.1

modifying, 7.10.7.1

problems configuring the virtual server, 7.10.7.1

sample definition, 7.10.7.1

listeners

changes for shared servers, 7.2.2

configuring, 4.2

configuring Oracle Net on nodes with multiple listeners, 7.2.4

created for single-instance databases added to a group, 7.4.1

creating new, 7.10.7.2

creating with Listener Control Utility (LSNRCTL), 7.10.7.2

log file, 7.10.4

network resources, 2.2.2

output files, 7.10.7.2

problems after changing or creating definition of, 7.10.7.1

problems creating, 7.10.7.2

specifying in the LOCAL_LISTENER parameter, 7.4.4.1

specifying information in the DISPATCHERS parameter, 7.4.4.1

troubleshooting, 7.10.4

load balancing, 2.6

in an active/active configuration, 3.1.2

static, 2.6.2

local area network, 1.3

LOCAL_LISTENER parameter

adding to single-instance database parameter file, 7.2.2

deletion after removing a single-instance database from a group, 7.4.4.1

specifying listeners in, 7.4.4.1

updating information for the group, 7.4.4.1

writing to the single-instance database parameter file, 7.4.4.1

LSNRCTL utility

troubleshooting listener problems, 7.10.7.2

---

M

management operations

single-instance database, 7.7

managing

cluster security, 4.3

tnsnames.ora file on client systems, 7.3.2

using a cluster alias, 2.5

Microsoft Windows Failover Cluster Manager

use during tracing, A.4

Microsoft Windows Failover Clusters

resource types, 2.2.4

mission-critical applications

in active/active configurations, 3.1.2

move group operation

effect on failback, 2.7.1

multiple Oracle homes, 4.6

configuring multiple listeners, 7.2.4

single-instance database SID in listener.ora files, 7.10.7.1

---

N

net service name

definition

referencing in archived configuration files, 7.10.7.3

entry after adding a single-instance database to a group, 7.4.2.1

when configuring the virtual server, 7.10.7.1

network name, 1.2.1

cluster alias, 2.5

correcting for group, 7.10.7.1

network names

groups and, 7.3.3

identifying, 2.3

networks

configuration

for highly available single-instance databases, 7.4.1

Oracle Net on nodes with multiple listeners, 7.2.4

verify with Verify Group, 7.10.2

dumping public and private information, 6.2

problems while configuring virtual server, 7.10.7.1

protocol information in tnsnames.ora file, 4.2

tracing configuration information, A.4

node

to which a group fails over, 2.6.11

node failures

effects of, 2.7.2

failover and, 2.6.1.2

nodes

adding to an existing cluster, 4.8

cluster, 1.2.1

definition of, 2.1

possible owner, 2.6.7

preferred, 2.7

preferred ownership of groups and, 2.6.10

---

O

operating system authentication, 7.3.3.5

ORA_DBA

Windows operating system group, 7.3.3.5

ORA_sid_DBA

Windows operating system group, 7.3.3.5

Oracle Database Upgrade Assistant

upgrading single-instance databases, 7.5.3

Oracle Enterprise Manager

authentication problems, 7.10.8

setting User Credentials, 7.10.8

troubleshooting authentication problems, 7.10.8

troubleshooting client connection problems, 7.10.8

use in an active/active configuration, 3.1.2

Oracle Fail Safe

installation of, 1.2.2

SID list entries, 7.2.3

Oracle Fail Safe Manager, 1.1

cluster alias and, 2.5

compatibility with prior releases of Oracle Fail Safe Server, 4.6

introduction to, 1.2.2

tree view, 1.2.2

verify tools, 1.2.2

wizards, 1.2.2

Oracle Fail Safe Server

described, 1.1

Oracle Fail Safe Manager releases and, 4.6

See also Oracle Fail Safe

Oracle homes

groups and, 4.6

multiple, 4.6

name of, 6.1.1

Oracle Intelligent Agent

managing communications, 2.2.2

Oracle Net Assistant

using to re-create network files, 7.10.7.1

Oracle Net listener

behavior, 7.2.1

configuration of, 7.4

creation of, 7.4

Oracle Net network

archived configuration files, 7.10.7.3

resource in a group, 2.2.2

single-instance database configuration, 7.4.2

tracing configuration information, A.4

verifying the configuration, 7.10.4

Oracle Support

calling, A.1

Oracle7 databases

See databases

Oracle8i databases

See databases

output files

listener, 7.10.7.2

owner nodes

See possible owner nodes list

ownership

of group, 2.2.2

---

P

parameter file

See initialization parameter file

parameters

SERVER=DEDICATED in tnsnames.ora file, 7.4.4

password files

synchronizing, 7.5.1

passwords

changes cause group problems, 7.10.4

changing for the DBA account, 7.10.6

problems with REMOTE_LOGIN_PASSWORDFILE parameter, 7.10.6

Pending Timeout value

setting, 7.10.4

troubleshooting, 7.10.4

performance

in an active/active configuration, 3.1.2

permissions

insufficient return error ORA-01031, 7.10.8

PFILE

See initialization parameter file

planned failover

static load balancing, 2.6.2

planned group failover, 2.6.2

planned maintenance, 2.6.2

policies

dumping failover and failback information, 6.2

polling

failures, 7.10.4, 7.10.6

possible owner nodes list

effect on failover, 2.6.11

effect on resources, 2.6.7

for a single-instance Oracle Database, 7.3.3.2

in determining failover node, 2.6.11

resources and, 2.6.7

Validate group and, 2.6.7

Verify Group command and, 4.8

PowerShell cmdlets

use in an active/active configuration, 3.1.2

preferences

setting to avoid access problems, 7.10.8

preferred owner nodes list

effect on failback, 2.7.1, 2.7.1

effect on failover, 2.6.10, 2.6.11

move group operation and, 2.7.1

private interconnect, 1.3, 2.1

privileges

granting on each cluster node, 7.5.1

required, 4.3

protocol address, 7.4.1

public interconnect, 1.3

---

Q

quorum disk

dumping information about, 6.2

---

R

RAID

hardware, 1.3

technology, 2.1.1

redundancy

servers and, 2.1.1

registration

dumping information about resource, 6.2

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 7.10.6

setting, 7.10.4

resource types

custom, 2.2.4

generic service, 2.2.4

IP addresses, 2.2.4

Microsoft Windows Failover Clusters, 2.2.4

Oracle MTS Service, 2.2.4

physical disks, 2.2.4

resources, 1.1

access to, 2.2.1

accessing through a virtual server, 2.3

client access to, 2.1

defined, 2.2.1

dependencies, 2.2.3, 2.2.3

discovering, 4.4

disks used by the database configuration, 4.2

DLLs, 2.2.4

effect of group Nodes property page changes on, 2.6.7

examples of, 2.2.2

failover policy effect on groups, 2.6.8

failure of, 2.6.1.1

possible owner nodes list and, 2.6.7

renaming, 4.5

repairing misconfigured, 7.10.2

restart policy, 2.6.9

returning to a preferred owner node, 2.7

verifying configuration of, 6.1.2, 6.1.2, 6.1.3

rolling upgrade

of application software, 1.2.2

---

S

sample database

privileges required, 7.10.8

scripts

FsDbError.bat script, 7.10.1

PowerShell cmdlets in an active/active configuration, 3.1.2

to handle errors when single-instance database cannot be placed online, 7.10.1

secondary node

creating the database instance on, 4.2

testing database shutdown, 4.2

security

increasing with multiple network names, 2.3

requirements

for single-instance databases, 7.5

synchronizing password files on nodes, 7.5.1

server nodes

attempting to restart, 2.7.2

cluster polling failure, 7.10.6

losing client connections, 7.10.9

trace flags, A.4

server redundancy, 2.1.1

SERVER=DEDICATED parameter, 7.4.4

shared-nothing configuration, 2.1.3

shared servers

configuring for Oracle8i or later databases, 7.4.4.1

SERVER=DEDICATED parameter and, 7.4.4

shared storage interconnect, 1.2.1, 2.1

Fibre Channel, 1.3

SID

entering for single-instance database, 7.10.7.1

entry in tnsnames.ora file, 4.2

silent mode installation, 1.2.2

single-instance databases

clients lose connection to, 7.10.9

configuring database resource to use shared servers, 7.4.4

handling errors for failures to place online, 7.10.1

management operations and, 7.7

possible owner nodes list for, 7.3.3.2

prerequisites to adding to a group, 7.3.1

upgrading, 7.5.3

software configuration, 1.3

SPFILE

See initialization parameter file

SQL*Plus

performing administrative tasks, 7.7

SQLNET string, A.4

SQLNET.AUTHENTICATION_SERVICES parameters

updated after adding a single-instance database to a group, 7.4.2.3

sqlnet.ora files

updates made when a single-instance database is added to a group, 7.4.2.3

standalone databases

discovering, 7.1

shared servers and, 7.2.2

Validate, 4.1, 6.1.3

verifying, 4.1, 6.1.3

standalone resources

discovering, 4.4

See also index entries for each resource

standby configurations, 3.1.1

static load balancing, 2.6.2

strings

Oracle Fail Safe tracing, A.4

SYS account, 7.5, 7.10.8, 7.10.8

SYSDBA privileges, 7.5.1

SYSOPER privileges, 7.5.1

---

T

temporary tables

failover and, 7.3.1

TNS_ADMIN Windows environment variable, 7.4.1

TNS_ADMIN Windows registry parameter, 7.4.1

tnsnames.ora files, 4.2

archived, 7.10.7.3

checking Oracle Net configuration data, 7.10.4

modifying for highly available single-instance databases, 7.4.1

problems configuring the virtual server, 7.10.7.1

SERVER=DEDICATED parameter and, 7.4.4

single-instance Oracle Databases and, 7.3.2

updating, 7.4.1

trace files, A.5

tracing

enabling, A.4

flags, A.4

transactions

failover and, 1.2.4

transparent application failover, 7.9

tree view, 1.2.2

populating with clusters, 2.5

troubleshooting

access to the cluster, 7.10.8

configuring the virtual address, 7.10.7.1

databases, 7.10

security access using Oracle Enterprise Manager, 7.10.8

startup problems, 6.3

unable to place a group online, 7.10.4

verification tools, 6.1

---

U

unplanned failover, 2.6.1

upgrading a single-instance database, 7.5.3

user

domain account for Oracle Fail Safe Manager, 4.3.2

user credentials

setting, 7.10.8

---

V

Validate group action

purpose, 6.1.2

Validate group operation

overview, 6.1.2

possible owner nodes list and, 2.6.7

updating information in the cluster registry, 7.7

Validate operation, 6.1.3, 6.1.3

tracing, A.4

Verify Cluster operation

purpose, 6.1.1

Verify Group operation

logging information about, A.4

possible owner nodes list and, 4.8

updating resource dependencies, 7.10.2

verify tools, 1.2.2

VERIFY_DB string, A.4

verifying

with groups, 7.10.4

virtual addresses

cluster alias, 2.5

definition, 2.3

for single-instance Oracle Databases, 7.3.3.3

multiple, 2.3, 4.7

reasons for multiple in a group, 4.7

troubleshooting configuration problems, 7.10.7.1

virtual servers, 1.2.1

configuration, 2.3

configuration problems, 7.10.7.1

definition, 2.3

listener failure and, 7.10.7.1

multiple, 4.7

multiple network names, 2.3

network configuration for, 7.4.1

updates to tnsnames.ora files during configuration of, 7.4.1

---

W

wide area network, 1.3

Windows cluster

See clusters

Windows environment variables

TNS_ADMIN, 7.4.1

Windows Failover Cluster

cluster software, 1.1

Is Alive polling, 2.2.4

Pending Timeout value, 7.10.4

Windows operating system groups

ORA_DBA, 7.3.3.5

ORA_sid_DBA, 7.3.3.5

Windows registry parameters

TNS_ADMIN, 7.4.1

wizards, 1.2.2

input, 4.2

workloads

setting Pending Timeout to accommodate heavy, 7.10.4