Oracle9i Real Application Clusters Setup and Configuration -- Index

acquiring rollback segments, 5-6

ACTIVE_INSTANCE_COUNT parameter, 9-8

ADD LOGFILE clause

thread required, 5-7

adding a file, 5-9

All Initialization Parameters dialog, 4-13

allocation

rollback segments, 5-5

ALTER DATABASE DISABLE THREAD statement, 5-8

ALTER DATABASE statement

DISABLE clause, 5-8

THREAD clause, 5-8

thread of redo, 5-8

ALTER ROLLBACK SEGMENT statement, 5-6

architecture

Optimal Flexible Architecture (OFA), 3-7

Oracle Enterprise Manager, 7-5

SRVCTL Utility on UNIX, 7-3

archive logs

destinations, conversion to multi-instance, 10-2

ARCHIVELOG mode, 5-3

ASCII file

for UNIX raw volume names, 2-10

automatic undo management, 5-5, 8-7

rollback segments, 5-4

backups

after creating new databases, 5-19

before database creation, 5-11

conversion to multi-instance, 10-2

server parameter file, 6-7

client load balancing

configuring, 9-2

description of, 9-2, 9-9

clustdb.sql script, 5-17

cluster database

reasons not to convert to, 10-2

clustered file systems

as required by Oracle Managed Files, 1-6

clusterware

diagnostics, 3-4

Communication Daemon, defined, 7-2

components, 9-3

created when using the DBCA, 8-4

Configuration Assistant, 7-8

configuration file, 8-2

configuration raw device, 2-2

configuration types

Customized, 3-5, 3-6

Data Warehouse, 3-5

General Purpose, 3-5

New Database, 3-6

Software Only, 3-6

Transaction Processing, 3-5

configurations

change in redo log, 5-9

configuring

clients

client load balancing, 9-2

connect-time failover, 9-2

primary and secondary instances, 9-9

global database name, 4-9

high availability, 9-1 to 9-4

primary and secondary instances, 9-8

listeners

primary and secondary instances, 9-9

Oracle Enterprise Manager, 7-10, 7-11

Oracle Performance Manager, 7-11

primary and secondary instances, 9-8

Server Management, 7-1

shared disks, 2-1

SID Prefix, 3-8, 3-10

connecting

Real Application Clusters database, 9-3

connection load balancing, 8-8

connect-time failover

configuring, 9-2

described, 9-2, 9-9

GLOBAL_DBNAME parameter in listener.ora file, 8-11

Console

setup, 7-5

control files, 1-5, 2-2

creating, 5-3

described, 8-6

log history, 5-2

raw devices, 2-6

converting

from single-instance to Real Application Clusters, 10-1

to Real Application Clusters from single-instance Oracle databases, 10-1

CREATE CONTROLFILE statement, 5-3

changing database options, 5-3

CREATE DATABASE, 5-2

creating threads, 5-7

MAXDATAFILES clause, 5-3

MAXINSTANCES clause, 5-2

MAXLOGFILES clause, 5-2

MAXLOGHISTORY clause, 5-2

MAXLOGMEMBERS clause, 5-2

Create Database

option on Creation Options page, 4-17

CREATE PUBLIC ROLLBACK SEGMENT statement, 5-6

CREATE ROLLBACK SEGMENT statement, 5-5, 5-6

creating

initdb_name.ora file, 5-15

initialization parameter files, 5-15

initsid.ora file, 5-15

new redo log groups, 5-7

Oracle Enterprise Manager repository, 7-8

password files, 5-16

raw devices on UNIX, 2-7

raw devices on Windows, 2-12

Real Application Clusters database

backing up the new database, 5-19

initdb_name.ora file, 5-15

initsid.ora file, 5-15

ORACLE_SID environment variable, 5-14

OracleServicesid service, 5-15

oratab file, 5-13, 8-3

password files, 5-16

with the Database Configuration Assistant, 3-8, 4-2, 4-3

Real Application Clusters database with manual methods, 5-10

rollback segments, 5-5, 5-6

server parameter files, 6-7

threads, 5-7

Creation Options page, 4-16

cross-node registration, 8-8

crtsrv batch file, 5-15

Customized

configuration type, 3-5, 3-6, 3-7

CWMLITE tablespace

raw devices, 2-6

cwmlite1

identifying on UNIX, 2-9

data dictionary

views, 5-6

Data Warehouse

