Oracle8<i>i</i> Parallel Server Setup and Configuration Guide -- Index

architecture

OPSCTL utility on UNIX, 5-4

OPSCTL utility on Windows NT, 5-6

Optimal Flexible Architecture (OFA), 1-2

Oracle Enterprise Manager, 5-8

Oracle Parallel Server, 1-2

Oracle Parallel Server Management, 5-2

auto-discovery

DB_NAME.CONF file, C-4

errors, C-3

LISTENER.ORA file, C-6

NMICONF.LOG file, C-9

NMICONF.LST file, C-10

on UNIX, C-4

on Windows NT, C-5

performing, 5-18

PM\DB_NAME registry key, C-5

SERVICES.ORA file, C-9

SID_LIST_listener_name parameter, C-6

TNSNAMES.ORA file, C-7

troubleshooting, C-10

understanding, C-3

BACKGROUND_DUMP_DEST parameter, C-11, C-12

backslash, defined, xvi

BACKUP parameter, 4-44

BSP0 process, 1-10

charts

OPS Overview, 7-19

Oracle Performance Manager, 7-1 to 7-19

Parallel Server Active Users, 7-17

Parallel Server Active Users by Instance, 7-18

Parallel Server Block Ping, 7-6

Parallel Server Block Ping Tablespace Instance, 7-7

Parallel Server Block Ping Tablespace Object, 7-7

Parallel Server Data Block Ping, 7-7

Parallel Server Data Block Ping by Instance, 7-9

Parallel Server File I/O Rate, 7-10

Parallel Server File I/O Rate by Instance, 7-12

Parallel Server File I/O Rate by Object, 7-11

Parallel Server Lock Activity, 7-13

Parallel Server Sessions, 7-14

Parallel Server Users Logged On, 7-15

Parallel Server Users Logged On by Instance, 7-16

CHECKPOINT_PROCESS parameter, 6-10

Choose Start >, defined, xvi

Client, 4-25

client load balancing, 4-25

cluster management, 1-7

Cluster Manager (CM)

defined, 1-4

See CM, 1-6

cluster, defined, 1-9

CM

cluster management, 1-7

defined, 1-4

DefinedNodes registry value, 4-6

described, 1-6

determining groups available, 1-7

determining instances available, 1-7

Group Membership Service (GMS), 1-7

interacting with IDLM, 1-6, 1-16

node monitoring, 1-6

coexistence, 3-8

Configuration Assistant, 5-13

configuration tasks

adding nodes to a cluster, 8-6

configuring the listener, 4-13

configuring the listener for failover, 4-36

creating net service names, 4-20

creating the database, 3-6

database creation, 4-3

establishing client load balancing, 4-25

establishing connect-time failover, 4-35

establishing transparent application failover, 4-43

moving from single instance to parallel server, 8-2 to 8-5

Net8 on clients, 4-34

Net8 on Console, 5-11

Net8 on nodes, 4-12

Net8 on Oracle Performance Manager machine, 5-29

OPSCTL utility on UNIX, B-1 to B-12

Oracle Enterprise Manager, 5-11 to 5-28

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

Oracle Parallel Server, 4-1 to 4-45

Oracle Parallel Server Management, 5-1 to 5-37

Oracle Performance Manager, 5-29 to 5-37

testing the network, 4-45

with Oracle Database Configuration Assistant, 4-4

connect descriptor, defined, 4-20

connecting to the database, 4-45

connecting to the repository, 5-31, 5-36

connect-time failover, 4-35

Try each address, in order, until one succeeds option, 4-41

Try each address, randomly, until one succeeds option, 4-41

with transparent application failover, 4-43

Consistent Read Server, 1-10

Console

control files, 1-10

control files raw devices, 2-7

CONTROL_FILES parameter, 6-11

CPU_COUNT parameter, 6-11

CR Server, 1-10

Create Job property sheet, 6-32 to 6-39

creating

DB_NAME.CONF file, B-2

net service name for each database, 4-25

net service names, 4-20

net service names for each instance, 4-20

net service names for Windows NT, 4-29

network configuration files, 3-6, 4-12, 5-11, 5-29

