Oracle9i Real Application Clusters Installation and Configuration
Release 1 (9.0.1)

Part Number A89868-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

Index

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


A

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

B

backups
after creating new databases, 5-17
before database creation, 5-9
conversion to multi-instance, 10-3

C

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

D

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

E

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

F

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

G

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

H

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

I

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

L

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

M

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

N

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

O

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

P

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

R

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

S

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

T

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

U

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

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

W

warming the cache, xxx, 9-9

Go to previous page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback