Index

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

---

Symbols

\database directory, A-4

\network directory, A-4

\ops directory, A-4

\opsm\admin directory, A-4

---

A

abort mode, warning notice, 7-10

ACTIVE_INSTANCE_COUNT parameter, 5-6

adding nodes to a cluster, 9-7

administering instances

with initialization parameter files, 4-4

with Oracle Parallel Server Management, 7-2

alert logs, C-10

ALTER DATABASE ADD LOGFILE statement, 9-4

applications

converting to multi-instance, 9-3

architecture

OPSCTL utility on UNIX, 6-4

OPSCTL utility on Windows NT, 6-5

Optimal Flexible Architecture (OFA), 1-8, 1-9

Oracle Enterprise Manager, 6-7

Oracle Parallel Server, 1-2

Oracle Parallel Server Management, 6-2

archive log destinations

conversion to multi-instance, 9-3

multiple

on UNIX, 4-15

on Windows NT, 4-16

shared

on UNIX, 4-10

on Windows NT, 4-12

---

B

BACKGROUND_DUMP_DEST parameter, 4-7, C-9, C-10

BACKUP parameter, 5-3

backups

after creating new databases, 3-39

Backup Wizard, 4-16

before database creation, 3-32

consistent, 4-16

conversion to multi-instance, 9-3

Recovery Manager, 4-9

boldface, defined, xvii

brackets, defined, xvii

---

C

client load balancing

configuring, 4-2

described, 4-2

with TAF, 5-4

with Transparent Application Failover, 5-4

Cluster Manager (CM)

described, 1-5

DefinedNodes registry value, 3-26

cluster, defined, 1-2

CM

described, 1-5

DefinedNodes registry value, 3-26

components, 4-3

Configuration Assistant, 6-10

configuring

archive logs for backup and recovery, 4-9 to 4-16

clients

client load balancing, 4-2

connect-time failover, 4-2

primary and secondary instances, 5-8

global database name, 3-4

high availability, 5-1 to 5-16

primary and secondary instances, 5-6

TAF, 5-2

Transparent Application Failover, 5-2

listeners

primary and secondary instances, 5-9

Oracle Enterprise Manager, 6-10 to 6-27

Oracle Intelligent Agents on UNIX, B-10 to B-11

Oracle Parallel Server Management, 6-1 to 6-34

Oracle Performance Manager, 6-27 to 6-34

primary and secondary instances, 5-6

Recovery Manager, 4-9 to 4-16

SID Prefix, 3-4

TAF, 5-2

Transparent Application Failover, 5-2

connecting

Oracle Enterprise Manager repository database, 6-28

Oracle Parallel Server database, 4-3

connection load balancing, 3-13

connect-time failover

configuring, 4-2

described, 4-2

GLOBAL_DBNAME parameter in listener.ora file, 3-15

with TAF, 5-4

with Transparent Application Failover, 5-4

Console

described, 2-3, 6-2

Event Management window, 6-2

Group window, 6-2

Job window, 6-2

Navigator window, 6-2

Navigator window with Oracle Parallel Server objects, 7-3

right-mouse menu, 7-5

Connect, 7-6

Disconnect, 7-6

Edit, 7-6, 7-16

Related Tools, 7-6

Remove, 7-6

Results, 7-6, 7-12

Shutdown, 7-6, 7-9

Startup, 7-6, 7-7

scheduling jobs, 7-19

setup, 6-7

starting, 6-12

starting Oracle Parallel Server database, 7-7

stopping Oracle Parallel Server database, 7-9

viewing Oracle Parallel Server status, 7-16

viewing shutdown results, 7-12

viewing startup results, 7-12

control files

described, 1-14

raw devices, 2-6

CONTROL_FILES parameter, 4-7

CREATE DATABASE OPS script, 3-38

Create Job property sheet, 7-20 to 7-25

General tab, 7-21

Parameters tab, 7-23

Tasks tab, 7-22

creating

db_name.conf file, B-2

initdb_name.ora file, 3-36

initialization parameter files, 3-12, 3-36

initsid.ora file, 3-12, 3-36

Oracle Enterprise Manager repository, 6-10

