Oracle9i Real Application Clusters Administration -- Index

abort mode, warning notice, 5-9

ACTIVE_INSTANCE_COUNT parameter, 2-14

Adding an Instance page, 8-16

adding nodes to a cluster, 8-2

administering instances

with Server Management, 5-2

administration

issues, general, 1-2

with SQL and SQL*Plus, 4-15

with SRVCTL, 4-2

affinity

awareness, 7-3

ALERT file, 7-11

alert log

managing, 3-9

alert logs, A-3

ALLOCATE EXTENT option

DATAFILE option, B-3

instance number, B-2

INSTANCE option, B-3

SIZE option, B-3

allocation

free space, B-3

sequence numbers, 3-10

ALTER DATABASE ADD LOGFILE statement, 4-21

ALTER DATABASE statement

CLOSE clause, 4-21

ALTER ROLLBACK SEGMENT statement, 3-5

ALTER SESSION statement

SET INSTANCE clause, B-3

ALTER SYSTEM ARCHIVE LOG CURRENT statement, 4-21

ALTER SYSTEM ARCHIVE LOG statement, 4-21

THREAD clause, 4-21

ALTER SYSTEM CHECK DATAFILES statement

instance recovery, 7-11

ALTER SYSTEM CHECKPOINT LOCAL statement, 4-21

ALTER SYSTEM CHECKPOINT statement

global versus local, 4-21

specifying an instance, 4-21

ALTER SYSTEM SWITCH LOGFILE statement, 4-21

ARCHIVE LOG command, 4-22

archive logging

enabling, 6-13

archive logs

file format and destination, 6-12

ARCHIVE_LOG_TARGET parameter, 2-13

archiving redo log files

identified in control file, 3-8

log sequence number, 6-12

Automatic Undo Management, 2-18, 3-2

using, 3-2

automatic undo management

overriding, 3-6

using, 3-2

availability

datafiles, 7-11

single-node failure, 7-10

steps of recovery, 7-11

background processes

SMON, 4-20, 7-10

background thread trace files, A-2

BACKGROUND_DUMP_DEST parameter, A-2, A-3

backups

general information about, 1-3

blocks

associated with instance, 7-10, B-3

buffer cache

instance recovery, 7-10

cache

sequence cache, 3-9, 3-10

CACHE option, CREATE SEQUENCE, 3-10

CHECK DATAFILES clause

instance recovery, 7-11

client-side parameter files

naming conventions, 2-6

using, 2-6

Cluster Command Error Messages (PRKC), C-4

Cluster Database

Destination Type tasks, 5-18

Cluster Database Instances folder

in Console Navigator window, 5-5

Cluster Database Management Error Messages (PRKP), C-11

Cluster Database Operation Results dialog box, 5-10

Cluster Database Shutdown dialog box, 5-9

Cluster Database Shutdown Progress dialog box, 5-10

Cluster Database Started message box, 5-8

Cluster Database Startup dialog box, 5-7

Cluster Database Startup Results dialog box, 5-8

Cluster Database Startup/Shutdown Results dialog box, 5-10

Cluster Database Stopped message box, 5-10

Cluster databases

disconnecting from, 5-9

cluster databases

displaying objects in Console, 5-3

Cluster Manager (CM)

software, 4-15

Cluster Setup for Windows NT Error Messages (PRKI), C-7

CLUSTER_DATABASE parameter, 2-15

CLUSTER_DATABASE_INSTANCES parameter, 2-15

CLUSTER_INTERCONNECTS parameter, 2-14, 2-16

clusterware layer

adding a node, 8-3

comments

specifying in server parameter file, 2-5

committed data

instance failure, 7-10

sequence numbers, 3-10

common parameter files

using multiple, 2-11

concurrency

maximum number of instances, B-2

sequences, 3-10

Confirmation dialog, 8-26

CONNECT command, 4-18, 4-19, 4-22

connect strings, 4-19

CONNECT SYS

example of, 2-20

connecting

to instances, 4-17

to remote instances, 4-18

connecting to instances, 4-17

Console

Navigator window with Cluster Database objects, 5-3

right-mouse menu, 5-7

Edit, 5-13

Related Tools, 5-7

Results, 5-7, 5-10

Shutdown, 5-7, 5-9

Startup, 5-7

View Edit Details, 5-7

scheduling jobs, 5-16

setting Cluster Database events, 5-22

starting Oracle Cluster Database database, 5-7

stopping database, 5-9

viewing Cluster Database status, 5-13

