Oracle9i Real Application Clusters Installation and Configuration -- Index

acquiring rollback segments, 5-5

ACTIVE_INSTANCE_COUNT parameter, 9-6

ADD LOGFILE clause

thread required, 5-7

adding a file, 5-8

allocation

rollback segments, 5-5

ALTER DATABASE DISABLE THREAD statement, 5-7

ALTER DATABASE statement

DISABLE clause, 5-7

THREAD clause, 5-7

thread of redo, 5-7

ALTER ROLLBACK SEGMENT statement, 5-5

architecture

Optimal Flexible Architecture (OFA), 3-6, 4-2

Oracle Enterprise Manager, 7-5

Server Management, 7-2

SRVCTL Utility on UNIX, 7-3

archive logs

destinations, conversion to multi-instance, 10-3

ARCHIVELOG mode, 5-3

ASCII file

for UNIX raw volume names, 2-10

automatic undo management, 8-8

rollback segments, 5-4

backups

after creating new databases, 5-17

before database creation, 5-9

conversion to multi-instance, 10-3

client load balancing

configuring, 9-9

description of, 9-8, 9-9

clustdb.sql script, 5-16

cluster database

reasons to convert to, 10-2

clustered file systems

as required by Oracle Managed Files, 1-6

Communication Daemon, defined, 7-2

components, 9-11

concurrency

maximum number of instances, 5-2

Configuration Assistant, 7-7

configuration raw device, 2-2

configuration type

Customized, 3-4

configurations

change in redo log, 5-8

configuring

clients

client load balancing, 9-9

connect-time failover, 9-9

primary and secondary instances, 9-7

global database name, 4-9

high availability, 9-1 to 9-11

primary and secondary instances, 9-6

listeners

primary and secondary instances, 9-8

Oracle Enterprise Manager, 7-10, 7-11

Oracle Parallel Server Management, 7-1

Oracle Performance Manager, 7-10

primary and secondary instances, 9-6

shared disks, 2-1

SID Prefix, 3-7, 3-9

connecting

Real Application Clusters database, 9-11

connection load balancing, 8-8, 8-9

connect-time failover

configuring, 9-9

described, 9-8, 9-9

GLOBAL_DBNAME parameter in listener.ora file, 8-12

Console

setup, 7-5

contention

SYSTEM tablespace, 5-4

control files, 1-5, 2-2

creating, 5-3

described, 8-7

log history, 5-2

raw devices, 2-6

CREATE CONTROLFILE statement, 5-3

changing database options, 5-3

CREATE DATABASE, 5-2

creating threads, 5-6

MAXDATAFILES clause, 5-3

MAXINSTANCES clause, 5-2

MAXLOGFILES clause, 5-2

MAXLOGHISTORY clause, 5-2

MAXLOGMEMBERS clause, 5-2

CREATE PUBLIC ROLLBACK SEGMENT statement, 5-5

CREATE ROLLBACK SEGMENT statement, 5-5

creating

initdb_name.ora file, 5-14

initialization parameter files, 5-14

initsid.ora file, 5-14

new redo log groups, 5-7

Oracle Enterprise Manager repository, 7-7

password files, 5-15

preferred credentials, 7-8

raw devices on UNIX, 2-7

raw devices on Windows, 2-12

Real Application Clusters database

backing up the new database, 5-17

initdb_name.ora file, 5-14

initsid.ora file, 5-14

ORACLE_SID environment variable, 5-12

OracleServicesid service, 5-13

oratab file, 5-12, 8-4

password files, 5-15

with Oracle Database Configuration Assistant, 3-6, 4-2, 4-3

Real Application Clusters database with manual methods, 5-8

rollback segments, 5-4, 5-5

server parameter files, 6-7

threads, 5-6

crtsrv batch file, 5-13

Customized

configuration type, description of, 3-4

configuration type, using, 3-5

CWMLITE tablespace

raw devices, 2-6

cwmlite1

identifying on UNIX, 2-9

data dictionary

views, 5-5

Data Warehousing

description of configuration type, 3-4

database

archiving mode, 5-7

configurations, types, 3-4

number of instances, 5-2

rollback segments, 5-4

database directory, A-4

datafiles, 1-5, 2-2

described, 8-5

raw devices, 2-5

db_name.conf file

service discovery, B-3

DBA Studio

limitations, 7-12

DBA_ROLLBACK_SEGS view

public rollback segments, 5-5

DBCA_RAW_CONFIG

environment variable, 3-2

DBMS_LIBCACHE Package, xxx

DBMS_LIBCACHE package, 9-9

dbs directory, A-3

default user names

expiration of, xxx

deleting databases