Oracle Parallel Server database

backing up the new database, 3-39

CREATE DATABASE OPS script, 3-38

db_name.conf file, 3-9, 3-33

during installation, 3-7

initdb_name.ora file, 3-36

initsid.ora file, 3-12, 3-36

ORACLE_SID environment variable, 3-35

OracleServicesid. service, 3-11, 3-35

oratab file, 3-9, 3-32

password files, 3-37

registry entries, 3-10, 3-33

with manual methods, 3-29

with Oracle Database Configuration Assistant, 3-7, 3-24

password files, 3-37

preferred credentials, 6-19

raw devices on UNIX, 2-7

raw devices on Windows NT, 2-9

crtsrv batch file, 3-35

curly brackets, defined, xvii

Custom database creation type, 1-11

Custom installation type, 3-2

---

D

data files, 1-3

described, 1-12

raw devices, 2-6

Data Warehousing database, 1-10

database creation during installation, 3-7

database, defined, 1-2

DB_DOMAIN parameter, 4-8

DB_NAME parameter, 1-15, 4-4, 4-7

db_name.conf file

creating, B-2

environ parameter, B-5

inst_init_ora parameter, B-5, B-7

inst_oracle_sid parameter, B-4, B-6

inst_sid_list parameter, C-4

instance parameters, B-6

listener configuration, B-8

lsnr_listener_name parameter, B-5, B-9, C-4

node#inst_init_ora parameter, B-5

node#tns_admin parameter, B-5

node_list parameter, B-4, C-3

oracle_home parameter, B-5

overview, B-2, B-10

parameter expansion, B-3

parameter syntax, B-3

parameters, B-4

parameters node overrides, B-6

sample, B-10

service discovery, C-3

tns_admin parameter, B-5, B-8

DBA Studio

described, 2-3

limitations, 6-34

DBCA_RAW_CONFIG environment variable, 2-9

/dbs directory, A-3

DBSNMP START command, 6-10

DefinedNodes registry value, 3-26

DELAY parameter, 5-3

directory structure, A-1 to A-4

UNIX, A-3

Windows NT, A-4

discovering nodes, 6-15

discovery

See service discovery

Discovery Wizard, 6-15

DRSYS tablespace

raw device, 2-6

DRSYS tablespace, description, 1-12

---

E

Edit Parallel Server dialog box, 7-16

Edit User Preferences dialog box, 6-25

ellipsis, defined, xvii

errors

call trace stack, C-11

ORA-600, C-12

ORA-9291, 4-16

Oracle Enterprise Manager discovery, C-2

exp utility, 9-5

export data from old database, 9-5

Export utility, 9-5

---

F

FAILOVER parameter, 4-2

FAILOVER_MODE parameter, 5-3

FORCE mode, warning notice, 7-8

---

G

General tab, from Create Job property sheet, 7-21

global database name, 1-2, 3-4, 3-27

global V$ view tables, 6-1, 8-2

GLOBAL_DBNAME parameter, 3-15

GUI, 6-12

GV$FILESTAT view, 8-9, 8-10, 8-11

GV$LICENSE view, 8-14, 8-15, 8-16, 8-17

GV$LOCK_ACTIVITY view, 8-12

GV$PING view, 8-5, 8-6, 8-8

GV$PROCESS view, 8-13

GV$SESSION view, 8-13

---

H

hardware requirements, 2-2

high availability

configuring, 5-1 to 5-16

primary and secondary instances, 5-6

TAF, 5-2

Transparent Application Failover, 5-2

host.equiv file, 2-11

---

I

IFILE parameter, 4-5

imp utility, 9-6

import data, 9-6

Import utility, 9-6

INDX tablespace

described, 1-12

raw device, 2-6

initdb_name.ora file

ACTIVE_INSTANCE_COUNT parameter, 5-6

BACKGROUND_DUMP_DEST parameter, 4-7, C-9, C-10

CONTROL_FILES parameter, 4-7

creating, 3-36

DB_DOMAIN parameter, 4-8

DB_NAME parameter, 1-15, 4-4, 4-7

described, 1-14, 4-6

LOCAL_LISTENER parameter, 3-6

