Index

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

A

abort mode

taking single-instance databases offline in, 5

access to resources, 2.2.1

accounts

adding to database password file, 8.5.1

privileges and permissions, 4.3

to manage a single-instance Oracle Database, 8.5

active/active configurations, 3.1.2

active/passive configurations, 3.1.1

Add Resource to Group operation

troubleshooting, 8.2.2

Add Resource to Group Wizard

Oracle single-instance databases, 8.3.3

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

authentication information, 8.3.3.4

database name, 8.3.3.3

instance name, 8.3.3.3

Oracle Net listener, 8.4.2

possible owner nodes, 8.3.3.1

prerequisites, 8.3.1

service name, 8.3.3.3

steps, 8.3.2

tnsnames.ora file, 8.3.2

virtual addresses, 8.3.3.2

Administrator privileges

logging in to a cluster, 4.3.2

specifying with the FSCMD command, 5

alert files, A.5

allocating IP addresses for a cluster, 2.4

application log

troubleshooting startup problems, 7.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, 8.10.7.3

authentication

checking preferences in Oracle Enterprise Manager, 8.10.8

log on as batch user access rights, 8.10.8

permissions and privileges required, 4.3

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 8.5

SYSDBA role, 8.5.1

SYSOPER privileges, 8.5.1

troubleshooting DBA authentication, 8.10.6

using SYS for databases, 8.5.1

availability

RAID technology, 2.1.1

B

backup operation

sample FSCMD commands in a script, 5

bandwidth

increasing with multiple virtual addresses, 2.3

benefits

of Oracle Fail Safe, 1.2

bequeath protocol adapter

Oracle Fail Safe connection to single-instance database and, 8.4

C

checkpoints

prior to database failover, 2.6.2

client connections

to single-instance Oracle Databases, 8.4.2

clients

access to resources, 2.3

accessing groups with multiple virtual addresses, 4.7

cluster connections, 2.7.2

connecting to resources using multiple virtual addresses, 4.7

reconnecting to a single-instance database after failover, 8.9

cluster alias

definition, 2.5

Oracle Fail Safe Manager and, 2.5

use of, 2.5

cluster disks

Oracle single-instance databases and, 8.3.1

RAID hardware and, 1.3

redundancy and, 2.1.1

D

data files

adding new, 8.7

database account

SYS, 8.5, 8.10.8

database administrator

changing the password, 8.10.6

connecting as internal, 8.10.6

DBA_AUTHORIZATION parameter, 8.5

database password file

adding accounts to for a database, 8.5.1

database recovery

optimization for single-instance databases, 8.6

databases

adding a new data file, 8.7

backup operations on, 8.7

using FSCMD commands, 5

changing DBA passwords, 8.10.6

checkpointing and, 2.6.2

clients lose single-instance database connection, 8.10.9

configuration data, 8.3.3

configuring database resource to use shared servers, 8.4.5

configuring using wizard input, 4.2

EXCLUSIVE access, 8.5

group resource, 2.2.2

identity, 8.3.3.3

improving connection time, 8.4.1

Is Alive polling, 8.10.6

listeners for standalone, 8.2.4

LOCAL_LISTENER parameter in the initialization file, 8.4.5.1

name, 8.3.3.3

net service name entry, 8.2.1

Oracle8i or later using shared servers, 8.4.5.1

resolving an unstable state, 8.10.4

security, 8.5

SHARED access, 8.5

shared servers and Windows Failover Cluster nodes, 8.4.5

steps for configuring, 8.3.2, 8.3.2

synchronizing password files, 8.5.1

taking offline, 5, 5, 8.7

due to change in password, 8.10.6

for cold backup operation, 8.7

Pending Timeout, 8.10.4

problems, 8.10.6

testing shutdown on the secondary node, 4.2

updating tnsnames.ora file for remote client access, 8.4.3.1

upgrading, 8.2.3

upgrading with Oracle Database Upgrade Assistant, 8.5.3

using shared servers, 8.4.5

using SQL*Plus for cold backup operations, 8.7

verifying, 7.1.2, 7.1.3

virtual addresses, 8.3.3.2

E

ENABLEISALIVE parameter, 5, 8.10.5

error handling

scripts and, 8.10.1

errors

FS-10066, 8.10.7.1

FS-10070, 8.10.7.1

FS-10101, 8.10.8

ORA-01031, 8.10.8

reporting, A.1

returned for insufficient privileges, 8.10.8

tracking information in a trace file, A.4

user authentication, 8.10.8

written to the Oracle Net listener log, 8.10.4

external procedures

configuring, 8.4.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, 7.2

specifying, 2.7

verifying with Validate group action, 7.1.2

verifying with Verify Group operation, 8.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, 8.7

due to resource failure, 2.6.1.1

dumping information about policies, 7.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, 8.10.5

unit of, 2.2.2

unplanned, 2.6

verifying with Validate group action, 7.1.2

verifying with Verify Group operation, 8.10.2

failures

unplanned, 2.6.1

verifying resources to prevent, 7.1.2, 7.1.3

Fibre Channel

shared storage interconnect, 1.3

file corruption

in tnsnames.ora and listener.ora files, 8.10.7.1

files

alert, A.5

archived, 8.10.7.3

rollback, 8.10.7.4, 8.10.7.4

trace, A.5

flags

tracing Oracle Fail Safe errors, A.4

FSCMD command, 1.2.2

DISABLEISALIVE parameter, 5, 8.10.5

DUMPCLUSTER parameter, 5

ENABLEISALIVE parameter, 5, 8.10.5

example usage in a script, 5

examples, 5

MOVEGROUP parameter, 5

OFFLINEGROUP parameter, 5

OFFLINERESOURCE parameter, 5

ONLINEGROUP parameter, 5

ONLINERESOURCE parameter, 5

parameters and qualifiers, 5

syntax, 5

usage notes, 5

VERIFYALLGROUPS parameter, 5

VERIFYCLUSTER parameter, 5

VERIFYGROUP parameter, 5

FsDbError.bat script, 8.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, 8.3.2

adding virtual addresses to, 2.3

correcting the network name, 8.10.7.1

DBA password mismatches, 8.10.6

definition of, 2.2.2

dumping information about, 7.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

moving, 5

multiple virtual addresses in, 4.7

Oracle homes, 4.6

ownership of, 2.2.2

placing online, 5

populating, 4.2

preferred owner nodes list, 2.6.10

privileges for adding a single-instance database, 8.10.8

resource dependencies, 2.2.3

taking offline, 5

verifying all groups in a cluster, 5

verifying resources in, 7.1.2

virtual addresses and, 8.3.3

with multiple virtual addresses, 4.7

H

hardware

configuration, 1.3

RAID, 1.3

heartbeat connection, 2.1

definition of, 1.3

I

immediate mode

taking single-instance databases offline in, 5

initialization parameter file

deleting the LOCAL_LISTENER parameter, 8.4.5.1

exporting SPFILE and, 8.3.3.3.1

for highly available single-instance databases, 8.3.3.3, 8.3.3.3

location of, 8.3.3.3

PFILE and, 8.3.3.3.1

placement of, 8.3.3.3

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 8.5, 8.10.6

restrictions on specifying SPFILE and, 8.3.3.3.1

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

instance name

for highly available single-instance databases, 8.3.3.3

J

jobs

troubleshooting access problems, 8.10.8

L

Listener Control Utility (LSNRCTL)

creating listeners, 8.10.7.2

listener.ora files, 4.2

archived, 8.10.7.3

checking configuration data, 8.10.4

configuring multiple, 8.2.4

example, 8.10.7.1

EXTPROC prefix, 8.4.4

modifying, 8.10.7.1

problems configuring the virtual server, 8.10.7.1

rollback files, 8.10.7.1

sample definition, 8.10.7.1

updated by Oracle Database Configuration Assistant, 8.2.1

listeners

changes for shared servers, 8.2.5

configuring, 4.2

configuring Oracle Net on nodes with multiple listeners, 8.2.4

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

creating new, 8.10.7.2

creating with Listener Control Utility (LSNRCTL), 8.10.7.2

definition in rollback file, 8.10.7.1

enabling shared sockets and, 8.4.1

log file, 8.10.4

network resources, 2.2.2

output files, 8.10.7.2

problems after changing or creating definition of, 8.10.7.1

problems creating, 8.10.7.2

specifying in the LOCAL_LISTENER parameter, 8.4.5.1

specifying information in the DISPATCHERS parameter, 8.4.5.1

starting, 8.2.4

troubleshooting, 8.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, 8.2.5

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