viewing shutdown results, 5-10

viewing startup results, 5-10

Console, starting, 5-2

contention

sequence number, 3-9

control files

MAXLOGHISTORY, 3-8

CONTROL_FILES parameter, 2-13

same for all instances, 2-13

CREATE DATABASE statement

MAXINSTANCES clause, B-2

MAXLOGHISTORY clause, 3-8

Create Job property sheet, 5-16, 5-21

General tab, 5-17

Parameters tab, 5-18

Tasks tab, 5-18

CREATE SEQUENCE statement, 3-9, 3-10

CACHE clause, 3-10, 3-11

CYCLE clause, 3-10

description, 3-9

ORDER clause, 3-10

CREATE TABLE statement

FREELIST GROUPS clause, B-3

FREELISTS clause, B-3

creating

SPFILE, 2-2

CYCLE option, CREATE SEQUENCE, 3-10

data dictionary

sequence cache, 3-10

database

number of archived log files, 3-8

number of instances, B-2

quiescing, 4-21

Database Configuration Assistant

Adding an Instance page, 8-16

adding instances, 8-10

and log files, 3-8

Confirmation dialog, 8-26

Database Storage page, 8-17

deleting instances, 8-21

Error dialog, 8-24

Instance Management page, 8-13, 8-21

List of Cluster Database Instances page, 8-15, 8-23

List of Cluster Databases page, 8-14, 8-22

Operations page, 8-12

placement of IFILE parameter, 2-10

Summary dialog, 8-19, 8-25

troubleshooting, 8-11

Welcome page, 8-11

Database Storage page, 8-17

datafiles

access for instance recovery, 7-11

adding, 3-2

instance recovery, 7-11

DB_BLOCK_SIZE parameter, 2-13

same for all instances, 2-13

DB_DOMAIN parameter, 2-13

DB_FILES parameter, 2-13

same for all instances, 2-13

DB_NAME parameter, 2-8, 2-13, 2-16

same for all instances, 2-13

DISCONNECT command, 4-19

disconnecting from instances, 4-19

multiple sessions, 4-21

user process, 4-20

DISPATCHERS parameter, 2-17

for the shared server, 2-17

distributed resources

sequence, 3-9

DML_LOCKS parameter, 2-13, 2-17

Edit Cluster Database dialog box, 5-13

Error dialog, 8-24

error messages

for management tools, C-1

parameter values, 2-21

errors

call trace stack, A-3

ORA-600, A-5

exclusive mode

specifying thread number, 2-21

export

raw device configuration information, 4-14

failure

access to files, 7-11

instance, 7-10

instance recovery, 7-11

multiple node, 7-11

node, 7-10

features, new, xxix

file management, 3-2

files

ALERT, 7-11

archiving redo log, 6-12

control file, 3-8

redo log, 6-12

FORCE mode, warning notice, 5-8

foreground processes

instance shutdown, 4-20

free list groups

assigned to instance, B-2

free lists, B-3

free space

managing with SQL, B-3

FREELIST GROUPS

storage option, instance number, B-2

FREELIST GROUPS option, B-2

GC_FILES_TO_LOCKS parameter, 2-14

GCS

recovery steps, 7-11

General tab, from Create Job property sheet, 5-17

Global Cache Service resource

sequence, 3-9

GLOBAL clause

forcing a checkpoint, 4-21

global constant parameters

same for all instances, 2-13

Global Services Daemon (GSD), 4-3

Global Services Daemon Error Messages (PRKA), C-2

Globalization Support parameters, 2-18

groups

redo log files, 3-7

unique numbers, 3-8

V$LOGFILE, 3-8

GSD

as a background process for manageability tools, 4-3

UNIX implementation of, 4-4

Windows implementation of, 4-4

gsdctl -remove

to stop and delete services, 4-14

gsdctl -start

to start services, 4-14

HOST command, 4-22

IFILE parameter

multiple files, 2-11

overriding values, 2-10

specifying identical parameters, 2-20

import

raw device configuration information, 4-14

initdb_name.ora file

BACKGROUND_DUMP_DEST parameter, A-2, A-3

DB_NAME parameter, 2-8

USER_DUMP_DEST parameter, A-3

initdb_name.ora file

described, 2-9

initialization parameter files

definition, 2-7

for instances, 2-2

initdb_name.ora, 2-9

initsid.ora, 2-8

initialization parameters

cluster database issues regarding, 2-15

duplicate values, 2-10

identical for all instances, 2-13