preferred credentials, 5-21

raw devices, 8-3

raw devices on UNIX, 2-7

raw devices on Windows NT, 2-9

repository, 5-13

Custom installation, 3-6

Custom installation type, 3-2, 4-2

data files, 1-10, 1-11, 1-14

database

creating, 3-5, 3-6, 4-3

creating a job on, 6-31

disconnecting, 6-22

displaying objects in Console, 6-14

mounting, 6-19

database creation, 3-5, 3-6, 4-3

database creation failure, C-2

database, defined, 1-9

\database directory, A-3

DB, 2-9, 4-19

DB_BLOCK_SIZE parameter, 6-11

DB_DOMAIN parameter, 6-7, 6-11

DB_FILES parameter, 6-11

DB_NAME parameter, 1-11, 6-3, 6-7, 6-11

DB_NAME.CONF file

DB_NAME.TBL file, 2-9

DBA locking, 1-18

DBCA, 2-8, 2-13, 4-3

DBCA_RAW_CONFIG environment variable, 2-8, 2-13, 4-3

/dbs directory, A-2

DBWR process, 1-10

DefinedNodes registry value, 4-6

DELAYED_LOGGING_BLOCK_
CLEANOUTS parameter, 6-10

directory structure, A-1 to A-3

UNIX, A-2

Windows NT, A-3

discovering nodes, 5-18

discovery

See auto-discovery

Distributed Lock Manager, described, 1-10

DLM, described, 1-10

DML_LOCKS parameter, 6-10, 6-11

DR tablespace raw device, 2-6

Edit Parallel Server dialog box, 6-27

error call trace stack, C-13

EXP, 8-3

export data from old database, 8-3

Export utility, 8-3

FAILOVER, 4-35, 4-41, 4-43

failover

connect-time, 4-35

transparent application failover, 4-35

FAILOVER parameter, 4-35, 4-41

FAILOVER_MODE parameter, 4-35, 4-43

fine-grain locks, 1-18

1 block-to-1 block ratio, 1-18

fixed, 1-18

releasable, 1-18

when to use, 1-19

FORCE mode, warning notice, 6-19

forward slash, defined, xvi

GC_FILES_TO_LOCKS parameter, 1-17, 6-9, 6-11

GC_RELEASABLE_LOCKS parameter, 1-18, 6-9

GC_ROLLBACK_LOCKS parameter, 6-9, 6-11

General tab, from Create Job property sheet, 6-33

Global Constant parameters list, 6-9

global database name, 1-9, 3-4, 4-8

global V$ view tables, 5-1, 7-2

GMS

described, 1-7

release 8.0 functionality, 1-7

GUI, 5-15

GV$FILESTAT view, 7-10, 7-11, 7-12

GV$LICENSE view, 7-15, 7-16, 7-17, 7-18

GV$LOCK_ACTIVITY view, 7-13

GV$PING view, 7-6, 7-7, 7-9

GV$PROCESS view, 7-14

GV$SESSION view, 7-14

hardware requirements, 2-2

HOSTS.EQUIV file, 2-14

IDLM

block access synchronization, 1-16

deadlock detection, 1-16

defined, 1-15

described, 1-15

interacting with CM, 1-6, 1-16

LMDN process, 1-15

LMON process, 1-15

modification synchronization, 1-16

IFILE parameter, 6-4, 6-5

IMP, 8-5

import data, 8-5

Import utility, 8-5

INDX1 tablespace raw device, 2-6

INITDB_NAME.ORA file, 1-11, 6-2

BACKGROUND_DUMP_DEST parameter, C-11, C-12

CHECKPOINT_PROCESS parameter, 6-10

CONTROL_FILES parameter, 6-11

CPU_COUNT parameter, 6-11

DB_BLOCK_SIZE parameter, 6-11

DB_DOMAIN parameter, 6-7, 6-11

DB_FILES parameter, 6-11

DB_NAME parameter, 1-11, 6-3, 6-7, 6-11

DELAYED_LOGGING_BLOCK_
CLEANOUTS parameter, 6-10

DML_LOCKS parameter, 6-10, 6-11