MTS_DISPATCHER parameter, 4-8

SERVICE_NAMES parameter, 4-9

USER_DUMP_DEST parameter, 4-9, C-10

initialization parameter files

creating for database creation, 3-12, 3-36

definition, 4-4

editing before database creation, 3-36

for instances, 4-4 to 4-9

initdb_name.ora, 4-6

initsid.ora, 4-4

initsid.ora file

creating, 3-12, 3-36

described, 1-14, 4-4

IFILE parameter, 4-5

INSTANCE_NAME parameter, 1-15, 1-16, 4-5

LOG_ARCHIVE_DEST parameter, 4-11

REMOTE_LOGIN_PASSWORDFILE parameter, 4-5

ROLLBACK_SEGMENTS parameter, 1-16, 4-5

THREAD parameter, 1-16, 4-5

inst_init_ora parameter, B-5, B-7

inst_oracle_sid parameter, B-4, B-6

inst_sid_list parameter, C-4

installation

directory structure, A-1 to A-4

ldap.ora file, 3-16

listener.ora file, 3-14

Net8 Configuration Assistant, 3-6

Oracle Database Configuration Assistant, 3-7

Oracle Parallel Server database creation, 3-7

pre-installation, 2-1 to 2-12

repository database, 6-9

software requirements, 2-2

tnsnames.ora file, 3-16

verifying raw devices, 3-5, 3-7, 3-23

installation requirements, 2-2 to 2-5

disk space, 2-5

hardware, 2-2

hardware requirements, 2-2

Oracle Enterprise Manager, 2-3

shared disk partitions, 2-5

software, 2-2

installation type

Custom, 3-2

Minimal, 3-2

Typical, 3-2

installing

Operating System Dependent layer, 2-11, 9-5

Oracle Enterprise Manager, 6-9

Oracle Parallel Server, 3-3

with Custom installation type, 3-5

with Typical installation type, 3-5

Oracle8i Enterprise Edition, 3-3

with Oracle Universal Installer, 3-3

instance name, 1-15, 1-16

INSTANCE_NAME parameter, 1-15, 1-16, 3-18, 4-5

instances

adding to cluster, 9-7

control files, 1-3

data files, 1-3

db_name.conf file, B-6

described, 1-2

Destination Type tasks for, 7-23

initialization parameter files, 4-4 to 4-9

initsid.ora file, 1-14

instance name, 1-15, 1-16

INSTANCE_NAME parameter, 1-15, 1-16

Oracle Parallel Server Management, 7-2

Oracle System Identifier (SID), 1-15

ORACLE_SID environment variable, 1-15

ORACLE_SID registry entry, 1-15

rollback segments, 1-16

ROLLBACK_SEGMENTS parameter, 1-16

SID, 1-15, 4-4

SID Prefix, 3-4, 3-27

startup and shutdown results, 7-12, 7-17

thread ID, 1-16

THREAD parameter, 1-16

verifying, 3-42

Inter-Process Communication (IPC)

described, 1-5

Introduction, 1-1

italic, defined, xvii

---

J

jobs

choosing tasks for, 7-22

creating for Oracle Parallel Server, 7-19

setting up rights for running, 7-24

specifying information for, 7-21

specifying parameters for OPSM tasks, 7-23

---

L

ldap.ora file, 3-16

creating, 3-16

default configuration, 3-16

LISTENER (LIS or LIST) attribute, 4-8

listener.ora file, 3-14, 3-40

default configuration, 3-14

Oracle Enterprise Manager service discovery, C-4

Oracle Parallel Server Management requirements, 6-6

SID_DESC parameter, C-4

SID_LIST_listener_name parameter, 3-40, 6-6, C-4

listeners

GLOBAL_DBNAME parameter, 3-15

listener.ora file, 3-14

lsnr_listener_name parameter in db_name.conf file, B-9

tns_admin parameter in db_name.conf file, B-8

LOAD_BALANCE parameter, 4-2

LOCAL_LISTENER parameter, 3-6, 4-8

Lock Manager, 3-24, 3-44

LOG_ARCHIVE_DEST parameter, 4-11

lowercase courier, defined, xvii

lsnodes -l -n command, 3-30