RECOVERY_PARALLELISM, 7-17

setting for cluster databases, 2-12

that must be identical on all instances, 2-13

that must be unique on all instances, 2-14

init.ora file

defined, 2-7

initsid.ora file

described, 2-7

initsid.ora file

described, 2-8

INSTANCE clause

SHOW INSTANCE command, 4-19

Instance Management page, 8-13, 8-21

INSTANCE_NAME parameter, 2-14

unique values for instances, 2-17

INSTANCE_NUMBER

setting, 2-21

INSTANCE_NUMBER parameter, 2-14, 2-21

and SQL options, B-3

exclusive or shared mode, 2-21

recommended settings for, 2-21

unique values for instances, 2-21

instances

adding at the Oracle layer, 8-10

associated with data block, B-3

associating with free list groups, B-2

connecting to, 4-17

current, 4-19

deleting with the DBCA, 8-21

failure, 7-11

failures, recovery from, 7-10

initialization parameter files, 2-2

initsid.ora file, 2-7

instance number, B-2

maximum number, B-2

recovery, 4-20, 7-10

recovery, abnormal shutdown, 4-20

recovery, access to files, 7-11

recovery, datafile access, 7-11

recovery, multiple failures, 7-11

remote, 2-20, 4-19

Server Management, 5-2

setting, 4-17

shutting down, 4-20

sid, 2-8

startup and shutdown results, 5-10, 5-14

startup order, 2-21

thread number, 2-21

verifying, 4-19

jobs

choosing tasks for, 5-18

creating for cluster database, 5-16

setting up rights for running, 5-20

specifying information for, 5-17

specifying parameters for server management tasks, 5-18

List of Cluster Database Instances page, 8-15, 8-23

List of Cluster Databases page, 8-14, 8-22

LISTENER

parameter for the shared server, 2-17

LOCAL clause

forcing a checkpoint, 4-21

local instances

nodes, 4-19

log sequence numbers, 6-12

log switches, 3-8

LOG_ARCHIVE_DEST parameter, 2-13, 6-5

specifying for recovery, 6-5

LOG_ARCHIVE_DEST_n parameter, 6-13

LOG_ARCHIVE_FORMAT parameter, 2-17, 6-12, 6-13

same for all instances, 6-5

used in recovery, 6-5

LOG_ARCHIVE_START parameter

automatic archiving, 2-11

LSNRCTL utility

START command, 4-15, 4-16

Massively Parallel Processing System, B-2

MAX_COMMIT_PROPAGATION_DELAY parameter, 2-13, 2-18

MAXEXTENTS storage parameter

automatic allocations, B-4

MAXINSTANCES clause, B-2

MAXINSTANCES option, B-2

MAXINSTANCES parameter, B-3

assigning free lists to instances, B-2

MAXLOGHISTORY option, 3-8

media failures

recovery from, 7-13

memory

SGA, 3-10

messages

access to files, 7-11

ALERT file, 7-11

errors for management tools, C-1

instance shutdown, 4-20

MINEXTENTS storage parameter

automatic allocations, B-4

modified data

instance recovery, 7-10

modulo, B-2

multiple node failures, 7-11

multiple nodes

starting from one node, 2-20

multiplexed redo log files, 3-7

example, 3-8

naming conventions

for client-side parameter files, 2-6

Navigator window

Cluster Database Instances folder, 5-5

Cluster Database objects, 5-3

right-mouse menu, 5-7, 5-10

Edit, 5-13

Related Tools, 5-7

Results, 5-7

Shutdown, 5-7, 5-9

Startup, 5-7

View Edit Details, 5-7

setting Cluster Database events, 5-22

starting Oracle Cluster Database database, 5-7

stopping database, 5-9

viewing Cluster Database status, 5-13

viewing shutdown results, 5-10

viewing startup results, 5-10

new features, xxix

nodes

adding at the clusterware layer, 8-3

adding at the Oracle layer, 8-9

adding to cluster, 8-2

affinity awareness, 7-3

failure of, 7-10

local, 2-20

remote, 4-19

NOORDER option, CREATE SEQUENCE, 3-10

number generator, 3-9

online recovery, 7-10, 7-11

online redo log files

thread of redo, 2-21

operating system

privileges, 4-22

operating system-specific Oracle documentation

archived redo log name, 6-12

Operations page, 8-12

ORA-600, A-5

Oracle Cluster Databases

shutdown, 5-10

Oracle Cluster Databases databases

mounting, 5-8