GC_FILES_TO_LOCKS parameter, 1-17, 6-9, 6-11

GC_RELEASABLE_LOCKS parameter, 1-18, 6-9

GC_ROLLBACK_LOCKS parameter, 6-9, 6-11

Global Constant (GC) parameters, 6-8

identical parameters, 6-11

INSTANCE_NUMBER parameter, 6-10

LM_LOCKS parameter, 6-11, 6-12

LM_PROCS parameter, 6-11, 6-12

LM_RESS parameter, 6-11, 6-12

LOCAL_LISTENER parameter, 3-6, 4-17, 4-37

LOG_ARCHIVE_FORMAT parameter, 6-10

MAX_COMMIT_PROPAGATION_DELAY parameter, 6-10, 6-11

NLS_* parameters, 6-10

PARALLEL_DEFAULT_MAX_INSTANCES parameter, 6-11

PARALLEL_DEFAULT_MAX_SCANS parameter, 6-11

PARALLEL_SERVER parameter, 6-10

parameter notes, 6-10

PROCESSES parameter, 6-10

RECOVERY_PARALLELISM parameter, 6-10

ROLLBACK_SEGMENTS parameter, 6-10, 6-11

ROW_LOCKING parameter, 6-11

SERVICE_NAMES parameter, 6-7

THREAD parameter, 6-10

USER_DUMP_DEST parameter, C-12

initialization files, 6-1 to 6-39

definition, 6-2

editing, 6-12

for instances, 6-2

identical parameters, 6-11

INITDB_NAME.ORA, 6-2

INITSID.ORA, 6-2

location, 6-12

initialization parameters

descriptions, 6-12

editing, 6-12

Global Constant (GC) parameters, 6-8

identical, 6-11

setting, 6-8

INITSID.ORA file, 1-11, 6-2, 6-4

IFILE parameter, 6-4, 6-5

INSTANCE_NAME parameter, 1-11, 4-24, 6-4

REMOTE_LOGIN_PASSWORDFILE parameter, 6-4

ROLLBACK_SEGMENTS parameter, 1-12

THREAD parameter, 1-12, 6-4

Input/Output (IO)

defined, 1-4

described, 1-7

on Windows NT, 1-4

inst_init_ora parameter, B-5, B-8

inst_oracle_sid parameter, B-5, B-7

inst_sid_list parameter, C-7

installation, 3-7

Custom install type, 3-2, 4-2

Custom procedure, 3-6

database creation, 3-5, 3-6

directory structure, A-1 to A-3

INITDB_NAME.ORA, 3-5, 4-8

INITSID.ORA, 3-5, 4-8

Minimal install type, 3-2

Net8 Configuration Assistant, 3-6

network configuration, 3-6

Operating System Dependent layer, 2-13, 8-3

Oracle Data Gatherer, 5-28

Oracle Database Configuration Assistant, 3-5, 3-6

Oracle Diagnostics Pack, 5-28

Oracle Enterprise Manager, 5-10

Oracle Enterprise Manager requirements, 2-3

Oracle Parallel Server Option, 3-3, 8-4

Oracle Performance Manager, 5-28

Oracle Universal Installer, 3-3

Oracle8i Enterprise Edition, 3-3, 8-4

pre-installation, 2-1 to 2-15

procedure, 3-3

repository database, 5-10

software requirements, 2-2

Typical install type, 3-2, 4-2

Typical procedure, 3-5

verifying raw devices, 3-5, 3-6

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

installation type

INSTANCE_NAME parameter, 1-11, 4-24, 4-29, 6-4

INSTANCE_NUMBER parameter, 6-10

instances

administering, 6-1 to 6-39

BSPO process, 1-10

control files, 1-10

data files, 1-10, 1-11, 1-14

DBWR process, 1-10

defined, 1-9

Destination Type tasks for, 6-36

examples of parameters in
DB_NAME.CONF file, B-7

identical parameters, 6-11

initialization files, 6-2

INITSID.ORA, 1-11

instance name, 1-11

INSTANCE_NAME parameter, 1-11, 4-24

Integrated Distributed Lock Manager (IDLM), 1-10

LCKN process, 1-10

management with Oracle Parallel Server Management, 6-13

Oracle System Identifier (SID), 1-11

ORACLE_SID environment variable, 1-11

ORACLE_SID registry entry, 1-11

PMON process, 1-10

rollback segments, 1-12

ROLLBACK_SEGMENTS parameter, 1-12

setting initialization parameters, 6-8

THREAD parameter, 1-12

verifying, 4-11

viewing startup and shutdown results, 6-24, 6-27

Integrated Distributed Lock Manager (IDLM)

defined, 1-15

described, 1-15

See IDLM

Inter-Process Communication (IPC)

jobs

choosing tasks for, 6-35

creating for Oracle Parallel Server, 6-31

setting up rights for running, 6-38

specifying information for, 6-33

specifying parameters for OPSM tasks, 6-37

LCKN process, 1-10

LGWR process, 1-10

listener

configuring, 4-13

configuring for failover, 4-36

configuring lsnr_listener_name parameter, B-10

configuring tns_admin parameter, B-9

starting, 4-18, 4-39

stopping, 4-16, 4-37

LISTENER.ORA file, 4-12, 5-7, B-9

configuring, 4-13

configuring for failover, 4-36

default configuration, 4-14

how used for auto-discovery, C-6

SID_DESC parameter, C-6

SID_LIST_listener_name parameter, 4-12, 4-37, C-6

SID_NAME parameter, C-6

LM_LOCKS parameter, 6-11, 6-12

LM_PROCS parameter, 6-11, 6-12

LM_RESS parameter, 6-11, 6-12

LMD0 process, 1-10

LMDN process, 1-15

LMON process, 1-10, 1-15

LOAD, 4-25, 4-41

LOAD_BALANCE parameter, 4-25, 4-41

LOCAL_LISTENER parameter, 3-6, 4-17, 4-37

Lock Manager, 4-4

LOG_ARCHIVE_FORMAT parameter, 6-10

lowercase courier, defined, xvi

lsnr_listener_name parameter, 4-19, B-5, B-10, C-7

LSNRCTL control utility

DBSNMP STARTommand, 5-13, B-12

START command, 4-18, 4-39

STOP command, 4-16, 4-37

managed targets, defined, 2-4

Management Server

OMSCONFIG.PROPERTIES file, 5-14

starting, 5-14, 6-14

Management Server, defined, 2-3, 5-2

MAX_COMMIT_PROPAGATION_DELAY parameter, 6-10, 6-11

METHOD parameter, 4-45

migrating, Oracle Parallel Server issues, 3-8

Minimal installation type, 3-2

multiple Oracle homes

UNIX, 3-9

Windows NT, 3-9

NAMES_DIRECTORY_PATH parameter, 4-32

Navigator window

net service names

configuring, 4-20

described, 4-12

Net8 Assistant

configuring net service names for each instance, 4-20

configuring net service names for the database, 4-25

configuring net service names for Windows NT, 4-29

configuring the listener, 4-16

configuring the listener for failover, 4-37

enabling client load balancing, 4-25

Net8 Configuration Assistant

automatically running as a part of installation, 3-6

network configuration, 3-6, C-6, C-7

additional steps for Windows NT, 4-29

configuring connect-time failover, 4-35

configuring net service names for Windows NT, 4-29

configuring the listener, 4-13

configuring the listener for failover, 4-36

configuring transparent application failover, 4-43

creating net service names, 4-20

enabling client load balancing, 4-25

on clients, 4-34

on Console, 5-11

on nodes, 4-12

Oracle Performance Manager machine, 5-29

testing components, 4-45

transparent application failover, 4-35

network configuration file

LISTENER.ORA, 4-13, 4-36

LISTENER.ORA file

how used for auto-discovery, C-6

SQLNET.ORA, 4-32

TNSNAMES.ORA file

how used for auto-discovery, C-7

network configuration files

LISTENER.ORA, 4-12, 5-7, B-9

on clients, 4-34

on Console, 5-11

on nodes, 4-12

on Oracle Performance Manager machine, 5-29

SQLNET.ORA, 4-13

testing, 4-45