lsnr_listener_name parameter, B-5, B-9, C-4

LSNRCTL utility

DBSNMP STARTommand, 6-10, B-11

START command, 3-41

---

M

managed targets, described, 2-3

Management Server

described, 2-3, 6-3

OMSCONFIG.PROPERTIES file, 6-11

starting, 6-11

METHOD parameter, 5-3

migrating

Oracle Parallel Server issues, 3-21

single instance to Oracle Parallel Server, 9-2 to 9-7

Minimal installation type, 3-2

MTS_DISPATCHERS parameter, 4-8

LISTENER attribute, 4-8

PROTOCOL attribute, 4-8

multi-instance database

converting application, 9-3

reasons not to convert to, 9-2

reasons to convert to, 9-2

requirements, 9-3

multiple Oracle homes

UNIX, 3-22

Windows NT, 3-22

Multi-Purpose database, 1-10

multi-threaded server

configuring, 3-13

connection load balancing, 3-13

dispatchers, 3-13

MTS_DISPATCHERS parameter, 4-8

---

N

Navigator window

Oracle Parallel Server folder, 7-3

Oracle Parallel Server objects, 7-3

Parallel Server Instances folder, 7-5

right-mouse menu, 7-5, 7-12

Connect, 7-6

Disconnect, 7-6

Edit, 7-6, 7-16

Related Tools, 7-6

Remove, 7-6

Results, 7-6

Shutdown, 7-6, 7-9

Startup, 7-6, 7-7

starting Oracle Parallel Server database, 7-7

stopping Oracle Parallel Server database, 7-9

viewing Oracle Parallel Server status, 7-16

viewing shutdown results, 7-12

viewing startup results, 7-12

Net8 Configuration Assistant

Custom installation, 3-6

Typical installation, 3-5

using during installation, 3-6

network configuration files

ldap.ora.ora, 3-16

listener.ora, 3-14, 3-40, 6-6

Oracle Enterprise Manager service discovery, C-4

sqlnet.ora, 3-21, 3-40

testing, 4-3

tnsnames.ora, 3-16, 3-40

Oracle Enterprise Manager service discovery, C-5

/network directory, A-3

nmiconf.log file, C-7

nmiconf.lst file, C-7

node#:environ parameter, B-5

node#:inst_init_ora parameter
, B-5

node#:tns_admin parameter, B-5

node_list parameter, B-4, C-3

nodes

adding to cluster, 9-7

described, 1-2

non-shared locations, B-10

---

O

oemapp console command, 6-12

oemapp pm command, 6-28

oemctrl start oms command, 6-11

OLTP database, 1-10

OMSCONFIG.PROPERTIES file, 6-11

Online Transaction Processing database, 1-10

Operating System Dependent layer

described, 1-5

installing, 2-11, 9-5

OPS Communication Daemon, defined, 6-4

/ops directory, A-3

OPS Overview chart, 8-18

OPS_DATABASE entry, C-6

OPS_DATABASE entry in services.ora file, C-6

OPS_INSTANCE entry, C-7

OPS_INSTANCE entry in services.ora file, C-7

OPSCTL utility, 6-4

architecture on UNIX, 6-4

architecture on Windows NT, 6-5

configuring on UNIX, B-1 to B-11

db_name.conf file, B-2

OPSD, defined, 6-4

/opsm/admin directory, A-3

ops.sql script, 3-38

Optimal Flexible Architecture (OFA), 1-8, 1-9

ORA-600, C-12

ORA-9291 message, 4-16

Oracle Data Gatherer

described, 6-3

starting, 6-27

Oracle Database Configuration Assistant

control files, 1-14

creating Oracle Parallel Server database

after installation, 3-24

during installation, 3-7

Custom database creation type, 1-11

data files, 1-12

database types

Data Warehousing, 1-10

Multi-Purpose, 1-10

OLTP, 1-10

deleting Oracle Parallel Server database, 3-43

error message, 3-26

initialization parameter files, 1-14

multi-threaded server configuration, 3-13

redo log files, 1-13

rollback segments, 1-14

running

during installation, 3-7

stand-alone mode, 3-23

tablespaces, 1-12