configuration type, 3-5, 3-6

database

archiving mode, 5-8

components, created when using the DBCA, 8-4

configurations, types, 3-6

rollback segments, 5-5

Database Configuration Assistant

All Initialization Parameters dialog, 4-13

components created by, 8-4

control files, 8-6

creating Real Application Clusters database

after installation, 4-3

during installation, 3-8, 4-2

Creation Options page, 4-16

Database Connection Options page, 4-10

Database Features page, 4-10

Database Identification page, 4-9

Database Storage page, 4-15

Database Templates page, 4-8

datafiles, 8-4

deleting databases with, 4-20

deleting Real Application Clusters databases, 4-20

initialization parameter files, 8-7

Initialization Parameters page, 4-11

List of Cluster Databases page, 4-21

Node Selection page, 4-6

Operations page, 4-6, 4-20

processing during installation, 3-7

raw devices for, 2-3

redo log files, 8-6

rollback segments, 8-7

Summary dialog, 4-18, 4-19, 4-23

tablespaces, 8-4

troubleshooting, 4-5

using, 4-2

Welcome page, 4-4

database configuration type

selecting, 3-5

database configuration types, 3-6

Database Connection Options page, 4-10

database directory, A-3

Database Features page, 4-10

Database Identification page, 4-9

Database Storage page, 4-15

Database Templates page, 4-8

datafiles, 1-5, 2-2

and the DBCA, 8-4

described, 8-4

raw devices, 2-6

db_name.conf file

service discovery, B-3

DBA Studio

limitations, 7-7

DBA_ROLLBACK_SEGS view

public rollback segments, 5-6

DBCA_RAW_CONFIG

environment variable, 3-3

DBMS_LIBCACHE package, 9-10

dedicated servers, 8-8

deleting databases

with the DBCA, 4-20

devices

minimum configuration requirements, 2-2

diagnostics

clusterware, 3-4

directory structure, A-1, B-1

UNIX, A-2

DISABLE THREAD clause, 5-8

disabling

the archive history, 5-3

threads, 5-8

dropping redo log files

manual archiving, 5-8

restrictions, 5-9

DRSYS tablespace

description, 8-4

raw device, 2-6

Edit User Preferences dialog box, 7-10

environment variable

for raw devices, 2-11

UNIX, 3-2

errors

messages, rollback segment, 5-6

Oracle Enterprise Manager discovery, B-2

EXAMPLE tablespace

raw devices, 2-6

example1

identifying on UNIX, 2-9

exclusive mode

media recovery, 5-2

extent management

rollback segments, 5-5

failover

and service registration, 8-8

FAILOVER parameter, 9-3

FAILOVER_MODE parameter, 9-4

for Transparent Application Failover, 9-4

features, new, xxvii

files

dropping, 5-8, 5-9

renaming, 5-9

General Purpose

configuration type, 3-5

description of configuration type, 3-6

Generate Database Creation Scripts

on Creation Options page, 4-17

global database name, 4-9

Global Services Daemon (GSD), 5-13

GLOBAL_DBNAME parameter, 8-11

groups

MAXLOGFILES, 5-2

redo log files, 5-2, 5-9

GSD, defined, 7-2

hardware requirements, 1-6

high availability

configuring, 9-1 to 9-4

primary and secondary instances, 9-8

Transparent Application Failover, 9-4

host.equiv file, 2-11

INDX tablespace

described, 8-4

raw device, 2-6

initdb_name.ora file

ACTIVE_INSTANCE_COUNT parameter, 9-8

creating, 5-15

initialization parameter files, 8-7

creating for database creation, 5-15

editing before database creation, 5-16

for instances, 6-2

listener parameters, 8-9

initialization parameters

DISPATCHERS, 8-8

LOCAL_LISTENER, 8-8

REMOTE_LISTENER, 8-8, 8-14

Initialization Parameters page, 4-11

initsid.ora file

creating, 5-15

installation

directory structure, A-1, B-1

ldap.ora file, 8-12

listener.ora file, 8-10

overview, 1-3, 1-5

preinstallation, 2-12

processing of the DBCA, 3-7

repository database, 7-7

requirements, hardware, 1-5, 1-6

requirements, hardware requirements, 1-6

requirements, software, 1-5

software requirements, 1-6

tnsnames.ora file, 8-12

verifying raw devices, 4-3

installing

Oracle Enterprise Manager, 7-7