TNSNAMES.ORA, 4-13, 4-20, 5-7, 5-11, 5-29

NLS_* parameters, 6-10

NMICONF, C-9, C-10

NMICONF.LOG file, C-9

NMICONF.LST file, C-10

node, 5-12, C-4

node monitoring, 1-6

node#:environ parameter, B-6

node#:inst_init_ora parameter
, B-5

node#:tns_admin parameter, B-5

node, defined, 1-9

node_list parameter, 5-12, B-5, C-4

non-shared locations, B-11

OEM_REPOSITORY tablespace raw device, 2-6

oemapp console command, 5-15

oemctrl start oms command, 5-14

OLTP, 1-21

OMSCONFIG.PROPERTIES file, 5-14

Operating System Dependent layer

Cluster Manager (CM), 1-6

components, 1-4

defined, 1-3

described, 1-4

Input/Output (IO), 1-7

installing, 2-13, 8-3

Inter-Process Communication (IP
C), 1-7

Startup (START), 1-8

OPS Communication Daemon (OPSD), defined, 5-4

/ops directory, A-2, C-4

\ops directory, A-3

\ops\dbca directory, 4-3

\ops_preinstall directory, 2-13

OPS Overview chart, 7-19

OPS_DATABASE entry, C-9

OPS_DATABASE entry in SERVICES.ORA file, C-9

OPS_INSTANCE entry, C-9

OPS_INSTANCE entry in SERVICES.ORA file, C-9

OPSCTL utility, 5-4

architecture on UNIX, 5-4

architecture on Windows NT, 5-6

configuring for UNIX, 5-12

configuring on UNIX, B-1 to B-12

DB_NAME.CONF file, B-2

OPSD, defined, 5-4

/opsm directory, A-2

OP.TBL, 4-3

Optimal Flexible Architecture (OFA), 1-2

Oracle Data Gatherer

Oracle Database Configuration Assistant

automatically running as a part of installation, 3-5, 3-6

creating a database, 4-4

creating a database with, 4-4

error message, 4-6

failing on Windows NT, C-2

initialization files, 1-11

minimum size, 2-6

running after installation, 3-7

troubleshooting, 4-4, 4-6

Oracle Diagnostics Pack

described, 2-4

Oracle Performance Manager, 2-4

installing, 5-28

Oracle Enterprise Manager

architecture, 5-8

auto-discovery, 5-18, C-3

components, 2-3

Configuration Assistant, 5-13

configuring, 5-11 to 5-28

configuring Net8 on Console, 5-11

configuring Net8 on Oracle Performance Manager machine, 5-29

configuring OPSCTL, 5-12

configuring repository, 5-13

Console, 2-3, 5-2, 5-15

discovering nodes, 5-18

hardware requirements, 2-3

installation, 5-10

installation requirements, 2-3

installing repository database, 5-10

managed targets, 2-4

Management Server, 2-3, 5-2, 5-14

NMICONF.LOG file, C-9

NMICONF.LST file, C-10

OPS Communication Daemon (OPSD), 5-4

OPSCTL utility, 5-4

Oracle Data Gatherer, 5-3

Oracle Diagnostics Pack, 2-4

Oracle Intelligent Agents, 5-3

Oracle Parallel Server Management, 1-3

Oracle Performance Manager, 5-3

repository database, 2-4, 5-3

scheduling jobs, 6-31

SERVICES.ORA file, C-9

setting up preferred credentials, 5-21

setup scenarios, 5-8

SID_LIST_listener_name parameter, 4-12, 4-37, C-6

software requirements, 2-3

solving auto-discovery failures, C-3

specifying preferred credentials, 5-21

starting, 5-13

starting Oracle Data Gatherer, 5-30

starting Oracle Intelligent Agents, 5-13, 6-14

starting Oracle Intellligent Agents, B-12

starting Oracle Parallel Server database, 6-18

starting Oracle Performance Manager, 7-4

starting the Console, 5-15, 6-14

starting the Management Server, 5-14, 6-14

stopping Oracle Parallel Server database, 6-21

super administrator account, 5-15

SYSDBA privilege, 5-28