troubleshooting, 3-24, 3-44

Typical database creation type, 1-11

Oracle Diagnostics Pack

described, 2-4

Oracle Performance Manager, 2-4

Oracle Enterprise Manager

architecture, 6-7

Backup Wizard, 4-9, 4-16

components of, 2-3

Configuration Assistant, 6-10

configuring, 6-10 to 6-27

repository, 6-10

Console, 2-3, 6-2, 6-12

db_name.conf file requirements, 3-9, 3-33

DBA Studio, 2-3

described, 6-2

discovering nodes, 6-15

Discovery Wizard, 6-15

hardware requirements, 2-3

installation requirements, 2-3

installing repository database, 6-9

managed targets, 2-3

Management Server, 2-3, 6-3, 6-11

nmiconf.log file, C-7

nmiconf.lst file, C-7

OPS Communication Daemon, 6-4

OPSCTL utility, 6-4

OPSD, 6-4

Oracle Data Gatherer, 6-3

Oracle Diagnostics Pack, 2-4

Oracle Intelligent Agents, 6-3

Oracle Parallel Server Management, 1-5

Oracle Performance Manager, 6-3

oratab file requirements, 3-32

preferred credentials, 6-19

Recovery Wizard, 4-9

registry requirements, 3-10, 3-33

repository database, 6-3

configuring, 6-10

described, 2-3

scheduling jobs, 7-19

service discovery, 6-15, C-2

services.ora file, C-6

setup scenarios, 6-7

SID_LIST_listener_name parameter in listener.ora file, 3-40, 6-6, C-4

software requirements, 2-3

solving service discovery failures, C-2

specifying preferred credentials, 6-19

starting

components, 6-10

Console, 6-12

Management Server, 6-11

Oracle Data Gatherer, 6-27

Oracle Intelligent Agents, 6-10

Oracle Parallel Server database, 7-7

Oracle Performance Manager, 8-4

stopping Oracle Parallel Server database, 7-9

super administrator account, 6-12

SYSDBA privilege, 6-26

SYSOPER privilege, 6-26

TOOLS tablespace, 2-6

understanding discovery failures, C-2

User Manager, 6-20

version 2 changes, 6-10

viewing

Oracle Parallel Server status, 7-16

shutdown results, 7-12

startup results, 7-12

Oracle home

defined, xvii

non-shared on UNIX, B-11

shared on UNIX, B-11

Oracle Intelligent Agents

described, 6-3

setup and location on UNIX, B-10 to B-11

starting, 6-10

Oracle Parallel Server

architecture, 1-2

data files, 1-3

database files, 1-17

Destination Type tasks, 7-23

folder in Console Navigator window, 7-3

hardware requirements, 2-2

initialization parameter files, 1-14

installation requirements, 2-2

installing, 3-3

instances, 1-2

Operating System Dependent layer, 1-5

Oracle Parallel Server Management, 1-5

overview, 1-1 to 1-4

pre-installation, 2-1 to 2-12

raw device setup, 2-5 to 2-10

software components

Oracle Parallel Server, 1-5

Oracle Parallel Server Management, 1-5

Oracle8i Enterprise Edition, 1-5

software requirements, 2-2

Oracle Parallel Server databases, 3-38

backing up, 3-39

creating

with manual methods, 3-29

with Oracle Database Configuration Assistant after installation, 3-24

with Oracle Database Configuration Assistant during installation, 3-7

creating a job on, 7-19

deleting, 3-43

disconnecting from, 7-10

displaying objects in Console, 7-3

mounting, 7-8

password files, 3-37

shutdown, 7-12

starting, 3-41

Oracle Parallel Server Management

administration of instances, 7-2

architecture, 6-2

configuring, 6-1 to 6-34

described, 1-5

node requirements, 6-6

OPS Communication Daemon, 6-4

OPSCTL utility, 6-4

OPSD process, 6-4

Oracle Enterprise Manager, 1-5, 6-2

requirements, 6-6

SIDs, 6-6

Oracle Performance Manager, 8-18

accessing Oracle Parallel Server charts, 6-30

charts, 8-1 to 8-18

OPS Overview, 8-18