specifying listeners in, 8.4.5.1

updating information for the group, 8.4.5.1

writing to the single-instance database parameter file, 8.4.5.1

LOGFILE qualifier

FSCMD command, 5

LSNRCTL utility

troubleshooting listener problems, 8.10.7.2

M

management operations

single-instance database, 8.7

managing

cluster security, 4.3

tnsnames.ora file on client systems, 8.3.2, 8.4.3.1

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

MOVEGROUP parameter, 5

multiple Oracle homes, 4.6

checking for overlapping addresses and single-instance database SID names, 8.10.7.1

configuring multiple listeners, 8.2.4

multiple listeners, 8.2.4

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

updating tnsnames.ora with Validate command, 8.2.1

N

net service name, 8.3.3.3

added for single-instance databases, 8.2.1

appended with the default domain name, 8.4.3.1

default domain name and, 8.4.3.1

definition

referencing in archived configuration files, 8.10.7.3

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

entry for new single-instance databases, 8.2.1

highly available single-instance databases and, 8.3.3.3

when configuring the virtual server, 8.10.7.1

network configuration

updating domain name values in sqlnet.ora files, 8.2.1

network name

cluster alias, 2.5

correcting for group, 8.10.7.1

networks

configuration

for highly available single-instance databases, 8.4.2

Oracle Net on nodes with multiple listeners, 8.2.4

updating, 8.2.1

verify with Verify Group, 8.10.2

dumping public and private information, 7.2

problems while configuring virtual server, 8.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

NODE qualifier

FSCMD command, 5

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

normal mode

taking single-instance databases offline in, 5

O

OFFLINE qualifier

FSCMD command, 5

OFFLINEGROUP parameter, 5

offline-option modes, 5

OFFLINERESOURCE parameter, 5

ONLINEGROUP parameter, 5

ONLINERESOURCE parameter, 5

operating system authentication, 8.3.3.4

ORA_DBA

Windows operating system group, 8.3.3.4

ORA_sid_DBA

Windows operating system group, 8.3.3.4

Oracle Database Configuration Assistant (DBCA), 8.2.1

creating the Oracle Net configuration, 8.2.1

net service name entry and, 8.2.1

Oracle Database Upgrade Assistant

upgrading single-instance databases, 8.5.3

Oracle Enterprise Manager

authentication problems, 8.10.8

setting User Credentials, 8.10.8

troubleshooting authentication problems, 8.10.8

troubleshooting client connection problems, 8.10.8

use in an active/active configuration, 3.1.2

Oracle Fail Safe

installation of, 1.2.2

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

P

parameter file

See initialization parameter file

parameters

SERVER=DEDICATED in tnsnames.ora file, 8.4.5

USE_SHARED_SOCKETS listener parameter, 8.4.1

password files

synchronizing, 8.5.1

passwords

changes cause group problems, 8.10.4

changing for the DBA account, 8.10.6

problems with REMOTE_LOGIN_PASSWORDFILE parameter, 8.10.6

Pending Timeout value

setting, 8.10.4

troubleshooting, 8.10.4

performance

in an active/active configuration, 3.1.2

permissions

insufficient return error ORA-01031, 8.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, 7.2

polling

failures, 8.10.4, 8.10.6

possible owner nodes list

effect on failover, 2.6.11

effect on resources, 2.6.7

for a single-instance Oracle Database, 8.3.3.1

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, 8.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, 8.5.1

required, 4.3

protocol address, 8.4.2

public interconnect, 1.3

PWD qualifier

FSCMD command, 5, 5

Q

quorum disk

dumping information about, 7.2

R

RAID

hardware, 1.3

technology, 2.1.1

redundancy

servers and, 2.1.1

registration

dumping information about resource, 7.2

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 8.10.6

setting, 8.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

placing online, 5

using FSCMD, 5

possible owner nodes list and, 2.6.7

renaming, 4.5

repairing misconfigured, 8.10.2

restart policy, 2.6.9

returning to a preferred owner node, 2.7

taking offline, 5, 5

using FSCMD, 5

verifying configuration of, 7.1.2, 7.1.2, 7.1.3

rollback

clusterwide operation, 8.10.3

files, 8.10.7.1, 8.10.7.4

rolling upgrade

of application software, 1.2.2

S

sample database

privileges required, 8.10.8