Oracle Enterprise Manager

Events

Cluster Database events, 5-22

performing administration with, 1-3

scheduling jobs, 5-16

starting

Oracle Cluster Database, 5-7

stopping database, 5-9

viewing

Cluster Database status, 5-13

shutdown results, 5-10

startup results, 5-10

Oracle layer

adding a node, 8-9

Oracle Real Application Clusters

creating a job on, 5-16

ORACLE_SID parameter, 2-14

Oracle8i

upgrading to Oracle9i, 4-14

Oracle9i

upgrading from Oracle8i, 4-14

Oracle9i Real Application Clusters

overview, 1-1

oraxxxxx.trc file, A-3

ORDER option, 3-10

Output tab

from Cluster Database Operation Results dialog box, 5-13

parallel mode

sequence restrictions, 3-11

parallel recovery, 7-17

PARALLEL_MAX_SERVERS parameter, 7-17

Parameter, 2-1

parameter files

client-side, using, 2-6

common file, 2-20

duplicate values, 2-10

instance-specific, 2-12

location, 2-12

PFILE, 2-20

remote instance, 2-20

remote instances, 4-19

server file, backing up, 2-2

server file, exporting, 2-4

server file, setting parameters in, 2-2

server file, using, 2-2

parameters

database creation, B-2

initialization, 2-2, 3-1

instance-specific settings in server parameter file, 2-5

management of, 1-2

setting for cluster databases, 2-12

that must be identical on all instances, 2-13

types of, 2-12

Parameters tab

from Create Job property sheet, 5-18

performance

caching sequences, 3-10

sequence numbers, 3-10

private rollback segments, 2-14, 3-4

specifying, 3-5

PRKA messages, C-2

PRKC messages, C-4

PRKI messages, C-7

PRKO

messages, C-8

PRKP

messages, C-11

PRKR, C-14, C-15

messages, C-14

PROCESSES parameter, 2-18

PROTOCOL

parameter for the shared server, 2-17

public rollback segments, 3-5

quiesce database

in Real Application Clusters, 4-21

raw device configuration information

export, 4-14

import, 4-14

Real Application Clusters

initialization parameter files, 2-7

Real Application Clusters databases

starting, 4-15

RECOVER command, 4-22, 7-17

recovery

access to files, 7-11

after SHUTDOWN ABORT, 4-20

from multiple node failure, 7-11

from single-node failure, 7-10

general information about, 1-3

instance, 4-20, 7-10

media failures, 7-13

online, 7-10

parallel, 7-17

PARALLEL_MAX_SERVERS parameter, 7-17

steps of, 7-11

RECOVERY_PARALLELISM parameter, 2-18, 7-16, 7-17

redo log files

identified in control file, 3-8

instance recovery, 7-10

log sequence number, 6-12

using, 3-7

redo log groups, 3-7

redo logs

format and destination specifications, 6-12

remote instances, 2-20, 4-19

Repository Error Messages (PRKR), C-14

resources

associating with free list groups, B-2

releasing, 7-10

restrictions

cached sequence, 3-11

RETRY option

STARTUP PARALLEL command, 4-17

rollback segments

private, 3-4

public, 3-5

SYSTEM, 3-4

ROLLBACK_SEGMENTS parameter, 2-14, 2-18, 3-5

rolling back

instance recovery, 7-10

ROW_LOCKING parameter, 2-13

scalability

adding instances, 8-10

adding nodes, 8-3

adding nodes and instances, 8-1

general information about, 1-3

Select Instances to Start dialog box, 5-8

Select Instances to Stop dialog box, 5-10

sequence number generator, 3-9

distributed resources, 3-9

in Real Application Cluster databases, 3-9

restriction, 3-11

skipping sequence numbers, 3-10

sequences

CACHE option, 3-10

data dictionary cache, 3-9, 3-10

log sequence number, 6-12

not cached, 3-11

ORDER option, 3-10

timestamp, 3-10

SERIALIZABLE parameter, 2-13

Server Control

using, 4-2

Server Control (SRVCTL) Utility Error Messages (PRKO), C-8

Server Management

administration of instances, 5-2

server parameter file

backing up, 2-2

exporting, 2-4

instance specific settings, 2-5

setting values in, 2-2

using, 2-2

SERVICE_NAMES parameter, 2-13

sessions

multiple, 4-19, 4-21

SESSIONS_PER_USER parameters, 2-19

SET INSTANCE command, 2-20, 4-18

example of, 2-20