Parallel Server Active Users, 8-16

Parallel Server Active Users by Instance, 8-17

Parallel Server Block Ping, 8-5

Parallel Server Block Ping Tablespace Instance, 8-6

Parallel Server Block Ping Tablespace Object, 8-6

Parallel Server Data Block Ping, 8-6

Parallel Server Data Block Ping by Instance, 8-8

Parallel Server File I/O Rate, 8-9

Parallel Server File I/O Rate by Instance, 8-11

Parallel Server File I/O Rate by Object, 8-10

Parallel Server Lock Activity, 8-12

Parallel Server Sessions, 8-13

Parallel Server Users Logged On, 8-14

Parallel Server Users Logged On by Instance, 8-15

configuring, 6-27 to 6-34

Databases folder, 6-32

described, 2-4, 6-3

displaying charts, 8-4

Oracle Diagnostics Pack, 2-4

overview, 8-2

Parallel Server Instance folder, 6-30

starting, 6-28, 8-4

Oracle System Identifier (SID), defined, 1-15

Oracle Universal Installer, 3-3

ORACLE_HOME environment variable, B-5

oracle_home parameter, B-5

ORACLE_HOME, defined, xvii

ORACLE_PSRV environment variable, B-3, B-5, C-7

ORACLE_SID environment variable, 1-15, 3-35

ORACLE_SID registry entry, 1-15

Oracle8i Enterprise Edition

described, 1-5

installing, 3-3

OracleHOME_NAMEAgent service, 6-10

OracleHOME_NAMEDataGatherer service, 6-27

OracleHOME_NAMEManagementServer service, 6-11

OraclePGMSService service, 3-21

OracleServicesid service, 3-11, 3-35

ORAPWD utility, 3-37

orapwsid file, 3-37

oraxxxxx.trc file, C-10

Output tab

from Parallel Server Operation Results dialog box, 7-15

---

P

PARALLEL option, 3-41, 3-42

Parallel Server Active Users by Instance chart, 8-17

Parallel Server Active Users chart, 8-16

Parallel Server Block Ping chart, 8-5

Parallel Server Block Ping Tablespace Instance chart, 8-6

Parallel Server Block Ping Tablespace Object chart, 8-6

Parallel Server Data Block Ping by Instance chart, 8-8

Parallel Server Data Block Ping chart, 8-6

Parallel Server File I/O Rate by Instance chart, 8-11

Parallel Server File I/O Rate by Object chart, 8-10

Parallel Server File I/O Rate chart, 8-9

Parallel Server Instances folder

in Console Navigator window, 7-5

Parallel Server Instances Logon dialog box, 6-31

Parallel Server Lock Activity chart, 8-12

Parallel Server Operation Results dialog box, 7-12

Parallel Server Sessions chart, 8-13

Parallel Server Shutdown dialog box, 7-10

Parallel Server Shutdown Progress dialog box, 7-11

Parallel Server Started message box, 7-9

Parallel Server Startup dialog box, 7-7

Parallel Server Startup Results dialog box, 7-9

Parallel Server Startup/Shutdown Results dialog box, 7-12

Parallel Server Stopped message box, 7-12

Parallel Server Users Logged On by Instance chart, 8-15

Parallel Server Users Logged On chart, 8-14

Parameters tab

from Create Job property sheet, 7-23

password files, 3-37

Performance Manager Login dialog box, 6-28

preferred credentials, 6-19

creating an operating system account, 6-20

database, 6-19

nodes, 6-19

SYSDBA or SYSOPER for database, 6-19

preferred user credentials, described, 6-19

pre-installation, 2-1 to 2-12

DBCA_RAW_CONFIG, 2-9

oracle account activities, 2-11

raw device creation, 2-5 to 2-10

root user activities, 2-11

primary and secondary instances

client configuration, 5-8

connecting to secondary instances, 5-9

initdb_name.ora file configuration, 5-7

listener configuration, 5-9

overview, 5-6

PROTOCOL (PRO or PROT) attribute, 4-8

pwdsid.ora file, 3-37

---

R

raw devices

control files, 2-6

creating, 2-7

on UNIX, 2-7

on Windows NT, 2-9