with the DBCA, 4-17

devices

minimum configuration requirements, 2-2

directory structure, A-1 to A-5, B-1

UNIX, A-2

Windows, A-4

DISABLE THREAD clause, 5-7

disabling

the archive history, 5-3

threads, 5-7

dropping redo log files

manual archiving, 5-7

restrictions, 5-8

DRSYS tablespace

description, 8-6

raw device, 2-6

Edit User Preferences dialog box, 7-9

environment variable

for raw devices, 2-11

UNIX, 3-2

errors

messages, rollback segment, 5-5

Oracle Enterprise Manager discovery, B-2

EXAMPLE tablespace

raw devices, 2-6

example1

identifying on UNIX, 2-9

exclusive mode

media recovery, 5-2

Export utility, 10-4

FAILOVER parameter, 9-10

FAILOVER_MODE parameter, 9-2

for Transparent Application Failover, 9-2

features, new, xxviii

files

dropping, 5-7, 5-8

renaming, 5-8

General Purpose

description of configuration type, 3-4

global database name, 4-9

Global Services Daemon (GSD), 5-11

global V$ view tables, 7-1

GLOBAL_DBNAME parameter, 8-11

groups

MAXLOGFILES, 5-2

redo log files, 5-2, 5-8

GSD, defined, 7-2

hardware requirements, 1-6

high availability

configuring, 9-1 to 9-11

primary and secondary instances, 9-6

Transparent Application Failover, 9-2

host.equiv file, 2-12

Import utility, 10-5

INDX tablespace

described, 8-5

raw device, 2-6

initdb_name.ora file

ACTIVE_INSTANCE_COUNT parameter, 9-6

creating, 5-14

initialization parameter files

creating for database creation, 5-14

editing before database creation, 5-15

for instances, 6-2

initsid.ora file

creating, 5-14

installation

directory structure, A-1 to A-5, B-1

ldap.ora file, 8-12

listener.ora file, 8-10

overview, 1-3, 1-5

pre-installation, 2-12

processing of the DBCA, 3-6

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-13

verifying raw devices, 4-3

installing

Oracle Enterprise Manager, 7-7

with Oracle Universal Installer, 3-2

Instance Management, xxix

INSTANCE_ROLE

for Transparent Application Failover, 9-2

use of in secondary instance connections, 9-8

instances

adding instances, 5-2

initialization parameter files, 6-2

maximum number, 5-2

recovery, 5-2

recovery, starting another instance, 5-2

SID Prefix, 3-7, 3-9

thread number, 5-6

Instances Logon dialog box, 7-11

interconnects

supported for Real Application Clusters, 1-7

ldap.ora file, 8-12

creating, 8-12

default configuration, 8-12

library cache

warming, xxx, 9-9

listener.ora file, 8-10

default configuration, 8-10

Oracle Enterprise Manager service discovery, B-3

Server Management requirements, 7-4

sid_DESC parameter, B-4

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

listeners

GLOBAL_DBNAME parameter, 8-11

listener.ora file, 8-10

LOAD_BALANCE parameter, 9-10

log history, 5-2

log switches

adding or dropping files, 5-8

manual archiving

dropping a redo log file, 5-7

MAXDATAFILES clause, 5-3

MAXDATAFILES parameter, 5-3

MAXINSTANCES clause, 5-2

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-3

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-20

single instance to Real Application Clusters, 10-2

to Real Application Clusters with raw devices, 10-6

to Real Application Clusters with shared file systems, 10-6

multi-instance database

reasons not to convert to, 10-2

requirements, 10-2

multiple Oracle homes

UNIX, 4-21

Windows, 4-21

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-3

sqlnet.ora, 5-18, 8-17

testing, 9-11

tnsnames.ora, 5-18, 8-13

Oracle Enterprise Manager service discovery, B-4

network directory, A-2, A-4

new features, xxviii

nmiconf.log file, B-6

OPS_INSTANCE entry, B-5

OPS_INSTANCE entry in services.ora file, B-5

Optimal Flexible Architecture (OFA), 3-6, 4-2

Oracle Cluster Setup Wizard, xxviii

Oracle Database Configuration Assistant

control files, 8-7

creating Real Application Clusters database

after installation, 4-3

during installation, 3-6, 4-2

datafiles, 8-5

deleting databases with, 4-17

deleting Real Application Clusters databases, 4-17

initialization parameter files, 8-8

new features, xxix

processing during installation, 3-6

raw devices for, 2-3

redo log files, 8-7

rollback segments, 8-8

shared server configuration, 8-8

tablespaces, 8-5

troubleshooting, 4-5

using, 4-2

Oracle Enterprise Manager