scripts

FsDbError.bat script, 8.10.1

PowerShell cmdlets in an active/active configuration, 3.1.2

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

using FSCMD commands in, 5, 5

secondary node

creating the database instance on, 4.2

testing database shutdown, 4.2

security

increasing with multiple virtual addresses, 2.3

requirements

for single-instance databases, 8.5

synchronizing password files on nodes, 8.5.1

server nodes

attempting to restart, 2.7.2

cluster polling failure, 8.10.6

losing client connections, 8.10.9

trace flags, A.4

server redundancy, 2.1.1

SERVER=DEDICATED parameter, 8.4.5

service name

T

temporary tables

failover and, 8.3.1

third-party proxy servers

using shared sockets and, 8.4.1

TNS listeners

updating net service names in, 8.2.4

TNS_ADMIN Windows environment variable, 8.4.2

TNS_ADMIN Windows registry parameter, 8.4.2

tnsnames.ora files, 4.2

archived, 8.10.7.3

checking Oracle Net configuration data, 8.10.4

EXTPROC_CONNECTION_DATA net service name entry, 8.4.4

modifying for highly available single-instance databases, 8.4.2

parsing to discover single-instance databases, 8.1

problems configuring the virtual server, 8.10.7.1

rollback files, 8.10.7.1

SERVER=DEDICATED parameter and, 8.4.5

single-instance Oracle Databases and, 8.3.2

updated by Oracle Database Configuration Assistant, 8.2.1

updating, 8.4.2

updating with default domain name values, 8.2.1

trace files, A.5

tracing

enabling, A.4

flags, A.4

transactional mode

taking databases offline in, 5

transactions

failover and, 1.2.4

transparent application failover, 8.9

tree view, 1.2.2

populating with clusters, 2.5

troubleshooting

access to the cluster, 8.10.8

configuring the virtual address, 8.10.7.1

databases, 8.10

security access using Oracle Enterprise Manager, 8.10.8

startup problems, 7.3

unable to place a group online, 8.10.4

users unable to connect to single-instance database, 8.4

verification tools, 7.1

U

unplanned failover, 2.6.1

upgrading a single-instance database, 8.5.3

USE_SHARED_SOCKETS parameter, 8.4.1

user

domain account for Oracle Fail Safe Manager, 4.3.2

user credentials

setting, 8.10.8

USER qualifier

FSCMD command, 5

V

Validate group action

purpose, 7.1.2

Validate group operation

overview, 7.1.2

possible owner nodes list and, 2.6.7

updating information in the cluster registry, 8.7

Validate operation, 7.1.3, 7.1.3

running on newly created databases, 8.2.1

tracing, A.4

Verify Cluster operation

purpose, 7.1.1

Verify Group operation

FSCMD command, 5

logging information about, A.4

possible owner nodes list and, 4.8

updating resource dependencies, 8.10.2

verify tools, 1.2.2

VERIFY_DB string, A.4

VERIFYALLGROUPS parameter, 5

VERIFYCLUSTER parameter, 5

VERIFYGROUP parameter, 5

verifying

with groups, 8.10.4

virtual addresses, 1.2.1

cluster alias, 2.5

definition, 2.3

for single-instance Oracle Databases, 8.3.3.2

groups and, 8.3.3

identifying, 2.3

internal cluster communications and, 8.4.3.1

multiple, 2.3, 4.7

reasons for multiple in a group, 4.7

troubleshooting configuration problems, 8.10.7.1

virtual servers, 1.2.1

configuration, 2.3

configuration problems, 8.10.7.1

definition, 2.3

listener failure and, 8.10.7.1

multiple, 4.7

multiple virtual addresses, 2.3

network configuration for, 8.4.2

updates to tnsnames.ora files during configuration of, 8.4.2

W

wide area network, 1.3

Windows cluster

See clusters

Windows environment variables

TNS_ADMIN, 8.4.2

Windows Failover Cluster

cluster software, 1.1

Is Alive polling, 2.2.4

Pending Timeout value, 8.10.4

Windows operating system groups

ORA_DBA, 8.3.3.4

ORA_sid_DBA, 8.3.3.4

Windows registry parameters

TNS_ADMIN, 8.4.2

wizards, 1.2.2

input, 4.2

workloads

setting Pending Timeout to accommodate heavy, 8.10.4