creating as root user, 2-7

data files, 2-6

DRSYS tablespace, 2-6

identifying on UNIX

control1 database object, 2-8

control2 database object, 2-8

drysys1 database object, 2-8

indx1 database object, 2-8

rbs1 database object, 2-8

redothread_number database object, 2-8

system1 database object, 2-8

temp1 database object, 2-8

tools1 database object, 2-8

users1 database object, 2-8

identifying on Windows NT

db_name_control1 symbolic link, 1-14, 2-10

db_name_control2 symbolic link, 1-14, 2-10

db_name_drsys1 symbolic link, 1-13, 2-10

db_name_indx1 symbolic link, 1-13, 2-10

db_name_rbs1 symbolic link, 1-13, 2-10

db_name_redothread_number symbolic link, 1-13, 2-10

db_name_system1 symbolic link, 1-13, 2-10

db_name_temp1 symbolic link, 1-13, 2-10

db_name_tools1 symbolic link, 1-13, 2-10

db_name_users1 symbolic link, 1-13, 2-10

INDX tablespace, 2-6

RBS tablespace, 2-6

redo log files, 2-6

setting DBCA_RAW_CONFIG environment variable, 2-9

setting up, 2-5 to 2-10

SYSTEM tablespace, 2-6

TEMP tablespace, 2-6

TOOLS tablespace, 2-6

USERS tablespace, 2-6

verification, 3-5, 3-7, 3-23

RBS tablespace

description, 1-12

raw device, 2-6

Recovery Manager

configure archive logs, 4-9 to 4-16

recovery with Recovery Manager, 4-9

redo log files

described, 1-13

raw devices, 2-6

registry

DefinedNodes value, 3-26

PM\db_name key, 3-11, 3-34, C-3

remote connections to secondary instances, 5-10

REMOTE_LOGIN_PASSWORDFILE parameter, 4-5

repository database

described, 2-3, 6-3

installing, 6-9

RETRIES parameter, 5-3

.rhosts file, 2-11

RMAN

See Recovery Manager

rollback segments, 1-16

described, 1-14

ROLLBACK_SEGMENTS parameter, 1-16, 4-5

root, 2-11

---

S

security login, 6-13

Select Instances to Start dialog box, 7-8

Select Instances to Stop dialog box, 7-11

service discovery

db_name.conf file, C-3

errors, C-2

listener.ora file, C-4

nmiconf.log file, C-7

nmiconf.lst file, C-7

on UNIX, C-3

on Windows NT, 3-11, 3-34, C-3

performing, 6-15

PM\db_name registry key, 3-11, 3-34, C-3

See auto-discovery

services.ora file, C-6

SID_LIST_listener_name parameter, C-4

tnsnames.ora file, C-5

troubleshooting, C-7

understanding, C-2

SERVICE_NAME parameter in tnsnames.ora file, 3-18

SERVICE_NAMES parameter in initdb_name.ora file, 4-9

services

OracleHOME_NAMEAgent, 6-10

OracleHOME_NAMEDataGatherer, 6-27

OracleHOME_NAMEManagementServer, 6-11

OraclePGMSService, 3-21

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

SGA, defined, 1-2

shared disk storage subsystem, 2-5

shared Oracle home, B-11

shutdown types, 7-10

abort, 7-10

immediate, 7-10

normal, 7-10

shutdown database and other services, 7-11

shutdown database only, 7-11

shutting down an Oracle Parallel Server database, 7-12

setting parameters, 7-25

viewing results, 7-12

with SYSDBA privilege, 6-26

with SYSOPER privilege, 6-26

SID

described, 1-15

SID Prefix, 3-4, 3-27

SID_DESC parameter, C-4

SID_LIST_listener_name parameter, 3-40, 6-6, C-4

SID_startup net service name, C-5

sidalrt.log file, C-10

sidbsp0.trc file, C-9

siddbwr.trc file, C-9

sidlckn.trc file, C-9, C-11

sidlmdn.trc file, C-9

sidlmon.trc file, C-9

sidp00n.trc file, C-9

sidsmon.trc file, C-9

single-instance database

migrating to multi-instance, 9-3