Oracle software with Oracle Universal Installer, 3-2

INSTANCE_ROLE

for Transparent Application Failover, 9-4

use of in secondary instance connections, 9-10

instances

initialization parameter files, 6-2

SID Prefix, 3-8, 3-10

thread number, 5-7

Instances Logon dialog box, 7-12

interconnects

supported for Real Application Clusters, 1-7

ldap.ora file, 8-12

creating, 8-12

default configuration, 8-12

library cache

warming, 9-10

Lightweight Directory Access Protocol (LDAP), 8-12

List of Cluster Databases page, 4-21

listener

local, 8-8

registration, 8-11

listener.ora file, 8-10

configuring, 8-9

default configuration, 8-10

Oracle Enterprise Manager service discovery, B-4

Server Management requirements, 7-4

sid_LIST_listener_name parameter, 5-20, 7-4, B-4

listeners

GLOBAL_DBNAME parameter, 8-11

listener.ora file, 8-10

load balancing

and service registration, 8-8

LOAD_BALANCE parameter, 9-3

local listener, 8-8

log history, 5-2

log switches

adding or dropping files, 5-9

lsnodes

command syntax, 3-4

manual archiving

dropping a redo log file, 5-8

manual undo management, 5-5

MAXDATAFILES clause, 5-3

MAXDATAFILES parameter, 5-4

MAXINSTANCES clause

changing, 5-3

MAXINSTANCES parameter, 5-3

MAXLOGFILES clause, 5-2, 5-3

MAXLOGFILES parameter, 5-3

MAXLOGHISTORY clause, 5-2

changing, 5-3

MAXLOGHISTORY parameter, 5-4

MAXLOGMEMBERS clause, 5-2, 5-3

MAXLOGMEMBERS parameter, 5-3

media recovery

log history, 5-2

member

MAXLOGMEMBERS, 5-2

migrating

Real Application Clusters issues, 4-24

migration

from single-instance, see conversion, 10-2

multiple Oracle homes

UNIX, 4-25

Windows, 4-25

multiplexed redo log files

total number of files, 5-2

network configuration files

ldap.ora.ora, 8-12

listener.ora, 7-4, 8-10

Oracle Enterprise Manager service discovery, B-4

sqlnet.ora, 5-20, 8-16, B-6

testing, 9-3

tnsnames.ora, 5-20, 8-12

Oracle Enterprise Manager service discovery, B-5

network directory, A-2, A-3

New Database

configuration type, 3-6

new features, xxvii

nmiconf.log file, B-7

Node Selection page, 4-6

Operations page, 4-6, 4-20

OPS_INSTANCE entry, B-7

OPS_INSTANCE entry in services.ora file, B-7

Optimal Flexible Architecture (OFA), 3-7

Oracle Enterprise Manager

architecture, 7-5

Configuration Assistant, 7-8

configuring, 7-10, 7-11

repository, 7-8

described, 7-2

GSD, 7-2

installing repository database, 7-7

nmiconf.log file, B-7

oratab file requirements, 5-13

repository database

configuring, 7-8

Server Management

Communication Daemon, 7-2

service discovery, B-2

services.ora file, B-6

setup scenarios, 7-5

sid_LIST_listener_name parameter in listener.ora file, 5-20, 7-4

solving service discovery failures, B-2

specifying preferred credentials, 7-8

SYSDBA privilege, 7-10

SYSOPER privilege, 7-10

TOOLS tablespace, 2-6

understanding discovery failures, B-2

Oracle Managed Files

requirements for using, 1-6

Oracle Performance Manager

accessing Real Application Clusters charts, 7-11

Cluster Database Instance folder, 7-11

configuring, 7-11

Databases folder, 7-12

Oracle Universal Installer, 3-2

for Real Application Clusters, 3-1

overview of processing, 1-3

starting, 3-2

ORACLE_SID

environment variable, 5-14

OracleServicesid service, 5-15

ORAPWD utility, 5-17

orapwsid file, 5-17

parameters

database creation, 5-2

initialization, 6-1

password files, 5-16

preconfigured database installation types, 3-6

preferred credentials, 7-8

creating an operating system account, 7-9

database, 7-8

nodes, 7-8

pre-installation

raw device creation, 2-13

preinstallation, 2-12

on UNIX, 2-11

raw device creation, 2-3, 8-6

primary and secondary instances

client configuration, 9-9

connecting to secondary instances, 9-10

listener configuration, 9-9

overview, 9-8

private rollback segments, 5-5, 5-6

creating, 5-5

private threads, 5-7

public rollback segments, 5-6

bringing online, 5-7

creating, 5-6

owner, 5-6

specifying, 5-6

using by default, 5-6

PUBLIC threads, 5-7

pwdsid.ora file, 5-17

RAC_DATABASE entry, B-6

RAC_DATABASE entry in services.ora file, B-6

raw devices

configuration raw device, 2-2

configuring, 2-7

control files, 2-6

creating

on UNIX, 2-7

on Windows, 2-12

datafiles, 2-6

DRSYS tablespace, 2-6

environment variable, 2-11

EXAMPLE tablespace, 2-6

identifying on UNIX

control1 database object, 2-9

control2 database object, 2-9

drsys1 database object, 2-9

indx1 database object, 2-9

system1 database object, 2-9

temp1 database object, 2-9

tools1 database object, 2-9

users1 database object, 2-9

identifying on Windows

db_name_control1 symbolic link, 2-13

db_name_control1 symbolic link, 8-6

db_name_control2 symbolic link, 2-13, 8-6

db_name_cwmlite1, 2-13

db_name_drsys1 symbolic link, 2-13, 8-5

db_name_indx1 symbolic link, 2-13, 8-5

db_name_rbs1 symbolic link, 8-5

db_name_redo thread_number symbolic link, 2-13, 8-6

db_name_redothread_number symbolic link, 8-7

db_name_spfile1 symbolic link, 2-13, 8-5

db_name_system1 symbolic link, 2-13, 8-5

db_name_temp1 symbolic link, 2-13, 8-5

db_name_tools1 symbolic link, 2-13, 8-5

db_name_users1 symbolic link, 2-13, 8-5

identifying on Windows, srvcfg, 2-13

identifying on Windows, undotbs1 and undotbs2 symbolic links, 2-13, 8-5

INDX tablespace, 2-6

redo log files, 2-6

server parameter files, 2-6

setting up, 2-3, 2-13, 8-6

srvcfg, 2-6

SYSTEM tablespace, 2-6

TEMP tablespace, 2-6

TOOLS tablespace, 2-6

UNDOTBS tablespace, 2-6

USERS tablespace, 2-6

verification, 4-3

raw devices CWMLITE tablespace, 2-6

raw volumes

on UNIX, configuring, 2-7

RBS tablespace

description, 8-4

Real Application Clusters

components, 1-2

databases, backing up, 5-19

databases, creating

with manual methods, 5-10

databases, deleting, 4-20

databases, password files, 5-16

hardware requirements, 1-6

installation requirements, 1-5

installed components of, 1-5

overview, 1-1, 4-1, 8-1

preinstallation, 2-12

raw device setup, 2-3, 2-13, 8-6

software requirements, 1-6

Real Application Clusters Guard II, 9-11

recovery

archive history, 5-2

redo log

changing, 5-9

redo log files, 1-5, 2-2

described, 8-6

identifying on UNIX, 2-9

raw devices, 2-6

reconfiguring, 5-9

redo log groups, creating, 5-7

redo log mode

setting, 5-8

registration

cross-node, 8-8

registry

PM\db_name key, B-4

repository database

installing, 7-7

requirements

for installing Real Application Clusters, 1-5

tablespace sizes, 2-5

restrictions

changing the redo log, 5-9

.rhosts file, 2-11

rollback segments, 5-5

described, 8-7

ID number, 5-5

manually creating, 5-5

multiple, 5-5

name, 5-5

public, 5-7

public versus private, 5-7

specifying, 5-5

tablespace, 5-5

ROLLBACK_SEGMENTS parameter

private and public segments, 5-5, 5-6

root, 2-11

Save as a Database Template

option on Creation options page, 4-17

segments

ID number, 5-5

server configuration

raw device for, 2-2

Server Management

configuring, 7-1

GSD process, 7-2

node requirements, 7-4

requirements, 7-4

SIDs, 7-4

server parameter file

backing up, 6-7

server parameter files, 1-5, 2-2, 6-1, 6-2, 8-7

creating, 6-7

errors, 6-6

raw devices, 2-6

service discovery

db_name.conf file, B-3

errors, B-2

listener.ora file, B-4

nmiconf.log file, B-7

on UNIX, B-3

on Windows NT, B-4