SYSOPER privilege, 5-28

understanding auto-discovery failures, C-3

User Manager, 5-22

version 2 changes, 5-11

viewing Oracle Parallel Server status, 6-27

viewing shutdown results, 6-24

viewing startup results, 6-24

Oracle home

non-shared on UNIX, B-12

shared on UNIX, B-12

Oracle home directory, defined, xvii

Oracle Intelligent Agents

defined, 5-3

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

starting, 5-13, 6-14, B-12

Oracle Parallel Query

defined, 1-15

described, 1-20

issuing SQL statements, 1-22

Oracle Parallel Server

Oracle Parallel Server database

creation, 4-4, 8-4

shutdown, 6-24

starting, 4-9, 8-5

Oracle Parallel Server Management

administration of instances, 6-13

architecture, 5-2

configuring, 5-1 to 5-37

defined, 1-3

LISTENER.ORA file, 5-7

node requirements, 5-7

OPS Communication Daemon (OPSD), 5-4

OPSCTL utility, 5-4

Oracle Enterprise Manager, 1-3, 5-2

Oracle Performance Manager, 5-28

requirements, 5-7

SIDs, 5-7

TNSNAMES.ORA file, 5-7

Oracle Parallel Server Option

defined, 1-3

installing, 3-3, 8-4

Oracle Performance Manager

accessing Oracle Parallel Server charts, 5-34

charts, 7-1 to 7-19

configuring, 5-29 to 5-37

Databases folder, 5-36

defined, 2-4, 5-3

displaying charts, 7-4

installing, 5-28

installing Oracle Data Gatherer, 5-28

installing Oracle Diagnostics Pack, 5-28

Oracle Diagnostics Pack, 2-4

overview, 7-2

Parallel Server Instance folder, 5-34

starting, 5-31, 7-4

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

Oracle Universal Installer

using, 3-3

ORACLE_HOME environment variable, B-6

oracle_home parameter, B-5

ORACLE_HOME, defined, xvii

ORACLE_PSRV environment variable, B-3, B-6

ORACLE_SID environment variable, 1-11

ORACLE_SID registry entry, 1-11

Oracle8i Enterprise Edition

defined, 1-3

installing, 3-3, 8-4

OracleHOME_NAMEAgent service, 5-13

OracleHOME_NAMEDataGatherer service, 5-30

OracleHOME_NAMEManagementServer service, 5-14

OracleServiceSID registry key

registry

OracleServiceSID key, C-2

OracleServiceSID service, 4-9

ORAXXXXX.TRC file, C-12

Output tab

from Parallel Server Operation Results dialog box, 6-26

Parallel Cache Management (PCM)

defined, 1-15

described, 1-17

See PCM

parallel coordinator, defined, 1-20

PARALLEL option, 4-10

Parallel Server Active Users by Instance chart, 7-18

Parallel Server Active Users chart, 7-17

Parallel Server Block Ping chart, 7-6

Parallel Server Block Ping Tablespace Instance chart, 7-7

Parallel Server Block Ping Tablespace Object chart, 7-7

Parallel Server Data Block Ping by Instance chart, 7-9

Parallel Server Data Block Ping chart, 7-7

Parallel Server File I/O Rate by Instance chart, 7-12

Parallel Server File I/O Rate by Object chart, 7-11

Parallel Server File I/O Rate chart, 7-10

Parallel Server Instances folder

in Console Navigator window, 6-16

Parallel Server Lock Activity chart, 7-13

Parallel Server Operation Results dialog box, 6-24

parallel server process, defined, 1-20

Parallel Server Sessions chart, 7-14

Parallel Server Shutdown dialog box, 6-21

Parallel Server Startup dialog box, 6-18

Parallel Server Users Logged On by Instance chart, 7-16

Parallel Server Users Logged On chart, 7-15

PARALLEL_DEFAULT_MAX_INSTANCES parameter, 6-11

PARALLEL_DEFAULT_MAX_SCANS parameter, 6-11

PARALLEL_SERVER parameter, 6-10

Parameters tab

from Create Job property sheet, 6-37

PCM

defined, 1-15

described, 1-17