architecture, 7-5

Configuration Assistant, 7-7

configuring, 7-10, 7-11

repository, 7-7

described, 7-2

GSD, 7-2

installing repository database, 7-7

nmiconf.log file, B-6

oratab file requirements, 5-12

preferred credentials, 7-8

repository database

configuring, 7-7

Server Management

Communication Daemon, 7-2

service discovery, B-2

services.ora file, B-5

setup scenarios, 7-5

sid_LIST_listener_name parameter in listener.ora file, 5-18, 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 Intelligent Agent, 1-4

Oracle Managed Files

requirements for using, 1-6

Oracle Parallel Server Management

configuring, 7-1

Oracle Performance Manager

accessing Oracle Parallel Server charts, 7-11

configuring, 7-10

Databases folder, 7-12

Parallel Server Instance folder, 7-11

Oracle Universal Installer, 3-2

for Real Application Clusters, 3-1

new features, xxix

overview of processing, 1-3

starting, 3-2

ORACLE_PSRV environment variable, B-6

ORACLE_SID

environment variable, 5-12

OracleCMService service, 4-20

OracleServicesid service, 5-13

ORAPWD utility, 5-16

orapwsid file, 5-15

parameters

database creation, 5-2

initialization, 6-1

password files, 5-15

Performance Manager

overview of, 1-4

preconfigured database installation types, 3-5

preferred credentials, 7-8

creating an operating system account, 7-9

database, 7-8

nodes, 7-8

pre-installation, 2-12

raw device creation, 2-3 to 2-13

preinstallation

on UNIX, 2-11

primary and secondary instances

client configuration, 9-7

connecting to secondary instances, 9-8

initdb_name.ora file configuration, 9-7

listener configuration, 9-8

overview, 9-6

private rollback segments, 5-5

creating, 5-5

private threads, 5-7

public rollback segments, 5-5

bringing online, 5-6

creating, 5-5

owner, 5-5

specifying, 5-6

using by default, 5-5

PUBLIC threads, 5-7

pwdsid.ora file, 5-15

RAC_DATABASE entry, B-5

RAC_DATABASE entry in services.ora file, B-5

raw devices, 2-2

configuration raw device, 2-2

configuring, 2-7

control files, 2-6

creating

on UNIX, 2-7

on Windows, 2-12

datafiles, 2-5

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

redo thread_number database object, 2-9, 2-10

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

db_name_control2 symbolic link, 2-13, 8-7

db_name_cwmlite1, 2-13

db_name_drsys1 symbolic link, 2-13, 8-6

db_name_indx1 symbolic link, 2-13, 8-6

db_name_rbs1 symbolic link, 8-6

db_name_redo thread_number symbolic link, 2-13

db_name_redothread_number symbolic link, 8-7

db_name_spfile1 symbolic link, 2-13, 8-6

db_name_system1 symbolic link, 2-13, 8-6

db_name_temp1 symbolic link, 2-13, 8-6

db_name_tools1 symbolic link, 2-13, 8-6

db_name_users1 symbolic link, 2-13, 8-6

identifying on Windows, srvcfg, 2-13

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

INDX tablespace, 2-6

new requirements, xxviii

redo log files, 2-6

server parameter files, 2-5

setting up, 2-3 to 2-13

srvcfg, 2-6

SYSTEM tablespace, 2-5

TEMP tablespace, 2-5

TOOLS tablespace, 2-6

UNDOTBS tablespace, 2-5

USERS tablespace, 2-5

verification, 4-3

raw devices CWMLITE tablespace, 2-6

raw volumes

on UNIX, configuring, 2-7

RBS tablespace

description, 8-5

Real Application Clusters

components, 1-2

databases, backing up, 5-17

databases, creating

with manual methods, 5-8

databases, deleting, 4-17

databases, password files, 5-15

hardware requirements, 1-6

installation requirements, 1-5

installed components of, 1-5

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

pre-installation, 2-12

raw device setup, 2-3 to 2-13

reasons to convert to, 10-2

software requirements, 1-6

recovery

archive history, 5-2

instance, 5-2

starting another instance, 5-2

redo log files, 1-5, 2-2

described, 8-7

identifying on UNIX, 2-9

raw devices, 2-6

reconfiguring, 5-8

redo log groups, creating, 5-7

registry

PM\db_name key, B-3

repository database

installing, 7-7

requirements

for installing Real Application Clusters, 1-5

tablespace sizes, 2-5

restrictions

changing the redo log, 5-8

.rhosts file, 2-12

rollback segments, 5-4

contention, 5-4

described, 8-8

ID number, 5-5

multiple, 5-4

name, 5-5