instance startup, 4-19

setting instances, 4-17

shared mode

instance number, 2-21

instance recovery, 7-10

shared server

parameters for, 2-17

SHOW INSTANCE command, 4-19, 4-22

SHOW PARAMETER command, 4-22

SHOW PARAMETERS command, 4-22

example of, 2-21

SHOW SGA command, 4-22

SHUTDOWN ABORT command, 4-20

SHUTDOWN command, 4-22

ABORT option, 4-20, 4-21

IMMEDIATE option, 4-21

specifying an instance, 4-19

SHUTDOWN TRANSACTIONAL, 4-20

shutdown types, 5-9

abort, 5-9

immediate, 5-9

normal, 5-9

shutdown database and other services, 5-10

shutdown database only, 5-10

shutting down

a cluster database, setting parameters, 5-21

instances, 4-20

shutting down a database

viewing results, 5-10

shutting down an instance

abnormal shutdown, 4-20

lost sequence numbers, 3-10

shutting down an Oracle Cluster Database, 5-10

shutting down instances, 4-20

sidalrt.log file, A-3

siddbwr.trc file, A-2

sidlckn.trc file, A-2, A-4

sidlmdn.trc file, A-2

sidlmon.trc file, A-3

sidp00n.trc file, A-3

sidsmon.trc file, A-2

SMON process

instance recovery, 7-10, 7-11

recovery after SHUTDOWN ABORT, 4-20

SPFILE

creating, 2-2

parameter, 2-19

SQL statements

instance-specific, 4-21

SQL*Plus sessions

multiple, 4-21

SRVCONFIG

importing and exporting raw device configuration with, 4-14

SRVCTL utility

using, 4-2

using to administer instance configurations, 4-4

start services

with gsdctl -start, 4-14

start up

remote instance, 4-19

starting

listener, 4-15, 4-16

Oracle Cluster Database, 5-7

Real Application Clusters database, 4-15

Starting the EM Console, 5-2

startup

and parameters, 2-19

on remote nodes, 2-20

remote instance, 2-20

results, 5-10

setting cluster database parameters for, 5-19

startup order, 2-21

STARTUP command, 2-20, 4-22

specifying an instance, 4-19

startup types, 5-7

force, 5-8

mount, 5-8

no mount, 5-8

open, 5-8

restrict, 5-8

Status Details tab, 5-11

from Cluster Database Operation Results dialog box, 5-11

Status tab

from Edit Cluster Database dialog box, 5-14

stop and delete services

with gsdctl, 4-14

stopping

database, 5-9

storage

administering, 1-2

Summary dialog, 8-19, 8-25

SYSDBA

privilege for connecting, 4-19

SYSDBA privilege, 5-20

SYSOPER privilege, 5-20

for connecting, 4-19

system change numbers

archive file format, 6-12

System Global Area (SGA)

sequence cache, 3-10

SYSTEM rollback segment, 3-4

tables

allocating extents, B-3

tablespaces

switching for undo, 3-3

Tasks tab

from Create Job property sheet, 5-18

THREAD clause, 4-21

THREAD parameter, 2-14, 2-19

threads

archive file format, 6-12

example, 3-7

exclusive mode, 2-21

number of groups, 3-7

of redo, 3-7

trace files, A-2

background thread trace files, A-2

error call trace stack, A-3

managing, 3-9

oraxxxxx.trc, A-3

sidalrt.log, A-3

siddbwr.trc file, A-2

sidlckn.trc, A-2, A-4

sidlmdn.trc, A-2

sidlmon.trc, A-3

sidp00n.trc, A-3

sidsmon.trc file, A-2

transactions

instance failure, 7-10

rolling back, 7-10

sequence numbers, 3-9

waiting for recovery, 7-10

troubleshooting, A-1 to A-5

Database Configuration Assistant, 8-11

general information about, 1-4

trace files, A-2

undo tablespace

switching, 3-3

UNDO_MANAGEMENT parameter, 3-2, 3-6

UNDO_TABLESPACE parameter, 2-14, 3-3

upgrading

Oracle8i configurations to Oracle9i, 4-14

user processes

associating with free lists, B-3

free lists, B-3

instance shutdown errors, 4-20

user trace files, A-3

USER_DUMP_DEST parameter, A-3

users

associating with free list groups, B-2

V$ACTIVE_INSTANCES, 4-19

V$ACTIVE_INSTANCES table, 5-14

V$LOGFILE view, 3-8

Welcome page, 8-11