fine-grain lock usage, 1-19

fine-grain locks, 1-18

GC_FILES_TO_LOCKS parameter, 1-17

GC_RELEASABLE_LOCKS parameter, 1-18

hashed lock usage, 1-19

hashed locks, 1-18

PM\DB_NAME registry key, C-2

PMON process, 1-10

preferred credentials, 5-21

creating an operating system account, 5-22

database, 5-21

nodes, 5-21

SYSDBA or SYSOPER for database, 5-21

preferred user credentials, described, 5-21

pre-installation, 2-1 to 2-15

DBCA_RAW_CONFIG, 2-8, 2-13, 4-3

oracle account activities, 2-15

root user activities, 2-14

PROCESSES parameter, 6-10

raw devices

control files, 2-7

creating, 2-7, 8-3

creating as root user, 2-7

creating on UNIX, 2-7

creating on Windows NT, 2-9

DB_NAME.TBL file, 2-9

DR tablespace, 2-6

identifying, 2-10

identifying on UNIX, 2-10

CTL1 database object, 2-10

CTL2 database object, 2-10

DR database object, 2-10

INDX1 database object, 2-10

LOGthread_id_number database object, 2-10

OEMREP1 database object, 2-10

RBS1 database object, 2-10

SYS1 database object, 2-10

TMP1 database object, 2-10

USR1 database object, 2-10

identifying on Windows NT, 2-11

db_name_ctl1 symbolic link, 2-12

db_name_ctl2 symbolic link, 2-12

db_name_dr symbolic link, 2-11

db_name_indx1 symbolic link, 2-12

db_name_logthread_id_number
symbolic link, 2-12

db_name_oemrep1 symbolic link, 2-12

db_name_rbs1 symbolic link, 2-11

db_name_sys1 symbolic link, 2-11

db_name_tmp1 symbolic link, 2-11

db_name_usr1 symbolic link, 2-12

INDX1 tablespace, 2-6

minimum size for Oracle Database Configuration Assistant, 2-6

number required, 2-6

OEM_REPOSITORY tablespace, 2-6

RBS tablespace, 2-6

redo log files, 2-7

setting DBCA_RAW_CONFIG environment variable, 2-8, 2-13, 4-3

setting up, 2-6 to 2-12

suggested file names on UNIX, 2-7

SYSTEM tablespace, 2-6

TEMP tablespace, 2-6

USERS tablespace, 2-6

verification, 3-5, 3-6

RBS tablespace raw device, 2-6

RECOVERY_PARALLELISM parameter, 6-10

redo log files raw devices, 2-7

redo log files, described, 1-12

REG_MULTI_SZ, C-5

registry

DefinedNodes value, 4-6

PM\DB_NAME key, C-2, C-5

REMOTE, 6-4

REMOTE_LOGIN_PASSWORDFILE parameter, 6-4

repository database

defined, 2-4, 5-3

installing, 5-10

Repository Login dialog box, 5-31, 5-36

resources, 1-15

.RHOSTS file, 2-14

rollback segments, 1-12

ROLLBACK_SEGMENTS parameter, 1-12, 6-4, 6-10, 6-11

rolling upgrades, 3-8

ROW_LOCKING parameter, 6-11

security login, 5-16

SERVICE, 4-29

service

OracleHOME_NAMEAgent, 5-13

OracleHOME_NAMEDataGatherer, 5-30

OracleHOME_NAMEManagementServer, 5-14

OracleServiceSID, 4-9

service discovery

See auto-discovery

SERVICE_NAME parameter in TNSNAMES.ORA file, 4-29

SERVICE_NAMES parameter in INITDB_NAME.ORA file, 6-7

SERVICES.ORA file, C-9

SETLINKS utility, 2-9

DB_NAME.TBL file, 2-9

OP.TBL, 4-3

TEMPLATE.TBL, 2-13, 4-3

SGA, defined, 1-9

shared disk storage subsystem, 2-5

shared Oracle home, B-12

shutdown of the Oracle Parallel Server database, 6-24

setting Oracle Parallel Server parameters, 6-39

with SYSDBA privilege, 5-28