public, 5-6

public versus private, 5-6

specifying, 5-5

tablespace, 5-4, 5-5

ROLLBACK_SEGMENTS parameter

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

root, 2-11

segments

ID number, 5-5

server configuration

raw device for, 2-2

Server Management

architecture, 7-2

GSD process, 7-2

node requirements, 7-4

Oracle Enterprise Manager, 7-2

overview of, 1-4

requirements, 7-4

SIDs, 7-4

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

creating, 6-7

raw devices, 2-5

service discovery

db_name.conf file, B-3

errors, B-2

listener.ora file, B-3

nmiconf.log file, B-6

on UNIX, B-3

on Windows NT, B-3

PM\db_name registry key, B-3

services.ora file, B-5

sid_LIST_listener_name parameter, B-4

tnsnames.ora file, B-4

understanding, B-2

services

OracleCMService, 4-20

services.ora file, B-5

shared disk storage subsystem, 2-2

shared disks

configuring, 2-1

shared server

configuring, 8-8

connection load balancing, 8-8, 8-9

dispatchers, 8-8

shutting down a Server database

with SYSDBA privilege, 7-10

with SYSOPER privilege, 7-10

sid Prefix, 3-7, 3-9

sid_DESC parameter, B-4

sid_LIST_listener_name parameter, 5-18, 7-4

Software Only

configuration type, description of, 3-4

software requirements, 1-6

spfile1

identifying on UNIX, 2-9

sqlnet.ora file, 5-18, 8-17

default configuration, 8-17

srvcfg

raw devices, 2-6

srvcfg raw device

identifying, 2-13

SRVCTL Utility, 1-4, 5-11, 7-2

architecture on UNIX, 7-3

srvm\admin directory, A-4

SRVM_SHARED_CONFIG

environment variable, 3-2

srvm/admin directory, A-3

startup

during instance recovery, 5-2

rollback segments, 5-5

SYSDBA privilege, 7-10

SYSOPER privilege, 7-10

SYSDBA privilege, 7-10

SYSDBA privilege, granting, 7-9

SYSOPER privilege, 7-10

SYSOPER privilege, granting, 7-9

SYSTEM tablespace, 5-4

description, 8-5

raw device, 2-5

tablespaces

control files, 2-6

CWMLITE, 2-6, 8-6

DRSYS, 2-6, 8-6

EXAMPLE, 2-6, 8-6

expanding for large sorts, 8-5

INDX, 2-6, 8-5

RBS, 8-5

recommended sizes of, 2-5

rollback segment, 5-4, 5-5

server parameter file, 2-5

server parameter file (SPFILE), 8-5

srvcfg, 2-6

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

TEMP, 2-5, 8-5

TOOLS, 2-6, 8-6

undo tablespaces for automatic undo management, 8-5

USERS, 2-5, 8-5

tablespaces UNDOTBS, 2-5

TAF

configuring, 9-2

GLOBAL_DBNAME parameter in listener.ora file, 8-12

overview, 9-2

pre-establishing a connection, 9-4

retrying a connection, 9-4

with client load balancing, 9-3

with connect-time failover, 9-3

TEMP tablespace

described, 8-5

raw device, 2-5

Template Management, xxix

testing the network, 9-11

THREAD clause, 5-7

disabling a thread, 5-7

when required, 5-7

THREAD parameter, 5-6

threads

associated with an instance, 5-6

changing from public to private, 5-7

creating, 5-6

disabled, 5-7

disabling, 5-7

public, 5-6, 5-7

tnsnames.ora file, 5-18, 8-13

default configuration, 8-13

FAILOVER parameter, 9-10

FAILOVER_MODE, 9-2

LOAD_BALANCE parameter, 9-10

service discovery, B-4

TOOLS tablespace

described, 8-6

raw device, 2-6

Transaction Processing

description of configuration type, 3-4

Transmission Control Protocol/Interconnect Protocol (TCP/IP)

for Real Application Clusters, 1-7

Transparent Application Failover

configuring, 9-2

GLOBAL_DBNAME parameter in listener.ora file, 8-12

overview, 9-2

pre-establishing a connection, 9-4

retrying a connection, 9-4

with client load balancing, 9-3

with connect-time failover, 9-3

troubleshooting

Oracle Database Configuration Assistant, 4-5

service discovery, B-2

UNDOTBS tablespace

raw devices, 2-5

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-20

user

PUBLIC, 5-5

User Datagram Protocol (UDP)

for Real Application Clusters, 1-7

user names

default, expiration of, xxx

USERS tablespace

described, 8-5

raw device, 2-5

V$SESSION table, 9-6

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, xxx, 9-9