PM\db_name registry key, B-4

services.ora file, B-6

sid_LIST_listener_name parameter, B-4

tnsnames.ora file, B-5

understanding, B-2

service registration

configuring, 8-8

services.ora file, B-6, B-7

shared configuration file, 8-2

shared disks

configuring, 2-1

shared server, 8-8

shutting down a Server database

with SYSDBA privilege, 7-10

with SYSOPER privilege, 7-10

sid Prefix, 3-8, 3-10

sid_LIST_listener_name parameter, 5-20, 7-4

Software Only

configuration type, 3-6

software requirements, 1-6

spfile1

identifying on UNIX, 2-9

sqlnet.ora file, 5-20, 8-16, B-6

default configuration, 8-16, B-6

srvcfg

raw devices, 2-6

srvcfg raw device

identifying, 2-13

srvconfig

command on UNIX, 8-2

srvConfig.loc, 8-2

SRVCTL Utility, 5-13, 7-2

architecture on UNIX, 7-3

srvm\admin directory, A-3

SRVM_SHARED_CONFIG

environment variable, 3-2

startup

rollback segments, 5-6

SYSDBA privilege, 7-10

SYSOPER privilege, 7-10

Summary dialog, 4-18, 4-19, 4-23

SYSDBA privilege, 7-10

SYSDBA privilege, granting, 7-9

SYSOPER privilege, 7-10

SYSOPER privilege, granting, 7-9

SYSTEM tablespace, 5-5

description, 8-4

raw device, 2-6

tablespaces

and the DBCA, 8-4

control files, 2-6

CWMLITE, 2-6, 8-5

DRSYS, 2-6, 8-4

EXAMPLE, 2-6, 8-4

expanding for large sorts, 8-4

INDX, 2-6, 8-4

ODM, 2-6

RBS, 8-4

recommended sizes of, 2-5

rollback segment, 5-5

server parameter file, 2-6

srvcfg, 2-6

SYSTEM, 2-6, 5-5, 8-4

TEMP, 2-6, 8-4

TOOLS, 2-6, 8-4

undo tablespaces for automatic undo management, 8-4

UNDOTBS, 2-6

USERS, 2-6, 8-4

XDB, 2-6

TAF

configuring, 9-4

GLOBAL_DBNAME parameter in listener.ora file, 8-11

overview, 9-4

pre-establishing a connection, 9-6

retrying a connection, 9-6

with client load balancing, 9-5

with connect-time failover, 9-5

TEMP tablespace

described, 8-4

raw device, 2-6

testing the network, 9-3

THREAD clause, 5-7

disabling a thread, 5-8

when required, 5-7

THREAD parameter, 5-7

threads

associated with an instance, 5-7

changing from public to private, 5-8

creating, 5-7

disabled, 5-8

disabling, 5-8

public, 5-7

tnsnames.ora file, 5-20, 8-12

default configuration, 8-12

FAILOVER parameter, 9-3

FAILOVER_MODE, 9-4

LOAD_BALANCE parameter, 9-3

service discovery, B-5

TOOLS tablespace

described, 8-4

raw device, 2-6

Transaction Processing

configuration type, 3-5

description of configuration type, 3-6

Transmission Control Protocol/Interconnect Protocol (TCP/IP)

for Real Application Clusters, 1-7

Transparent Application Failover, 9-4

configuring, 9-4

GLOBAL_DBNAME parameter in listener.ora file, 8-11

overview, 9-4

pre-establishing a connection, 9-6

retrying a connection, 9-6

with client load balancing, 9-5

with connect-time failover, 9-5

troubleshooting

Database Configuration Assistant, 4-5

service discovery, B-2

undo management, 8-7

UNDOTBS tablespace

raw devices, 2-6

undotbs1

identifying on UNIX, 2-9

UNIX

raw volume names ASCII file, 2-10

raw volumes, configuring, 2-7

upgrading

Real Application Clusters issues, 4-24

user

PUBLIC, 5-6

User Datagram Protocol (UDP)

for Real Application Clusters, 1-7

USERS tablespace

described, 8-4

raw device, 2-6

V$SESSION table, 9-8

Veritas Volume Manager

during installation, 2-5

Virtual Interface Architecture (VIA)

for Real Application Clusters, 1-7

volumes

Veritas Volume Manager, use of during installation, 2-5

warming the cache, 9-10

Welcome page, 4-4