software requirements, 2-2, 2-3

sqlnet.ora file, 3-21, 3-40

default configuration, 3-21

square brackets, defined, xvii

starting

Console, 6-12

listener, 3-41

Management Server, 6-11

Oracle Data Gatherer, 6-27

Oracle Enterprise Manager, 6-10

Oracle Intelligent Agents, 6-10

Oracle Parallel Server database, 3-41, 7-7

Oracle Performance Manager, 8-4

from Console, 6-28

standalone, 6-28

startup

results, 7-12

setting Parallel Server parameters for, 7-24

SYSDBA privilege, 6-26

SYSOPER privilege, 6-26

startup types, 7-8

force, 7-8

mount, 7-8

no mount, 7-8

open, 7-8

restrict, 7-8

Status Details tab, 7-13

from Edit Parallel Server dialog box, 7-18

from Parallel Server Operation Results dialog box, 7-13

Status tab

from Edit Parallel Server dialog box, 7-17

stopping

Oracle Parallel Server database, 7-9

switchlog.sql script, 4-15

SYSDBA privilege, 6-19, 6-26, 7-24

SYSDBA privilege, granting, 6-24

SYSOPER privilege, 6-19, 6-26, 7-24

SYSOPER privilege, granting, 6-24

System Global Area (SGA), defined, 1-2

SYSTEM tablespace

raw device, 2-6

SYSTEM tablespace, description, 1-12

---

T

tablespaces

DRSYS, 1-12

expanding for large sorts, 1-12

INDX, 1-12

RBS, 1-12

SYSTEM, 1-12

TEMP, 1-12

TOOLS, 1-12

USERS, 1-12

TAF

configuring, 5-2

GLOBAL_DBNAME parameter in listener.ora file, 3-15

overview, 5-2

pre-establishing a connection, 5-5

retrying a connection, 5-5

with client load balancing, 5-4

with connect-time failover, 5-4

Tasks tab

from Create Job property sheet, 7-22

TEMP tablespace

described, 1-12

raw device, 2-6

testing the network, 4-3

thread ID, 1-16

THREAD parameter, 1-16, 4-5

TNS_ADMIN environment variable, B-5

tns_admin parameter, B-5, B-8

tnsnames.ora file, 3-16, 3-40

BACKUP parameter, 5-3

default configuration, 3-16

DELAY parameter, 5-3

FAILOVER parameter, 4-2

FAILOVER_MODE, 5-3

INSTANCE_NAME parameter, 3-18

LOAD_BALANCE parameter, 4-2

METHOD parameter, 5-3

RETRIES parameter, 5-3

service discovery, C-5

SERVICE_NAME parameter, 3-18

TYPE parameter, 5-3

TOOLS tablespace

described, 1-12

raw device, 2-6

trace files, C-8

background thread trace files, C-9

error call trace stack, C-11

oraxxxxx.trc, C-10

sidalrt.log, C-10

sidbsp0.trc, C-9

siddbwr.trc file, C-9

sidlckn.trc, C-9, C-11

sidlmdn.trc, C-9

sidlmon.trc, C-9

sidp00n.trc, C-9

sidsmon.trc file, C-9

Transparent Application Failover

configuring, 5-2

GLOBAL_DBNAME parameter in listener.ora file, 3-15

overview, 5-2

pre-establishing a connection, 5-5

retrying a connection, 5-5

with client load balancing, 5-4

with connect-time failover, 5-4

troubleshooting, C-1 to C-12

Oracle Database Configuration Assistant, 3-24, 3-44

service discovery, C-2

trace files, C-8

TYPE parameter, 5-3

Typical database creation type, 1-11

Typical installation type, 3-2

---

U

upgrading

Oracle Parallel Server issues, 3-21

uppercase, defined, xvii

User Manager, for Oracle Enterprise Manager, 6-20

user trace files, C-10

USER_DUMP_DEST parameter, 4-9, C-10

USERS tablespace

described, 1-12

raw device, 2-6

---

V

V$ACTIVE_INSTANCES, 3-42

V$ACTIVE_INSTANCES table, 7-17

V$SESSION table, 5-6

vppcntl -start command, 6-27