with SYSOPER privilege, 5-28

shutdown results, 6-24

shutdown database and other services, 6-22

shutdown database only, 6-22

SID_DESC parameter, C-6

SID_LIST_listener_name parameter, 4-12, 4-37, C-6

SID_NAME parameter, C-6

SID_startup, 4-29, C-8

SIDALRT.LOG file, C-12

SIDBSP0.TRC file, C-12

SIDDBWR.TRC file, C-11

SIDLCKN.TRC file, C-12, C-13

SIDLMDN.TRC file, C-12

SIDLMON.TRC file, C-12

SIDP00N.TRC file, C-12

SIDSMON.TRC file, C-11

SMON process, 1-10

software requirements, 2-2, 2-3

SQLNET.ORA file, 4-13

configuring, 4-32

NAMES_DIRECTORY_PATH parameter, 4-32

starting

Console, 5-15, 6-14

listener, 4-9, 4-18, 4-39

Management Server, 5-14, 6-14

Oracle Data Gatherer, 5-30

Oracle Enterprise Manager, 5-13

Oracle Intelligent Agents, 5-13, 6-14, B-12

Oracle Parallel Server database, 4-9, 6-18, 8-5

Oracle Performance Manager, 7-4

startup

setting Parallel Server parameters for, 6-37

SYSDBA privilege, 5-28

SYSOPER privilege, 5-28

Startup (START)

open, 6-19

Status Details tab, 6-25

from Edit Parallel Server dialog box, 6-29

from Parallel Server Operation Results dialog box, 6-25

Status tab

from Edit Parallel Server dialog box, 6-28

stopping

listener, 4-16, 4-37

Oracle Parallel Server database, 6-21

SYSDBA privilege, 5-21, 5-28, 6-38

SYSDBA privilege, granting, 5-26

SYSOPER privilege, 5-21, 5-28, 6-38

SYSOPER privilege, granting, 5-26

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

SYSTEM tablespace raw device, 2-6

Tasks tab

from Create Job property sheet, 6-35

TEMP tablespace raw device, 2-6

TEMPLATE.TBL file, 2-13, 4-3

thread ID, 1-12

THREAD parameter, 1-12, 6-4, 6-10

TNS_ADMIN environment variable, B-5, B-6

tns_admin parameter, B-5, B-9

TNSNAMES.ORA file, 4-13, 5-7, 5-11, 5-29

BACKUP parameter, 4-44

configuring, 4-20

configuring transparent application failover, 4-43

FAILOVER parameter, 4-35, 4-41

FAILOVER_MODE parameter, 4-35, 4-43

how used for auto-discovery, C-7

INSTANCE_NAME parameter, 4-29

LOAD_BALANCE parameter, 4-25, 4-41

METHOD parameter, 4-45

SERVICE_NAME parameter, 4-29

TYPE parameter, 4-44

trace files, C-11

background thread trace files, C-11

error call trace stack, C-13

ORAXXXXX.TRC, C-12

SIDALRT.LOG, C-12

SIDBSP0.TRC, C-12

SIDDBWR.TRC file, C-11

SIDLCKN.TRC, C-12, C-13

SIDLMDN.TRC, C-12

SIDLMON.TRC file, C-12

SIDP00N.TRC, C-12

SIDSMON.TRC file, C-11

transparent application failover, 4-35

configuring, 4-43

with connect-time failove, 4-43

troubleshooting, C-1 to C-14

auto-discovery, C-3

Oracle Database Configuration Assistant, 4-4, 4-6

trace files, C-11

TYPE parameter, 4-44

Typical installation, 3-5

Typical installation type, 3-2, 4-2

upgrading, Oracle Parallel Server issues, 3-8

uppercase, defined, xvi

User Manager, for Oracle Enterprise Manager, 5-22

user trace files, C-12

USER_DUMP_DEST parameter, C-12

USERS tablespace raw device, 2-6

V$ACTIVE_INSTANCES, 4-11

V$ACTIVE_INSTANCES table, 6-28

V$PQ_SYSSTAT table, 1-22

VD-4520 error, 5-19

vppcntl -start command, 5-30

vtm command, 5-31